Db2

Showing 205

Ability to execute Pacemaker status and version commands as a non-root use

In TSA the following commands can be executed as a non-root user / db2 instance to check the status , get the version , enable disable cluster: lsrpdomain lsrpnode lssam samversion db2haicu -disable Pacemaker commands require root access to execut...

28 days ago in Db2 / High Availability and/or Disaster Recovery 0 Future consideration

7 VOTE

Enhance MON_GET_TRANSACTION_LOG to return Transaction Log number of OLDEST_TX_LSN and the Transaction log number of the minbuflsn recovery information returned by db2pd -dirtypages

Enhance MON_GET_TRANSACTION_LOG to return Transaction Log number of OLDEST_TX_LSN and the Transaction log number of the minbuflsn recovery information returned by db2pd -dirtypages. For example when trying to identify the reason for the First Acti...

2 months ago in Db2 / Backup/Restore/ Rollforward/ Recover / Monitoring 0 Future consideration

6 VOTE

HADR/Pacemaker for AIX

While HADR/Pacemaker for Linux is available, Pacemaker for AIX is not availabe and needed now to avoid a hold-up in our adoption of Db2 vNext.

3 months ago in Db2 / High Availability and/or Disaster Recovery 0 Future consideration

2 VOTE

Rebuild BLU columnar dictionaries and recompress data in BLU columnar tables

An engineered capability is required to automatically rebuild an optimal BLU columnar compression dictionary and recompress BLU columnar tables. A technique is needed to easily rebuild and recompress columnar tables like we have for adaptive compr...

3 months ago in Db2 / BLU Acceleration 0 Future consideration

1 VOTE

Please add the elements to 'LAST_REQUEST_TYPE' in the MON_GET_CONNECTION/MON_GET_UNIT_OF_WORK table function.

Please add the values from the following columns to 'LAST_REQUEST_TYPE' in the MON_GET_CONNECTION/MON_GET_UNIT_OF_WORK table function. (Please match the value of the STMT_OPERATION column in SYSIBMADM.SNAPSTMT/SNAP_GET_STMT) CALL EXECUTE_IMMEDIA...

5 months ago in Db2 / Monitoring 3 Future consideration

1 VOTE

Please add the missing SNAPSTMT/SNAP_GET_STMT columns to MON_GET_ACTIVITY.

1.SNAPSTMT administrative view/SNAP_GET_STMT table function is said to be replaced by MON_GET_ACTIVITY table function, but I would like to add the following columns because MON_GET_ACTIVITY does not have them. AGENT_ID STMT_TYPE STMT_OPERATION DEG...

5 months ago in Db2 / Monitoring 3 Future consideration

10 VOTE

Provide the ability to use db2audit data in the DMC.

Please provide a way to store db2audit data in DMC and to easily view, use, and report on audit logs. Currently db2luw can only store and extract audit data, but there is no repository db and no way to use it. I hope DMC will have such a feature a...

5 months ago in Db2 / Data Management Console 1 Future consideration

31 VOTE

Improved functionality for tablespace fast pre-allocation

My customer is experiencing huge performance problems due to Tablespace Pre-allocation (DB2_USE_FAST_PREALLOCATION).At this time, IOCP Timeout occurs in Db2 and many tossbuffers occur in GPFS.This customer has been struggling with this problem for...

5 months ago in Db2 / pureScale 5 Future consideration

4 VOTE

Db2 PureScale Spectrum Scale Package (GPFS) should include performance sensor and collector package

Dear IBM, in the Spectrum Scale distribution bundled with DB2 pureScale, the binary of mmperfmon is included but the packages for the required sensors and collectors are missing. mmperfmon is needed to identify possible performance bottlenecks wit...

5 months ago in Db2 / pureScale 1 Future consideration

6 VOTE

Log Failed LOADS in db history file

Please refer to IBM CASE TS012541333 for further details Db2 database history file registers several SUCCESS and FAILED operations. If a backup has been executed, and if it failed or completed ok . if a restore has been done, and if it failed or c...

6 months ago in Db2 / Utilities (Export Import Load db2look etc) 2 Future consideration

Please enter your email address

FILTER BY CATEGORY