DSTUTIL

Purpose

The DSTUTIL statement defines the possible maintenance actions that can be done on the data store database, and are usually invoked by a batch program.

The maintenance cleanup actions (DELUNSTR/DELSTRUC/DELBOTH) can be done by means of the cleanup data store task (if specified in the member identified by the CLNPARM statement).

Parameters

DELSTRUC|DELUNSTR|DELBOTH

Defines the criteria for deleting sysout from the data store database. It is possible to specify whether structured data (DELSTRUC) or unstructured data (DELUNSTR) are to be deleted. You can require to delete both types specifying DELBOTH.

The keyword DDNAME, if coded, identifies the DD name of a data set where the records will be copied before they are deleted from the database. When DELBOTH is coded, you must specify two DDnames, for the two different types of data: the first one is for the unstructured data, the second one is for the structured data).

The copy on a data set is allowed only in batch mode.

The SEARCHnn keyword (where nn can be a value from 1 to 10) identifies the criteria selected. The string value has the following format:

CodeNameComparisonOperFieldName

CodeName can assume the following values:

JBNM

Job name

JBDT

Date

JBTM

Time

JBID

Job ID

DSID

data set ID

STNM

Step name

PSNM

Procedure step name

DDNA

DD name

SYCL

SYSOUT class

OLDR

Older than

ComparisonOper can assume the following values:

EQ

Equal

NE

Not equal

GT

Greater than

GE

Greater or equal

LT

Less than

LE

Less or equal

LK

Like

UK

Unlike

MM

Month, used with OLDR codename only

DD

Days, used with OLDR codename only

HR

Hours, used with OLDR codename only

MN

Minutes, used with OLDR codename only

FieldName indicates the field where the selection is performed. For example, it can be a specific jobname if the JBNM codename has been used (JBNM EQ myjob causes all the job logs having the jobname equal to myjob to be deleted. For the LK operator, it can contain the wildcard * or ?).

Note: All dates must be specified in the format yyyymmdd. For example, the 22nd of July 2002 is coded as 20020722.

All the terms inside the SEARCHn key are logical ANDs, so they must be all true to select the sysout for the operation. The different search criteria (SEARCH1 to SEARCH10) are logical ORs, so at least one must be true to run the command.

EXPSTRUC|EXPUNSTR|EXPBOTH

Defines the criteria for exporting sysout records from the data store database. It’s possible to specify whether structured data (EXPSTRUC) or unstructured data (EXPUNSTR) are to be exported.

The keyword DDname is always required and identifies the DD name of a data set where the records will be exported. You can require to export both types specifying EXPBOTH: in this case, you must specify two different ddnames as values in the DDNAME clause. The first one is for the unstructured data, the second one is for the structured data).

The keywords used in the same clause have the same meaning specified for the parameters DELSTRUC/DELUNSTR/DELBOTH.

You can also specify selection criteria, coding the SEARCHnn keyword.

IMPORT

Defines the criteria for importing sysout records (previously stored in a sequential data set) into the data store database.

The keywords have the same meaning as those specified for the previous parameters. In addition, the REPLACE keyword specifies whether matching sysout records in the data store data base should be overwritten. The default is NO. One data set at a time can be imported (only one DDname can be coded). If both structured and unstructured data is to be imported, you must codify the parameter IMPORT twice, to process separately the structured and the unstructured export files. IMPORT can be used by the batch program only when data store is not operating.

You can also specify selection criteria, coding the SEARCHnn keyword.

RECOVER(PRIMARY)

Indicates that the batch program extracts a data set of keys for all sysout records stored in the data store database, to enable the recovery of a corrupted primary key data set. The EQQPKREC DD statement in the batch JCL identifies the name of the extracted data set. It can be used by the batch program only when the data store is not operating.

In this case, you cannot use SEARCHnn keyword to specify selection criteria, because it is not accepted.