database:db2_list_cmd
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
database:db2_list_cmd [2024/05/28 10:17] manu [DB2 list database] |
database:db2_list_cmd [2024/05/28 10:25] (current) manu [List tables] |
||
|---|---|---|---|
| Line 225: | Line 225: | ||
| List all tables using list tables or list tables for all | 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> | ||
| - | [db2inst1@dev-tpc ~]$ db2 LIST TABLES for all | + | ==== Select on table ==== |
| - | + | ||
| - | Table/View Schema Type Creation time | + | |
| - | ------------------------------- --------------- ----- -------------------------- | + | |
| - | ACLINHERIT LDAPDB2 T 2011-02-23-10.49.51.236767 | + | |
| - | ACLPERM LDAPDB2 T 2011-02-23-10.49.51.479535 | + | |
| - | ACLPROP LDAPDB2 T 2011-02-23-10.49.51.123359 | + | |
| - | AIXADMINGROUPID LDAPDB2 T 2011-02-23-14.55.31.528944 | + | |
| ==== DB2 Database Manager Configuration ==== | ==== DB2 Database Manager Configuration ==== | ||
database/db2_list_cmd.1716884273.txt.gz · Last modified: 2024/05/28 10:17 by manu
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
