If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > quick help - db2 upgrade command fails with sql1042N

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-27-10, 14:37
blazer789 blazer789 is offline
Registered User
 
Join Date: Jun 2009
Posts: 221
quick help - db2 upgrade command fails with sql1042N

Upgrading db2 V9.5 - db2 V9.7 FP2 on AIX.

Instance migrated sucessfully and check migration also worked fine.

Once the instance has migrated, I started the instance and tried to run db2 upgrade db dbname, this command fails with error

SQL1042C An unexpected system error occurred. SQLSTATE=58004



This is what db2diag.log shows







2010-07-27-14.31.48.787144-240 I1022615A579 LEVEL: Error
PID : 671990 TID : 1801 PROC : db2sysc
INSTANCE: qacdmxs NODE : 000 DB : CDMQA
APPHDL : 0-64 APPID: *LOCAL.qacdmxs.100727183148
AUTHID : DB2UDB
EDUID : 1801 EDUNAME: db2agent (CDMQA)
FUNCTION: DB2 UDB, buffer pool services, sqlbMigratePoolOnDisk, probe:40
MESSAGE : ZRC=0x87020002=-2029912062=SQLB_BPSE "Debug logic error detected"
DIA8501C A buffer pool logic error has occurred.
DATA #1 : unsigned integer, 4 bytes
0

2010-07-27-14.31.48.790442-240 I1023195A699 LEVEL: Error
PID : 671990 TID : 1801 PROC : db2sysc
INSTANCE: qacdmxs NODE : 000 DB : CDMQA
APPHDL : 0-64 APPID: *LOCAL.qacdmxs.100727183148
AUTHID : DB2UDB
EDUID : 1801 EDUNAME: db2agent (CDMQA)
FUNCTION: DB2 UDB, buffer pool services, sqlbVerifyBacklevelPDEFOnDisk, probe:20
MESSAGE : ZRC=0x82020001=-2113798143=SQLB_NONSEVERE_PRGERR
"non-severe BPS programming error"
DIA8532C An internal processing error has occurred.
DATA #1 : Dumped object of size 262144 bytes at offset 4529424, 45 bytes
/udb_db2diag/qacdmxs/671990.1801.000.dump.bin

2010-07-27-14.31.48.791631-240 I1023895A699 LEVEL: Error
PID : 671990 TID : 1801 PROC : db2sysc
INSTANCE: qacdmxs NODE : 000 DB : CDMQA
APPHDL : 0-64 APPID: *LOCAL.qacdmxs.100727183148
AUTHID : DB2UDB
EDUID : 1801 EDUNAME: db2agent (CDMQA)
FUNCTION: DB2 UDB, buffer pool services, sqlbVerifyBacklevelPDEFOnDisk, probe:20
MESSAGE : ZRC=0x82020001=-2113798143=SQLB_NONSEVERE_PRGERR
"non-severe BPS programming error"
DIA8532C An internal processing error has occurred.
DATA #1 : Dumped object of size 262144 bytes at offset 4791688, 45 bytes
/udb_db2diag/qacdmxs/671990.1801.000.dump.bin

2010-07-27-14.31.48.792810-240 I1024595A825 LEVEL: Error
PID : 671990 TID : 1801 PROC : db2sysc
INSTANCE: qacdmxs NODE : 000 DB : CDMQA
APPHDL : 0-64 APPID: *LOCAL.qacdmxs.100727183148
AUTHID : DB2UDB

EDUID : 1801 EDUNAME: db2agent (CDMQA)
FUNCTION: DB2 UDB, buffer pool services, sqlbMigratePoolTableFiles, probe:130
MESSAGE : ZRC=0x86020019=-2046689255=SQLB_CSUM "Bad Page, Checksum Error"
DIA8426C A invalid page checksum was found for page "".
DATA #1 : unsigned integer, 2 bytes
4
DATA #2 : Dumped object of size 65536 bytes at offset 5053952, 45 bytes
/udb_db2diag/qacdmxs/671990.1801.000.dump.bin
DATA #3 : Dumped object of size 65536 bytes at offset 5119608, 45 bytes
/udb_db2diag/qacdmxs/671990.1801.000.dump.bin

2010-07-27-14.31.48.793695-240 I1025421A695 LEVEL: Error
PID : 671990 TID : 1801 PROC : db2sysc
INSTANCE: qacdmxs NODE : 000 DB : CDMQA
APPHDL : 0-64 APPID: *LOCAL.qacdmxs.100727183148
AUTHID : DB2UDB
EDUID : 1801 EDUNAME: db2agent (CDMQA)
FUNCTION: DB2 UDB, buffer pool services, sqlbMigratePoolTableFiles, probe:130
MESSAGE : ZRC=0x86020019=-2046689255=SQLB_CSUM "Bad Page, Checksum Error"
DIA8426C A invalid page checksum was found for page "".
DATA #1 : unsigned integer, 8 bytes
21474836736
DATA #2 : unsigned integer, 8 bytes
25769804032
DATA #3 : unsigned integer, 8 bytes
30064771328

2010-07-27-14.31.48.794009-240 I1026117A723 LEVEL: Error
PID : 671990 TID : 1801 PROC : db2sysc
INSTANCE: qacdmxs NODE : 000 DB : CDMQA
APPHDL : 0-64 APPID: *LOCAL.qacdmxs.100727183148
AUTHID : DB2UDB
EDUID : 1801 EDUNAME: db2agent (CDMQA)
FUNCTION: DB2 UDB, buffer pool services, sqlbMigrateFiles, probe:20
MESSAGE : ZRC=0x86020019=-2046689255=SQLB_CSUM "Bad Page, Checksum Error"
DIA8426C A invalid page checksum was found for page "".
DATA #1 : unsigned integer, 4 bytes
2



Any help on this situation will be greatly appreciated.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On