|
Problem IC92160
|
Status: Closed |
WHEN DOING THE REDIRECT RESTORE TO MIGRATE DATABASE FROM V9.5 OR V9.7 TO V10.1, GENERATED WARNING MESSAGES of -1704 RC=5 |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
|
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC95384
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 07.05.2013
06.01.2014
11.09.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
