Home / server / Questions / 271913
Accepted
Eddy
Asked: 2011-05-21 04:42:37 +0800 CST

DB2 V9.7 upgrade failure

  • 772

I'm upgrading a V9.1 to a v9.7

The scripts for compatibility checks pass but

/opt/ibm/db2/V9.7/instance/db2iupgrade -d -u db2fenc1 db2inst1

fails with the following error message:

db2: symbol lookup error: db2: undefined symbol: sqltGetCompTraceFlag
Update DBM cfg SYSADM_GROUP errcode = 127
DBI1281E  The database manager configuration file could not be
      initialized.
...

According to the script log it chokes on get_db2dir_ver() from db2iutil. If I run the command manually as:

/opt/ibm/db2/V9.7/bin/db2fupdt -f /home/db2inst1/sqllib/ctrl/.instuse -p DB2DIR

I get: 

/opt/ibm/db2/V9.1

I have lost hope...

db2

1 Answers

  1. Best Answer

    After poring over the setup one more time, it was discovered that the 9.1 instance paths were hardcoded in the machine-wide /etc/profile.

    It's a big RTFM and I'd like to beat myself for this: I did look into the file but didn't actually page down to check all of it... and the export was at the end.

    • 0