Db2 for z/OS

Showing 820

Add a message to report orphan threads in DB2

Due to TCPIP abend, there are several orphan threads in DB2 causing contention issues on resources. There is no message to report these orphan threads. Having a report helps us to avoid contention issues sooner by cancelling the underlying orphan ...

21 days ago in Db2 for z/OS 1 Not under consideration

1 VOTE

Db2: V13 Access Path regression: Tablespace scan regresses to nonmatching index scan. After turning this in as a problem, we were told that it was working as designed. Our suggestion is that the design is flawed.

We feel the design is flawed and strongly feel this is a bug. The only time a non-matching index scan should be considered versus the tablespace scan is when it can at least filter the result somewhat. There are ZERO columns in the index that matc...

2 months ago in Db2 for z/OS 1 Not under consideration

3 VOTE

Eliminate x-locks on CREATE INDEX DEFER YES to improve concurrency

This is similar to DB24ZOS-I-1114 and DB24ZOS-I-1689. When attempting to create an index with CREATE INDEX DEFER YES, there should be no need to lock packages that are dependent on the table. Requiring an x-lock doesn't seem necessary. With phase-...

2 months ago in Db2 for z/OS 1 Not under consideration

2 VOTE

IFI READ calls to be zIIP enabled

QREP CAPTURE use IFI READ calls to read the Db2 LOG . Usage of QREP CAPTURE will be cost effective , if IFI calls are zIIP enabled

3 months ago in Db2 for z/OS 1 Not under consideration

2 VOTE

Enhance Db2 System profiles to allow exceptions

System profiles are being used to control applcompat levels for distributed connections. This is being done by trapping on the default db2 driver COLLECTION NULLID then setting the attributes to another collection using a higher applcompat. This w...

3 months ago in Db2 for z/OS 0 Not under consideration

1 VOTE

the message DSNZ015I should be a warning and not an informational message

running a batch -SET SYSPARM command should end in a CC 0004 if there are parms that are NOT pulled in.

3 months ago in Db2 for z/OS 1 Not under consideration

3 VOTE

Allow application to decide what to do when a timeout occurs (-911 vs. -913)

In time-critical processes, it can be important to be able to react to timeout conditions in Db2. In Db2 V13, there is new functionality that allows an application to override the default timeout setting (the CURRENT LOCK TIMEOUT special register)...

4 months ago in Db2 for z/OS 1 Not under consideration

10 VOTE

Provide one Db2 message to indicate that GRECP and LPL recovery is complete across a Db2 data sharing group.

We use automation to drive our disaster recovery processes to reduce the recovery time and remove human interaction. We have been running into issues with starting software products that require access to Db2 before it has completed GRECP and LPL ...

4 months ago in Db2 for z/OS 1 Not under consideration

1 VOTE

Add support for GRANT ROLE to AUTHID.

In DB2 for z/OS I am allowed to CREATE ROLE, GRANT priviledges to ROLE but I can't GRANT that role to a USERID. Seems something is broke to me. What are ROLES good for if I can't assign a user or group of users to that role.

4 months ago in Db2 for z/OS 1 Not under consideration

1 VOTE

allow CREATE TABLE LIKE another table and propagate table partition limits

Today, it is possible to create a PBG tablespace and then use CREATE TABLE like another table and the new table is in the new ts. CREATE TABLESPACE ZPOLCL IN DDB01P SEGSIZE 64; CREATE TABLE TPOLCL LIKE DBCCLP1.TPOL IN DDB01P.ZPOLCL; If the source...

4 months ago in Db2 for z/OS 0 Not under consideration

Please enter your email address

FILTER BY CATEGORY