SELECT DBNAME, NAME 00012006
FROM SYSIBM.SYSTABLESPACE T 00015000
WHERE NOT EXISTS 00015106
(SELECT * 00015206
FROM SYSIBM.SYSCOPY C 00015306
WHERE C.DBNAME = T.DBNAME AND C.TSNAME = T.NAME) 00015406
AND DBNAME IN( 00016007
'XB9O8117', 00017000
'XB9O9015', 00018000
'XB9O8116', 00019000
'XB9PI001', 00020000
'XB9PI002', 00030000
'XB9PI003', 00040000
'XB9P2001', 00050000
'XB9P2002', 00060000
'XB9P2003', 00070000
'XB9P2004', 00080000
'XB9P2005', 00090000
'XB9P2006', 00100000
'XB9P2007', 00110000
'XB9OM001', 00120000
'XB9OM002', 00130000
'XB9OM003', 00140000
'XB9O6001', 00150000
'XB9O6002', 00160000
'XB9O6003', 00170000
'XB9OZ001', 00180000
'XB9OZ002', 00190000
'XB9OZ003', 00200000
'XB9OJ001', 00210000
'XB9OJ002', 00220000
'XB9OJ003', 00230000
'XB9OT001', 00240000
'XB9OT002', 00250000
'XB9OT003', 00260000
'XB9OD001', 00270000
'XB9OD002', 00280000
'XB9P7001', 00290000
'XB9P7002', 00300000
'XB9OR001', 00310000
'XB9OR002', 00320000
'XB9OR003', 00330000
'XB9OB001', 00340000
'XB9OB002', 00350000
'XB9OB003', 00360000
'XB9NV001', 00370000
'XB9NV002', 00380000
'XB9P3001', 00390000
'XB9P3002', 00400000
'XB9P3003', 00410000
'XB9P3004', 00420000
'XB9ON001', 00430000
'XB9ON002', 00440000
'XB9ON003', 00450000
'XB9ON004', 00460000
'XB9ON005', 00470000
'XB9ON006', 00480000
'XB9ON007', 00490000
'XB9ON008', 00500000
'XB9ON009', 00510000
'XB9ON010', 00520000
'XB9ON011', 00530000
'XB9ON012', 00540000
'XB9ON013', 00550000
'XB9ON014', 00560000
'XB9ON015', 00570000
'XB9ON016', 00580000
'XB9ON017', 00590000
'XB9ON018', 00600000
'XB9ON019', 00610000
'XB9ON020', 00620000
'XB9ON021', 00630000
'XB9ON022', 00640000
'XB9ON023', 00650000
'XB9ON024', 00660000
'XB9ON025', 00670000
'XB9ON026', 00680000
'XB9ON027', 00690000
'XB9ON028', 00700000
'XB9ON029', 00710000
'XB9ON030', 00720000
'XB9ON031', 00730000
'XB9ON032', 00740000
'XB9ON033', 00750000
'XB9ON034', 00760000
'XB9ON035', 00770000
'XB9ON036', 00780000
'XB9ON037', 00790000
'XB9ON038', 00800000
'XB9ON039', 00810000
'XB9ON040', 00820000
'XB9ON041', 00830000
'XB9ON042', 00840000
'XB9ON043', 00850000
'XB9ON044', 00860000
'XB9O7001', 00870000
'XB9O7002', 00880000
'XB9O7003', 00890000
'XB9O7004', 00900000
'XB9O7005', 00910000
'XB9O7006', 00920000
'XB9O7007', 00930000
'XB9O7008', 00940000
'XB9O7009', 00950000
'XB9O7010', 00960000
'XB9O7011', 00970000
'XB9O7012', 00980000
'XB9O7013', 00990000
'XB9O7014', 01000000
'XB9O7015', 01010000
'XB9NR001', 01020000
'XB9NR002', 01030000
'XB9NR003', 01040000
'XB9P8001', 01050000
'XB9P8002', 01060000
'XB9OS001', 01070000
'XB9OS002', 01080000
'XB9OS003', 01090000
'XB9OC001', 01100000
'XB9OC002', 01110000
'XB9OC003', 01120000
'XB9PA001', 01130000
'XB9PA002', 01140000
'XB9PA003', 01150000
'XB9OU001', 01160000
'XB9OU002', 01170000
'XB9OU003', 01180000
'XB9OU004', 01190000
'XB9OU005', 01200000
'XB9OU006', 01210000
'XB9OE001', 01220000
'XB9OE002', 01230000
'XB9OE003', 01240000
'XB9OE004', 01250000
'XB9NY001', 01260000
'XB9NY002', 01270000
'XB9NY003', 01280000
'XB9PB001', 01290000
'XB9PB002', 01300000
'XB9PB003', 01310000
'XB9OV001', 01320000
'XB9OV002', 01330000
'XB9OV003', 01340000
'XB9OF001', 01350000
'XB9OF002', 01360000
'XB9OF003', 01370000
'XB9NZ001', 01380000
'XB9NZ002', 01390000
'XB9NZ003', 01400000
'XBAXF001', 01410000
'XBAXE001', 01420000
'XBAXD001', 01430000
'XBAXC001', 01440000
'XBAOQ001', 01450000
'XBAOQ002', 01460000
'XBAOQ003', 01470000
'XBAOP001', 01480000
'XBAOP002', 01490000
'XBAOP003', 01500000
'XBAOO001', 01510000
'XBAOO002', 01520000
'XBAON001', 01530000
'XBAON002', 01540000
'XBAON003', 01550000
'XB9ZV001', 01560000
'XB9ZV002', 01570000
'XB9ZV003', 01580000
'XB9ZU001', 01590000
'XB9ZU002', 01600000
'XB9ZU003', 01610000
'XB9ZT001', 01620000
'XB9ZT002', 01630000
'XB9ZT003', 01640000
'XB9OX001', 01650000
'XB9OX002', 01660000
'XB9OX003', 01670000
'XB9OH001', 01680000
'XB9OH002', 01690000
'XB9OH003', 01700000
'XB9O1001', 01710000
'XB9O1002', 01720000
'XB9P4001', 01730000
'XB9P4002', 01740000
'XB9P4003', 01750000
'XB9P4004', 01760000
'XB9P4005', 01770000
'XB9P4006', 01780000
'XB9P4007', 01790000
'XB9P4008', 01800000
'XB9OO001', 01810000
'XB9OO002', 01820000
'XB9OO003', 01830000
'XB9OO004', 01840000
'XB9OO005', 01850000
'XB9OO006', 01860000
'XB9OO007', 01870000
'XB9OO008', 01880000
'XB9OO009', 01890000
'XB9OO010', 01900000
'XB9OO011', 01910000
'XB9OO012', 01920000
'XB9OO013', 01930000
'XB9OO014', 01940000
'XB9OO015', 01950000
'XB9OO016', 01960000
'XB9OO017', 01970000
'XB9OO018', 01980000
'XB9OO019', 01990000
'XB9OO020', 02000000
'XB9OO021', 02010000
'XB9OO022', 02020000
'XB9OO023', 02030000
'XB9OO024', 02040000
'XB9OO025', 02050000
'XB9OO026', 02060000
'XB9OO027', 02070000
'XB9OO028', 02080000
'XB9OO029', 02090000
'XB9OO030', 02100000
'XB9OO031', 02110000
'XB9OO032', 02120000
'XB9OO033', 02130000
'XB9OO034', 02140000
'XB9OO035', 02150000
'XB9OO036', 02160000
'XB9OO037', 02170000
'XB9OO038', 02180000
'XB9OO039', 02190000
'XB9OO040', 02200000
'XB9OO041', 02210000
'XB9OO042', 02220000
'XB9OO043', 02230000
'XB9OO044', 02240000
'XB9OO045', 02250000
'XB9OO046', 02260000
'XB9OO047', 02270000
'XB9OO048', 02280000
'XB9OO049', 02290000
'XB9OO050', 02300000
'XB9OO051', 02310000
'XB9OO052', 02320000
'XB9OO053', 02330000
'XB9OO054', 02340000
'XB9OO055', 02350000
'XB9OO056', 02360000
'XB9OO057', 02370000
'XB9OO058', 02380000
'XB9OO059', 02390000
'XB9OO060', 02400000
'XB9OO061', 02410000
'XB9OO062', 02420000
'XB9OO063', 02430000
'XB9OO064', 02440000
'XB9OO065', 02450000
'XB9OO066', 02460000
'XB9OO067', 02470000
'XB9OO068', 02480000
'XB9OO069', 02490000
'XB9OO070', 02500000
'XB9OO071', 02510000
'XB9OO072', 02520000
'XB9OO073', 02530000
'XB9OO074', 02540000
'XB9OO075', 02550000
'XB9OO076', 02560000
'XB9OO077', 02570000
'XB9OO078', 02580000
'XB9OO079', 02590000
'XB9OO080', 02600000
'XB9OO081', 02610000
'XB9OO082', 02620000
'XB9OO083', 02630000
'XB9OO084', 02640000
'XB9OO085', 02650000
'XB9OO086', 02660000
'XB9OO087', 02670000
'XB9OO088', 02680000
'XB9OO089', 02690000
'XB9OO090', 02700000
'XB9OO091', 02710000
'XB9OO092', 02720000
'XB9OO093', 02730000
'XB9OO094', 02740000
'XB9OO095', 02750000
'XB9OO096', 02760000
'XB9OO097', 02770000
'XB9OO098', 02780000
'XB9OO099', 02790000
'XB9OO100', 02800000
'XB9OO101', 02810000
'XB9OO102', 02820000
'XB9OO103', 02830000
'XB9OO104', 02840000
'XB9OO105', 02850000
'XB9OO106', 02860000
'XB9OO107', 02870000
'XB9OO108', 02880000
'XB9OO109', 02890000
'XB9OO110', 02900000
'XB9OO111', 02910000
'XB9OO112', 02920000
'XB9OO113', 02930000
'XB9OO114', 02940000
'XB9OO115', 02950000
'XB9OO116', 02960000
'XB9OO117', 02970000
'XB9OO118', 02980000
'XB9OO119', 02990000
'XB9OO120', 03000000
'XB9OO121', 03010000
'XB9OO122', 03020000
'XB9OO123', 03030000
'XB9OO124', 03040000
'XB9OO125', 03050000
'XB9OO126', 03060000
'XB9OO127', 03070000
'XB9OO128', 03080000
'XB9OO129', 03090000
'XB9OO130', 03100000
'XB9OO131', 03110000
'XB9OO132', 03120000
'XB9OO133', 03130000
'XB9OO134', 03140000
'XB9OO135', 03150000
'XB9OO136', 03160000
'XB9OO137', 03170000
'XB9OO138', 03180000
'XB9OO139', 03190000
'XB9OO140', 03200000
'XB9OO141', 03210000
'XB9OO142', 03220000
'XB9OO143', 03230000
'XB9OO144', 03240000
'XB9OO145', 03250000
'XB9OO146', 03260000
'XB9OO147', 03270000
'XB9OO148', 03280000
'XB9OO149', 03290000
'XB9OO150', 03300000
'XB9OO151', 03310000
'XB9OO152', 03320000
'XB9OO153', 03330000
'XB9OO154', 03340000
'XB9OO155', 03350000
'XB9OO156', 03360000
'XB9OO157', 03370000
'XB9OO158', 03380000
'XB9OO159', 03390000
'XB9OO160', 03400000
'XB9OO161', 03410000
'XB9OO162', 03420000
'XB9OO163', 03430000
'XB9OO164', 03440000
'XB9OO165', 03450000
'XB9OO166', 03460000
'XB9OO167', 03470000
'XB9OO168', 03480000
'XB9OO169', 03490000
'XB9OO170', 03500000
'XB9OO171', 03510000
'XB9OO172', 03520000
'XB9OO173', 03530000
'XB9OO174', 03540000
'XB9OO175', 03550000
'XB9OO176', 03560000
'XB9OO177', 03570000
'XB9OO178', 03580000
'XB9OO179', 03590000
'XB9OO180', 03600000
'XB9OO181', 03610000
'XB9OO182', 03620000
'XB9OO183', 03630000
'XB9OO184', 03640000
'XB9OO185', 03650000
'XB9OO186', 03660000
'XB9OO187', 03670000
'XB9OO188', 03680000
'XB9OO189', 03690000
'XB9OO190', 03700000
'XB9OO191', 03710000
'XB9OO192', 03720000
'XB9OO193', 03730000
'XB9OO194', 03740000
'XB9OO195', 03750000
'XB9OO196', 03760000
'XB9OO197', 03770000
'XB9OO198', 03780000
'XB9OO199', 03790000
'XB9OO200', 03800000
'XB9OO201', 03810000
'XB9OO202', 03820000
'XB9OO203', 03830000
'XB9OO204', 03840000
'XB9OO205', 03850000
'XB9OO206', 03860000
'XB9OO207', 03870000
'XB9OO208', 03880000
'XB9OO209', 03890000
'XB9OO210', 03900000
'XB9OO211', 03910000
'XB9OO212', 03920000
'XB9OO213', 03930000
'XB9OO214', 03940000
'XB9OO215', 03950000
'XB9OO216', 03960000
'XB9OO217', 03970000
'XB9OO218', 03980000
'XB9OO219', 03990000
'XB9OO220', 04000000
'XB9OO221', 04010000
'XB9OO222', 04020000
'XB9OO223', 04030000
'XB9OO224', 04040000
'XB9OO225', 04050000
'XB9OO226', 04060000
'XB9OO227', 04070000
'XB9OO228', 04080000
'XB9OO229', 04090000
'XB9O8001', 04100000
'XB9O8002', 04110000
'XB9O8003', 04120000
'XB9O8004', 04130000
'XB9O8005', 04140000
'XB9O8006', 04150000
'XB9O8007', 04160000
'XB9O8008', 04170000
'XB9O8009', 04180000
'XB9O8010', 04190000
'XB9O8011', 04200000
'XB9O8012', 04210000
'XB9O8013', 04220000
'XB9O8014', 04230000
'XB9O8015', 04240000
'XB9O8016', 04250000
'XB9O8017', 04260000
'XB9O8018', 04270000
'XB9O8019', 04280000
'XB9O8020', 04290000
'XB9O8021', 04300000
'XB9O8022', 04310000
'XB9O8023', 04320000
'XB9O8024', 04330000
'XB9O8025', 04340000
'XB9O8026', 04350000
'XB9O8027', 04360000
'XB9O8028', 04370000
'XB9O8029', 04380000
'XB9O8030', 04390000
'XB9O8031', 04400000
'XB9O8032', 04410000
'XB9O8033', 04420000
'XB9O8034', 04430000
'XB9O8035', 04440000
'XB9O8036', 04450000
'XB9O8037', 04460000
'XB9O8038', 04470000
'XB9O8039', 04480000
'XB9O8040', 04490000
'XB9O8041', 04500000
'XB9O8042', 04510000
'XB9O8043', 04520000
'XB9O8044', 04530000
'XB9O8045', 04540000
'XB9O8046', 04550000
'XB9O8047', 04560000
'XB9O8048', 04570000
'XB9O8049', 04580000
'XB9O8050', 04590000
'XB9O8051', 04600000
'XB9O8052', 04610000
'XB9O8053', 04620000
'XB9O8054', 04630000
'XB9O8055', 04640000
'XB9O8056', 04650000
'XB9O8057', 04660000
'XB9O8058', 04670000
'XB9O8059', 04680000
'XB9O8060', 04690000
'XB9O8061', 04700000
'XB9O8062', 04710000
'XB9O8063', 04720000
'XB9O8064', 04730000
'XB9O8065', 04740000
'XB9O8066', 04750000
'XB9O8067', 04760000
'XB9O8068', 04770000
'XB9O8069', 04780000
'XB9O8070', 04790000
'XB9O8071', 04800000
'XB9O8072', 04810000
'XB9O8073', 04820000
'XB9O8074', 04830000
'XB9O8075', 04840000
'XB9O8076', 04850000
'XB9O8077', 04860000
'XB9O8078', 04870000
'XB9O8079', 04880000
'XB9O8080', 04890000
'XB9O8081', 04900000
'XB9O8082', 04910000
'XB9O8083', 04920000
'XB9O8084', 04930000
'XB9O8085', 04940000
'XB9O8086', 04950000
'XB9O8087', 04960000
'XB9O8088', 04970000
'XB9O8089', 04980000
'XB9O8090', 04990000
'XB9O8091', 05000000
'XB9O8092', 05010000
'XB9O8093', 05020000
'XB9O8094', 05030000
'XB9O8095', 05040000
'XB9O8096', 05050000
'XB9O8097', 05060000
'XB9O8098', 05070000
'XB9O8099', 05080000
'XB9O8100', 05090000
'XB9O8101', 05100000
'XB9O8102', 05110000
'XB9O8103', 05120000
'XB9O8104', 05130000
'XB9O8105', 05140000
'XB9O8106', 05150000
'XB9O8107', 05160000
'XB9O8108', 05170000
'XB9O8109', 05180000
'XB9O8110', 05190000
'XB9O8111', 05200000
'XB9O8112', 05210000
'XB9O8113', 05220000
'XB9O8114', 05230000
'XB9O8115', 05240000
'XB9NS001', 05250000
'XB9NS002', 05260000
'XB9NS003', 05270000
'XB9NS004', 05280000
'XB9NS005', 05290000
'XB9NS006', 05300000
'XB9NS007', 05310000
'XB9NS008', 05320000
'XB9NS009', 05330000
'XB9P5001', 05340000
'XB9P5002', 05350000
'XB9P5003', 05360000
'XB9P5004', 05370000
'XB9OP001', 05380000
'XB9OP002', 05390000
'XB9OP003', 05400000
'XB9OP004', 05410000
'XB9OP005', 05420000
'XB9OP006', 05430000
'XB9OP007', 05440000
'XB9OP008', 05450000
'XB9OP009', 05460000
'XB9OP010', 05470000
'XB9OP011', 05480000
'XB9OP012', 05490000
'XB9OP013', 05500000
'XB9OP014', 05510000
'XB9OP015', 05520000
'XB9OP016', 05530000
'XB9OP017', 05540000
'XB9OP018', 05550000
'XB9OP019', 05560000
'XB9OP020', 05570000
'XB9OP021', 05580000
'XB9OP022', 05590000
'XB9OP023', 05600000
'XB9OP024', 05610000
'XB9OP025', 05620000
'XB9OP026', 05630000
'XB9OP027', 05640000
'XB9OP028', 05650000
'XB9OP029', 05660000
'XB9OP030', 05670000
'XB9OP031', 05680000
'XB9OP032', 05690000
'XB9OP033', 05700000
'XB9OP034', 05710000
'XB9OP035', 05720000
'XB9OP036', 05730000
'XB9OP037', 05740000
'XB9OP038', 05750000
'XB9OP039', 05760000
'XB9OP040', 05770000
'XB9OP041', 05780000
'XB9OP042', 05790000
'XB9OP043', 05800000
'XB9OP044', 05810000
'XB9OP045', 05820000
'XB9OP046', 05830000
'XB9OP047', 05840000
'XB9OP048', 05850000
'XB9OP049', 05860000
'XB9OP050', 05870000
'XB9OP051', 05880000
'XB9OP052', 05890000
'XB9OP053', 05900000
'XB9OP054', 05910000
'XB9OP055', 05920000
'XB9OP056', 05930000
'XB9OP057', 05940000
'XB9OP058', 05950000
'XB9OP059', 05960000
'XB9OP060', 05970000
'XB9OP061', 05980000
'XB9OP062', 05990000
'XB9OP063', 06000000
'XB9OP064', 06010000
'XB9OP065', 06020000
'XB9OP066', 06030000
'XB9OP067', 06040000
'XB9OP068', 06050000
'XB9OP069', 06060000
'XB9OP070', 06070000
'XB9OP071', 06080000
'XB9OP072', 06090000
'XB9OP073', 06100000
'XB9OP074', 06110000
'XB9OP075', 06120000
'XB9OP076', 06130000
'XB9OP077', 06140000
'XB9OP078', 06150000
'XB9OP079', 06160000
'XB9OP080', 06170000
'XB9OP081', 06180000
'XB9OP082', 06190000
'XB9OP083', 06200000
'XB9OP084', 06210000
'XB9OP085', 06220000
'XB9OP086', 06230000
'XB9OP087', 06240000
'XB9OP088', 06250000
'XB9OP089', 06260000
'XB9OP090', 06270000
'XB9OP091', 06280000
'XB9OP092', 06290000
'XB9OP093', 06300000
'XB9OP094', 06310000
'XB9OP095', 06320000
'XB9OP096', 06330000
'XB9OP097', 06340000
'XB9OP098', 06350000
'XB9OP099', 06360000
'XB9OP100', 06370000
'XB9OP101', 06380000
'XB9OP102', 06390000
'XB9OP103', 06400000
'XB9OP104', 06410000
'XB9OP105', 06420000
'XB9OP106', 06430000
'XB9OP107', 06440000
'XB9OP108', 06450000
'XB9OP109', 06460000
'XB9OP110', 06470000
'XB9OP111', 06480000
'XB9O9001', 06490000
'XB9O9002', 06500000
'XB9O9003', 06510000
'XB9O9004', 06520000
'XB9O9005', 06530000
'XB9O9006', 06540000
'XB9O9007', 06550000
'XB9O9008', 06560000
'XB9O9009', 06570000
'XB9O9010', 06580000
'XB9O9011', 06590000
'XB9O9012', 06600000
'XB9O9013', 06610000
'XB9O9014', 06620000
'XB9NT001', 06630000
'XB9NT002', 06640000
'XB9NT003', 06650000
'XB9P6001', 06660000
'XB9P6002', 06670000
'XB9P6003', 06680000
'XB9OQ001', 06690000
'XB9OQ002', 06700000
'XB9OQ003', 06710000
'XB9OA001', 06720000
'XB9OA002', 06730000
'XB9OA003', 06740000
'XB9NU001', 06750000
'XB9NU002', 06760000
'XB9NU003') 06770000
ORDER BY DBNAME, NAME 06800006