38IBM Sterling Connect:Direct for i5/OS User’s Guide
K enables the KQV logic trace.
D enables the
H enables the FMH dump.
V enables the XDR dump.
P enables the CIPC dump.
*ALL enables all product traces.(L, S, F, C, X, K, D, H, V, and P)
*EXT enables all product traces plus two other traces. (TRCICF and TRCJOB)
*COMMON enables the most commonly used traces. (L, S, F, C, and H)
*NONE turns off all traces.
TSPACE(avgblk, type, primary, secondary, pdsblk, rlse, contig, round)
specifies the amount of storage to be allocated for new files on the destination node.
If you specify SPACE, the DISP of the destination file must be NEW. If you do not specify SPACE and the DISP is NEW, space allocation defaults to the value obtained from the source file (unless a TTYPE has been specified). The default allocation is in blocks and, if supplied with the ROUND option, provides
This parameter is required for all new
avgblk defines the average blocksize.
type defines the space allocation. Valid options are:
CYL specifies that space is to be allocated by cylinder. TRK specifies that space is to be allocated by track.
blk specifies that space is to be allocated by the average block length of the data and is the default. The system computes the number of tracks to be allocated. If the subparameter ROUND is also specified, the system allocates the space in cylinders. ROUND is preferred because allocation is performed on cylinders in a
primary specifies the primary allocation of storage in number of units.
secondary specifies the secondary allocation of storage in number of units.
pdsblk specifies the number of PDS directory blocks to be created in the file.
rlse specifies that the unused storage allocated to the output file be released. Valid values are *YES and *NO.
contig specifies that the storage for the local allocation must be contiguous. Valid values are *YES and *NO.
round specifies that the storage allocated by average block length is rounded to an integral number of cylinders. Valid values are *YES and *NO.
TSQL (‘sql-statement’‘DSN=data-set-name’)
defines the SQL statement to be processed against the database identified by the DBPARMS parameter or the DSN containing the SQL statements. The SQL parameter is used with the optional Sterling Connect:Direct for z/OS SQL feature. This parameter is valid for Sterling Connect:Direct for z/OS nodes only.