By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,304 Members | 3,132 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,304 IT Pros & Developers. It's quick & easy.

RESTORE ERRORS on 8.1 WIN2k

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Mike" <mi*********@thomson.net> wrote in message
news:a3**************************@posting.google.c om...
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


I would suggest you upgrade to fixpak 5 and then try again. If you still get
an internal error code, contact IBM.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.