TSM has been uninstalled and now db2 reports SQL2071N error with Reason code 1

[former_member240656]

Hello db2 experts,

TSM has been uninstalled on our SUSE server hosting SAP and now db2 reports 'SQL2071N  An error occurred while access the shared library /db2/TCK/sqllib/adsm/libtsm.a. Reason code: "1" when attempting to access the db. Also I can't start my instance of ECC6.

For example.......

host-name:db2tck 91> db2 select schemaname from syscat.schemata

SQL2071N  An error occurred while accessing the shared library

"/db2/TCK/sqllib/adsm/libtsm.a". Reason code: "1".

host-name:db2tck 92> db2adutl query

db2adutl: error while loading shared libraries: libApiTSM64.so: cannot open shared object file: No such file or directory

host-name:db2tck 93>

NOTE: db2 config settings

First log archive method                 (LOGARCHMETH1) = DISK:/db2/TCK/log_dir/

Second log archive method            (LOGARCHMETH2) = OFF

How do I resolve this? 

[maria_shen · Accepted solution]

Hello Mike,

Did you get the same error when trying to connect the database? (db2 connect to <sid>)
If yes, then you may consider to re-install the DB2 software, and then update the database instance under the newly installed software directory with root user.

Kind regards
Maria

[former_member240656 · Accepted solution]

Hello Maria,

Thank you for your response.

When I execute db2 connect to TCK I do get the same error.

host:db2tck 52>  db2 connect to TCK

SQL2071N  An error occurred while accessing the shared library

"/db2/TCK/sqllib/adsm/libtsm.a". Reason code: "1".

host:db2tck 53>

I've got some other things I will try before I do a re-install.

Regards,

Mike

[former_member185954 · Accepted solution]

Hello Mike,

Looks like your TSM library files are missing.

Are you able to locate the library : libApiTSM64.so

On linux , I thought you could use the locate command

locate libApiTSM64.so

or if that fails, try the find command

find / -name "libApiTSM64.so" -print

Regards,

Siddhesh

[former_member240656 · Accepted solution]

Hi Siddesh,

You were correct. Library libApiTSM64.so was missing on my system. I was able to copy it from another system and all is good now. I am able to start db2 and startsap.

Thank you for your suggestion. It resolved my problem.

Sincerely,

Mike

[former_member185954 · Accepted solution]

Fantastic, glad to know, good luck.

Regards,

Siddhesh