up vote 0 down vote favorite
share [g+] share [fb]

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

link|improve this question
Might help if you also tell us what OS. – mfinni May 20 '11 at 13:55
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
RedHat Linux 5.5 and there's no db2grep on the fs – Eddy May 20 '11 at 14:17
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
feedback

1 Answer

up vote 0 down vote accepted

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.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.