SELECT * FROM GROUPxx.V_OSM_OBJ_DIR WHERE ODNAME = 'yy';
SELECT * FROM GROUPxx.V_OSM_04K-OBJ_TBL WHERE OTNAME = 'yy';
SELECT * FROM GROUPxx.V_OSM_32K_OBJ_TBL WHERE OTNAME = 'yy';
SELECT * FROM OAMADMIN.CBR_MGT_CLASS_TBL;
SELECT * FROM OAMADMIN.CBR_STO_CLASS_TBL;
SELECT * FROM OAMADMIN.CBR_COLLECTION_TBL;
SELECT * FROM XXXXXXXX.TAPEVOL;
The storage administrator can also use IDCAMS LISTCAT function to retrieve information on the collection names in the catalog. In order to list all data sets in the VTOC for problem analysis, you can give access to the specific individuals by using the FACILITY class profile, STGADMIN.IFG.READVTOC.volser. The default does not allow users to list data sets for which they do not have READ access.