It can be most useful to you, the database administrator, if you can obtain current information relating to the dbspace. The SHOWDBS function provides information such as the number of header, data, or index pages available in a dbspace when the server is offline or online.
The SHOWDBS command is similar to the DB2 SHOW DBSPACE operator command. The SHOWDBS function usually provides better performance than the SHOW DBSPACE command.
Note: | Only information about acquired dbspaces is displayed. |