Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2010
    Posts
    36

    Unanswered: tableid 1 in schema SYSIBM

    I don't have tableid 1 in schema SYSIBM. What I mean is I don't have table in syscat.tables with tableid 1 and schema SYSIBM. Can you tell me why?

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    If you would explain your problem more in detail with sample and correct description, somebody might help you./.
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Quote Originally Posted by shamikp View Post
    I don't have tableid 1 in schema SYSIBM. What I mean is I don't have table in syscat.tables with tableid 1 and schema SYSIBM. Can you tell me why?
    Neither do I. Why do you care?

    Andy

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    sysibm.sysboot is id 1. You won't see it in the system catalog and can't query it directly. It contains some internal info for the system catalog tables. You can see this name in the db2dart or db2ckbkp output.

Posting Permissions

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