DB2 error

chris_newbie · #1 (**permalink**) 05-09-07, 16:46

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.

meehange · #2 (**permalink**) 05-09-07, 20:54

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)

stolze · #3 (**permalink**) 05-10-07, 04:29

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.

chris_newbie · #4 (**permalink**) 05-10-07, 12:14

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

chris_newbie · #5 (**permalink**) 05-10-07, 17:58

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

Internet Services

Web Development

Digital Marketing

Consumer Tech