Results 1 to 4 of 4

Thread: DB2 LUW Catalog

  1. #1
    Join Date
    Jun 2006
    Posts
    5

    Unanswered: DB2 LUW Catalog

    Hey Folks...
    Can anyone tell me where there might be documentation on what tables comprise the catalog and what the columns are within the tables? Thanks in advance...
    Mike D.

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    IBM DB2 9.7 for Linux, UNIX, and Windows
    SQL Reference, Volume 1

    Appendix D. System catalog views

  3. #3
    Join Date
    Jun 2006
    Posts
    5
    Thank you!

  4. #4
    Join Date
    Apr 2010
    Location
    Chennai
    Posts
    4
    Hi Cowzz,

    Have u asked about the remote db catalog information? If u need to have those details, u couldn't get it within the database. You can get those details using db2cfexp utility.

    Eg:
    db2cfexp c:\filename.txt (on windows)
    db2cfexp /home/db2inst1/filename.txt (on windows)
    Execute the cmd based on ur environment & it'll be produced a file along with the catalog info.
    If u need to have the column names of the table, u can get them in the syscat.columns table.
    By

    KK

Posting Permissions

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