TSM 7.1.1.100 to 7.1.5 x86_64 problems

[lipi]

After upgrading the server using the wizard, and after not getting any visible error, I cannot start tsm instance:

tsminst1@tsm01:~/tsminst1> /opt/tivoli/tsm/server/soft/server/bin/rc.dsmserv -u tsminst1 -i /tsm/db/tsminst1/tsminst1/ -q
db2set: symbol lookup error: db2set: undefined symbol: _Z8sqlfcsysP9sqlf_kcfd
db2set: symbol lookup error: db2set: undefined symbol: _Z8sqlfcsysP9sqlf_kcfd
db2set: symbol lookup error: db2set: undefined symbol: _Z8sqlfcsysP9sqlf_kcfd
db2set: symbol lookup error: db2set: undefined symbol: _Z8sqlfcsysP9sqlf_kcfd
db2set: symbol lookup error: db2set: undefined symbol: _Z8sqlfcsysP9sqlf_kcfd
db2set: symbol lookup error: db2set: undefined symbol: _Z8sqlfcsysP9sqlf_kcfd
db2set: symbol lookup error: db2set: undefined symbol: _Z8sqlfcsysP9sqlf_kcfd
db2set: symbol lookup error: db2set: undefined symbol: _Z8sqlfcsysP9sqlf_kcfd

tsminst1@tsm01:~/tsminst1> db2set
db2set: symbol lookup error: db2set: undefined symbol: _Z8sqlfcsysP9sqlf_kcfd


Any hints?

 

[rgg]

I ran a similar upgrade this week...no issues.

I think something happened during the db2 upgrade - that type of error looks like some of the db2 binaries got updated, but others did not.

Maybe try a db2 instance update? http://www-01.ibm.com/support/docview.wss?uid=swg21677705

You might see what db2start/"db2 connect to tsmdb1" report too - i bet it's a more useful error.

 

[lipi]

I ran a similar upgrade this week...no issues.

I think something happened during the db2 upgrade - that type of error looks like some of the db2 binaries got updated, but others did not.

Maybe try a db2 instance update? http://www-01.ibm.com/support/docview.wss?uid=swg21677705

You might see what db2start/"db2 connect to tsmdb1" report too - i bet it's a more useful error.

Yes, it seems that tsminst1 database user binaries had not been upgraded.

You see one from 2015 and one from yesterday:

tsminst1@tsm01:~/sqllib/adm> ls -lah /opt/tivoli/tsm/server/soft/db2/adm/db2set
-r-xr-xr-x 1 bin bin 120K Mar 15 16:14 /opt/tivoli/tsm/server/soft/db2/adm/db2set

tsminst1@tsm01:~/sqllib/adm> ls -lah /tsm/db/tsminst1/sqllib/adm/db2set
-r-xr-xr-x 1 tsminst1 tsmsrvrs 115K Mar 11 2015 /tsm/db/tsminst1/sqllib/adm/db2set

Trying to run it:
tsminst1@tsm01:~/sqllib/adm> /opt/tivoli/tsm/server/soft/db2/adm/db2set
DB2_PMODEL_SETTINGS=MAX_BACKGROUND_SYSAPPS:500
DB2_ALTERNATE_GROUP_LOOKUP=GETGROUPLIST
DB2_SKIPINSERTED=ON
DB2_OPTPROFILE=YES
DB2_BCKP_PAGE_VERIFICATION=TRUE
DB2_KEEPTABLELOCK=OFF
DB2_EVALUNCOMMITTED=ON
DB2_SKIPDELETED=ON
DB2MAXFSCRSEARCH=5
DB2NOEXITLIST=ON
DB2LIBPATH=/opt/tivoli/tsm/server/soft/server/bin/dbbkapi
DB2ENVLIST=LIBPATH
DB2COMM=TCPIP
DB2CODEPAGE=819
DB2_PARALLEL_IO=*

I cannot perform "db2start" since tsminst1 binaries are wrong and "db2start" from tivoli directory is not allowed to be executed (even if I give +x permissions):
tsminst1@tsm01:~/sqllib/adm> /tsm/db/tsminst1/sqllib/adm/db2set
/tsm/db/tsminst1/sqllib/adm/db2set: symbol lookup error: /tsm/db/tsminst1/sqllib/adm/db2set: undefined symbol: _Z8sqlfcsysP9sqlf_kcfd

tsminst1@tsm01:~> /opt/tivoli/tsm/server/soft/db2/adm/db2start
SQL1641N The db2start command failed because one or more DB2 database manager program files was prevented from executing with root privileges by file system mount settings.


I opened a case to IBM but your help would be more than welcome.

I will try what you suggested, also commented here http://www-01.ibm.com/support/docview.wss?uid=swg21639192 , after receiving some feedback from IBM:

/opt/tivoli/tsm/db2/instance/db2iupdt tsminst1 tsminst1

and inform you of the progress.

 

[lipi]

Solved. Although all the logs showed everything went fine in the upgrade (checked also by IBM support), the instance was not upgraded.

performing:

/opt/tivoli/tsm/db2/instance/db2iupdt -u tsminst1 tsminst1

and then starting normally solved the problem.

Regards,

 

[rgg]

Excellent - glad the instance update fixed it! Now you can play with container pool compression