Code Place

145 Entries
 
 
12 years ago
Be the first person to recommend this.

Does what it says in the title line! Will also work in V7 and V8 CM as long as you remove the STATSTIME CASE structure for the TP and IP.

Now updated with a new file for DB2 10 ...

Attachments
12 years ago
1 person recommends this.

I recently sent you RUNSQL in XMIT unload format. Here it is again in a simple .txt file.

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

You can use a Rexx Program to read the catalog, then use that output to generate you unloads and load Jobs. You can also use the DB2 Admin Tool to gen you unload and loads, but this ...

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

This is a major update to the DBRMMAP code originally written by Ron Root. This exec goes with the panel and messages from May 1 2008 in Code Place. It adds many enhancements to the ...

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

Input is 2 tables: TOGRP7.PLAN_TABLE and TOGRP8.PLAN_TABLE. All packages bound in V8 are into collection BSCV8. Program PARMS in the V7 collection ID. 2 files created, a Summary: Program ...

Attachments
13 years ago
1 person recommends this.

This is a set of SQL scripts that accompany Chris' IDUG Europe 2008 and IDUG NA 2008 presentation entitled 'Using the New Admin Views to Monitor Your Database. The files show you how ...

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

This is a technical document that describes how the production database is backed up, copied and restored to the hot backup server. The reasons for having a hot backup are clear disaster ...

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

This REXX will use the stored proc DSNWZP to read a DB2 subsystem's active Zparms, copy the ...SDSNSAMP(DSNTIJUZ) Zparm assemble job then update the copy of DSNTIJUZ with the selected ...

Attachments
13 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
13 years ago
1 person recommends this.

To experience the benefits of Deep Compression firsthand, download and use the DB2 Compression Estimation Calculator (DB2 for LUW users working with V7 or V8): The download comprises ...

Attachments