Discussion:
After fixpack upgrade my DB2 won't start
(too old to reply)
Christian Pedersen
2007-08-16 21:07:21 UTC
Permalink
Hi All

I've just installed 8.2 32bit on a RedHat Enterprise, and as always I've verified that after the install I could start, create db, drop db, and stop the db2 sucessfully. That worked fine.

I then upgraded to Fixpack 15 using the ./installFixpack.sh -y, and that also ran successfully, but now my db2start command returns an error:

[***@portal ~]$ db2start
08/16/2007 07:12:50 0 0 SQL1042C An unexpected system error occurred.
SQL1032N No start database manager command was issued. SQLSTATE=57019

Here is the output from the db2diag.log after running the db2start:

2007-08-16-07.02.13.261489+060 I1G1263 LEVEL: Event
PID : 30151 TID : 2415488 PROC : db2start
INSTANCE: db2inst2 NODE : 000
FUNCTION: DB2 UDB, RAS/PD component, _pdlogInt, probe:120
START : New db2diag.log file
DATA #1 : Build Level, 124 bytes
Instance "db2inst2" uses "32" bits and DB2 code release "SQL08028"
with level identifier "03090106".
Informational tokens are "DB2 v8.1.2.136", "s070720", "MI00189", FixPak "15".
DATA #2 : System Info, 436 bytes
System: Linux portal.ibm.com 6 2 i686
CPU: total:1 online:1 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:1079 free:840
Virtual Memory(MB): total:3063 free:2750
Swap Memory(MB): total:1984 free:1910
Kernel Params: msgMaxMessageSize:8192 msgMsgMap:16384 msgMaxQueueIDs:1024
msgNumberOfHeaders:16384 msgMaxQueueSize:16384
msgMaxSegmentSize:16 shmMax:268435456 shmMin:1 shmIDs:4096
shmSegments:4096 semMap:32000 semIDs:1024 semNum:32000
semUndo:32000 semNumPerID:250 semOps:32 semUndoSize:20
semMaxVal:32767 semAdjustOnExit:32767
Information in this record is only valid at the time when this file was
created (see this record's time stamp)

2007-08-16-07.02.13.261092+060 I1265G1505 LEVEL: Event
PID : 30151 TID : 2415488 PROC : db2start
INSTANCE: db2inst2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 34 bytes
/home/db2inst2/sqllib/adm/db2star2
DATA #2 : Hexdump, 256 bytes
0xBFFFC408 : 2F68 6F6D 652F 6462 3269 6E73 7432 2F73 /home/db2inst2/s
0xBFFFC418 : 716C 6C69 622F 6164 6D2F 6462 3273 7461 qllib/adm/db2sta
0xBFFFC428 : 7232 0000 0000 0000 0000 0000 0000 0000 r2..............
0xBFFFC438 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFFFC448 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFFFC458 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFFFC468 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFFFC478 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFFFC488 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFFFC498 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFFFC4A8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFFFC4B8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFFFC4C8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFFFC4D8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFFFC4E8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFFFC4F8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

I have also tried db2stop; ipclean; db2start as suggested elsewhere, but to no avail.

Any help is appreciated

Thanks!
Christian
Joachim Müller
2007-08-17 13:21:26 UTC
Permalink
Hello Christian,

have you doing post installations task like (db2iupdt -e, dasupdt , bind's
db2updv8 -d <db-name>, etc...)

Regards,
Joachim Müller
Post by Christian Pedersen
Hi All
I've just installed 8.2 32bit on a RedHat Enterprise, and as always I've
verified that after the install I could start, create db, drop db, and
stop the db2 sucessfully. That worked fine.
I then upgraded to Fixpack 15 using the ./installFixpack.sh -y, and that
08/16/2007 07:12:50 0 0 SQL1042C An unexpected system error occurred.
SQL1032N No start database manager command was issued. SQLSTATE=57019
2007-08-16-07.02.13.261489+060 I1G1263 LEVEL: Event
PID : 30151 TID : 2415488 PROC : db2start
INSTANCE: db2inst2 NODE : 000
FUNCTION: DB2 UDB, RAS/PD component, _pdlogInt, probe:120
START : New db2diag.log file
DATA #1 : Build Level, 124 bytes
Instance "db2inst2" uses "32" bits and DB2 code release "SQL08028"
with level identifier "03090106".
Informational tokens are "DB2 v8.1.2.136", "s070720", "MI00189", FixPak "15".
DATA #2 : System Info, 436 bytes
System: Linux portal.ibm.com 6 2 i686
CPU: total:1 online:1 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:1079 free:840
Virtual Memory(MB): total:3063 free:2750
Swap Memory(MB): total:1984 free:1910
Kernel Params: msgMaxMessageSize:8192 msgMsgMap:16384
msgMaxQueueIDs:1024
msgNumberOfHeaders:16384 msgMaxQueueSize:16384
msgMaxSegmentSize:16 shmMax:268435456 shmMin:1 shmIDs:4096
shmSegments:4096 semMap:32000 semIDs:1024 semNum:32000
semUndo:32000 semNumPerID:250 semOps:32 semUndoSize:20
semMaxVal:32767 semAdjustOnExit:32767
Information in this record is only valid at the time when this file was
created (see this record's time stamp)
2007-08-16-07.02.13.261092+060 I1265G1505 LEVEL: Event
PID : 30151 TID : 2415488 PROC : db2start
INSTANCE: db2inst2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 34 bytes
/home/db2inst2/sqllib/adm/db2star2
DATA #2 : Hexdump, 256 bytes
0xBFFFC408 : 2F68 6F6D 652F 6462 3269 6E73 7432 2F73 /home/db2inst2/s
0xBFFFC418 : 716C 6C69 622F 6164 6D2F 6462 3273 7461 qllib/adm/db2sta
0xBFFFC428 : 7232 0000 0000 0000 0000 0000 0000 0000 r2..............
0xBFFFC438 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFFFC448 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFFFC458 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFFFC468 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFFFC478 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFFFC488 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFFFC498 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFFFC4A8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFFFC4B8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFFFC4C8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFFFC4D8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFFFC4E8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFFFC4F8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
I have also tried db2stop; ipclean; db2start as suggested elsewhere, but to no avail.
Any help is appreciated
Thanks!
Christian
Loading...