database:db2_list_cmd
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
database:db2_list_cmd [2024/05/21 13:46] manu |
database:db2_list_cmd [2024/05/28 10:25] (current) manu [List tables] |
||
|---|---|---|---|
| Line 221: | 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 762: | 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.1716291972.txt.gz ยท Last modified: 2024/05/21 13:46 by manu
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
