Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Posts
    5

    Unanswered: SQL1039C Error on db2 7.1

    Hi Folks:

    I recently installed DB2 7.1 on Win2000.I am getting an error while trying to create a Database.These are the relevant connection information.Any help is greatly appreciated.

    Thanks

    Instance Attachment Information

    Instance server = DB2/NT 7.2.1
    Authorization ID = DB2ADMIN
    Local instance alias = DB2


    C:\>db2 create db testing
    SQL1039C An I/O error occurred while accessing the database directory.
    SQLSTATE=58031

    C:\>db2level
    DB21085I Instance "DB2" uses DB2 code release "SQL07021" with level identifier "03020105" and informational tokens "DB2 v7.1.0.43", "n010504" and "WR21254a".

    C:\>db2 list db directory

    System Database Directory

    Number of entries in the directory = 8

    Database 1 entry:

    Database alias = TBC_MD
    Database name = TBC_MD
    Database drive = C:\DB2
    Database release level = 9.00
    Comment =
    Directory entry type = Indirect
    Catalog node number = -1

    Database 2 entry:

    Database alias = RMT
    Database name = RMT
    Database drive = C:\DB2
    Database release level = 9.00
    Comment =
    Directory entry type = Indirect
    Catalog node number = -1

    Database 3 entry:

    Database alias = TEST
    Database name = TEST
    Database drive = C:\DB2
    Database release level = 9.00
    Comment =
    Directory entry type = Indirect
    Catalog node number = -1

    Database 4 entry:

    Database alias = TBC
    Database name = TBC
    Database drive = C:\DB2
    Database release level = 9.00
    Comment =
    Directory entry type = Indirect
    Catalog node number = -1

    Database 5 entry:

    Database alias = SATCTLDB
    Database name = SATCTLDB
    Node name = DB2CTLSV
    Database release level = 9.00
    Comment =
    Directory entry type = Remote
    Catalog node number = -1

    Database 6 entry:

    Database alias = DTE
    Database name = DTE
    Database drive = C:\DB2
    Database release level = 9.00
    Comment =
    Directory entry type = Indirect
    Catalog node number = -1

    Database 7 entry:

    Database alias = DWCTRLDB
    Database name = DWCTRLDB
    Database drive = C:\DB2
    Database release level = 9.00
    Comment =
    Directory entry type = Indirect
    Catalog node number = -1

    Database 8 entry:

    Database alias = SAMPLE
    Database name = SAMPLE
    Database drive = C:\DB2
    Database release level = 9.00
    Comment =
    Directory entry type = Indirect
    Catalog node number = -1

  2. #2
    Join Date
    Apr 2003
    Location
    Singapore
    Posts
    59

    Re: SQL1039C Error on db2 7.1

    Hi,
    Which user have u logged in as? while creating this database I'd log in as the instance owner and use the db2 CLP
    rgds
    brat.

    Originally posted by barani
    Hi Folks:

    I recently installed DB2 7.1 on Win2000.I am getting an error while trying to create a Database.These are the relevant connection information.Any help is greatly appreciated.

    Thanks

    Instance Attachment Information

    Instance server = DB2/NT 7.2.1
    Authorization ID = DB2ADMIN
    Local instance alias = DB2


    C:\>db2 create db testing
    SQL1039C An I/O error occurred while accessing the database directory.
    SQLSTATE=58031

    C:\>db2level
    DB21085I Instance "DB2" uses DB2 code release "SQL07021" with level identifier "03020105" and informational tokens "DB2 v7.1.0.43", "n010504" and "WR21254a".

    C:\>db2 list db directory

    System Database Directory

    Number of entries in the directory = 8

    Database 1 entry:

    Database alias = TBC_MD
    Database name = TBC_MD
    Database drive = C:\DB2
    Database release level = 9.00
    Comment =
    Directory entry type = Indirect
    Catalog node number = -1

    Database 2 entry:

    Database alias = RMT
    Database name = RMT
    Database drive = C:\DB2
    Database release level = 9.00
    Comment =
    Directory entry type = Indirect
    Catalog node number = -1

    Database 3 entry:

    Database alias = TEST
    Database name = TEST
    Database drive = C:\DB2
    Database release level = 9.00
    Comment =
    Directory entry type = Indirect
    Catalog node number = -1

    Database 4 entry:

    Database alias = TBC
    Database name = TBC
    Database drive = C:\DB2
    Database release level = 9.00
    Comment =
    Directory entry type = Indirect
    Catalog node number = -1

    Database 5 entry:

    Database alias = SATCTLDB
    Database name = SATCTLDB
    Node name = DB2CTLSV
    Database release level = 9.00
    Comment =
    Directory entry type = Remote
    Catalog node number = -1

    Database 6 entry:

    Database alias = DTE
    Database name = DTE
    Database drive = C:\DB2
    Database release level = 9.00
    Comment =
    Directory entry type = Indirect
    Catalog node number = -1

    Database 7 entry:

    Database alias = DWCTRLDB
    Database name = DWCTRLDB
    Database drive = C:\DB2
    Database release level = 9.00
    Comment =
    Directory entry type = Indirect
    Catalog node number = -1

    Database 8 entry:

    Database alias = SAMPLE
    Database name = SAMPLE
    Database drive = C:\DB2
    Database release level = 9.00
    Comment =
    Directory entry type = Indirect
    Catalog node number = -1

Posting Permissions

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