Online views for SMDBASxx-controlled databases

The online views for each database lists the VSAM KSDS data sets in the database. The SMDBASxx member and the active database provide the data set list for the views.

The File Status column in each view displays the current status of the VSAM KSDS data set in the active database.

Related topic

Database-data-sets-and-SMDBASxx

The DBAS Status column in each view displays the current status of the VSAM KSDS data set in the SMDBASxx member.

If you change a database in the database views, the active database and the SMDBASxx member reflect the change. However, editing SMDBASxx outside the views described in this section can cause the active database and SMDBASxxto become out of synchronization. Therefore, to update an active database, BMC recommends that you update SMDBASxx by using the online views presented in this section. This process keeps the active database and the active SMDBASxx member synchronized when you make online changes that force a rebuild of the active database.

You can use the File Status and DBAS Status fields to determine a potential out-of-sync condition as follows:

A file status of DBAS only means a file that was added to the SMDBASxx member is not included in the active database.
A DBAS status of -- means a file that was removed from SMDBASxx is still included in the active database.

For more information, see:

HSM database (HSMLOGDB)
Space collector database (SPDB)
Capacity planning database (CAPDB)
Tapescan trending database (TSDB)

HSM database (HSMLOGDB)

The HSMLOGDB view can be accessed by selecting Log Database in the EZSRMHSM Menu. The HSMLOGDB view displays the following fields for each database data set:

File status
DBAS status
Data set name
Date and Time of Latest record
Date and Time of Oldest record
Total count of HSM log records

Space collector database (SPDB)

The SPDB view can be accessed by selecting Space Database in the Space Utilization Menu (EZSRMSU). The SPDB view displays the following fields for each database data set:

File status
DBAS status
Data set name
Date and Time of the Earliest detail collection interval
Date and Time of the Latest detail collection interval
Total number of days spanned for the intervals collected
Total number of intervals collected
Total record count
Total space used by the database data set
The count, space usage, and percent of total records of POOL records
The count, space usage, and percent of total records of VOLUME records
The count, space usage, and percent of total records of BOX records
The count, space usage, and percent of total records of PHYSICAL DISK records
The count, space usage, and percent of total records of SYSTEM SUMMARY records
The count, space usage, and percent of total records of APPLICATION records
The count, space usage, and percent of total records of INTERNAL records

Important

BMC AMI Storage creates INTERNAL records for each detail collection interval to summarize the data that was collected. These records are used internally by BMC AMI Storage to facilitate better reporting performance.

Capacity planning database (CAPDB)

The CAPDB view can be accessed by selecting Capacity Database in the Space Utilization Menu (EZSRMSU). The CAPDB view displays the following fields for each database data set:

File status
DBAS status
Data set name
Date of the Earliest record
Date of the Latest record
Total number of days spanned for the records collected
Total record count
Total space used by the database data set
The count, space usage, and percent of total records of POOL and VOLUME records
The count, space usage, and percent of total records of PHYSICAL DISK, BOX, and SYSTEM SUMMARY records
The count, space usage, and percent of total records of APPLICATION records
The count, space usage, and percent of total records of DATA SET records

Tapescan trending database (TSDB)

BMC.AMISTG.SPE2301

The TSDB view can be accessed by selecting Tape Scan Trending in the Space Utilization Menu (EZSRMSU), or the Trending Database in the Tape Node Trend EZMenu (TTRNDEZ). The TSDB view displays the following fields for each database data set:

File status
DBAS status
Data set name
Date of the Earliest record
Date of the Latest record
Total number of days spanned for the records collected
Total record count
Total space used by the database data set
The count, space usage, and percent of total records of Node Level records