Results 1 to 6 of 6

Thread: System Tables

  1. #1
    Join Date
    Dec 2001
    Location
    Sao Paulo - Brazil
    Posts
    6

    Unanswered: System Tables

    Does anyone Know where I can find instance, catalog information, like where it's stored things such when using catalog tcpip node command or by using client configuration stuff? Does have any system table or command that shows it?

  2. #2
    Join Date
    Jan 2002
    Posts
    6

    Question

    I am not quite sure what exactly is the problem, but I think you find all the relevant information in system catalog tables.

    System catalog tables are created automatically with each database and views for these tables are defined under SYSCAT schema.

    Description of the tables can be found in SQL Reference in Appendix D.

    Hope that helps

  3. #3
    Join Date
    Dec 2001
    Location
    Sao Paulo - Brazil
    Posts
    6
    I've already seen there, but there's naught.

  4. #4
    Join Date
    Jan 2002
    Posts
    6

    Smile

    Let me redraw your scenario:

    you have an instace with no local database. you have catalogued some remote nodes and remote databases (on those nodes), and you want to list the nodes and the databases.

    If it is correct than to list nodes:

    db2 "list node directory"

    and to list databases:

    db2 "list database directory"

    If this does not help, please explain your scenario more detailed.

  5. #5
    Join Date
    Dec 2001
    Location
    Sao Paulo - Brazil
    Posts
    6
    All I want to do is a "select" on a view or system table that shows me where things are, and not sort of hiding as it seems to be.
    Oracle has views for all things, but maybe I'm being too demanding.

    All that commands I've been through, but thanks anyway and all of best.

  6. #6
    Join Date
    Jan 2002
    Posts
    6

    Unhappy

    to do a select on a instance catalog is a problem, because, imho, there are no tables for it. these information are stored in some files (some of them I know where are), but they are pretty unreadable.

    But I assume, there IS a way, sice 'db2cc' does it, but truthfully, I have no idea at the moment. I will ask around, and when I find this out, I will let you know.

    Sorry I wasnt too much of a help

Posting Permissions

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