Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2005
    Posts
    2

    Unanswered: How to Create a Table in SYSIBM

    Dear Firends,

    I know that all the catalog tables available in SYSIBM.*

    What is catalog tables? SYSIBM is the catalog database. Is it true?

    Now is it possible to create/catalog user defined tables in SYSIBM database.

    Is yes, pelase explain how? thans in advance. Sorry for my english. i am a new bie.

  2. #2
    Join Date
    Jan 2005
    Posts
    191
    SYSIBM is a schema - every (DB2 LUW) database has its own set of catalog tables. (In DB2 zOS its one set of catalog tables per instance - "database" has a very different meaning.) These tables are used to store a variety of system related information, including definitions of items created by users. Apart from some specialised information, no information in them is stored by INSERT or UPDATE statements.

    Why would you want to create your own catalog tables? What do you intend to store in them?

    James Campbell

  3. #3
    Join Date
    Mar 2005
    Posts
    2

    Re

    No, that's an interview question.

    They have asked me:

    "Is it possible to create/catalog your own table in SYSIBM database."

  4. #4
    Join Date
    Jan 2005
    Posts
    191
    In that case the correct answer is "I don't know".

    James Campbell

Posting Permissions

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