SQL queries used for the discovery of IBM DB2 database

Last published : Jul 06, 2026
The InfoScale Operations Manager agentlet uses the following SQL queries to discover IBM DB2 database:
  • db2_home_dir/sqllib/adm/db2licm -l
  • db2_home_dir/sqllib/bin/db2 get dbm configuration
  • db2_home_dir/sqllib/bin/db2 list database directory
  • db2_home_dir/sqllib/bin/db2 connect to <database_name>
  • db2_home_dir/sqllib/bin/db2 get db configuration for <database_name>
  • db2_home_dir/sqllib/bin/db2 list tablespaces show detail
  • db2_home_dir/sqllib/bin/db2 list tablespace containers for <tablespace_name> show detail
  • For IBM DB2 versions earlier than 9.7:
print J "su $sid -c \" $home_dir/sqllib/bin/db2 connect to $db_name\; $home_dir/sqllib/bin/db2 \\\"select TABLESPACE_NAME,total_pages as TBSPC_Pages, USED_PAGES, PAGE_SIZE, TABLESPACE_STATE, TBS_CONTENTS_TYPE, FREE_PAGES, EXTENT_SIZE, PREFETCH_SIZE, NUM_CONTAINERS, USABLE_PAGES from table (snapshot_tbs_cfg (\'$db_name\',-2)) as snapshot_tbs_cfg\\\"; $home_dir/sqllib/bin/db2 disconnect $db_name\"";
  • For IBM DB2 version 9.7 or later:
print J "su $sid -c \" $home_dir/sqllib/bin/db2 connect to $db_name\; $home_dir/sqllib/bin/db2 \\\"SELECT TBSP_NAME as TABLESPACE_NAME, TBSP_TOTAL_PAGES as TBSPC_Pages, TBSP_USED_PAGES as USED_PAGES, TBSP_PAGE_SIZE as PAGE_SIZE, TBSP_STATE as TABLESPACE_STATE, TBSP_CONTENT_TYPE as TBS_CONTENTS_TYPE , TBSP_FREE_PAGES as FREE_PAGES, TBSP_EXTENT_SIZE as EXTENT_SIZE, TBSP_PREFETCH_SIZE as PREFETCH_SIZE, TBSP_NUM_CONTAINERS as NUM_CONTAINERS, TBSP_USABLE_PAGES as USABLE_PAGES FROM TABLE(MON_GET_TABLESPACE('',-1)) AS snapshot_tbs_cfg\\\"; $home_dir/sqllib/bin/db2 disconnect $db_name\"";
  • db2_home_dir/sqllib/bin/db2
More Information
Application setup requirements for IBM DB2 discovery