Clean, meaning remove data from a z/OS LogStream source URL only. The action is destructive, the source records are permanently removed from the source.
Syntax
sqdutil clean zlog:///<logstream_name> [options]
Keyword and Parameter Descriptions
| Keyword | Description |
|---|---|
| zlog:///<logstream_name> | The source URL for the z/OS LogStream to be cleaned. Note: The logstream_name must not be enclosed in single or double quotes.
|
| [options] |
|
Warning: Use caution when running sqdutil clean to delete records from a z/OS LogStream. Cleaning records from an active LogStream (i.e. one being monitored by a publisher) may cause the publisher to terminate abnormally. You may also want to avoid cleaning CICS forward recovery logs unless they are only being used for changed data capture and not actual recovery purposes.
Warning: SQDutil knows nothing about the content of the LogStream specified. It can clean any LogStream the user has write access to, including possibly a VSAM forward recovery log or even a system zlog.
Example 1
Delete all of the records in z/OS LogStream SQDATA.VSAMCDC.LOGn
//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 *
clean zlog:///SQDATA.VSAMCDC.LOGn --all
/*
//Example 2
Delete z/OS LogStream records that have an IMS Storeclock (STCK) value less than or equal to 0xd381de8e8b5ebbc0
//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 *
clean zlog:///SQDATA.IMSCDC.LOGn --stck=0xd381de8e8b5ebbc0
/*
//