xvsamLog

 Top  Previous  Next

xvsamLog is a utility which provides you the possibility to analyze what C_ISAM has stored in the RECOVERY.LOG file, with the aim to identify all operations executed on a single record, a single file etc.

Syntax

xvsamLog [-r] [-d] [-p pid] [-f file [-x] [-k regexp]] < RECOVERY.LOG > file

Launched without any parameter, xvsamLog analyzes the input-output sequence of operations stored by C-ISAM on the RECOVERY.LOG file, and it produces a printout in a readable format.

At the moment, recognized I/O operations are :

•Begin Transaction beginning of a LUW - logical unit of work -
•Rollback LUW rollback
•Open data set OPEN
•Close data set CLOSE
•Insert insert of a new record
•Delete deletion of an existing record
•Update rewriting of an existing record
•Build data set up
•Create Index creating index record
•Erase data set removing

For each operation contained in the RECOVERY.LOG file, the following information is printed : time of operation, internal process identifier of the transaction - that, for UNIX servers, coincides with the pid of the process - and file sequence number - isfd - that is assigned at the moment of the OPEN of each file and remains unique within the transaction.

Options

-r

to print the content of each record for INSERT, DELETE and UPDATE operations

-d

to switch report to the distributive mode. In this way, all operations belonging to one single transaction are grouped and they will appear all together in the output file. Transactions will be in any case presented ordered by starting time

-p

<pid> to print only transactions with the specified identification number, that means a specific UNIX process. The UNIX process is characterized by its pid : Process ID

-f

<file> is used to print out only operations that were performed on the specified data set. <file> must contain the complete path to the file, without any extensions as i.e. .dat or .idx The distributive mode is automatically activated when this parameter is invoked and in the print out only transactions which have opened the specified file are listed

-k

<regexp> may be specified only together with the -f parameter. It extracts only operations on the specified file and the records containing the supplier string of characters <regexp>. Binary strings for comparison may be also entered; they must be prefixed by the -x parameter with indicates that the subsequent string of data is in hexadecimal format

Examples

# xvsamLog -r < RECOVERY.LOG > recovery.txt

All input-output operations and contents of each record are listed out on the RECOVERY.TXT file.

# xvsamLog -f /host/valb/data/USRCAT3/PRONTOT < RECOVERY.LOG > recovery.txt

This command extracts only the input-output operations performed by transactions which have opened the specified XVSAM file PRONTOT, belonging to the USRCAT3 catalog, and it lists them out on RECOVERY.TXT.

# xvsamLog -r -f /host/valb/data/USRCAT3/PRONTOT -x -k "^0219040[CF]" < RECOVERY.LOG > recovery.txt

This command extracts only input-output operations performed on all the records of a specified file - the XVSAM file PRONTOT from catalog USRCAT3 - which contain in their 4 first bytes the hexadecimal value X’0219040C’ or X’0219040F’.