|
| After fixpack upgrade my DB2 won't start |
 |
Thu, 16 Aug 2007 17:07:21 EDT |
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:
[db2inst2@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
|
| Post Reply
|
| Re: After fixpack upgrade my DB2 won't start |
 |
Fri, 17 Aug 2007 15:21:26 +020 |
Hello Christian,
have you doing post installations task like (db2iupdt -e, dasupdt , bind's
db2updv8 -d <db-name>, etc...)
Regards,
Joachim Müller
"Christian Pedersen" <christian@christianpedersen.com> schrieb
im
Newsbeitrag
news:1518643087.1187298474108.JavaMail.wassrvr@ltsgwas010.sby.ibm.com...
> 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:
>
> [db2inst2@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
>
|
| Post Reply
|
|
|