Search results: Db2 for z/OS

Showing 23

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...

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

16 VOTE

DSNTIAUL should support input LRECL size of > 80 bytes and not ignore input beyond the first 72 bytes

It is sometimes easy to put SQL all on one record as long as the LRECL of that record is very large. It becomes difficult to parse that SQL so it is divided into 72 byte records. Currently, the IBM utilities have input files that can have a LRECL ...

about 6 years ago in Db2 for z/OS 1 Not under consideration

15 VOTE

Alters to objects that require reorg to material should be put into advisory reorg, such as PCTFREE

If an alter is done to a TS to PCTFREE and a REORG is not run, then the catalog is updated but the change is not materialized. This results in the DBA thinking it was done, but it really wasn;t.

about 6 years ago in Db2 for z/OS 0 Not under consideration

3 VOTE

Enhancement ALTER of STOGROUP to be NO-DISRUPTIVE change.

As we all know to perform an ALTER DB.TS/IX USING STOGROUP XXXXX a STOP/ALTER/START process is required which is a DISRUPTIVE change. So, looking for an enhancement on that ALTER process maybe it could be "improved" by putting the involved Db2 obj...

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

10 VOTE

Provide a threshold for the number of incidents caused by a single holder for message DSNT376I.

Availability and stable systems are very important to us (as they are for most users of DB2 for Z). Recently, I implemented a process that automatically terminated any process that shows up as the holder for a specific number (threshold) of DSNT37...

over 7 years 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...

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

5 VOTE

New ZPARM for SYSTIMESENSITIVE Bind Option

Please reference CASE TS005056787 ( Temporal Table access path in Plan_Table does not match dynamic explain). This bind option which is set for using a Temporal Timestamp Register was set with a DEFAULT to YES by IBM for all binds that exclude thi...

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

6 VOTE

static SQL with DGTT and REOPT(ALWAYS) should be traced by IFCID 401

We realized that not all static SQLs are captured by DB2 to be put into IFI buffers (IFCID 401) I'm referring to static SQL related to packages bound with REOPT(ALWAYS) and DGTTs statements. For REOPT(ALWAYS) packages, only statements not affec...

over 5 years ago in Db2 for z/OS 2 Not under consideration

7 VOTE

Request to convert classic partitioned to UTS PBR by partition

Would like to see if it could be considered to perform an alter classic partitioned tablespace and then reorg by partition instead of the entire tablespace. While I agree it may be more housekeeping, some of the tablespaces we eventually will need...

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

2 VOTE

If ADMIN_UTL_SCHED is used for imagecopies it should put the triggering jobname/CorrID into SYSIBM.SYSCOPY

If ADMIN_UTL_SCHED is used do to image copies it writes the name of the wlm-addressspace to the jobname columne of SYSIBM.SYSCOPY. We like to see the name of the triggering job/CorrID there, because we need this information. An alternative would b...

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

Please enter your email address

FILTER BY CATEGORY