Db2 for z/OS
Sort by:
Trending
Filter by:
Status
Showing 963 of 14952
31
VOTE
30
VOTE
Changing partitioning key columns
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...
1
Not under consideration
12
VOTE
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...
1
Not under consideration
2
VOTE
Register all dependencies in SYSPACKDEP
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...
3
Not under consideration
12
VOTE
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...
5
Not under consideration
5
VOTE
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...
0
Not under consideration
8
VOTE
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...
1
Not under consideration
3
VOTE
Provide a facility to track Db2 Command History
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...
3
Not under consideration
12
VOTE
21
VOTE
Track Date last used/accessed for TABLE objects
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...
2
Not under consideration