Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2013
    Posts
    11

    Unanswered: migrationg from 8.2 to 9.5 32 bit on windows 7

    i am restoring sms managed database. while resotring it fails. below is the error msg. can any one suggest the solution.


    SQL2519N The database was restored but the restored database was
    not migrated to the current release. Error "-1224" with tokens
    "*N" is returned.


    2013-09-13-12.48.05.500000+300 I1H1080 LEVEL: Event
    PID : 3364 TID : 5272 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : ISLBKG
    APPHDL : 0-54 APPID: *LOCAL.DB2.130913074805
    AUTHID : USER
    EDUID : 5272 EDUNAME: db2agent (ISLBKG) 0
    FUNCTION: DB2 UDB, RAS/PD component, pdLogInternal, probe:120
    START : New Diagnostic Log file
    DATA #1 : Build Level, 128 bytes
    Instance "DB2" uses "32" bits and DB2 code release "SQL09050"
    with level identifier "03010107".
    Informational tokens are "DB2 v9.5.0.808", "s071001", "NT3295", Fix Pack "0".
    DATA #2 : System Info, 1564 bytes
    System: WIN32_NT USER-PC 6.1 x86 Family 6, model 15, stepping 13
    CPU: total:2 online:2 Cores per socket:2 Threading degree per core:1
    Physical Memory(MB): total:2019 free:863 available:863
    Virtual Memory(MB): total:4038 free:3147
    Swap Memory(MB): total:2019 free:2284
    Information in this record is only valid at the time when this file was
    created (see this record's time stamp)

    2013-09-13-12.48.05.499000+300 E1084H620 LEVEL: Info
    PID : 3364 TID : 5272 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : ISLBKG
    APPHDL : 0-54 APPID: *LOCAL.DB2.130913074805
    AUTHID : USER
    EDUID : 5272 EDUNAME: db2agent (ISLBKG) 0
    FUNCTION: DB2 UDB, database utilities, sqludValidateUserOptionsAgainstMediaHead, probe:459
    DATA #1 : <preformatted>
    The database detected in the backup image requires that this restore
    be done WITHOUT ROLLING FORWARD. No rollforward will be required
    following this restore.

    2013-09-13-12.48.05.527000+300 E1706H498 LEVEL: Info
    PID : 3364 TID : 5272 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : ISLBKG
    APPHDL : 0-54 APPID: *LOCAL.DB2.130913074805
    AUTHID : USER
    EDUID : 5272 EDUNAME: db2agent (ISLBKG) 0
    FUNCTION: DB2 UDB, database utilities, sqludPrintStartingMsg, probe:1292
    DATA #1 : <preformatted>
    Starting a full database restore.
    Agent EDU ID: 5272

    2013-09-13-12.48.05.547000+300 E2206H553 LEVEL: Warning
    PID : 3364 TID : 5272 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : ISLBKG
    APPHDL : 0-54 APPID: *LOCAL.DB2.130913074805
    AUTHID : USER
    EDUID : 5272 EDUNAME: db2agent (ISLBKG) 0
    FUNCTION: DB2 UDB, database utilities, sqluCompareDB, probe:1432
    DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
    2523
    DATA #2 : Hexdump, 4 bytes
    0x7B895570 : DB09 0000 ....

    2013-09-13-12.48.05.568000+300 E2761H999 LEVEL: Warning
    PID : 3364 TID : 5272 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : ISLBKG
    APPHDL : 0-54 APPID: *LOCAL.DB2.130913074805
    AUTHID : USER
    EDUID : 5272 EDUNAME: db2agent (ISLBKG) 0
    FUNCTION: DB2 UDB, database utilities, sqluCompareDB, probe:1432
    MESSAGE : SQL2540W Restore is successful, however a warning "" was encountered
    during Database Restore while processing in No Interrupt mode.
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: 2540 sqlerrml: 4
    sqlerrmc: 2523
    sqlerrp : sqluComp
    sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
    (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate:

    2013-09-13-12.48.06.067000+300 I3762H2769 LEVEL: Severe
    PID : 3364 TID : 4152 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    EDUID : 4152 EDUNAME: db2bm.5272.0 (ISLBKG) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbContainerTagIsValid, probe:100
    DATA #1 : String, 20 bytes
    *pTag(CONTAINER_TAG)
    DATA #2 : Hexdump, 512 bytes
    0x7BB23040 : 4442 3243 4F4E 5400 1302 0000 F094 A352 DB2CONT........R
    0x7BB23050 : 0000 0000 0000 0000 0100 0000 0100 0000 ................
    0x7BB23060 : 0000 0000 000C 4953 4C42 4B47 2020 0044 ......ISLBKG .D
    0x7BB23070 : 4232 0000 0000 0000 0000 0000 0000 0000 B2..............
    0x7BB23080 : 0000 433A 5C44 4232 5C4E 4F44 4530 3030 ..C:\DB2\NODE000
    0x7BB23090 : 305C 5351 4C30 3030 3032 5C00 0000 0000 0\SQL00002\.....
    0x7BB230A0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x7BB230B0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x7BB230C0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x7BB230D0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x7BB230E0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x7BB230F0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x7BB23100 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x7BB23110 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x7BB23120 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x7BB23130 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x7BB23140 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x7BB23150 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x7BB23160 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x7BB23170 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x7BB23180 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x7BB23190 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x7BB231A0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x7BB231B0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x7BB231C0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x7BB231D0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x7BB231E0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x7BB231F0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x7BB23200 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x7BB23210 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x7BB23220 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x7BB23230 : 0000 0000 0000 0000 0000 0000 CFA2 865C ...............\

    2013-09-13-12.48.06.097000+300 I6533H2819 LEVEL: Severe
    PID : 3364 TID : 4152 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    EDUID : 4152 EDUNAME: db2bm.5272.0 (ISLBKG) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbContainerTagIsValid, probe:200
    DATA #1 : Codepath, 8 bytes
    2:4:9:11:12:14:15:16
    DATA #2 : String, 19 bytes
    iTag(CONTAINER_TAG)
    DATA #3 : Hexdump, 512 bytes
    0x05E7EC14 : 4442 3243 4F4E 5400 1302 0000 7444 2B4F DB2CONT.....tD+O
    0x05E7EC24 : 0000 0000 0000 0000 0100 0000 0100 0000 ................
    0x05E7EC34 : 0000 0000 000C 4953 4C42 4B47 2020 0044 ......ISLBKG .D
    0x05E7EC44 : 4232 0000 0200 0038 0000 0000 0000 0000 B2.....8........
    0x05E7EC54 : 000C 433A 5C44 4232 5C4E 4F44 4530 3030 ..C:\DB2\NODE000
    0x05E7EC64 : 305C 5351 4C30 3030 3032 5C00 0000 0000 0\SQL00002\.....
    0x05E7EC74 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x05E7EC84 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x05E7EC94 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x05E7ECA4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x05E7ECB4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x05E7ECC4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x05E7ECD4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x05E7ECE4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x05E7ECF4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x05E7ED04 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x05E7ED14 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x05E7ED24 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x05E7ED34 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x05E7ED44 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x05E7ED54 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x05E7ED64 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x05E7ED74 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x05E7ED84 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x05E7ED94 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x05E7EDA4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x05E7EDB4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x05E7EDC4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x05E7EDD4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x05E7EDE4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x05E7EDF4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x05E7EE04 : 0000 0000 0000 0000 0000 0000 497E 0E79 ............I~.y

    2

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Check that you have enough memory for bufferpools as defined in the original database.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    db2diag.log should have more info, you just included the messages related to the restore operation, nothing for db migration. Look for message that begin with 'begin engn migration'.

    -1224 -> could be an instance crash during db migration. First thing you need to do is to install the latest v9.5 fixpack (you have FP0) and then retry migrating the db again.

  4. #4
    Join Date
    Sep 2013
    Posts
    11
    Thanks. all of for helping me to migrate the database.
    I just installed the db2 9.5 with latest fixpack and just restored and migrated the databases to current version.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •