Upgrading from DB2 from 9.7.9 to 10.5.0

[Former Member]

Hi All

Before upgrading the db2ckupgrade  log say the database can be upgraded but when  upgrading the db2 to version 10.5.0 I have encounter the following error  as per attachment attach .

Please advice .Thanks

Regards

Clement

[former_member283840 · Accepted solution]

Clement;

I don't know if you got your answer yet or not but the db2upgrade usually creates the logs in /tmp directory.  Look there for the logs.  You will probably be able to see why you got the error just by looking at them.  Hope this helps.

Len.

[Former Member · Accepted solution]

Hi Leonard

I have not found the answer yet , I have attach the log , can you identify where is the error ? >Thanks

Regards

Clement

DB2-SERVER-Fri Feb 05 14_38_17 2016.txt.zip

[former_member182505 · Accepted solution]

Hi

On log i found

1: ERROR:The upgrade of the instance "DB2EPD" has failed. The return value is "2".

1: ERROR:An error occurred while configuring the instance "DB2EPD".

Action 14:46:54: DB2CustomAction. Configuring DB2 instances

1: Configuring DB2 instances:.......Failure 

Action 14:46:54: DB2CustomAction. Configuring DB2 extended security

1: ERROR:SQL1390C  The environment variable DB2INSTANCE is not defined or is invalid.

Below links will help you to fix the issue,

IBM Knowledge Center

Information Management:IBM DB2 Express-C Forum:DB2 Express-C not starting on Windows 7 - SQL1390C Th...

IBM The 'db2level' failing with error code SQL1390C when DB2INSTANCE variable is not set. - United S...

Connect to database not possible | SCN

Thanks

Sadiq

[Former Member · Accepted solution]

Hi sadiq

Before upgrading the db2instance was intact , after upgrading the db2instance got disappeared after the error upgrade db2instance failed and then nothing seems to work after that . In fact I have set the db2instance and it doesn't work at all .

Regards

Clement

[Former Member · Accepted solution]

Hi Clement,

Dropping of DB2 instances failed due to error as reported in log.

1: Failed to drop DB2 Instances.

Please follow below steps to re-create the instance and also check if PATH environment variable contains the sqllib/adm path in it.

DB2PATH should have path set to something like C:\Program Files\IBM\SQLLIB\BIN

Log in as <sid>adm

Open the DB2 command window

db2icrt db2 -  Creates the missing instance 'DB2'

db2systray db2 - Puts an green database symbol into the system tray

Select the green database symbol in systray with right mouse button

deselect 'Launch Tool at Startup'

Select 'Exit' to exit the tool

In the DB2 command windows

db2idrop db2 - drops the instance 'DB2'

Hope this helps

Regards,

Prithviraj.