DB2 Version 9.7 for Linux, UNIX, and Windows

LIST TABLESPACES and LIST TABLESPACE CONTAINERS commands have been deprecated

The commands and APIs that show information about table spaces and table space containers have been deprecated and might be removed in a future release.

Details

The LIST TABLESPACES [SHOW DETAIL] and LIST TABLESPACE CONTAINERS commands are no longer being updated with new features.

As a result, the following data structure and APIs are also deprecated:

SQLB_TBSPQRY_DATA data structure
sqlbctsq API
sqlbftsq API
sqlbftpq API
sqlbgtss API
sqlbmtsq API
sqlbotsq API
sqlbstpq API
sqlbstsq API
sqlbtcq API

User response

Modify any of your existing scripts using the deprecated commands or APIs to call the MON_GET_TABLESPACE or the MON_GET_CONTAINER table functions instead. These table functions return more information than was provided by the deprecated commands and APIs.