I notice something odd about our qa database. When I use the control center tool I can see all of the tables for our database. However when I run the db2 list tables command in the CLI I only see 2 tables. How do I get all of the tables to appear in the CLI interface when I run a simple db2 list tables command? We are running DB2 UDB 7.2 on AIX 5.2L. Thanks

Scott

Connect to the database with the user id that created the schema, db2 connect to mydb user mydata


Then it will show all the tables

If I understand your problem correctly, the following command should help:
list tables for all

By default "list tables" command shows only tables in current schema (the user name your connected to db)

Full syntax:
LIST TABLES [FOR {USER | ALL | SYSTEM | SCHEMA schema-name}] [SHOW DETAIL]

That did the trick thanks for the help

Scott