Reporting for BMC AMI Unload
PBR TBLSPC DPBRLMD3.TXA2PR03 DB=8762 PS=0002 FILE=0001 PTNS=3 SGSZ=32
TBL 0015 TXA2PR03_TBL1
Each line of this report represents part of the object being processed:
- The first line specifies the database.tableSpace, followed by the hexadecimal value for the DBID (DB), PSID (PS), OBID (FILE), and the number of partitions (PTNS).
- The second line specifies the table OBID and name.
Objects Being Unloaded report
The Objects Being Unloaded report documents the type and size of the objects being unloaded by the utility.
DBNAME SPNAME OBID PSID PART TYPE I/J PTNS (# 4K PAGES) (# 4K PAGES) SIZE
-------- -------- ---- ---- ---- ---- --- ---- -------------- -------------- ----
DBNAME TXA2PR03 8762 0002 1 PTTS J 3 540 67 4K
DBNAME TXA2PR03 8762 0002 2 PTTS J 3 540 67 4K
DBNAME TXA2PR03 8762 0002 3 PTTS J 3 540 67 4K
TOTALS 1,620 201
Objects Unloaded report
The Objects Unloaded report documents the content, format, and size of the output file created by the utility.
DBNAME SPNAME PARTS SRT FMT UNLOAD DSNAME DEVICE LOGRBA LRCL UNLOADED UNLOADED
-------- -------- -------- --- --- -------------------------------------------- -------- ------------ ---- -------- ----------------
DBNAME TXA2PR03 3PTS NO DSN DB2USER.TXA2PR03.TBL1.UNL0.G0008V00 3390 0C70DFA488E 53 2K 28
TOTALS 28
The following table describes the columns in the Objects Unloaded report:
Column | Description |
|---|---|
DBNAME | Database name |
SPNAME | Table space name |
PARTS | Partition number or total number of partitions |
SRT | Output has been sorted |
FMT | ASC—FORMAT CSV/DELIMITED |
UNLOAD DSNAME | Unload data set name |
UNLOAD DEVICE | Unload output device type |
SYNC LOGRBA | Table log RBA |
OTPT LRCL | DCB LRECL of the output data |
BYTES UNLOADED | Bytes unloaded in KB |
ROWS UNLOADED | Number of rows unloaded |
SYSCNTL report
The SYSCNTL report documents the control files created for the BMC AMI Unload utility job.
CREATOR TABLE NAME DDNAME DSNAME DDNAME
-------- ----------------------------------------------------------- -------- -------------------------------------------- --------
DBNAME PART0004_TBL1 SYSPUNCH DBUSER.NGTUNLDC.J0441221.D0000107 SYSREC00
The following table describes the columns in the SYSCNTL report:
Column | Description |
|---|---|
CREATOR | Database name |
TABLE NAME | Table name |
DDNAME | Output LOAD statement ddname |
LOAD STATEMENT DSNAME | Output LOAD statement data set name |
SYSREC DDNAME | Corresponding output UNLOADDN ddname |
Unloaded Output report
The Unloaded Output report clearly identifies the table being unloaded for UNLOAD, UNLD, and UNLOAD TABLESPACE jobs. For unload of a single table, this report identifies the table that is being unloaded. For UNLOAD TABLESPACE jobs, this report identifies all the tables being processed in the table space.
UNLOAD DATA SET NAME ROW COUNT OBID TABLE NAME
-------------------------------------------- -------------- ---- ---------------------------
DBUSER.NGTUNLDS.J0441221.D0000107 4,993 000D OWNER1.TBNAME1
-------------- ---------------------------
4,993 TOTAL ROWS
The following table describes the columns in the Unloaded Output report:
Column | Description |
|---|---|
UNLOAD DATA SET NAME | Unload output data set name |
ROW COUNT | Number of unloaded rows in this data set |
OBID | Table object identifier |
TABLE NAME | Creator.Table names |
Partition Row Count report
The Partition Row Count report is displayed for all UNLOAD, UNLD, and UNLOAD TABLESPACE jobs.
CREATOR TABLE PART SELECT UNLOADED ROWS SKIPPED ROWS SORTED ROWS
-------- -------------------------------------------- ---- ---- --------------- --------------- ---------------
MGUM3DB MGUM3TB1 1 0001 1 999 0
MGUM3DB MGUM3TB1 1 0002 0 1,000 0
MGUM3DB MGUM3TB1 1 0003 0 1,000 0
MGUM3DB MGUM3TB1 2 0001 0 1,000 0
MGUM3DB MGUM3TB1 2 0002 0 1,000 0
MGUM3DB MGUM3TB1 2 0003 0 1,000 0
MGUM3DB MGUM3TB1 3 0001 0 1,000 0
MGUM3DB MGUM3TB1 3 0002 1 999 0
MGUM3DB MGUM3TB1 3 0003 0 1,000 0
MGUM3DB MGUM3TB1 4 0001 0 1,000 0
MGUM3DB MGUM3TB1 4 0002 0 1,000 0
MGUM3DB MGUM3TB1 4 0003 0 1,000 0
MGUM3DB MGUM3TB1 5 0001 0 1,000 0
MGUM3DB MGUM3TB1 5 0002 0 1,000 0
MGUM3DB MGUM3TB1 5 0003 1 999 0
MGUM3DB MGUM3TB1 6 0001 0 1,000 0
MGUM3DB MGUM3TB1 6 0002 0 1,000 0
MGUM3DB MGUM3TB1 6 0003 0 1,000 0
MGUM3DB MGUM3TB1 7 0001 0 1,000 0
MGUM3DB MGUM3TB1 7 0002 0 1,000 0
MGUM3DB MGUM3TB1 7 0003 0 1,000 0
MGUM3DB MGUM3TB1 8 0001 0 1,000 0
MGUM3DB MGUM3TB1 8 0002 0 1,000 0
MGUM3DB MGUM3TB1 8 0003 0 1,000 0
MGUM3DB MGUM3TB1 9 0001 0 1,000 0
MGUM3DB MGUM3TB1 9 0002 0 1,000 0
MGUM3DB MGUM3TB1 9 0003 0 1,000 0
MGUM3DB MGUM3TB1 10 0001 0 999 0
MGUM3DB MGUM3TB1 10 0002 0 999 0
MGUM3DB MGUM3TB1 10 0003 0 999 0
MGUM3DB MGUM3TB2 1 0004 0 333 0
MGUM3DB MGUM3TB2 2 0004 1 332 0
MGUM3DB MGUM3TB2 3 0004 0 333 0
TOTALS : 4 30,992 0
The following table describes the columns in the Partition Row Count report:
Column | Description |
|---|---|
CREATOR | Creator name |
TABLE | Table name |
PART | Unloaded partition number |
SELECT | Relative SELECT number |
UNLOADED ROWS | Rows unloaded for each part |
SKIPPED ROWS | Unselected rows for each part |
SORTED ROWS | Rows sorted during the ORDER BY processing |