Problem description
When doing the redirect restore to migrate database from V9.7 to
V10.5, 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 |
