DB2 V9.7 upgrade failure

Question

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...

5 seconds of Google also suggests that you should run this and see if there's any hints in there : db2grep -dump — mfinni, May 20 '11 at 13:56
Aha - typo on someone's part. db2greg -dump works on my AIX systems. — mfinni, May 20 '11 at 14:46
Have you had a chance to run db2greg -dump? What were the results? — mfinni, May 24 '11 at 13:00

score 0 · Accepted Answer · answered May 29 '11 at 09:07

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.

DB2 V9.7 upgrade failure

1 Answers1