CCB occasionally received SQLCODE -20528. As stated in DB2 CODES manual, this can occur while two transactions trying to update a row in system-period temporal table closely. A row being moved to history table can have sys_start higher than sys_en...
about 6 years ago
in Db2 for z/OS
4
Planned for future release
Allow for LISTDEF processing when using CHECK Utility
Details: 1) Manual does not mention use of "LIST" on the "CHECK DATA" page. Example proposed syntax: LISTDEF CHKLIST INCLUDE TABLESPACE DB123.* CHECK LIST CHKLIST SCOPE ALL EXCEPTIONS 0 SORTDEVT WORK
over 8 years ago
in Db2 for z/OS
1
Not under consideration
Drop STP SQL with dependency of other STP SQL type NATIVE
We have a general purpose StoredProcedure (STPX1) that is called by other native StoredProcedures (STPA1, STPA2, STPA3, etc) that have CALL statements to STPX1, If I need DROP the STP STPX1 (for recreate later) I receive the error -478 for depende...
almost 4 years ago
in Db2 for z/OS
0
Not under consideration
We have noticed that the structure DB2P_SCA in production the reason for high CPU consumption in the Coupling Facility is. Our reporting proofs this behaviour. We opened a case and did a deeper dive with IBM’s experts into. At the end we can say t...
9 months ago
in Db2 for z/OS
1
Not under consideration
REORG TABLESPACE REBALANCE option to leave some partitions empty
The current REORG TABLESPACE utility with REBALANCE option will distribute rows evenly accross partitions.
Many of my tables have ascending keys, so after a REBALANCE of several partitions (example PART(10:16) ), most new rows will be inserted int...
almost 5 years ago
in Db2 for z/OS
0
Not under consideration
POWER Built-in function got rewritten and so I am hoping to get a list of all changed built-in functions in Db2 12 so that I can do better testing before going into production.
almost 7 years ago
in Db2 for z/OS
0
Not under consideration
IFCID 366/376: include SQL text in the trace records
The analysis of IFCID 366/376 is done via SMF records. When these records are available (one day delay), it is nearly impossible to match the statement ID to a statement in dynamic statement cache, because the statement might be already discarded....
over 5 years ago
in Db2 for z/OS
1
Not under consideration
The absence of report class in DB2 SMF record 101 is cumbersome for capacity management. Report Class is used for workload reporting and accounting. To match SMF 72 (values by report class) with SMF 101 (values by thread, i.e. for userid and other...
over 12 years ago
in Db2 for z/OS
1
Not under consideration