database:db2_list_cmd
Differences
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> | ||
database/db2_list_cmd.1609532694.txt.gz ยท Last modified: 2021/01/01 21:24 by 127.0.0.1
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
