Unanswered: DB2 Restore dump file from 10.1 to 10.5 failed
I had an error concerning the restore of a dump file created on DB2 10.1. I try to export it in DB2 10.5 version but I had this problem:
SQL2519N The database was restored but the restored database was not upgraded
to the current release. Error "-912" with tokens "1
" is returned.
In the db2log I saw that message :
2014-07-03-184.108.40.2065000+120 I1438880F965 LEVEL: Severe
PID : 3924 TID : 3336 PROC : db2bp.exe
INSTANCE: DB2 NODE : 000 DB : SS11
APPID : *LOCAL.DB2.140703105526
EDUID : 3336
FUNCTION: DB2 UDB, base sys utilities, sqlescdb, probe:183
MESSAGE : ZRC=0xFFFFFC70=-912
SQL0912N The maximum number of lock requests has been reached for
the database. Reason code = ""
I already try to increase the agent_stack_sz but it doesn't work.
I read some topics suggesting to increase the "locklist" parameter but this parameter is database based and I can only modify this paramter after creating the database. I think it would be good if I can specifie a default value for that parametre before doing my restore.
DBT5529N The db2ckupgrade utility did not complete successfully. The database cannot be upgraded. The output log file is named "myLog.log".
in the log file I have this error message:
Version of DB2CKUPGRADE being run: VERSION "10.5"Database: "SS11" DBT5509N The db2ckupgrade utility failed because it could not connect to the database. Database: "SS11".DBT5529N The db2ckupgrade utility did not complete successfully. The database cannot be upgraded. The output log file is named "myLog.log".
I try to connect to the database but I get this:
SQL5035N The database must be upgraded to the current release.
My login and password are good but I think my failed previous upgrade prevent me to connect to the database.