Dump |
Scroll |
Dump data from a z/OS LogStream source URL only. The action is non-destructive and must be used prior to any use of the clean action to confirm the content of the source.
Syntax
sqdutil dump zlog:///<logstream_name> [options]
Parameters
zlog:///<logstream_name> - The (localhost) source URL for the z/OS LogStream to be dumped.
Options
--count=<number> - Specifies the number of log records to be extracted and printed.
--start-bid=0x<bid_value> - Specifies the block id (bid) from which to start extracting and printing log records.
--start-stck=0x<stck_value> - Specifies the Storeclock (STCK) from which to start extracting and printing log records.
--stop-bid=0x<bid_value> - Specifies the block id (bid) from which to stop extracting and printing log records.
--stop-stck=0x<stck_value> - Specifies the storeclock (STCK) from which to stop extracting and printing log records.
--summary - Prints the first five (5) units-of-work and the last five (5) units-of-work in a logstream.
--tail - Prints the last two (2) units-of-work in a logstream. When used with --count, the last number of records are printed.
Notes:
1.The LogStream name must not be enclosed in single or double quotes.
2.sqdutil is one component of the Connect CDC SQData "application". It is not a system level utility. Data in a LogStream displayed by sqdutil will be data that has not been "cleaned" by the application. Using native system utilities including ISPF to view the contents of LogStream datasets may and often will include data, that from the "application" perspective has been Published and Cleaned. The System Logger will, based on it's own configuration, physically delete either the data in those datasets and the datasets themselves.
Example 1
Dump all of the records in z/OS LogStream SQDATA.VSAMCDC.LOG1 - no options specified
//SQDUTIL EXEC PGM=SQDUTIL
//SQDPUBL DD DSN=&SYSUID.NACL.PUBLIC,DISP=SHR
//SQDPKEY DD DSN=&SYSUID.NACL.PRIVATE,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SQDPARMS DD *
dump zlog:///SQDATA.VSAMCDC.LOGn
/*
//
Sample z/OS LogStream dump containing only two records:
=== Block id=0xef85 len=210, flags=0xd0 stck=0xca92f1a4d974d004(2016-12-05-18.04.50.377550)
0 :E2 D8 C9 D3 19 D9 00 00 C9 E5 D7 F1 40 40 40 40 SQIL.R..IVP1
10 :00 00 00 1C 00 00 00 10 CA 92 F1 A4 D3 23 C0 00 .........k1uL.{.
20 :C9 E5 D7 C4 C2 F2 40 40 00 00 00 00 00 00 00 00 IVPDB2 ........
30 :C1 F1 F1 F1 F1 F1 F1 F1 00 00 00 0A 00 0A 00 78 A1111111........
40 :00 01 00 28 00 82 00 28 00 00 00 AA 00 00 00 00 .....b..........
50 :C7 C5 D6 D9 C7 C5 40 40 D4 D7 D7 40 40 40 40 40 GEORGE MPP
60 :C4 C6 E2 C9 E5 D7 F2 40 C4 C6 E2 C9 E5 D7 F2 40 DFSIVP2 DFSIVP2
70 :C9 E5 E3 D5 E5 40 40 40 C8 D6 D4 C5 D9 40 40 40 IVTNV HOMER
80 :40 40 C8 D6 D4 C5 D9 40 40 40 40 40 D1 D6 D5 C5 HOMER JONE
90 :E2 40 40 40 40 40 E3 F4 F4 F4 F3 40 40 40 40 40 S T4443
A0 :F2 F2 F2 F2 F2 40 40 40 40 40 C8 D6 D4 C5 D9 40 22222 HOMER
B0 :40 40 40 40 D1 D6 D5 C5 E2 40 40 40 40 40 E3 F3 JONES T3
C0 :F3 F3 F3 40 40 40 40 40 F2 F2 F2 F2 F2 40 40 40 333 22222
D0 :40 40
=== Block id=0xf07f len=32, flags=0xd0 stck=0xca92f1a4e340a000(2016-12-05-18.04.50.417623)
0 :E2 D8 C9 D3 04 C3 00 00 C9 E5 D7 F1 40 40 40 40 SQIL.C..IVP1
10 :00 00 00 1C 00 00 00 10 CA 92 F1 A4 D3 23 C0 00 .........k1uL.{.
SQDC016I SQDUTIL(pid=0xba) terminated with Return Code 0, Reason Code=0x190001
Example 2
Dump the log records between LogStream block id 0x2b24408 and block id 0x2ec30ba
//SQDUTIL EXEC PGM=SQDUTIL
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SQDPARMS DD *
dump zlog:///SQDATA.VSAMCDC.LOG1
--start-bid=0x2b24408
--stop-bid=0x2ec30ba
/*
//
Example 3
Dump the log records for five IMS transactions (units-of-work) that begin on or after a Storeclock value of o0xd381de8e8b5ebbc0
//SQDUTIL EXEC PGM=SQDUTIL
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SQDPARMS DD *
dump zlog:///SQDATA.IMSCDC.LOG1
--start-stck=0xd381de8e8b5ebbc0
--count=5
/*
//
The first record when viewed in SDSF will look like the following.