Code Place

147 Entries
 
 
9 years ago
Be the first person to recommend this.

This article demonstrates how to check LOAD and IMPORT operations through ETL calls to
SYSPROC.ADMIN_CMD in a database partitioning (DPF) environment.  Developers can do this simply, ...

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

In adidition to keeping at least x versions, we also ensure that everying bound in last y days (regardless of number of versions) is kept. For example if I bound a package 5 times yesterday, ...

Attachments
12 years ago
1 person recommends this.

Supplied in PL/I source code format, this version of DSNTEP2 does not 'wrap' the output report around 133 byte lines. For best results, execute with ALIGN(LHS) run time option.

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
14 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
6 years ago
Be the first person to recommend this.

SQL to create GRANT statements to copy table data privileges (SEL/INS/UPD/DEL only) from one schema to another. Resulting statements are longer than 72 characters/line.

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

To handle a situation where no NFS was available (just SSH/SCP). log_copy.pl copies logs to a remote server via scp (public key, passphraseless). Cleanup.pl deletes all logs not needed(locally ...

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
14 years ago
Be the first person to recommend this.

Customize Explain for your application you can easy read and understand

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

If you ever need to recover a DB2 environment from a disaster or serious operational system problem and want the database to perform like it did before the recovery, information about ...

Attachments