This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
database:db2_list_cmd [2021/01/01 21:24] 127.0.0.1 external edit |
database:db2_list_cmd [2024/05/28 10:25] (current) manu [List tables] |
||
---|---|---|---|
Line 53: | Line 53: | ||
JDK 11.1.0.0 0 IBM Software Development Kit (SDK) for Java(TM) | JDK 11.1.0.0 0 IBM Software Development Kit (SDK) for Java(TM) | ||
... | ... | ||
+ | </cli> | ||
+ | |||
+ | List the database version | ||
+ | <cli prompt='$'> | ||
+ | [db2inst1@BIGFIX01 ~]$ db2 connect to BESREPOR | ||
+ | |||
+ | Database Connection Information | ||
+ | |||
+ | Database server = DB2/LINUXX8664 11.5.8.0 | ||
+ | SQL authorization ID = DB2INST1 | ||
+ | Local database alias = BESREPOR | ||
+ | |||
+ | [db2inst1@BIGFIX01 ~]$ db2 "SELECT fixpack_num, service_level FROM TABLE (sysproc.env_get_inst_info()) as informationOfInstance" | ||
+ | |||
+ | FIXPACK_NUM SERVICE_LEVEL | ||
+ | ----------- -------------------------------------------------------------------------------------------------------------------------------- | ||
+ | 0 DB2 v11.5.8.0 | ||
+ | |||
+ | 1 record(s) selected. | ||
</cli> | </cli> | ||
Line 202: | Line 221: | ||
</cli> | </cli> | ||
+ | |||
+ | ==== List tables ==== | ||
+ | |||
+ | List all tables using list tables or list tables for all | ||
+ | <cli prompt='$'> | ||
+ | [db2inst1@LINVH ~]$ db2 LIST TABLES for all | grep ADM | ||
+ | ADMINFIELDS DBO T 2017-02-09-10.17.01.153303 | ||
+ | COMPUTER_ADMINISTRATORS DBO T 2017-02-09-10.17.01.547467 | ||
+ | ADMINTABCOMPRESSINFO SYSIBMADM V 2021-07-26-16.07.45.473279 | ||
+ | ADMINTABINFO SYSIBMADM V 2021-07-26-16.07.45.460435 | ||
+ | </cli> | ||
+ | |||
+ | ==== Select on table ==== | ||
==== DB2 Database Manager Configuration ==== | ==== DB2 Database Manager Configuration ==== | ||
Line 743: | Line 775: | ||
</cli> | </cli> | ||
+ | ===== List DB2 installed componenets ===== | ||
+ | |||
+ | <cli prompt='#'> | ||
+ | [root@lnx01]/tmp/db2/universal # ./db2ls -q -b /opt/ibm/db2/V11.5 | ||
+ | |||
+ | Install Path : /opt/ibm/db2/V11.5 | ||
+ | |||
+ | Feature Response File ID Level Fix Pack Feature Description | ||
+ | --------------------------------------------------------------------------------------------------------------------- | ||
+ | BASE_CLIENT 11.5.4.0 0 Base client support | ||
+ | JAVA_SUPPORT 11.5.4.0 0 Java support | ||
+ | SQL_PROCEDURES 11.5.4.0 0 SQL procedures | ||
+ | BASE_DB2_ENGINE 11.5.4.0 0 Base server support | ||
+ | DB2_DATA_SOURCE_SUPPORT 11.5.4.0 0 DB2 data source support | ||
+ | ... | ||
+ | </cli> | ||
+ | |||
+ | <cli prompt='#'> | ||
+ | [root@lnx01]/tmp/db2/universal # ./db2ls -q -a -b /opt/ibm/db2/V11.5 | ||
+ | |||
+ | Install Path : /opt/ibm/db2/V11.5 | ||
+ | |||
+ | Feature Response File ID Level Fix Pack Feature Description | ||
+ | --------------------------------------------------------------------------------------------------------------------- | ||
+ | BASE_CLIENT_R 11.5.4.0 0 Base Client Support for installation with root privileges | ||
+ | DB2_PRODUCT_MESSAGES_EN 11.5.4.0 0 Product Messages - English | ||
+ | BASE_CLIENT 11.5.4.0 0 Base client support | ||
+ | JAVA_RUNTIME_SUPPORT 11.5.4.0 0 Java Runtime Support | ||
+ | DB2_JAVA_HELP_EN 11.5.4.0 0 Java Help (HTML) - English | ||
+ | BASE_DB2_ENGINE_R 11.5.4.0 0 Base server support for installation with root privileges | ||
+ | GSK 11.5.4.0 0 Global Secure ToolKit | ||
+ | ... | ||
+ | </cli> |