Default language.

Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Unload for Db2 13.1.

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

  • MAJOR
  • MINOR

highdsnum

High data set number

Not applicable

ibmreqd

Whether the row came from the basic machine-readable material (MRM) tape

  • N (no)
  • Y (yes)

icbackup

Type of copy

  • LP (local primary copy)
  • LB (local backup copy)
  • RP (remote primary copy)
  • RB (remote backup 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

  • F (COPY FULL YES)
  • I (COPY FULL NO)
  • S (LOAD REPLACE)
  • W (REORG)
  • Y (LOAD RESUME)

icunit

Type of media of the copy data set

  • T (tape)
  • D (DASD)

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

  • Yes
  • No

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

  • I (index)
  • T (table space)
  • Blank (any other object)

pbg

Whether the object is a partition-by-growth object

  • Yes
  • No

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

  • Blank (Version 8)
  • M (Version 9)
  • O (Version 10)
  • P (Version 11 or later)

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

  • C (CHANGE)
  • R (REFERENCE)

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)

  • Yes
  • No

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

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Unload for Db2 12.1