Code Place

146 Entries
 
 
15 years ago
1 person recommends this.

This zip file contains the scripts and README file for the DB2 UDB admin and monitoring scripts that I presented at the 2005 IDUG/IIUG Conference. The scripts perform full backups, ...

Attachments
11 years ago
Be the first person to recommend this.

Shows the DBRM SQL statements, with Unicode translation when necessary (well, ASCII to EBCDIC). Results are saved to a data set, which is then Browsed (when running under ISPF). Uses ...

Attachments
16 years ago
Be the first person to recommend this.

SMF has a standard program to select the record type that you want, but unfortunately, it doesn`t go further: IFCIDs records are still hidden ! This program does the job, it gives you ...

Attachments
14 years ago
Be the first person to recommend this.

Batch process to automate image copy process, copying only tablespaces that have had changes since the last copy. Customize the process for your shop.

Attachments
16 years ago
Be the first person to recommend this.

After pressing the enter on ISPF panel, the rexx program under ISPF panel runs and it prepares the GRANT+SYNONYM+BIND statements related to that table. After the table is dropped, the ...

Attachments
6 years ago
Be the first person to recommend this.

DB2 for z/OS UDF that converts a bit string into a number

Attachments
4 years ago
Be the first person to recommend this.

This Rexx Exec can be modified to take advantage of DSNACCOX.

 Available from ---> https://ruban.de/db2zos/rexx-procedure-to-execute-dsnaccox-db2-supplied-stored-procedure-v10/

 /* ...

Attachments
15 years ago
Be the first person to recommend this.

Converts the input string to Titlecase. Example values(titlecase(`pRime MinIster`)) will give the result as `Prime Minister`. This has been tested on DB2 8.2 on LUW. Though not tested, ...

Attachments
15 years ago
Be the first person to recommend this.

This is a job that issues -ARCHIVE LOG in the 1st step and the 2nd step checks the status up to 20 times, with a 30 second pause between each check. CC=0 means the archive is complete. ...

Attachments
15 years ago
Be the first person to recommend this.

These little SQLs show you your current actual used size in the SPT01 and can be used to see if you are approaching the dreaded 30GB limit...

Attachments