User Tools

Site Tools


database:db2_list_cmd

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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