Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2007
    Posts
    51

    Unanswered: DB2 tables - description

    I have hundreds of tables in my DB2.
    Is there a way to get a list of them with a description of their content (the
    procedure and the transaction they are related to)?

    Thank you. Anna - Verona (Italy)

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    db2look can reproduce the ddl of all objects
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Apr 2007
    Posts
    51

    Tables Description

    Quote Originally Posted by guyprzytula
    db2look can reproduce the ddl of all objects

    Please, could you tell me what is db2look and what is a ddl?
    I use QMF for Windows or TSO.
    Thank you
    Anna - Verona (Italy)

  4. #4
    Join Date
    Jun 2006
    Posts
    471
    ddl is all the statements you need to recreate the database and objects
    db2look is a utility supplied with db2 to mimic a database
    try : start - run - db2cmd
    db2look -d dbname -e -l -x -o db2look.out
    the file db2look.out will contain all statements (data definition language)
    to recreat all objects in indicated database
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  5. #5
    Join Date
    Apr 2007
    Posts
    51

    Tables Description

    Quote Originally Posted by guyprzytula
    ddl is all the statements you need to recreate the database and objects
    db2look is a utility supplied with db2 to mimic a database
    try : start - run - db2cmd
    db2look -d dbname -e -l -x -o db2look.out
    the file db2look.out will contain all statements (data definition language)
    to recreat all objects in indicated database
    Excuse me, but do I have to write -e -l -x -o?
    Thank you
    Anna - Verona (Italy

  6. #6
    Join Date
    Jun 2006
    Posts
    471
    yes
    -e mimic plain text objects
    -l tablespaces
    -o output file
    -x grant statements
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  7. #7
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    db2look is available on the DB2 for Linux, UNIX, and Windows client, and maybe works with DB2 for z/OS if you have a remote dcs client connection. It does not work directly in DB2 for z/OS from TSO. It will not show which plans/packages (programs) the tables are bound to, except that it "may" show SQL stored procedures DDL. I doubt that this is what you are looking for.

    Many DB2 for z/OS shops have TSO applications (from IBM or 3rd party tools) that let you browse for information from the DB2 catalog. Contact your DBA about such tools.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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