Symptom
During db2iupgrade, the db2iupgrade.log.xxx.txt reports the following errors. The upgrade.log must be checked to retrieve the actual error.
DB2 Setup log file started at: <date/timestamp>
============================================================
Operating system information: <OS version>
Existing instances to configure: db2<sid>
Instance user information:
User name: db2<sid>
Fenced user information:
User name: db2<sid>
Setting default global profile registry variables :.......Success
Initializing instance list :.......Success
ERROR: An error occurred while upgrading the instance "db2<sid>". The return value is "1". If the problem persists contact your technical service representative.
ERROR: DBI1205E One or more local databases cannot be upgraded to the version from which you are running this command.
Check the log file /db2/db2<sid>/upgrade.log for the list of errors.
=>
ERROR: An error occurred while configuring the instance "db2<sid>".
Configuring DB2 instances :.......Failure
Updating global profile registry :.......Success
Post-installation instructions
-------------------------------
/db2/db2<sid>/upgrade.log
SQL0551N Authorization ID does not have required authorization Authorization ID: "DB2<SID>"
Operation: EXECUTE
Object: SYSPROC.ENV_GET_REG_VARIABLES
". Operation: "EXECUTE". Object: "SYSPROC.ENV_GET_REG_VARIABLES". - DB2CKUPGRADE/DB2IUPGRADE"> Read more...
Environment
Db2 LUW IBM
Product
Keywords
upgrade, failure, success, utility, database, global profile registry variables, first steps, validate your installation files, instance, and database functionality, , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview