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/24 11:16] manu [List DB2 installed componenets] |
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 ==== | ||
database/db2_list_cmd.1716542174.txt.gz ยท Last modified: 2024/05/24 11:16 by manu
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
