XSUTPOST (post-SYSCOPY) automation control point
Use the XSUTPOST automation control point to provide a control point that contains the data posted to SYSIBM.SYSCOPY.
The product invokes this automation control point just after the update to SYSIBM.SYSCOPY. Because it is invoked only when SYSIBM.SYSCOPY is updated, the automation control point is not invoked for REORG INDEX or UNLOAD utilities.
Variables
The following table describes the variables used in the XSUTPOST automation control point:
Variable name | Contents | Possible values |
|---|---|---|
authid | Authorization ID of the utility | Not applicable |
copypagesf | Total number of pages written to the copy data set. This value will match the TOTAL PAGES value reported in the DATASET SUMMARY report. | Not applicable |
cpagesf | Number of changed pages | Not applicable |
dbname | Database name of the posted object | Not applicable |
devtype | Device type | 8-character identifier |
dsname | Name of the image copy data set | Not applicable |
dsnum | Partition number (or 0 for nonpartitioned objects) | Not applicable |
dsvolser | String of up to 36 volume serial numbers of the volumes containing the image copy data set | Not applicable |
fileseqno | File sequence number on tape of the image copy data set | Not applicable |
function_attr | Type of function |
|
highdsnum | High data set number | Not applicable |
ibmreqd | Whether the row came from the basic machine-readable material (MRM) tape |
|
icbackup | Type of copy |
|
icdate | Date of the entry, in the character format yymmdd | Not applicable |
ictime | Time of the entry, in the character format hhmmss | Not applicable |
ictype | Type of entry added to SYSIBM.SYSCOPY |
|
icunit | Type of media of the copy data set |
|
instance | Current instance number | Not applicable |
ixcreator | Creator of the index that is being processed | Blank if this is a non-index function |
ixname | Name of the index that is being processed | Blank if this is a non-index function |
jobname | Job name for the utility | Not applicable |
logged | Whether the object is logged |
|
logical_part | Logical partition number | Not applicable |
lowdsnum | Version number of an index for SYSCOPY records created for a copy (ictype=F) or an index space (otype=I) An index is versioned when a VARCHAR column in the index key is lengthened. | Not applicable |
member | Group member | Not applicable |
npagesf | Number of pages in the data set | Not applicable |
oldest_version | Oldest version | Not applicable |
otype | Object type |
|
pbg | Whether the object is a partition-by-growth object |
|
pit_rba | Point-in-time RBA | Not applicable |
primary | Primary quantity used to perform the DEFINE | Value in 4-KB units |
priqty | Primary quantity from the Db2 catalog | Not applicable |
relcreated | Db2 release in which the object was created |
|
secondary | Secondary quantity used to perform the DEFINE | Value in 4-KB units |
secqty | Secondary quantity from the Db2 catalog | Not applicable |
shrlevel | Type of copy |
|
start_rba | Log RBA related to this entry | 12-digit hexadecimal value |
timestamp | Date and time of this entry | 26-character Db2 timestamp in the format yyyy-mm-dd-hh.mm.ss.tttttt |
tsname | Table space name of the posted object | Not applicable |
ttype | Table type | Not applicable |
uts | Whether the object is a universal table space (UTS) |
|
Return codes
The XSUTPOST automation control point returns the following return codes:
Return code | Description |
|---|---|
0 | Continue the run as normal |
Any other value | Abnormal termination |