Db2

Showing 1391

db2look with -printdbcfg must support parameters with "automatic" value

To clone a database and all its objects IBM recommend to use the db2look utility. If you use the -printdbcfg to clone the db configuration too the db2look utility generate the parameter values in the update commands but without the "automatic" val...

almost 5 years ago in Db2 / Utilities (Export Import Load db2look etc) 1 Not under consideration

1 VOTE

Functions to transform DB2 XML to JSON data and the other way around

if you have a table with a XML column it will be nice to be able to export the xml part of the data in a JSON format it will also be nice to be able to update the XML data with input in JSON format.

about 2 months ago in Db2 / Application Development 0 Submitted

16 VOTE

IBM Data Management Console scheduled reports in PDF format

Currently the "Create scheduled report" only allows a URL of the report to be sent out in an email. This is to request a PDF attachment option made available so that users can access it directly in their emails instead of logging on to DMC to view...

about 2 years ago in Db2 / Data Management Console 0 Future consideration

14 VOTE

ADMIN_MOVE_TABLES needs to support INDEXES on EXPRESSION

ADMIN_MOVE_TABLE (AMT) procedure fails in SWAP phase, if the table to be moved has an expression based index defined. This issue has been lifted partially, as the RENAME of the table is now supported with INDEX on EXPRESSION (IoE). But in our case...

almost 2 years ago in Db2 / Utilities (Export Import Load db2look etc) 3 Future consideration

62 VOTE

BLU CDE Online REORG

Currently BLU CDE tables only have the RECLAIM EXTENTS option of REORG enabled. This does not physically move rows and therefore REORG cannot reclaim extents unless 100% of the rows in an extent have been deleted (via deletes or BLU updates). Also...

almost 9 years ago in Db2 / BLU Acceleration / Tables/Index (Range MQ MDC etc.) 5 Future consideration

11 VOTE

Please provide the last grant time for auth (system/db/schema level) and privilege.

Please provide account creation, deletion, and the timestamp when a particular account was granted auth (system/db/schema level) and privileges on an object. db2luw is branded as an insecure DBMS every time in a security certification audit becaus...

over 1 year ago in Db2 / Security 0 Not under consideration

4 VOTE

Automate the clean up of orphan rows in the database catalogs during the db2ckupgrade processing.

We have been dealing with orphan rows in the database catalogs for many years now. The first tool to deal with this was db2cleancat and it has gone through various iterations to address all of the various flavors of this type of issue and now has ...

7 months ago in Db2 / Installation & Upgrade 0 Submitted

9 VOTE

Enable 'SYSADM' authority to end users in Db2 on Cloud

In the db2 database configuration for IBM Security Verify Governance Identity Manager, the 'CREATE_EXTERNAL_ROUTINE' authority is required as part of setup. This is not supported on DB2 Cloud since granting it requires the 'SYSADM' authority which...

over 1 year ago in Db2 / Db2 on Cloud 0 Not under consideration

60 VOTE

Performance enhancement for admintabinfo

For example, the customer wants to get the name list for tables which are in load pending status, he may issue a SQL statement "select tabschema,tabname from sysibmadm.admintabinfo where load_status='PENDING'", the statement will execute for a ver...

almost 9 years ago in Db2 / Utilities (Export Import Load db2look etc) 2 Future consideration

4 VOTE

Add Arm64 support for Net.IBM.Data.Db2-osx

I am trying to use the dotnet library Net.IBM.Data.Db2-osx on an Apple Macbook M3 Pro, but it fails to work. I was told it is because the library does not support Arm64 systems. Can we add Arm64 support? See this thread for back story.

7 months ago in Db2 / Other/Unknown 2 Submitted

Please enter your email address

FILTER BY CATEGORY