Db2 for z/OS

Showing 1010

ARCRETN - Managing by DFSMS - SMS Management Class

In a situation related to replication delay, it was necessary to keep the Db2 archive log longer than its current retention period. The subsystem parameter ARCRETN was set as 17 days as in Management Class. The planning was to alter the retention ...

5 days ago in Db2 for z/OS 0 Under review

10 VOTE

Support REORG for DEFINE NO

I have heard, in various IBM presentations (Haakon at IDUG Valencia, John Lyle at CCDB2) talking about Db2 Vnext, the statement "no migration to vnext if you have 6 byte RBA/LRSN or non-UTS tablespaces". This if fine unless you happen to have old ...

6 days ago in Db2 for z/OS 1 Under review

2 VOTE

Dataset Processing (CREATE, DELETE, EXTEND) should get a timelimit

We had an unimportant pageset, which was defined with ERASE YES. Due to the long timeframe of writing x'00' (ERASE YES) on the tracks of this pageset, another dataset processing (EXTEND) of a very important pageset waits and is timed out. This tim...

10 days ago in Db2 for z/OS 0 Under review

1 VOTE

Better error message when using incorrect dataset for recover tocopy

A PGR table with 5 partition have a combination of full Image copier and partition image copies. executing RECOVER TABLESPACE userid.table DSNUM ALL TOCOPY hlq.DB2.IC.userid.table.PART4 gave this error DSNUCATO - TOCOPY DATASET NOT FOUND but the d...

10 days ago in Db2 for z/OS 0 Under review

1 VOTE

Sample job for RECOVER of catalog and directory

Db2 deliver a sample job (DSNTIJIC) to COPY the catalog and directory. If we have to RECOVER one or more of these jobs it is vital that they are recovered in the right order and the right way. As this is so important Db2 should include a sample jo...

15 days ago in Db2 for z/OS 0 Under review

1 VOTE

Sample job for REORG of catalog and directory

We maintain a partly homegrown job to reorg the catalog (DSNDB06) and directory (DSNDB01) table spaces. It is built using sample job DSNTIJCV. It is hard to maintain that job when the catalog and directory changes. Just as Db2 deliver a sample job...

15 days ago in Db2 for z/OS 0 Under review

1 VOTE

Have Db2 for z/OS issue a message at Db2 subsystem restart if a DSNZPARM or DSNHDECP member has been changed.

Configuration management is a major focus of our auditors and compliance officers. We have to be able to show that we have a standard build and that any changes from the standard configuration would be closely governed via change control. The focu...

16 days ago in Db2 for z/OS 0 Under review

3 VOTE

DSNTEP2/DSNTEP4 program parameter to specify the output record length without the need to recompile the program

we are in the process of migrating IBM tools and utilities from a third party vendor to IBM software and we need a program to run SQL select statements in batch with an output record length greater than 133 characters. In the IBM manual for sample...

21 days ago in Db2 for z/OS 0 Under review

1 VOTE

Index on Expression with Soundex Function

For most Index on Expression uses we've been able to just include the function as part of the index without any extra changes involved. Such as with the column UPPER(colname). Just create the index with that option. However SOUNDEX requires that y...

27 days ago in Db2 for z/OS 0 Under review

1 VOTE

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

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

Please enter your email address

FILTER BY CATEGORY