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

24
votes

TRIGGERS referencing system temporal tables

Hello, Since we are in DB2 V10 we use triggers with bi-temporal tables (system temporal + business temporal table) to implement complex relational integrity rules that can not be defined using stan...

Under Consideration

23
votes

Console message for inoperative packages

MR0125102752 GGDB209021

Uncommitted Candidate

21
votes

Request to add parameters - Control Unload Utility:Specify new "Register" O...

In Db2 12, the UNLOAD utility have a new "REGISTER" option, with SHRLEVEL CHANGE/ISOLATION UR. The default is NO. The default behavior of UNLOAD utility with REGISTER option is to reads pages directly...

Uncommitted Candidate

20
votes

DB2 z/OS V11 NFM - 6-Byte LOG RBA Limit Reached for BASIC format objects

DB2 : Stand-alone Ver : V11 NFM We need a monitoring and alert mechanism in DB2 z/OS (V11), to display warning messages when there are DB2 objects still in BASIC format and the 6 byte log limit is ab...

Uncommitted Candidate

9
votes

IFCID amendment to include SQL Text

Currently the ifcid 366 and 376 do not always supply the SQL text, but rely on the explain statement cache to supply it. This means SMF extracts rarely supply the SQL text required for these records.

Under Consideration

8
votes

In traces, associate COMMIT/ROLLBACK activity with the package that issued ...

Referencing the description for QW0124CP "current package name" in the DSNWMSGS member of DSNIVPD, I see this statement: 'COMMIT', 'ROLLBACK', 'SET <HOST VARIABLE> = CURRENT PACKAGE SET', AN...

Under Consideration

7
votes

Provide a threshold for the number of incidents caused by a single holder f...

Availability and stable systems are very important to us (as they are for most users of DB2 for Z). Recently, I implemented a process that automatically terminated any process that shows up as the ho...

Under Consideration

7
votes

Enable customers running 24/7 to create unique indexes

Our Internet and Mobile applications are used 24/7 and we do not have any batch windows nor any maintenance windows. When creating new indexes on existing tables the a CREATE INDEX operation generat...

Uncommitted Candidate

6
votes

optimiser to consider workfile size to determine to use a sort operation

Hi, were coping with a -904 00C90084 or 00C90085 DSNDB07 during a simple left outer join. Apparently the optimiser is not smart enough to determine wether or not to use a sort operation because his l...

Under Consideration

6
votes

Wrong result from reading Archive Enabled Tables with GET_ARCHVIE set to Y

When reading Archive Enabled Tables we set a value for the global variable GET_ARCHIVE in order to get the appropriate result. If we set it to N only the base table is read. If we set it to Y we want ...

Under Consideration

6
votes

Wrong result from reading System Temporal Tables with CURRENT TEMPORAL SYST...

When reading System Temporal Tables we set a value for the special register CURRENT TEMPORAL SYSTEM_TIME in order to get the appropriate result. If it is NULL only the base table is read. If it is not...

Under Consideration

6
votes

Enhance ALTER of STOGROUP

Would like additional flexibility to change storage options without taking outages. First situation, we had a special storage group defined with a specific STORCLAS that was used to isolate a specifi...

Under Consideration

6
votes

Allow REBIND of in-use Dynamic SQL Packages

Since the requirement to have a Package for Dynamic SQL was introduced there has always been the problem about when to REBIND these "empty shells". The requirement to REBIND was only slightly annoying...

Uncommitted Candidate

6
votes

Support JSON index on array in DB2 Z/OS as it is in DB2 LUW

support json index on array in db2 for z/os in order to have adequate performance in the ultimate database for mobile,as it already is in databases not so ultimate

Need More Information

6
votes

ALTER TABLESPACE DEFINE YES

Currently, if a tablespace or index is created with DEFINE NO, the underlying VSAM cluster is not created until the first row is inserted, or until LOAD RESUME NO REPLACE is executed. This is used a l...

Under Consideration


Your ideas matter!

As of today:

18 new
26 planned
336 delivered


682 users
6472 votes
1674 comments

Give us feedback

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