linux db2查询表空间,db2中怎么查看表空间的使用情况(SQL)

找到了

Deprecated SQL administrative routines and their replacement routines or views

In order to provide expanded support in DB2 Version 9 for the existing administrative routines, some of the DB2 UDB for Linux, UNIX, and Windows Version 8 routines have been replaced with new, more comprehensive routines or views.

Applications that use the DB2 UDB for Linux, UNIX, and Windows Version 8 table functions should be modified to use the new functions or administrative views. The new table functions have the same base names as the original functions but are suffixed with '_Vxx' for the version of the product in which they were added (for example, _V91). In most cases, the new table functions and administrative views return additional information. The administrative views will always be based on the most current version of the table functions, and therefore allow for more application portability. Since the columns might vary from one release to the next (that is, some are added and some are deleted), it is recommended that specific columns be selected from the administrative views, or that the result set be described if a SELECT * statement is used by an application.

SNAPSHOT_TBS_CFG table function

Returns configuration information from a table space snapshot.

>>-SNAPSHOT_TBS_CFG--(--dbname--,--dbpartitionnum--)-----------><

比如:

select * from table(snapshot_tbs_cfg('STUDY',-1));

其中STUDY是数据库名

-1 表示当前活动的数据库分区