zOs/WK/XBCHKLST
Select XBC181_CREATOR , XBC181_TABNAME, XBC181_PARTNR
, (select partitions
from sysibm.sysTablespace ts, sysibm.sysTables t
where t.creator = x.XBC181_CREATOR
and t.Name = x.XBC181_TABNAME
and ts.dbName = t.dbName
and ts.name = t.tsName
) parts
, i.creator ixCreator, i.name ix, ip.partition ixPart
From bua.tXBC181 x
left join sysibm.sysIndexes i
on i.tbCreator = x.XBC181_CREATOR
and i.tbName = x.XBC181_TABNAME
left join sysibm.sysIndexPart ip
on ip.ixCreator = i.creator
and ip.ixName = i.name
and ip.partition = x.XBC181_PARTNR
Where XBC181_STATUS = 'UL'
order by 1, 2, 3
$#out 20130314 12:01:48
XBC181_C XBC181_TABNAME NR TS IXC IX RT
BUA XBAI4001HS001001 1 1 BUA IPAI4010 1
BUA XBA1J001HS001001 1 1 BUA IPA1J007 1
BUA XBA8X001HS001001 1 1 BUA IPA8X010 1
BUA XBA8X001PM001002 1 1 BUA IPA8X003 1
BUA XBA8X001PM001002 1 1 BUA IPA8X002 1
BUA XBA8X001PM001003 1 1 BUA IPA8X004 1
BUA XBA8X001PS001001 1 1 BUA IPA8X005 1
BUA XBA8X001PS001001 1 1 BUA IPA8X007 1
BUA XBA8X001PS001001 1 1 BUA IPA8X006 1
BUA XBA8X001PS002001 1 1 BUA IPA8X009 1
BUA XBA8X001PS002001 1 1 BUA IPA8X008 1
BUA XBBM7001HS001001 1 1 BUA IPBM7010 1
BUA XBBM7001IT002001 1 1 BUA IPBM7003 1
BUA XBBM7001PS001001 1 1 BUA IPBM7009 1
BUA XBBM7001PS001001 1 1 BUA IPBM7008 1
BUA XBBM7001PS001001 1 1 BUA IPBM7007 1
BUA XBBM7001PS001001 1 1 BUA IPBM7006 1
BUA XBBM7001PS001001 1 1 BUA IPBM7005 1
BUA XBBM7001PS001001 1 1 BUA IPBM7004 1
BUA XBBM7001PS002001 1 1 BUA IPBM7002 1
BUA XBBM7001PS002001 1 1 BUA IPBM7001 1
BUA XBB88001IT003001 1 2 BUA IPB88002 1
BUA XBCU1001HS001001 1 1 BUA IPCU1010 1
BUA XBCU1001IT002001 1 1 BUA IPCU1003 1
BUA XBCU1001PS001001 1 1 BUA IPCU1005 1
BUA XBCU1001PS001001 1 1 BUA IPCU1004 1
BUA XBCU1001PS001001 1 1 BUA IPCU1009 1
BUA XBCU1001PS001001 1 1 BUA IPCU1008 1
BUA XBCU1001PS001001 1 1 BUA IPCU1007 1
BUA XBCU1001PS001001 1 1 BUA IPCU1006 1
BUA XBCU1001PS002001 1 1 BUA IPCU1002 1
BUA XBCU1001PS002001 1 1 BUA IPCU1001 1
BUA XBCZT001HS001001 1 1 BUA IPCZT008 1
BUA XBCZ1001HS001001 1 1 BUA IPCZ1006 1
BUA XBCZ1001IT002001 1 1 BUA IPCZ1003 1
BUA XBCZ1001PS001001 1 1 BUA IPCZ1005 1
BUA XBCZ1001PS001001 1 1 BUA IPCZ1004 1
BUA XBCZ1001PS002001 1 1 BUA IPCZ1002 1
BUA XBCZ1001PS002001 1 1 BUA IPCZ1001 1
BUA XBDJJ001IT002001 1 2 BUA IPDJJ001 1
BUA XBDMZ001IT002001 1 2 BUA IPDMZ001 1
BUA XBDPL001IT002001 1 16 --- --- --
BUA XBDPL001IT002001 2 16 --- --- --
BUA XBDPL001IT002001 3 16 --- --- --
BUA XBDPL001IT002001 4 16 --- --- --
BUA XBDPL001IT002001 5 16 --- --- --
BUA XBDPL001IT002001 6 16 --- --- --
BUA XBDPL001IT002001 7 16 --- --- --
BUA XBDPL001IT002001 8 16 --- --- --
BUA XBDPL001IT002001 9 16 --- --- --
BUA XBDPL001IT002001 10 16 --- --- --
BUA XBDPL001IT002001 11 16 --- --- --
BUA XBDPL001IT002001 12 16 --- --- --
BUA XBDPL001IT002001 13 16 --- --- --
BUA XBDPL001IT002001 14 16 --- --- --
BUA XBDPL001IT002001 15 16 --- --- --
BUA XBDPL001PS001001 1 16 --- --- --
BUA XBDPL001PS001001 2 16 --- --- --
BUA XBDPL001PS001001 3 16 --- --- --
BUA XBDPL001PS001001 4 16 --- --- --
BUA XBDPL001PS001001 5 16 --- --- --
BUA XBDPL001PS001001 6 16 --- --- --
BUA XBDPL001PS001001 7 16 --- --- --
BUA XBDPL001PS001001 8 16 --- --- --
BUA XBDPL001PS001001 9 16 --- --- --
BUA XBDPL001PS001001 10 16 --- --- --
BUA XBDPL001PS001001 11 16 --- --- --
BUA XBDPL001PS001001 12 16 --- --- --
BUA XBDPL001PS001001 13 16 --- --- --
BUA XBDPL001PS001001 14 16 --- --- --
BUA XBDPL001PS001001 15 16 --- --- --
BUA XBDPL001PS002001 1 16 --- --- --
BUA XBDPL001PS002001 2 16 --- --- --
BUA XBDPL001PS002001 3 16 --- --- --
BUA XBDPL001PS002001 4 16 --- --- --
BUA XBDPL001PS002001 5 16 --- --- --
BUA XBDPL001PS002001 6 16 --- --- --
BUA XBDPL001PS002001 7 16 --- --- --
BUA XBDPL001PS002001 8 16 --- --- --
BUA XBDPL001PS002001 9 16 --- --- --
BUA XBDPL001PS002001 10 16 --- --- --
BUA XBDPL001PS002001 11 16 --- --- --
BUA XBDPL001PS002001 12 16 --- --- --
BUA XBDPL001PS002001 13 16 --- --- --
BUA XBDPL001PS002001 14 16 --- --- --
BUA XBDPL001PS002001 15 16 --- --- --
BUA XBDPV001HS001001 1 16 --- --- --
BUA XBDPV001HS001001 2 16 --- --- --
BUA XBDPV001HS001001 3 16 --- --- --
BUA XBDPV001HS001001 4 16 --- --- --
BUA XBDPV001HS001001 5 16 --- --- --
BUA XBDPV001HS001001 6 16 --- --- --
BUA XBDPV001HS001001 7 16 --- --- --
BUA XBDPV001HS001001 8 16 --- --- --
BUA XBDPV001HS001001 9 16 --- --- --
BUA XBDPV001HS001001 10 16 --- --- --
BUA XBDPV001HS001001 11 16 --- --- --
BUA XBDPV001HS001001 12 16 --- --- --
BUA XBDPV001HS001001 13 16 --- --- --
BUA XBDPV001HS001001 14 16 --- --- --
BUA XBDPV001HS001001 15 16 --- --- --
BUA XBDPV001IT002001 1 16 BUA I0001FXV_MIG 1
BUA XBDPV001IT002001 2 16 BUA I0001FXV_MIG 2
BUA XBDPV001IT002001 3 16 BUA I0001FXV_MIG 3
BUA XBDPV001IT002001 4 16 BUA I0001FXV_MIG 4
BUA XBDPV001IT002001 5 16 BUA I0001FXV_MIG 5
BUA XBDPV001IT002001 6 16 BUA I0001FXV_MIG 6
BUA XBDPV001IT002001 7 16 BUA I0001FXV_MIG 7
BUA XBDPV001IT002001 8 16 BUA I0001FXV_MIG 8
BUA XBDPV001IT002001 9 16 BUA I0001FXV_MIG 9
BUA XBDPV001IT002001 10 16 BUA I0001FXV_MIG 10
BUA XBDPV001IT002001 11 16 BUA I0001FXV_MIG 11
BUA XBDPV001IT002001 12 16 BUA I0001FXV_MIG 12
BUA XBDPV001IT002001 13 16 BUA I0001FXV_MIG 13
BUA XBDPV001IT002001 14 16 BUA I0001FXV_MIG 14
BUA XBDPV001IT002001 15 16 BUA I0001FXV_MIG 15
BUA XBDPV001PS001001 1 16 BUA I0001FXW_MIG 1
BUA XBDPV001PS001001 1 16 BUA I0001FXX_MIG 1
BUA XBDPV001PS001001 1 16 BUA I0001FY1_MIG 1
BUA XBDPV001PS001001 1 16 BUA I0001FY0_MIG 1
BUA XBDPV001PS001001 1 16 BUA I0001FXZ_MIG 1
BUA XBDPV001PS001001 1 16 BUA I0001FXY_MIG 1
BUA XBDPV001PS001001 2 16 BUA I0001FXY_MIG 2
BUA XBDPV001PS001001 2 16 BUA I0001FXZ_MIG 2
BUA XBDPV001PS001001 2 16 BUA I0001FY0_MIG 2
BUA XBDPV001PS001001 2 16 BUA I0001FY1_MIG 2
BUA XBDPV001PS001001 2 16 BUA I0001FXX_MIG 2
BUA XBDPV001PS001001 2 16 BUA I0001FXW_MIG 2
BUA XBDPV001PS001001 3 16 BUA I0001FXW_MIG 3
BUA XBDPV001PS001001 3 16 BUA I0001FXX_MIG 3
BUA XBDPV001PS001001 3 16 BUA I0001FY1_MIG 3
BUA XBDPV001PS001001 3 16 BUA I0001FY0_MIG 3
BUA XBDPV001PS001001 3 16 BUA I0001FXZ_MIG 3
BUA XBDPV001PS001001 3 16 BUA I0001FXY_MIG 3
BUA XBDPV001PS001001 4 16 BUA I0001FXY_MIG 4
BUA XBDPV001PS001001 4 16 BUA I0001FXZ_MIG 4
BUA XBDPV001PS001001 4 16 BUA I0001FY0_MIG 4
BUA XBDPV001PS001001 4 16 BUA I0001FY1_MIG 4
BUA XBDPV001PS001001 4 16 BUA I0001FXX_MIG 4
BUA XBDPV001PS001001 4 16 BUA I0001FXW_MIG 4
BUA XBDPV001PS001001 5 16 BUA I0001FXW_MIG 5
BUA XBDPV001PS001001 5 16 BUA I0001FXX_MIG 5
BUA XBDPV001PS001001 5 16 BUA I0001FY1_MIG 5
BUA XBDPV001PS001001 5 16 BUA I0001FY0_MIG 5
BUA XBDPV001PS001001 5 16 BUA I0001FXZ_MIG 5
BUA XBDPV001PS001001 5 16 BUA I0001FXY_MIG 5
BUA XBDPV001PS001001 6 16 BUA I0001FXY_MIG 6
BUA XBDPV001PS001001 6 16 BUA I0001FXZ_MIG 6
BUA XBDPV001PS001001 6 16 BUA I0001FY0_MIG 6
BUA XBDPV001PS001001 6 16 BUA I0001FY1_MIG 6
BUA XBDPV001PS001001 6 16 BUA I0001FXX_MIG 6
BUA XBDPV001PS001001 6 16 BUA I0001FXW_MIG 6
BUA XBDPV001PS001001 7 16 BUA I0001FXW_MIG 7
BUA XBDPV001PS001001 7 16 BUA I0001FXX_MIG 7
BUA XBDPV001PS001001 7 16 BUA I0001FY1_MIG 7
BUA XBDPV001PS001001 7 16 BUA I0001FY0_MIG 7
BUA XBDPV001PS001001 7 16 BUA I0001FXZ_MIG 7
BUA XBDPV001PS001001 7 16 BUA I0001FXY_MIG 7
BUA XBDPV001PS001001 8 16 BUA I0001FXY_MIG 8
BUA XBDPV001PS001001 8 16 BUA I0001FXZ_MIG 8
BUA XBDPV001PS001001 8 16 BUA I0001FY0_MIG 8
BUA XBDPV001PS001001 8 16 BUA I0001FY1_MIG 8
BUA XBDPV001PS001001 8 16 BUA I0001FXX_MIG 8
BUA XBDPV001PS001001 8 16 BUA I0001FXW_MIG 8
BUA XBDPV001PS001001 9 16 BUA I0001FXW_MIG 9
BUA XBDPV001PS001001 9 16 BUA I0001FXX_MIG 9
BUA XBDPV001PS001001 9 16 BUA I0001FY1_MIG 9
BUA XBDPV001PS001001 9 16 BUA I0001FY0_MIG 9
BUA XBDPV001PS001001 9 16 BUA I0001FXZ_MIG 9
BUA XBDPV001PS001001 9 16 BUA I0001FXY_MIG 9
BUA XBDPV001PS001001 10 16 BUA I0001FXY_MIG 10
BUA XBDPV001PS001001 10 16 BUA I0001FXZ_MIG 10
BUA XBDPV001PS001001 10 16 BUA I0001FY0_MIG 10
BUA XBDPV001PS001001 10 16 BUA I0001FY1_MIG 10
BUA XBDPV001PS001001 10 16 BUA I0001FXX_MIG 10
BUA XBDPV001PS001001 10 16 BUA I0001FXW_MIG 10
BUA XBDPV001PS001001 11 16 BUA I0001FXW_MIG 11
BUA XBDPV001PS001001 11 16 BUA I0001FXX_MIG 11
BUA XBDPV001PS001001 11 16 BUA I0001FY1_MIG 11
BUA XBDPV001PS001001 11 16 BUA I0001FY0_MIG 11
BUA XBDPV001PS001001 11 16 BUA I0001FXZ_MIG 11
BUA XBDPV001PS001001 11 16 BUA I0001FXY_MIG 11
BUA XBDPV001PS001001 12 16 BUA I0001FXY_MIG 12
BUA XBDPV001PS001001 12 16 BUA I0001FXZ_MIG 12
BUA XBDPV001PS001001 12 16 BUA I0001FY0_MIG 12
BUA XBDPV001PS001001 12 16 BUA I0001FY1_MIG 12
BUA XBDPV001PS001001 12 16 BUA I0001FXX_MIG 12
BUA XBDPV001PS001001 12 16 BUA I0001FXW_MIG 12
BUA XBDPV001PS001001 13 16 BUA I0001FXW_MIG 13
BUA XBDPV001PS001001 13 16 BUA I0001FY1_MIG 13
BUA XBDPV001PS001001 13 16 BUA I0001FY0_MIG 13
BUA XBDPV001PS001001 13 16 BUA I0001FXZ_MIG 13
BUA XBDPV001PS001001 13 16 BUA I0001FXY_MIG 13
BUA XBDPV001PS001001 13 16 BUA I0001FXX_MIG 13
BUA XBDPV001PS001001 14 16 BUA I0001FXX_MIG 14
BUA XBDPV001PS001001 14 16 BUA I0001FXZ_MIG 14
BUA XBDPV001PS001001 14 16 BUA I0001FXY_MIG 14
BUA XBDPV001PS001001 14 16 BUA I0001FY0_MIG 14
BUA XBDPV001PS001001 14 16 BUA I0001FY1_MIG 14
BUA XBDPV001PS001001 14 16 BUA I0001FXW_MIG 14
BUA XBDPV001PS001001 15 16 BUA I0001FXW_MIG 15
BUA XBDPV001PS001001 15 16 BUA I0001FY1_MIG 15
BUA XBDPV001PS001001 15 16 BUA I0001FY0_MIG 15
BUA XBDPV001PS001001 15 16 BUA I0001FXZ_MIG 15
BUA XBDPV001PS001001 15 16 BUA I0001FXY_MIG 15
BUA XBDPV001PS001001 15 16 BUA I0001FXX_MIG 15
BUA XBDPV001PS002001 1 16 BUA I0001FXU_MIG 1
BUA XBDPV001PS002001 1 16 BUA I0001FXT_MIG 1
BUA XBDPV001PS002001 2 16 BUA I0001FXT_MIG 2
BUA XBDPV001PS002001 2 16 BUA I0001FXU_MIG 2
BUA XBDPV001PS002001 3 16 BUA I0001FXU_MIG 3
BUA XBDPV001PS002001 3 16 BUA I0001FXT_MIG 3
BUA XBDPV001PS002001 4 16 BUA I0001FXT_MIG 4
BUA XBDPV001PS002001 4 16 BUA I0001FXU_MIG 4
BUA XBDPV001PS002001 5 16 BUA I0001FXU_MIG 5
BUA XBDPV001PS002001 5 16 BUA I0001FXT_MIG 5
BUA XBDPV001PS002001 6 16 BUA I0001FXT_MIG 6
BUA XBDPV001PS002001 6 16 BUA I0001FXU_MIG 6
BUA XBDPV001PS002001 7 16 BUA I0001FXU_MIG 7
BUA XBDPV001PS002001 7 16 BUA I0001FXT_MIG 7
BUA XBDPV001PS002001 8 16 BUA I0001FXT_MIG 8
BUA XBDPV001PS002001 8 16 BUA I0001FXU_MIG 8
BUA XBDPV001PS002001 9 16 BUA I0001FXU_MIG 9
BUA XBDPV001PS002001 9 16 BUA I0001FXT_MIG 9
BUA XBDPV001PS002001 10 16 BUA I0001FXT_MIG 10
BUA XBDPV001PS002001 10 16 BUA I0001FXU_MIG 10
BUA XBDPV001PS002001 11 16 BUA I0001FXU_MIG 11
BUA XBDPV001PS002001 11 16 BUA I0001FXT_MIG 11
BUA XBDPV001PS002001 12 16 BUA I0001FXT_MIG 12
BUA XBDPV001PS002001 12 16 BUA I0001FXU_MIG 12
BUA XBDPV001PS002001 13 16 BUA I0001FXU_MIG 13
BUA XBDPV001PS002001 13 16 BUA I0001FXT_MIG 13
BUA XBDPV001PS002001 14 16 BUA I0001FXT_MIG 14
BUA XBDPV001PS002001 14 16 BUA I0001FXU_MIG 14
BUA XBDPV001PS002001 15 16 BUA I0001FXU_MIG 15
BUA XBDPV001PS002001 15 16 BUA I0001FXT_MIG 15
BUA XBDQJ001IT002001 1 3 BUA IPDQJ001 1
BUA XBDQJ001IT002001 2 3 BUA IPDQJ001 2
BUA XBDT4001IT002001 1 2 BUA IPDT4001 1
BUA XBD0J001HS001001 1 1 BUA IPD0J008 1
BUA XBD1Z001HS001001 1 1 BUA IPD1Z011 1
BUA XBD19001HS001001 1 1 BUA IPD19011 1
BUA XBEHL001IT002001 1 3 BUA IPEHL003 --
BUA XBEHL001IT002001 2 3 BUA IPEHL003 --
BUA XBEIP001IT002001 1 2 BUA IPEIP001 1
BUA XBET3001IT002001 1 2 BUA IPET3003 1
BUA XBEWV001IT002001 1 2 BUA IPEWV001 1
BUA XBEYB001HS001001 1 2 BUA IPEYB008 1
BUA XBEYB001IT002001 1 4 BUA IPEYB001 1
BUA XBEYB001IT002001 2 4 BUA IPEYB001 2
BUA XBEYB001IT002001 3 4 BUA IPEYB001 3
BUA XBFYI001HS001001 1 1 BUA IPFYI014 1
BUA XBFZY001HS001001 1 1 BUA IPFZY014 1
BUA XBFZ8001HS001001 1 1 BUA IPFZ8016 1
BUA XBF2Y001HS001001 1 4 --- --- --
BUA XBF2Y001HS001001 2 4 --- --- --
BUA XBF2Y001HS001001 3 4 --- --- --
BUA XBF2Y001IT002001 1 2 BUA IPF2Y001 1
BUA XBF2Y001PS001001 1 2 BUA IPF2Y007 1
BUA XBF2Y001PS001001 1 2 BUA IPF2Y006 1
BUA XBF2Y001PS001001 1 2 BUA IPF2Y008 1
BUA XBF2Y001PS002001 1 2 BUA IPF2Y004 1
BUA XBF2Y001PS002001 1 2 BUA IPF2Y003 1
BUA XBF29001IT002001 1 2 BUA IPF29008 1
BUA XBF29001IT003001 1 2 BUA IPF29011 1
BUA XBF3O001HS001001 1 7 --- --- --
BUA XBF3O001HS001001 2 7 --- --- --
BUA XBF3O001HS001001 3 7 --- --- --
BUA XBF3O001HS001001 4 7 --- --- --
BUA XBF3O001HS001001 5 7 --- --- --
BUA XBF3O001HS001001 6 7 --- --- --
BUA XBF3O001IT002001 1 5 BUA IPF3O011 1
BUA XBF3O001IT002001 2 5 BUA IPF3O011 2
BUA XBF3O001IT002001 3 5 BUA IPF3O011 3
BUA XBF3O001IT002001 4 5 BUA IPF3O011 4
BUA XBF3O001PM001002 1 2 BUA IPF3O010 1
BUA XBF3O001PM001002 1 2 BUA IPF3O003 1
BUA XBF3O001PM001002 1 2 BUA IPF3O004 1
BUA XBF3O001PS001001 1 2 BUA IPF3O005 1
BUA XBF3O001PS001001 1 2 BUA IPF3O007 1
BUA XBF3O001PS001001 1 2 BUA IPF3O006 1
BUA XBF3O001PS001001 1 2 BUA IPF3O002 1
BUA XBF3O001PS001001 1 2 BUA IPF3O001 1
BUA XBF3O001PS001001 1 2 BUA IPF3O009 1
BUA XBF3O001PS001001 1 2 BUA IPF3O008 1
BUA XBF3O001PS002001 1 3 BUA IPF3O012 1
BUA XBF3O001PS002001 1 3 BUA IPF3O013 1
BUA XBF3O001PS002001 2 3 BUA IPF3O012 2
BUA XBF3O001PS002001 2 3 BUA IPF3O013 2
BUA XBF5I001IT002001 1 3 BUA IPF5I001 1
BUA XBF5I001IT002001 2 3 BUA IPF5I001 2
BUA XBG0O001HS001001 1 1 BUA IPG0O021 1
BUA XBG0O001IT003001 1 1 BUA IPG0O020 1
BUA XBG0O001PS003001 1 1 BUA IPG0O002 1
BUA XBG0O001PS003001 1 1 BUA IPG0O001 1
BUA XBG1E001HS001001 1 1 BUA IPG1E015 1
BUA XBG1E001IT002001 1 1 BUA IPG1E001 1
BUA XBG1E001IT003001 1 1 BUA IPG1E002 1
BUA XBG1E001PM001002 1 1 BUA IPG1E004 1
BUA XBG1E001PM001002 1 1 BUA IPG1E003 1
BUA XBG1E001PM001003 1 1 BUA IPG1E005 1
BUA XBG1E001PM001004 1 1 BUA IPG1E006 1
BUA XBG1E001PM001005 1 1 BUA IPG1E007 1
BUA XBG1E001PS001001 1 1 BUA IPG1E008 1
BUA XBG1E001PS001001 1 1 BUA IPG1E010 1
BUA XBG1E001PS001001 1 1 BUA IPG1E009 1
BUA XBG1E001PS002001 1 1 BUA IPG1E012 1
BUA XBG1E001PS002001 1 1 BUA IPG1E011 1
BUA XBG1E001PS003001 1 1 BUA IPG1E014 1
BUA XBG1E001PS003001 1 1 BUA IPG1E013 1
BUA XB9ZN001HS001001 1 1 BUA IP9ZN012 1
BUA XB9ZN001PM001003 1 1 BUA IP9ZN002 1
312 rows fetched: Select XBC181_CREATOR , XBC181_TABNAME, XBC181_PARTNR , ...
$#out 20130314 12:01:42