Hi,
I am using "DB2 v8.1.14.292" version of DB2 on windows XP SP2 machine.
While starting the m/c, I m getting the SQL6031N error:
Error in db2nodes.cfg file at line no "" reason code "".
After checking the services my DB2 - DB2-0, DB2 Governor and DB2 JDBC Applet Server : services are not running, in this first n last services are automatic, and an attempt to start the above services also fails.
My db2nodes.cfg has following entry:
0 aa-d07295811445 AA-D07295811445 0
My user is "aa", which is the member of db2admin group.
Also I have tried to start the m/c by removing 1 entry at a time i.e.
first with 0 aa-d07295811445 0 and secondly with 0 AA-D07295811445 0. But that is of no result.
My db2diag.txt contents are also given below.
Please suggest ASAP.
Thanks & Regards
Amit Kanodia
db2diag.txt
2006-12-01-11.21.21.828000+330 I147130H368 LEVEL: Severe
PID : 2460 TID : 2484 PROC : db2jds.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleInitApplicationEnvironment, probe:32
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0099F864 : 71E8 FFFF q...
2006-12-01-11.21.24.125000+330 I147500H368 LEVEL: Severe
PID : 2460 TID : 2484 PROC : db2jds.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleInitApplicationEnvironment, probe:32
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0099F3DC : 71E8 FFFF q...
2006-12-01-11.28.52.281000+330 I147870H353 LEVEL: Severe
PID : 1952 TID : 1520 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:140
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0097FBBC : 71E8 FFFF q...
2006-12-01-11.31.58.578000+330 I148225H367 LEVEL: Severe
PID : 1172 TID : 3252 PROC : db2bp.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleInitApplicationEnvironment, probe:32
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0012FED0 : 71E8 FFFF q...
2006-12-01-11.31.58.578000+330 I148594H349 LEVEL: Severe
PID : 1172 TID : 3252 PROC : db2bp.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, command line process, clp_bp_main, probe:2
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0012FF20 : 71E8 FFFF q...
2006-12-01-11.32.57.453000+330 I148945H370 LEVEL: Severe
PID : 3244 TID : 3248 PROC : db2javit.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleInitApplicationEnvironment, probe:32
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0010DAD0 : 71E8 FFFF q...
2006-12-01-11.33.01.281000+330 I149317H367 LEVEL: Severe
PID : 3648 TID : 3888 PROC : javaw.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleInitApplicationEnvironment, probe:32
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0006F220 : 71E8 FFFF q...
2006-12-01-11.33.10.781000+330 I149686H367 LEVEL: Severe
PID : 3648 TID : 3888 PROC : javaw.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleInitApplicationEnvironment, probe:32
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0006F4DC : 71E8 FFFF q...
2006-12-01-11.33.13.109000+330 I150055H367 LEVEL: Severe
PID : 3648 TID : 3888 PROC : javaw.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleInitApplicationEnvironment, probe:32
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0006F498 : 71E8 FFFF q...
2006-12-01-11.38.57.593000+330 I150424H370 LEVEL: Severe
PID : 1484 TID : 2248 PROC : db2javit.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleInitApplicationEnvironment, probe:32
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0010DAD0 : 71E8 FFFF q...
2006-12-01-11.39.00.750000+330 I150796H367 LEVEL: Severe
PID : 3332 TID : 2168 PROC : javaw.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleInitApplicationEnvironment, probe:32
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0006F220 : 71E8 FFFF q...
2006-12-01-11.39.05.953000+330 I151165H367 LEVEL: Severe
PID : 3332 TID : 2168 PROC : javaw.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleInitApplicationEnvironment, probe:32
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0006F4DC : 71E8 FFFF q...
2006-12-01-11.39.08.234000+330 I151534H367 LEVEL: Severe
PID : 3332 TID : 2168 PROC : javaw.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleInitApplicationEnvironment, probe:32
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0006F498 : 71E8 FFFF q...
2006-12-01-11.47.09.281000+330 I151903H353 LEVEL: Severe
PID : 1964 TID : 1996 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:140
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0097FBBC : 71E8 FFFF q...
2006-12-01-11.47.09.296000+330 I152258H368 LEVEL: Severe
PID : 2000 TID : 2012 PROC : db2jds.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleInitApplicationEnvironment, probe:32
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0099F864 : 71E8 FFFF q...
2006-12-01-11.47.11.593000+330 I152628H368 LEVEL: Severe
PID : 2000 TID : 2012 PROC : db2jds.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleInitApplicationEnvironment, probe:32
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0099F3DC : 71E8 FFFF q...
2006-12-01-11.54.04.000000+330 I152998H372 LEVEL: Severe
PID : 2816 TID : 2820 PROC : db2systray.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleInitApplicationEnvironment, probe:32
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0012FBA8 : 71E8 FFFF q...
2006-12-01-12.13.31.250000+330 I153372H353 LEVEL: Severe
PID : 1920 TID : 2000 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:140
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0097FBBC : 71E8 FFFF q...
2006-12-01-12.13.31.281000+330 I153727H368 LEVEL: Severe
PID : 2004 TID : 2016 PROC : db2jds.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleInitApplicationEnvironment, probe:32
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0099F864 : 71E8 FFFF q...
2006-12-01-12.13.33.562000+330 I154097H368 LEVEL: Severe
PID : 2004 TID : 2016 PROC : db2jds.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleInitApplicationEnvironment, probe:32
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0099F3DC : 71E8 FFFF q...
2006-12-01-12.13.34.296000+330 I154467H372 LEVEL: Severe
PID : 1484 TID : 1344 PROC : db2systray.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleInitApplicationEnvironment, probe:32
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0012FBA8 : 71E8 FFFF q...
2006-12-01-12.16.00.734000+330 I154841H353 LEVEL: Severe
PID : 1988 TID : 1996 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:140
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0097FBBC : 71E8 FFFF q...
2006-12-01-12.16.00.734000+330 I155196H368 LEVEL: Severe
PID : 2004 TID : 2008 PROC : db2jds.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleInitApplicationEnvironment, probe:32
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0099F864 : 71E8 FFFF q...
2006-12-01-12.16.03.031000+330 I155566H368 LEVEL: Severe
PID : 2004 TID : 2008 PROC : db2jds.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleInitApplicationEnvironment, probe:32
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0099F3DC : 71E8 FFFF q...
2006-12-01-12.16.50.750000+330 I155936H372 LEVEL: Severe
PID : 2080 TID : 2084 PROC : db2systray.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleInitApplicationEnvironment, probe:32
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0012FBA8 : 71E8 FFFF q...
2006-12-01-12.26.48.078000+330 I156310H369 LEVEL: Severe
PID : 2908 TID : 2912 PROC : db2licm.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleInitApplicationEnvironment, probe:32
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0012FF00 : 71E8 FFFF q...
by: ghp7000Posted on 2006-12-01 at 06:50:10ID: 18053874
could you explain what the m/c is?
are you running an instance with the data partitioning feature activated?
can you tell me who is the owner of the db2 service? typically it is db2admin
did you create the instance yourself or was it done for you?