Dump - connect_cdc_sqdata

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]

Keyword and Parameter Descriptions

Keyword	Description
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-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.

Keyword

Description

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-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.

Note:

The LogStream name must not be enclosed in single or double quotes.
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.

Dump - connect_cdc_sqdata - Latest

Connect CDC (SQData) Utilities