If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DB2 error

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
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.
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Jul 2004
Posts: 292
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)
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On