New DB2 View for Accessing DB2 Disk Storage Information

MVS

New DB2 View for Accessing DB2 Disk Storage Information

A new and improved way of accessing disk storage information for DB2 tablespaces and indexspaces is now available. The new view is more efficient and, therefore, less expensive.

This new view DB2.VSPACE can be queried using a simple SQL SELECT statement, for example:

SELECT * FROM DB2.VSPACE

The information available from this view includes:

creator
database name
number of extents
number of tracks used
number of tracks allocated (primary and secondary quantities)
name of tablespace or indexspace

Note: You will be able to access disk storage information for tablespaces and indexspaces in your database or where you are the creator.

The DB2.VSPACE view will provide information that was previously available through QMF procedures (DB2.EXTENTS, DB2.SPACE1, DB2.SPACE2) and the views underlying those procedures. We encourage you to start using the DB2.VSPACE view in place of the other QMF procedures and underlying views.

Interface 196 (June 15, 1996)

Other Issues and "Back Pages" | Comments