Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Posts
    369

    Unanswered: db2 database tables dont appear in CLI

    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

  2. #2
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186

    Re: db2 database tables dont appear in CLI

    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

  3. #3
    Join Date
    Dec 2002
    Posts
    134

    Re: db2 database tables dont appear in CLI

    Originally posted by mixxalot
    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
    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]

  4. #4
    Join Date
    May 2003
    Posts
    369

    thanks!

    That did the trick thanks for the help

    Scott

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •