Topic
  • No replies
GregorKovač
GregorKovač
3 Posts

Pinned topic DB2 upgrade from 9.7.5 to 10.5 fixPack 1

‏2013-10-15T11:55:16Z |

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