This topic describes the additional information that
BMC AMI Reorg
sends to the SUMMARY DD for LOB table spaces.
The LOBS ON BASE TBL section is included in the Internal IDS report for each defined LOB column, showing the auxiliary table space and index for each LOB column.
InformationExample
- INTERNAL IDS REPORT
- TABLESPACE BI12DWWA.PBRLOB01 DB=0112 PS=008C FILE=008B PTNS=4 SGSZ=16
- TBL 008D TEST_PBRLOB01_TBL1
- PTGIX DBPROD1.FAKE PIX FANSET=0000 PGSET=0000 TYPE=DF KYLEN=4 KYCOLS=1
- C NPI DBPROD1.RLOBIX02 FANSET=00A8 PGSET=00A9 TYPE=UF KYLEN=4 KYCOLS=1
- NPI DBPROD1.RLOBIX26 FANSET=00EB PGSET=00EC TYPE=DF KYLEN=13 KYCOLS=2
- LOBS ON BASE TBL COL #26
- FILE FSET AUX AUX
- PART OBID OBID TSNAME IXSPACE
- ---- ---- ---- -------- --------
- 1 0003 000D QAS Q9098IX1
- 2 0005 000F QBS Q9091CNW
For more information about this report, see Reporting for BMC AMI Reorg.
The LOBs space report documents the type and size of the LOB objects being processed.
InformationExample
LOBS SPACE REPORT TABL ALLOCATED USED SPACE PG NO. NO.
TSNAME IXNAME TYPE COL# PART OBID PSID I/J (# 4K PAGES) (# 4K PAGES) SZ XTNT DSET
-------- -------- ----- ---- ---- ---- ---- --- -------------- -------------- --- ---- ----
LOBC10 LOBTS 12 1 000C 000D I 360 21 4K 1 1
LXLOBC10 LOBIX 12 1 0018 0019 I 180 180 4K 1 1
LOBC11 LOBTS 13 1 000E 000F I 54,180 50,277 4K 20 1
LXLOBC11 LOBIX 13 1 001A 001B I 540 540 4K 2 1
LOBC17 LOBTS 19 1 0010 0011 I 360 21 4K 1 1
LXLOBC17 LOBIX 19 1 001C 001D I 180 180 4K 1 1
TOTALS 55,800 51,219
The data set summary report documents the size of the base table space by partition.
InformationExample
PARTITION DATASET SUMMARY
CNTL EMPTY PTR OFLOW VERSIONED NULL CLIX
PART PAGES PAGES PAGES ROWS ROWS ROWS DISCARDS ROWS ROWS
---- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
1 65,509 5 28 65,472 0 0 0 0
2 65,509 5 28 65,472 0 0 0 0
3 65,509 5 28 65,472 0 0 0 0
4 65,509 5 28 65,472 0 0 0 0
5 65,509 5 28 65,472 0 0 0 0
6 65,509 5 28 65,472 0 0 0 0
