Results 1 to 5 of 5

Thread: DB2 error

  1. #1
    Join Date
    May 2007
    Posts
    3

    DB2 error

    hey guys and gals
    i am using DB2 version 8 with fix pack 12, on windows server 2003
    along with IBM websphere V5.1

    i got this error message which i am not able to resolve
    can any1 be of any assistance

    thanks in advance
    chris

    (ERROR MESSAGE)

    IBM][CLI Driver] SQL5005C System Error.




    Explanation:

    A system error, probably an I/O error, was encountered while
    accessing a configuration file.

    The command cannot be processed.

    User Response:

    Resubmit the command.

  2. #2
    Join Date
    Jul 2004
    Posts
    295
    Are you issueing a command at the time? What is it?
    Is there any additional information in the db2diag.log? (type db2diag from the DB2 command prompt)

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    The help for the error message tells you this:
    Code:
    $ db2 "? sql5005"
    
    
    SQL5005C System Error.
    
    Explanation:
    
    A system error, probably an I/O error, was encountered while
    accessing a configuration file.
    
     The command cannot be processed.
    
    User Response:
    
    Resubmit the command.
    
     If the error persists, check the db2diag.log file for details
    and ensure that the configuration file is accessible. If unable
    to resolve the problem, contact an IBM Service Representative for
    assistance.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  4. #4
    Join Date
    May 2007
    Posts
    3
    Quote Originally Posted by meehange
    Are you issueing a command at the time? What is it?
    Is there any additional information in the db2diag.log? (type db2diag from the DB2 command prompt)
    I get the error when ever i try to open the tables u the database
    The db2diag shows lock escalation errors on some of my tables

  5. #5
    Join Date
    May 2007
    Posts
    3

    Thumbs up

    Quote Originally Posted by chris_newbie
    hey guys and gals
    i am using DB2 version 8 with fix pack 12, on windows server 2003
    along with IBM websphere V5.1

    i got this error message which i am not able to resolve
    can any1 be of any assistance

    thanks in advance
    chris

    (ERROR MESSAGE)

    IBM][CLI Driver] SQL5005C System Error.




    Explanation:

    A system error, probably an I/O error, was encountered while
    accessing a configuration file.

    The command cannot be processed.

    User Response:

    Resubmit the command.
    my team and I have resolved the problem
    Solution
    My SQLCONF(this is the configuration file for ur database) file in the C:\DB2\NODE0000\SQL00001 directory was corrupted
    so i deleted it( or u could just rename it)

    run this script at command promt
    Connect to database "db name"
    and DB2 will recreate the SQLCONF file and your db is good to go again

    thanks felllas for your 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
  •