Need some help please. Trying to restore a 7.2 DB from one machine to
a newer machine running 8.2. Upon restoring I get:
SQL2519N The database was restored, but the restored database was not
migrated to the current release. Error "<sqlcode>" with tokens
"<tokens>" is returned.
Explanation: The backup image contains a previous release of the
database. After the database files were restored, an attempt was made
to migrate the database to the current release. The migration failed.
"SQL2519N Database restored but failed migration
I tried creating the database first. Upping log file size and number.
Set bufferpools and tried restore again same thing. I have had a
similiar problem before because the bufferpool size of the db I was
restoring from was larger than the memory size of the server I
restored to but I have already checked this and this is not the case.
DIAG.log shows:
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFEC55".
2004-06-25-10.22.07.105000 Instance:DB2 Node:000
PID:2340(db2syscs.exe) TID:2484 Appid:*LOCAL.DB2.011B05151958
data protection sqlpgResSpace Probe:2860 Database:DVDBSE
ADM1823E The log is full. The active log is held by application
handle "8".
Terminate this application by COMMIT, ROLLBACK or FORCE APPLICATION.
2004-06-25-10.22.07.199000 Instance:DB2 Node:000
PID:2340(db2syscs.exe) TID:2484 Appid:*LOCAL.DB2.011B05151958
data protection sqlpWriteLR Probe:980 Database:DVDBSE
DIA8309C Log file was full.
ZRC=0x85100009
PID:2340 TID:2484 Node:000 Title: insertNew Migration[-7] DMS
rc=85100009
696e 7365 7274 4e65 7720 4d69 6772 6174 insertNew Migrat
696f 6e5b 2d37 5d20 444d 5320 7263 3d38 ion[-7] DMS rc=8
3531 3030 3030 39 5100009
PID:2340 TID:2484 Node:000 Title: sqlrlm_logDMS_Err: Object name
5359 5349 424d 2020 2e53 5953 5345 4354 SYSIBM .SYSSECT
494f 4e ION
PID:2340 TID:2484 Node:000 Title: migrate_catalog_Fixup Migration[7]
DMS rc=85100009
6d69 6772 6174 655f 6361 7461 6c6f 675f migrate_catalog_
4669 7875 7020 4d69 6772 6174 696f 6e5b Fixup Migration[
375d 2044 4d53 2072 633d 3835 3130 3030 7] DMS rc=851000
3039 09
PID:2340 TID:2484 Node:000 Title: sqlrlm_logDMS_Err: Object name
5359 5349 424d 2020 2e53 5953 5345 4354 SYSIBM .SYSSECT
494f 4e ION
2004-06-25-10.22.07.730000 Instance:DB2 Node:000
PID:2340(db2syscs.exe) TID:2484 Appid:*LOCAL.DB2.011B05151958
base sys utilities sqlefmig Probe:30 Database:DVDBSE
Catalog migration failed with -964.
2004-06-25-10.22.10.386000 Instance:DB2 Node:000
PID:2340(db2syscs.exe) TID:2484 Appid:none
base sys utilities sqlelost Probe:40
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFC3C".
2004-06-25-10.22.37.852000 Instance:DB2 Node:000
PID:2340(db2syscs.exe) TID:2484 Appid:*LOCAL.DB2.00F785152237
base sys utilities sqlePrepareForSerialization Probe:30
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFEC55".
2004-06-25-10.22.37.899000 Instance:DB2 Node:000
PID:2340(db2syscs.exe) TID:2484 Appid:*LOCAL.DB2.00F785152237
base sys utilities sqleserl Probe:10
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFEC55".
2004-06-25-10.22.37.962000 Instance:DB2 Node:000
PID:2340(db2syscs.exe) TID:2484 Appid:*LOCAL.DB2.00F785152237
base sys utilities sqlelost Probe:40
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFEC55".
2004-06-25-10.22.57.006000 Instance:DB2 Node:000
PID:2340(db2syscs.exe) TID:2484 Appid:*LOCAL.DB2.011B05152256
data protection sqlpMigrate Probe:123
Log files from previous release have been renamed with extention .MIG