Db2 for z/OS

Showing 963 of 14952

Enable create index during prime time

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

11 VOTE

Simplify Alter

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

25 VOTE

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

18 VOTE

RTS Temporal samples for housekeeping and cleanup

There are no samples for (a) how to cleanup the RTS history tables(b) how to calculate e.g. REORGSPACE

over 7 years ago in Db2 for z/OS 1 Not under consideration

28 VOTE

REOPT(ALWAYS) on statement level additional to package level

MR0123086821 GGDB208004 Make it possible to state REOPT(ALWAYS) additionally to the bind option as a clause at the statement level.

almost 12 years ago in Db2 for z/OS 2 Not under consideration

4 VOTE

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

9 VOTE

Allow column masking on system temporal tables

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

8 VOTE

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

8 VOTE

Improving latch contention in Db2 z/OS

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

16 VOTE

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

Please enter your email address

FILTER BY CATEGORY