Db2

Showing 988

Reorg a data partitioned table with non partitioned indexes online

Currently a data partitioned table with non partitioned indexes can not be reorged online, even the latest V11.1.2.2 can not do this.

over 6 years ago in Db2 / High Availability and/or Disaster Recovery 1 Not under consideration

15 VOTE

Security enhancement - support of roles for GRANT SETSESSIONUSER privilege

After the change of the security setup in DB2 database to a role based model there is still a part where some rights can only be granted to groups instead of roles. This forces admins to maintain to sets of security setups making a complex Task ev...

over 7 years ago in Db2 / Security 0 Not under consideration

15 VOTE

Enable HA/failover functionality at instance level or for groups of databases

DB2 performs failover only at the database level. If a group/set of databases are related, e.g. used for the same application, those databases should ideally failover together, but under the current design, those failovers have to be done individu...

almost 8 years ago in Db2 / pureScale 0 Not under consideration

15 VOTE

Bufferpool Purge without database deactivation

Ability to purge the bufferpools (perhaps specified by bufferpool name) without deactivating the entire database. While dirty pages can be flushed from bufferpools with the flush bufferpools command, the bufferpools cannot be entirely purged witho...

almost 9 years ago in Db2 / Serviceability 0 Not under consideration

15 VOTE

Error DIA3202C in db2diag.log does not include database name

getting an error in db2diag.log that a connection to a database ist not possible because of a TCP/IP call does not work. In our case a connection to a remote database should be established, which was already dropped. But there is no database name ...

over 9 years ago in Db2 / Serviceability 0 Not under consideration

15 VOTE

Perform rebuild of each index (for a table) in its own transaction

In the current design, all the index rebuilds for a table are performed within the same transaction (as the action that triggered them). If the transaction is interrupted (e.g. user interrupt or dropped session), then the entire transaction is rol...

over 9 years ago in Db2 / Utilities (Export Import Load db2look etc) 2 Not under consideration

14 VOTE

DB2 v11.5 Bind File and Package Name List

IBM published a technote "DB2 Bind File and Package Name List" https://www-01.ibm.com/support/docview.wss?uid=swg21987465 listing all the names of the bind files of the different versions of Db2. It needs to be extended for Db2 11.5

over 4 years ago in Db2 / Other/Unknown 7 Not under consideration

14 VOTE

Application status change time is not available in any mon_get_* table functions

In snap admin views, users could see STATUS_CHANGE_TIME column for the application which was helpful in determining when exactly the application changed it status when investigating performance issues. This would help users to estimate or know how...

almost 5 years ago in Db2 / Monitoring 1 Not under consideration

14 VOTE

Make Export add a column header row to output

Export is often used to download data from a Db2 Server to a user's workstation where they then look at it in excel.

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

14 VOTE

LOAD to COMMIT extent allocation

LOAD is today a single transaction. It does not create much log volume, but LOAD might run long if lots of data need to be loaded. This can lead to log full disk situation, if concurrent transactions create a large log volume.The extent allocation...

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

Please enter your email address

FILTER BY CATEGORY