Retrieving information from the OAM DB2 databases for diagnosis

The storage administrator can use SPUFI to retrieve information from the object directory and object tables. This might be helpful in diagnosing problems. SQL statements can retrieve a variety of information, as follows:

Object directory

SELECT * FROM GROUPxx.V_OSM_OBJ_DIR WHERE ODNAME = 'yy';

4K object table

SELECT * FROM GROUPxx.V_OSM_04K-OBJ_TBL WHERE OTNAME = 'yy';

32K object table

SELECT * FROM GROUPxx.V_OSM_32K_OBJ_TBL WHERE OTNAME = 'yy';

Management class conversion table

SELECT * FROM OAMADMIN.CBR_MGT_CLASS_TBL;

Storage class conversion table

SELECT * FROM OAMADMIN.CBR_STO_CLASS_TBL;

Collection names conversion table

SELECT * FROM OAMADMIN.CBR_COLLECTION_TBL;

Optical Configuration Database
```
SELECT * FROM XXXXXXXX.TAPEVOL;
```

where:

xx - Storage group number from 00-99
yy - Object name.
xxxxxxxx is the qualifier of the ID that created the table (this information can be obtained from SYSIBM.SYSTABLES).

Note: The information from the preceding tables is crucial to the operation of OSMC. IBM® strongly advises against altering these tables.

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.