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.

XULDMDIA (unload data) automation control point


Use the XULDMDIA automation control point to control routing of unload files to DASD or tape devices.

The product invokes this automation control point at the beginning of the Unload phase.

(PTF BQU1777 applied) BMC AMI Reorg invokes this automation control point immediately before invoking the XULDDYNM-unload-data-set-and-discards-automation-control-point when BMC AMI Reorg dynamically allocates discarded rows during a reorganization. For more information, see DISCARDDN.

Variables

The following table describes the variables used in the XULDMDIA automation control point:

Variable name

Contents

Possible values

dbid

Database ID of the object being unloaded

Not applicable

dbname

Database name of the object being unloaded

Not applicable

dsnum

Partition number

Not applicable

format

Format of the unloaded data

  • DSN (DSNTIAUL)
  • EXT (external)
  • REP (report)
  • ARC (archive)
  • ASC (ASCII)

media

Media type

  • T (tape)
  • D (disk)

obid

Object ID of the object being unloaded

Not applicable

part

Partition number, if applicable

Not applicable

parts

Total number of partitions

Not applicable

recsize

Output record size

Not applicable

rows

Number of rows successfully unloaded

Not applicable

rowsfrom

The source of the row count

Not applicable

tapedd

Preferred tape DD name

Not applicable

tbcreator

Creator of the object being unloaded

Not applicable

tbname

Name of the table being unloaded

Not applicable

tsname

Table space name of the object being unloaded

Not applicable

Return codes

The XULDMDIA automation control point returns the following return codes:

Return code

Description

0

(default value) Signifies normal completion

No action is required.

Any other value

Abnormal termination

Set the return code to any non-zero value to cancel the entire job.

 

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

BMC AMI Unload for Db2 12.1