Span Report Files

Following are examples of Span output based on the Span parameter file described previously. The Span report files are named as follows:

DBBD/RUN/SPAN/databasename/jobnumber/tasknumber/

nnnMSGFILE ON packname

First Printer Backup File

The following printer backup file is created when you run Span for the first time for a database.

DATABridge SPAN Initializing month dd, yyyy @ hh:mm:ss on host hostname.

Version 62.x.x compiled mm dd, yyyy @ hh:mm:ss

Creating new parameter file DATA/SPAN/BANKDB/CONTROL

DATABridge SPAN Terminating month dd, yyyy @ hh:mm:ss

Report File

A printer backup file similar to the following is created whenever you run Span to replicate or track a database. After the list of option settings, the Span report file shows the mode and data set name followed by the output file name:

To the left of the arrow is a description of the mode (for example, extracts or updates) and type of record.
To the right of the arrow is the actual name of the file Span used to write these records. A + (plus sign) preceding the file name indicates that the file already existed and Span appended the new records to it.

The message "DATABridge Engine: >>> [0007] Audit file 3 is unavailable; Current (active) audit file <<<" indicates why Span stopped processing. In this case, Span processed all of the available audit files and then stopped when it encountered the audit file the Accessroutines was still using.

The last part shows how many records Span wrote and skipped (due to the filter) for each data set.

DATABridge SPAN Initializing month dd, yyyy @ hh:mm:ss on host hostname

Version 62.x.x compiled mm dd, yyyy @ hh:mm:ss

Reading parameter file (DB50)DATA/SPAN/BANKDB/CONTROL ON HOST

Option settings for database BANKDB:

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

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

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

Support = (DB50)OBJECT/DATABRIDGE/SUPPORT/BANKDB ON HOST

Transform = DBTRANSFORM

Format = COMMAFORMAT

Filter = DBFILTER

Errors = Fatal

Audits = Normal

TranGroup = Checkpoint

Limit = <no limits>

Logging = Errors Warnings Informational

DataErrors= <ignore>

Clone = Online

Defaults:

Block = 100 records

Area = 1000 records

Modifies= After-images only

Extracts BANK ===> (DB50)DATA/SPAN/BANKDB/BANK ON HOST

Extracts BRANCH ===> (DB50)DATA/SPAN/BANKDB/BRANCH ON HOST

>>> [0007] Active audit file 2 is unavailable <<<

Replicated Skipped

---------- -------

BANK 7 0

BRANCH 28 0

Total records: 35 0

Thruput: 9 records/sec. CPU (excluding Extract Workers)

2 records/sec. elapsed

Final audit location: month day, year @ time, AFN = 2, ABSN = 56

DATABridge SPAN Terminating month day, year @ time