Sample Span Parameter File

Following is an example Span parameter file for a sample DMSII database titled BANKDB. (For this example, the DMSII restart data set has been deleted.)

The Span parameter file is divided as follows:

• The first part lists the Span parameters.
• The second part lists all of the data sets and remaps in the database you are replicating.

% DATABridge Span parameter file for BANKDB

% Created month day, year @ time by Version 60.x.x

% location of output data files

Extracts on DISK

Fixups on DISK

Updates (DB50)DATA/SPAN/BANKDB/= on DISK

Support (DB50)OBJECT/DATABRIDGE/SUPPORT

ON HOST

%Transform <transformname> % transform routine in the Support Library

Format BINARYFORMAT % formatting routine in the Support Library

Filter DBFILTER % filtering routine in the Support Library

Prefiltered false % false => do not use filtered audits

% ONLY => use only filtered audits

% PREFERRED => filtered audits preferred

%Reader "librarytitle" using "param" % FILEBridge

TranGroup Checkpoint % use Engine's Checkpoint value (default)

%TranGroup QPT % commit at every quiet point

%Source <sourcename> at <hostname> via TCPIP port 3000 % remote host

%Audit on <packname> % location of audit files

%Audit on ORIGINAL FAMILY % audit files on original packs

%Audit on TAPE % audit files on COPYAUDIT tapes

%Audit Job "<WFL job>" % job to zip when done with audit file

%Audit no wait % don’t wait on NO FILE for audit

Report ERRORS WARNINGS INFO % message reporting options

% INVALID Numbers Text % report invalid data

% NULL Numbers Text % report NULL data

ErrorsFatal true % true => if any error occurs, stop program

Header false % true => audit location in consolidated file

%Embedded Extracts % true => extract embedded w/o INDEPENDENTTRANS

%Clone OFFLINE % OFFLINE => exclusive use of database

% ONLINE => allow updates and database dump

%Stop At First QPT After n AUDIT FILES % max audit files processed

%Stop At First QPT After n RECORDS % max records written

%Stop At First QPT After hh:mm on + 0 % lower bound time and date

%Stop At Last QPT Before hh:mm on + 0 % upper bound time and date

%Stop At First QPT After "taskname" % after EOT

% or Before hh:mm on mm/dd/yyyy % but by this time & date

%Stop At Last QPT Before "taskname" % before BOT

Default Records per Block 100 % default number of records per block

Default Records per Area 1000 % default number of records per area

Default Modifies After Images Only % new record value only

%Default Modifies Before and After Images % old record value first

%Data Rec File Aud Block Segment Word Date Time Mo- Format-Lvl

%-set Type Nbr SerialNbr Number Index YYYYMMDDhhmmss de DMS Client

%---- --- ---- --------- ------- ----- -------------- - ---- ----

% Dataset "BANKDB"

% Records per Area 1000

% Records per Block 100

% Bytes per Record ?

% After Images Only % modified records

% Before and After Images % modified records

%0001 000 0000 0000000000 0000000 00000 00000000000000 0 00000 00000

% Dataset "MASTER-DS"

% Records per Area 1000

% Records per Block 100

% Bytes per Record ?

% After Images Only % modified records

% Before and After Images % modified records

%0002 000 0000 0000000000 0000000 00000 00000000000000 0 00000 00000

% Dataset "ORDERED-DS"

% Records per Area 1000

% Records per Block 100

% Bytes per Record ?

% After Images Only % modified records

% Before and After Images % modified records

%0003 000 0000 0000000000 0000000 00000 00000000000000 0 00000 00000

% Dataset "EMB-STANDARD"

% Records per Area 1000

% Records per Block 100

% Bytes per Record ?

% After Images Only % modified records

% Before and After Images % modified records

%0005 000 0000 0000000000 0000000 00000 00000000000000 0 00000 00000