Most of our tables that are created before DB2 V8 (and even some created later than that) uses the primary key as the partitioning key. The resulting partitioning key therefore consists of many columns, but the significant columns for partitioning...
almost 12 years ago
in Db2 for z/OS
1
Not under consideration
Add a STOP DB2 mode that cancels connected threads, but not internal processes.
We have struggled with getting a "clean" shutdown of Db2 for years.
If we try to use STOP DB2 MODE(QUIESCE), Db2 will not stop. Persistent threads from STCs such as CICS regions, WAS Z servants, and ARS CMOD servers do not "end", so they never all...
almost 5 years ago
in Db2 for z/OS
1
Not under consideration
Today SYSPACKDEP records the dependencies of packages - but not dependencies related to RI. That means that a user or a tool needs to run additional queries to understand all dependencies to e.g. answer the question: which packages do I need to RE...
10 months ago
in Db2 for z/OS
3
Not under consideration
extend MERGE syntax to allow Common Table Expressions (CTE)
The MERGE SQL statement is a new favourite SQL statement.
But I also like to use Common Table Expressions (CTE).
CTE can be used in other type of SQL (mostly SELECT) but CTE is not allowed with MERGE
What is my idea? Allow MERGE to use CTE.
I...
almost 5 years ago
in Db2 for z/OS
5
Not under consideration
Rotate an archive-enabled PBR tablespace without causing a deadlock
When we try to rotate partitions of an archive-enabled PBR tablespace, Db2 requires us to disable archiving before the rotate then re-enable archiving after the rotate. However, when we re-enable archiving we cause a deadlock with CICS and the onl...
about 2 years ago
in Db2 for z/OS
0
Not under consideration
Distributed Thread cancelled due to Idle Thread Timeout or MONITOR IDLE THREADS not writing record to SYS1.LOGREC
We noticed that every DB2 distributed thread that is cancelled because:
1) Idle thread timeout value that is specified by Db2 subsystem parameter IDTHTOIN in macro DSN6FAC is exceeded; or
2) ATTRIBUTE2 value in a row with KEYWORD value MO...
about 3 years ago
in Db2 for z/OS
1
Not under consideration
A table that would record commands (like START/STOP, ), when they were executed, by whom, etc. Some commands (like DISPLAY) could be excluded. One Use Case would be to analyze why a tablespace might be in UT status when no utilities are running. A...
about 1 year ago
in Db2 for z/OS
3
Not under consideration
As more people use EXPLAIN PLAN and BIND_EXPLAIN(ONLY), and EXPLAIN PACKAGE to collect explain data for managing rebinds and package changes, PLAN Tables proliferate. Some customers find the proliferation of explain tables to be problematic. We ne...
over 8 years ago
in Db2 for z/OS
2
Not under consideration