Db2 for z/OS
Sort by:
Trending
Filter by:
Status
Showing 963 of 14951
16
VOTE
SQLCODE -20528 SQLCODE20528N
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...
4
Planned for future release
31
VOTE
23
VOTE
10
VOTE
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...
0
Not under consideration
2
VOTE
High CPU utilisation in CF structure xxxx_SCA
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...
1
Not under consideration
13
VOTE
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...
0
Not under consideration
18
VOTE
15
VOTE
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....
1
Not under consideration
32
VOTE
DB2 accounting SMF101 with reporting class
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...
1
Not under consideration
19
VOTE