We are running 24/7 banking applications and are unable to create an index during peak times. One reason for this behaviour might be APAR PK74729 resulting in a timeout for the create index command when packages are active. But we also get conflic...
over 6 years ago
in Db2 for z/OS
1
Not under consideration
In Db2 z/OS version 10 Pending Alters/Deferred Alters were introduced.
Deferred Alters are not compatible with most Immediate Alters. Deferred Alters need materializing REORG before immediate Alter, or the Immediate Alter has to be run before D...
over 4 years ago
in Db2 for z/OS
0
Not under consideration
Materialize a reorg pending change through part-level reorgs
At the moment an AREOR exception state can only be solved by reorganizing the whole (partitioned) tablespace in one go. We want to do the materialization in several sequential steps on a part-level base.
over 10 years ago
in Db2 for z/OS
1
Not under consideration
Real time statistics (RTS) should include information about index traversal count
Application DBA's and developers use performance metrics, acess paths, object definitions and Real Time Statistics (RTS) when analyzing application perfomance. Information about FTB should be syncronized with other information about the index and ...
over 1 year ago
in Db2 for z/OS
1
Not under consideration
We have a few System Temporal tables that have sensitive data. We need to be able to create column masks on those columns. Currently we get a SQL20474N with Reason Code 17 when we try to run a CREATE MASK on system temporal tables.
almost 4 years ago
in Db2 for z/OS
1
Not under consideration
improve documentation about CONDBAT (& MDBAT) and how to watch the limit being approached
The IBM provided documentation for important ZPARM of CONDBAT and MDBAT is a bit vague on exactly what to watch for these important limits. The documentation could be improved. I reviewed the documentation for DISPLAY DDF command https://www.ibm.c...
over 3 years ago
in Db2 for z/OS
0
Planned for future release
DB2 workloads run at a priority that is related to their origin (may it be batch, IMS, DDF, …) and according to WLM service class definitions. In high system utilization scenarios, or due to workloads running in a WLM service class with a resource...
over 3 years ago
in Db2 for z/OS
1
Not under consideration
SQLCODE -180 (invalid date/time) - add identifier for hostvariable.
When it comes to SQLCODE -180 (invalid value for date/time/timestamp) due to wrong data in an input-hostvarible currently DB2 issues following SQLCODE: SELECT * FROM SYSIBM.SYSTABLES WHERE CREATEDTS = ? Hostvariable holds 'SCHUBIDU' DSNT408I SQLCO...
almost 7 years ago
in Db2 for z/OS
0
Not under consideration