DB2 backup 1

[Morsing]

Hi,
I've been trying to backup to TSM (z/OS) from a DB2 client (AIX).
I keep getting this error and can't find a solution anywhere:

db2 => backup db tsmtest use tsm
SQL2071N An error occurred while accessing the shared library
"/home/db2inst1/sqllib/adsm/libtadsm.a". Reason code: "1".
db2 =>

Is it obvious to anyone what the problem might be??
It runs on a p690 partion and I have tried several different.

Cheers

Henrik Morsing
Certified AIX 4.3 Systems Administration
& p690 Technical Support

 

[mcridercoach]

Check the environment (in db2, env |grep DSMI) and make sure they are set properly pointing to the tivoli directory.

Also you might try to update the TSM_NODENAME and TSM_PASSWORD in db2:
db2 update db cfg for DBNAME using TSM_NODENAME "hostname"-db2
db2 update db cfg for DBNAME using TSM_PASSWORD "password"

 

[Morsing]

Hi and thanks for your answer. I got it sorted.

The problem is that even though the TSM client install has to be the AIX 5.1 64bit version, the API libraries has to be the AIX 4.3 32bit version.
The OS itself is AIX 5.1 32bit to add to the confusion!!!!

Cheers

Henrik Morsing
Certified AIX 4.3 Systems Administration
& p690 Technical Support

 

[ddprasad]

For Quite a Few Days I am trying to develop an interactive backup interface using both java swing and also on Visual C++. Both of them stuck at a point where I am trying to execute SQL backup command.

The following command works fine from Command Center:

backup database ddp to c:\testdb2\dp

But When the same command is executed through
ExecuteSQL of CDatabase in Visual C++ and execute() of Statement in Java Swing I Get the following error message:

java.sql.SQLException: [IBM][CLI Driver][DB2/NT] SQL0007N The character "\" following "P DATABASE DDP TO c:" is not valid. SQLSTATE=42601

I would be thankful if any one can sort out the problem.