DB2 database upgrade from 9.7.5 to 10.5 fixPack 1

Gregor Kovač

unread,

Oct 15, 2013, 8:30:55 AM10/15/13

to

Hi!
I have a database that was created on DB2 Express-C 9.7.5. I uninstalled DB2 9.7.5, installed DB2 10.5 fixpack 1 and did:
db2 upgrade db DBNAME
database manager crashed with lots of there errors in db2diag.log:
Begin migrating catalog table: SYSTABLES

2013-10-15-13.40.32.205649+120 I116917G1287 LEVEL: Error
PID : 2158 TID : 3028282176 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : LUMINA
HOSTNAME: ubuntu
EDUID : 27 EDUNAME: db2pfchr (LUMINA)
FUNCTION: DB2 UDB, oper system services, sqloReadVLow, probe:100
MESSAGE : ZRC=0x870F0009=-2029060087=SQLO_EOF "the data does not exist"
DIA8506C Unexpected end of file was reached.
DATA #1 : Codepath, 8 bytes
7:17:27
DATA #2 : String, 17 bytes
End of file hit !
DATA #3 : signed integer, 4 bytes
0
DATA #4 : unsigned integer, 4 bytes
0
DATA #5 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
File Handle = 15
File System Block Size = 4096 bytes
File System Type = ext4
File Handle Flags :
Require Sector Align = No
DIO/CIO Mode = Yes
Raw Block Device = No
Reserved Handle = No
Flush On Close = No
Thread-Level Lock = No
Write-through Mode = Yes
File Not Tracked = Yes
DATA #6 : signed integer, 4 bytes
2
DATA #7 : signed integer, 4 bytes
0
DATA #8 : File Offset, 8 bytes
874680320
DATA #9 : signed integer, 4 bytes
12
DATA #10: signed integer, 4 bytes
4096
DATA #11: signed integer, 4 bytes
0

2013-10-15-13.40.32.236565+120 I118205G664 LEVEL: Error
PID : 2158 TID : 3028282176 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : LUMINA
HOSTNAME: ubuntu
EDUID : 27 EDUNAME: db2pfchr (LUMINA)
FUNCTION: DB2 UDB, buffer pool services, sqlbReadAndReleaseBuffers, probe:4122
MESSAGE : ZRC=0x870F0009=-2029060087=SQLO_EOF "the data does not exist"
DIA8506C Unexpected end of file was reached.
DATA #1 : <preformatted>
Tablespace 0 (SYSCATSPACE) flags=3102 HighWaterMark=236008 ConOffset=213545 startPoolPageNum=1 diskPageNumber=213541 lowestindex=0 highextindex=2 num-pages 3

2013-10-15-13.40.32.245116+120 I118870G2497 LEVEL: Severe
PID : 2158 TID : 3028282176 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : LUMINA
HOSTNAME: ubuntu
EDUID : 27 EDUNAME: db2pfchr (LUMINA)
FUNCTION: DB2 UDB, buffer pool services, sqlbProcessRange, probe:60
MESSAGE : ZRC=0x870F0009=-2029060087=SQLO_EOF "the data does not exist"
DIA8506C Unexpected end of file was reached.
DATA #1 : String, 16 bytes
Prefetcher Error
DATA #2 : Page ID, PD_TYPE_SQLB_PAGE_ID, 4 bytes
1
DATA #3 : unsigned integer, 4 bytes
0
DATA #4 : unsigned integer, 4 bytes
2
DATA #5 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 88 bytes
Obj: {pool:0;obj:1302;type:0} Parent={0;1302}
lifeLSN: 000000007A32B107
tid: 0 0 0
extentAnchor: 213536
initEmpPages: 0
poolPage0: 0
poolflags: 0x 3102
objectState: 0x 80027
lastSMP: 0
pageSize: 4096
extentSize: 4
bufferPoolID: 1
partialHash: 85327872
objDescAttributes: 0
objDescEHLState: 0x9c9ee1d8
bufferPool: 0x5c4d7b50
pdef: 0x6fbda1a0
DATA #6 : Prefetcher SQLB_pfMisc structure, PD_TYPE_SQLB_PFMISC, 5220 bytes
q_id: 0x9b2b6290
MyNum: 0
Recovery: 0
bpcb: 0x5c449a10
pfcb: 0x9b2b5f10
MaxNum4kPgs: 128
victimBPDs: 0xb30514e0
victimBPDIDXs: 0xb3051700
victimPageKeys: 0xb3051920
bpsglob: 0xb3053580
bufferpool: 0x5c4d7b50
req: 0x9bc2ec7c
pfFlags: 0
victimCB: 0xb305009c
objDesc: 0x00000000
DATA #7 : Prefetcher SQLB_pfRequest structure, PD_TYPE_SQLB_PFREQUEST, 868 bytes
type: 1
Obj: {pool:0;obj:1302;type:0} Parent={0;1302}
lifeLSN: 000000007A32B107
tid: 0 0 0
extentAnchor: 213536
initEmpPages: 0
poolPage0: 0
poolflags: 0x 3102
objectState: 0x 80027
lastSMP: 0
pageSize: 4096
extentSize: 4
bufferPoolID: 1
partialHash: 85327872
objDescAttributes: 0
objDescEHLState: 0x9c9ee1d8
bufferPool: 0x5c4d7b50
pdef: 0x6fbda1a0
numentries: 2
numPagesTotal: 7
priority: 1
next: 0x00000000
prev: 0x00000000

2013-10-15-13.40.32.329979+120 I121368G1287 LEVEL: Error
PID : 2158 TID : 3028282176 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : LUMINA
HOSTNAME: ubuntu
EDUID : 27 EDUNAME: db2pfchr (LUMINA)
FUNCTION: DB2 UDB, oper system services, sqloReadVLow, probe:100
MESSAGE : ZRC=0x870F0009=-2029060087=SQLO_EOF "the data does not exist"
DIA8506C Unexpected end of file was reached.
DATA #1 : Codepath, 8 bytes
7:17:27
DATA #2 : String, 17 bytes
End of file hit !
DATA #3 : signed integer, 4 bytes
0
DATA #4 : unsigned integer, 4 bytes
0
DATA #5 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
File Handle = 15
File System Block Size = 4096 bytes
File System Type = ext4
File Handle Flags :
Require Sector Align = No
DIO/CIO Mode = Yes
Raw Block Device = No
Reserved Handle = No
Flush On Close = No
Thread-Level Lock = No
Write-through Mode = Yes
File Not Tracked = Yes
DATA #6 : signed integer, 4 bytes
3
DATA #7 : signed integer, 4 bytes
0
DATA #8 : File Offset, 8 bytes
875282432
DATA #9 : signed integer, 4 bytes
12
DATA #10: signed integer, 4 bytes
4096
DATA #11: signed integer, 4 bytes
0

2013-10-15-13.40.32.331090+120 I122656G664 LEVEL: Error
PID : 2158 TID : 3028282176 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : LUMINA
HOSTNAME: ubuntu
EDUID : 27 EDUNAME: db2pfchr (LUMINA)
FUNCTION: DB2 UDB, buffer pool services, sqlbReadAndReleaseBuffers, probe:4122
MESSAGE : ZRC=0x870F0009=-2029060087=SQLO_EOF "the data does not exist"
DIA8506C Unexpected end of file was reached.
DATA #1 : <preformatted>
Tablespace 0 (SYSCATSPACE) flags=3102 HighWaterMark=236008 ConOffset=213692 startPoolPageNum=8 diskPageNumber=213688 lowestindex=0 highextindex=3 num-pages 4

Why is that?

Best regards,
Kovi

Helmut Tessarek

unread,

Oct 15, 2013, 9:04:36 AM10/15/13

to

On 15.10.13 8:30 , Gregor Kovač wrote:
> I have a database that was created on DB2 Express-C 9.7.5. I uninstalled DB2 9.7.5, installed DB2 10.5 fixpack 1 and did:
> db2 upgrade db DBNAME
> database manager crashed with lots of there errors in db2diag.log:

I don't work for IBM anymore, so I can't check the DB2 code to figure out
what's going on, but this error seems rather severe.
Without looking at the code, I can't say, if it is a corrupt database control
file or if you have some issues with your filesystem.

I'm sure you took a backup on 9.7.5. Do you get the same errors when restoring
the 9.7.5 image on 10.5.1?

In any case, I would suggest to post this issue in the Express-C forum. The
IBMers there can forward it to the respective component owners.
I'm sure they are pretty much interested in solving this problem as quickly as
possible.

--
Helmut K. C. Tessarek

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/

Mark A

unread,

Oct 15, 2013, 1:38:56 PM10/15/13

to

On Tue, 15 Oct 2013 05:30:55 -0700, Gregor Kovač wrote:

> Hi!
> I have a database that was created on DB2 Express-C 9.7.5. I uninstalled
> DB2 9.7.5, installed DB2 10.5 fixpack 1 and did: db2 upgrade db DBNAME
> database manager crashed with lots of there errors in db2diag.log:

It is possible that DB2 9.7 Express-C cannot be upgraded. I would take a backup of the 9.7.5 database
(I assume you have one) and restore it on a fresh install of DB2 10.5 (remove 9.7.5 first).

Gregor Kovač

unread,

Oct 15, 2013, 1:46:08 PM10/15/13

to

Dne torek, 15. oktober 2013 19:38:56 UTC+2 je oseba Mark A napisala:

I have done that and it still crashes.

Gregor Kovač

unread,

Oct 15, 2013, 1:48:04 PM10/15/13

to

Dne torek, 15. oktober 2013 19:46:08 UTC+2 je oseba Gregor Kovač napisala:

Funny thing is that on one Ubuntu 12.04 that had 10.1 upgrade to 10.5 fp1 worked.
Then I tried to install 10.1, restore, install 10.5 and upgrade, but db2 crashed again.

Larry

unread,

Oct 18, 2013, 9:15:47 PM10/18/13

to

I may be missing something here, but did you say that you uninstalled
DB2 9.7.5, and then attempted a DB2 Upgrade DB? Can you uninstall the
prior release and still "upgrade" the database? Or do you need to keep
the 9.7 binaries installed, then install 10.5, then upgrade the
instance, then upgrade the database, then uninstall 9.7? In other words,
CAN you upgrade a standalone database created from a prior release to a
more recent release after the prior release is uninstalled?

--
Larry E.

--- news://freenews.netfront.net/ - complaints: ne...@netfront.net ---

Gregor Kovač

unread,

Oct 23, 2013, 3:05:43 PM10/23/13

to

Dne sobota, 19. oktober 2013 03:15:47 UTC+2 je oseba Larry napisala:

I have uninstalled 9.7.5, installed DB2 10.5 and tried to upgrade.

Larry

unread,

Oct 23, 2013, 3:24:34 PM10/23/13

to

Yes, I know. But I am asking if that can even be done. Is it possible
that you need to keep 9.7.5 installed in order to upgrade and then
remove 9.7.5 after the upgrade? Support would know.

Larry E.

Gregor Kovač

unread,

Oct 23, 2013, 5:17:15 PM10/23/13

to

Dne sreda, 23. oktober 2013 21:24:34 UTC+2 je oseba Larry napisala:

OK, now I understand.
For a database to be upgraded to a new version you don't need to keep the old one around.