Welcome users! Here you have an opportunity to collaborate directly with the product development teams and other product users.

Filter the page content by brand and product


This is a table showing requests
Number of votes Request headline and description

89
votes

PDF manuals for DB2 LUW v11

I would like to suggest that pdf manuals be made available in addition to the online manuals which are currently the only option.

Uncommitted Candidate

44
votes

Grant insert, select, update and delete on a schema

Ability to grant insert, select, update and delete on a schema

Uncommitted Candidate

34
votes

export data from tables out of a backup image

Introduce a new parameter to the export utility to be able to export data from a table that is in a backup image. This functionality is especially useful for data extraction without touching/impacting...

Under Consideration

21
votes

Add the hidden attribute for index

我们希望给索引添加一个属性visible on/off 比如: ALTER INDEX VISIBLE ON (默认属性) ALTER INDEX VISIBLE OFF (索引不可见) 当索引不可见以后优化器无法使用不可见的索引,如果需要,直接alter index visible on 即可恢复索引状态。 给视图syscat.indexes增加两个字段:1.索引是否可见;2.索引不可见的开始...

Submitted

16
votes

Make reducible the tablespace size in pureScale environments

DB2 LUW does not support reducing container file size in the alter tablespace statement as below. •The following clauses are not supported in DB2 pureScale® environments: ◦LOWER HIGH WATER MARK ◦LOWE...

Planned for Future Release

13
votes

Ability to keep configuration parameters in sync on HADR standby databases

Currently configuration parameter changes (db2set, dbm cfg and db cfg) on HADR primary database do not propogate to the standby databases. Having an optional clause or switch to propogate the config ...

Uncommitted Candidate

13
votes

timeout option for log archiving sessions

We're using DB2 LUW in combination with TSM for backups and log archiving. In certain problem situations on TSM side, e.g. when a disk pool for the log archives is full, we encounter a "hang" situatio...

Uncommitted Candidate

12
votes

Memory reuse in DBHEAP

In current design, when SQL statement accesses a table, the compression and expansion dictionaries of that table will be read into DBHEAP and kept there until database deactivation. For column-based t...

Uncommitted Candidate

12
votes

Need GSKTRACE tool to format binary GSKTRACE ouput ... similar to DB2 z/OS

We have enabled TLS on a db2 connect gateway SSL cipher specs (SSL_CIPHERSPECS...

Uncommitted Candidate

12
votes

DB2 LUW Federation Server should be able to use Sysplex Workload Balance (W...

Implement Sysplex Workload Balance (WLB) for DB2 Federation Server connections to DB2 z/OS sysplex data sharing like exists for JDBC driver/DB2 Connect.

Under Consideration

10
votes

Include failure / warning counts in mon_get_pkg_cache_stmt

It's currently not possible to monitor the failure rate of an SQL statement. For example, count of dupkey on INSERT. Likewise for 'soft' errors (warnings) like +100 - row not found on INSERT or DELE...

Uncommitted Candidate

10
votes

LOAD / ADMIN_MOVE_TABLE COPY YES and LOB improvements

In an OLTP / TSA HADR environment .. When using the COPY YES on ADMIN_MOVE_TABLE it uses LOAD under the covers. When LOBs are involved howere it writes out the full buffer 64k up to several 100k i...

Uncommitted Candidate

10
votes

Decouple archive log purging from BACKUP utility

For databases using AUTO_DEL_REC_OBJ, at the end of the BACKUP utility there is a synchronous process which purges any history records and their associated archive logs. This can take a very long ti...

Uncommitted Candidate

9
votes

uncouple history pruning from backup process

The pruning of the database history and the deletion of the recovery objects is part of the backup process, today. Especially, the run time of flashcopy backups are extended enormously, because e.g. T...

Duplicate

7
votes

Extension to Temporal (TimeTravel) SQL

Avoid error SQL20524 RC 3 which is returned once you try specifying a column name instead of a explicit value like in following SQL: SELECT * FROM FACT INNER JOIN TA_DIM_BITEMP FOR BUSINESS_TIME AS ...

Uncommitted Candidate


Your ideas matter!

As of today:

14 new
22 planned
78 delivered


321 users
2107 votes
948 comments

Give us feedback

Participate in the RFE Community survey to help us improve your experience.