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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
Batch process to automate image copy process, copying only tablespaces that have had changes since the last copy. Customize the process for your shop.
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 ...
Have you ever run the db2 [call get_dbsize_info(?,?,?,0)] command to get the size of your DB2 LUW database and noticed that the size is much smaller than the space used on your UNIX ...
Small change to original panel from Ron Root