DB2 - Problembeschreibung
Problem IC92160 | Status: Geschlossen |
WHEN DOING THE REDIRECT RESTORE TO MIGRATE DATABASE FROM V9.5 OR V9.7 TO V10.1, GENERATED WARNING MESSAGES of -1704 RC=5 | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
Problem description When doing the redirect restore to migrate database from V9.5 or V9.7 to V10.1, restore generated warning messages of sqlcode -1704 rc=5: RESTORE DATABASE SAMPLE FROM '/usr/db/db2admn' TAKEN AT 20130312111306 ON '/usr/db/db2admn/' DBPATH ON '/home/db2admn' INTO SAMPLE REPLACE HISTORY FILE REDIRECT WITHOUT ROLLING FORWARD ... RESTORE DATABASE SAMPLE CONTINUE SQL2519N The database was restored but the restored database was not upgraded to the current release. Error "-1704" with tokens "5" is returned. The following errors seen in db2diag.log: 2013-03-19-09.29.51.377293-300 I438243E866 LEVEL: Warning PID : 4549 TID : 46914309450048 PROC : db2sysc 0 INSTANCE: db2admn NODE : 000 DB : SAMPLE APPHDL : 0-2465 APPID: *LOCAL.db2admn.130319142903 AUTHID : DB2ADMN HOSTNAME: sv95db23 EDUID : 103 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, config/install, sqlfUpdateDbCfg, probe:5724 MESSAGE : ZRC=0x00000553=1363 SQL1363W One or more of the parameters submitted for immediate modification were not changed dynamically. For these configuration parameters, the database must be shutdown and reactivated before the configuration parameter changes become effective. DATA #1 : <preformatted> DB cfg update happened non-dyn resulting in 1363. action: 1 db active: 1 2013-03-19-09.29.51.378162-300 I439110E514 LEVEL: Event PID : 4549 TID : 46914309450048 PROC : db2sysc 0 INSTANCE: db2admn NODE : 000 DB : SAMPLE APPHDL : 0-2465 APPID: *LOCAL.db2admn.130319142903 AUTHID : DB2ADMN HOSTNAME: sv95db23 EDUID : 103 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : CFG DB SAMPLE: "Database_level" From: "3328" To: "3840" 2013-03-19-09.29.51.378667-300 I439625E775 LEVEL: Warning PID : 30457 TID : 46912581142128 PROC : db2bp INSTANCE: db2admn NODE : 000 DB : SAMPLE APPID : *LOCAL.db2admn.130319142903 HOSTNAME: sv95db23 FUNCTION: DB2 UDB, base sys utilities, sqlemgdb, probe:609 MESSAGE : failed to update the config DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: 1363 sqlerrml: 0 sqlerrmc: sqlerrp : SQL10012 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * When doing the redirect restore to migrate database from * * V9.7 to * * V10.1, restore generated warning messages of sqlcode -1704 * * rc=5: * * * * RESTORE DATABASE SAMPLE FROM '/usr/db/db2admn' TAKEN AT * * 20130312111306 ON '/usr/db/db2admn/' DBPATH ON * * '/home/db2admn' * * INTO SAMPLE REPLACE HISTORY FILE REDIRECT WITHOUT ROLLING * * FORWARD * * ... * * RESTORE DATABASE SAMPLE CONTINUE * * SQL2519N The database was restored but the restored * * database * * was not upgraded * * to the current release. Error "-1704" with tokens "5" is * * returned. * * * * The following errors seen in db2diag.log: * * * * 2013-03-19-09.29.51.377293-300 I438243E866 LEVEL: * * Warning * * PID : 4549 TID : 46914309450048 PROC : * * db2sysc 0 * * INSTANCE: db2admn NODE : 000 DB : * * SAMPLE * * APPHDL : 0-2465 APPID: * * *LOCAL.db2admn.130319142903 * * AUTHID : DB2ADMN HOSTNAME: sv95db23 * * EDUID : 103 EDUNAME: db2agent (SAMPLE) 0 * * FUNCTION: DB2 UDB, config/install, sqlfUpdateDbCfg, * * probe:5724 * * MESSAGE : ZRC=0x00000553=1363 * * SQL1363W One or more of the parameters submitted * * for * * immediate * * modification were not changed dynamically. For * * these * * configuration * * parameters, the database must be shutdown and * * reactivated before the * * configuration parameter changes become effective. * * * * DATA #1 : <preformatted> * * DB cfg update happened non-dyn resulting in 1363. * * action: 1 * * db active: 1 * * * * 2013-03-19-09.29.51.378162-300 I439110E514 LEVEL: * * Event * * PID : 4549 TID : 46914309450048 PROC : * * db2sysc 0 * * INSTANCE: db2admn NODE : 000 DB : * * SAMPLE * * APPHDL : 0-2465 APPID: * * *LOCAL.db2admn.130319142903 * * AUTHID : DB2ADMN HOSTNAME: sv95db23 * * EDUID : 103 EDUNAME: db2agent (SAMPLE) 0 * * FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, * * probe:20 * * CHANGE : CFG DB SAMPLE: "Database_level" From: "3328" To: * * "3840" * * * * 2013-03-19-09.29.51.378667-300 I439625E775 LEVEL: * * Warning * * PID : 30457 TID : 46912581142128 PROC : * * db2bp * * INSTANCE: db2admn NODE : 000 DB : * * SAMPLE * * APPID : *LOCAL.db2admn.130319142903 * * HOSTNAME: sv95db23 * * FUNCTION: DB2 UDB, base sys utilities, sqlemgdb, probe:609 * * MESSAGE : failed to update the config * * DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes * * sqlcaid : SQLCA sqlcabc: 136 sqlcode: 1363 * * sqlerrml: 0 * * sqlerrmc: * * sqlerrp : SQL10012 * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 version 10.1 FixPak 3 * **************************************************************** | |
Local-Fix: | |
The database restore and database upgrade/migration are successful, and this -1704 warning message can be ignored. | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC95384 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 07.05.2013 06.01.2014 11.09.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.3 | |
10.1.0.3 |