Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DB2 start error 2

Status
Not open for further replies.

AlucardBelmont

Programmer
Jan 30, 2005
3
TW
can anybody please help me? :(
my DB2 suddenly can't start after I clean my computer(defragment,tidy directory,spyware,msconfig, etc..)
I'm sure I don't make any chance to important system directory.
I'm using Windows XP SP2 ,the IBM DB2 version is 8.1

The error message is
SQL6031N db2nodes.cfg files, line 0 error. error message "11",
maybe not so accurate, I translate it from chinese message.

the content of my db2nodes.cfg is
0 chnbpc0010 CHNBPC0010 0

I found this application crash when I restart my computer.
szAppName : db2jds.exe
szAppVer : 8.1.0.36
szModName : unknown
szModVer : 0.0.0.0
offset : 00000000

the content of db2diag.log

DiagData
71e8 ffff q...

2005-04-09-10.58.01.908000 Instance:DB2 Node:000
PID:1812(db2.exe) TID:1740 Appid:none
oper system services sqloReadDb2nodes Probe:50

Unable to add TCP/IP port range from 60000 to 60003 to services file

2005-04-09-11.31.01.344000 Instance:DB2 Node:000
PID:956(db2bp.exe) TID:240 Appid:none
oper system services sqloReadDb2nodes Probe:50

Unable to add TCP/IP port range from 60000 to 60003 to services file


the content of my services file

DB2_DB2 60000/tcp
DB2_DB2_1 60001/tcp
DB2_DB2_2 60002/tcp
DB2_DB2_END 60003/tcp
db2c_DB2 50000/tcp
DB2_DB2CTLSV 60004/tcp
DB2_DB2CTLSV_1 60005/tcp
DB2_DB2CTLSV_2 60006/tcp
DB2_DB2CTLSV_END 60007/tcp
db2c_DB2CTLSV 50001/tcp


thnx
 
thanks for the reply.
if it is possible, I don't want to reinstall DB2 , because there's some important data inside the database.
 
AlucardBelmont,

haven't had time to fully understand the full post. However if you re-install db2 you won't loose you underlying databases, you simply need to recatalog them.

Cheers
Greg
 
AlucardBelmont,

There is a thread on dbforums: that mentions this problem. It suggest you may have those ports already assigned, so to manually edit the file to use unused ones, or, more disturbingly, that the machine had spyware/malware that had grabbed the ports. HijackThis discovered and sorted the problem.

Hope this helps.
Marc
 
thanks everybody for the reply, :)
due to the shortage of time, I've reinstalled my whole computer.
MarcLodge, I've seen the thread while googling, I'm unable to find the malicious software though.
I'm able to get backup from my team, so no major harm was done.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top