Error - 1224 With Tokens *n Is Returned
z/os Fixes are available DB2 windows error codes list Version 9.7 Fix Pack 5 for Linux, UNIX, and windows error codes lookup Windows DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows Subscribe You can track all active APARs for this component. APAR status Closed as program error. Error description When upgrading a database via the RESTORE DATABASE command and the registry variable DB2_RESTORE_GRANT_ADMIN_AUTHORITIES=YES is set, the command will fail with -1224. restore db sample SQL2519N The database was restored but the restored database was not upgraded to the current release. Error "-1224" with tokens "*N" is returned. DB2 is trapping with the below call stack: 0x09000000C5DCAC50 sqle_panic__Fv + 0x110 0x09000000C61720F0 sqli_set_compfnc_array__FP8sqeAgentPP14COMP_FUNC_VECTP14COMP_FUN C_VECTT3P9SQLD_IDEFP8SQLD_KEYT6PUlUl + 0xD0 0x09000000C6173FC4 sqliScanSetupCmpFunc__FP8sqeAgentP10SQLI_IXPCRP9SQLD_IXCBP9sqli_ scan + 0x1E4 0x09000000C6175200 sqliScanSetup__FP7SQLI_CBP8sqeAgentP10SQLI_IXPCRP9SQLD_IXCBUlP8S QLD_KEYP12SQLI_KEYDATAP9sqli_scan + 0xA00 0x09000000C61849A8 sqlirdk__FP8sqeAgentP10SQLI_IXPCRP9SQLD_IXCBUlP8SQLD_KEYP12SQLI_ KEYDATAP9sqli_scanPi + 0x288 0x09000000C71FDF70 sqldIndexFetch__FP8SQLD_CCBP8SQLZ_RID + 0x3D0 0x09000000C7206E70 sqldRowFetch__FP8sqeAgentP8SQLD_CCBUlT3PP10SQLD_VALUEP8SQLZ_RIDT 3P12SQLD_ID_LISTP9SQLP_LSN8 + 0x1510 0x09000000C644EDDC fetch__16sqlrlCatalogScanFv + 0x37C 0x09000000C6454110 fetchOneRow__16sqlrlCatalogScanFv + 0x130 0x09000000C7E5A4BC sqlrlInsertOrUpdateDBAuth__FP8sqlrr_cbPUcsUcUiT2T3T4T5T2T5 + 0x37C 0x09000000C7E5AF90 sqlrlInsertDbCreatorPrivs__FP8sqlrr_cbPUcs + 0x170 0x09000000CAA9F3AC sqlrr_handle_restore_authorities__FP8sqeAgent + 0x4AC Local fix Unset DB2_RESTORE_GRANT_ADMIN_AUTHORITIES and retry the upgrade, or upgrade the database via the UPGRADE DATABASE command instead. Problem summary *************************************************************
your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 13 of 13 Thread: Restoring Database with different version and edition Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 03-03-11,07:20 #1 muklee View Profile View Forum Posts Registered User Join Date Nov 2007 Posts 13 http://www.ibm.com/support/docview.wss?uid=swg1IC78160 Unanswered: Restoring Database with different version and edition Hi, I am trying to restore a database from development server to my local PC, using a backup file (offline backup). Here is some information of the DB2 and server environment: Development DB2 Workgroup Server Edition, version 8.2 Windows Server 2003 32-bits Local PC DB2 Express-C, version 9.7 Windows XP 32-bits Restoring database from a lower version (2 levels) to higher http://www.dbforums.com/showthread.php?1664639-Restoring-Database-with-different-version-and-edition version is alright. But my concern is, can I do so in my case since I am using Express-C edition and the server is using workgroup server edition? Appreciate if anyone could help. Thanks. Reply With Quote 03-03-11,09:07 #2 ARWinner View Profile View Forum Posts Registered User Join Date Jan 2003 Posts 4,286 Provided Answers: 5 The differences in editions will only matter if you used a feature in the Workgroup edition that is not available in Express-C. Other than that it should work. Andy Reply With Quote 03-04-11,06:37 #3 muklee View Profile View Forum Posts Registered User Join Date Nov 2007 Posts 13 Thanks for the answer. However, I was getting this error when I am trying to perform the DB restored. Code: SQL2519N The database was restored but the restored database was not upgraded to the current release. Error "-1224" with tokens "-2029060040 * * * * SEMAPHORE WAIT " is returned. Below are the command I used in DB2 CLP. What I am trying to do is, first I created a empty database with the same DB name as the backup. Then, replace the whole DB using the backup. Code: db2 => db2start DB20000I The DB2START command completed successfully. db2 => attach t
how to tackle this problem http://www.databaseuser.info/tag/29711/db2ts ? Code: db2inst2#bob2:/dbs/temp/PODBTEMP2> db2 restore db im_rm redirect SQL1277W A redirected restore operation is being performed. During a table space restore, only table spaces being restored can have their paths reconfigured. During a database restore, storage group storage paths and DMS table space windows error containers can be reconfigured. DB20000I The RESTORE DATABASE command completed successfully. db2inst2#bob2:/dbs/temp/PODBTEMP2> db2 "set tablespace containers for 0 using (file '/home/db2inst2/db2inst2/NODE0000/IM_RM/T0000000/C0000000.CAT' 70000)" SQL20319N The SET TABLESPACE CONTAINERS command is not allowed on an automatic storage table space. SQLSTATE=55061 db2inst2#bob2:/dbs/temp/PODBTEMP2> db2 "set tablespace containers windows error codes for 1 using (path '/home/db2inst2/db2inst2/NODE0000/IM_RM/T0000001/C0000000.TMP')" SQL20319N The SET TABLESPACE CONTAINERS command is not allowed on an automatic storage table space. SQLSTATE=55061 db2inst2#bob2:/dbs/temp/PODBTEMP2> db2 "set tablespace containers for 2 using (file '/home/db2inst2/db2inst2/NODE0000/IM_RM/T0000002/C0000000.LRG' 20000)" SQL20319N The SET TABLESPACE CONTAINERS command is not allowed on an automatic storage table space. SQLSTATE=55061 db2inst2#bob2:/dbs/temp/PODBTEMP2> db2 "set tablespace containers for 3 using (file '/home/db2inst2/db2inst2/NODE0000/IM_RM/T0000003/C0000000.LRG' 20000)" SQL20319N The SET TABLESPACE CONTAINERS command is not allowed on an automatic storage table space. SQLSTATE=55061 db2inst2#bob2:/dbs/temp/PODBTEMP2> db2 "set tablespace containers for 4 using (path '/home/db2inst2/db2inst2/NODE0000/IM_RM/T0000004/C0000000.UTM')" SQL20319N The SET TABLESPACE CONTAINERS command is not allowed on an automatic storage table space. SQLSTATE=55061 db2inst2#bob2:/dbs/temp/PODBTEMP2> db2 "set tablespace containers for 5 using (file '/home/db2inst2/db2inst2/NODE0000/IM_RM/T0000005/C0000000.USR' 82000)" SQL20319N The SET TABLESPACE CONTAINERS command is not allowed on an automatic storage table space. SQLSTATE=55061