Hi all once again!

More data related to the Db2 <--> TSM problem.

I hope this helps.

1.-

TSM version: 5.1
S.O. :  4.3.3. y
DB2 : 7.01

Host: crtpxd

The online backup has worked fine for about 7 days. Then. It has crashed
returning the following error.

db2 => backup db TJD online use adsm
SQL2062N  An error occurred while accessing media
"/db2/db2TJD/sqllib/adsm/libtadsm.a".  Reason code: "610".



2.- My dsmclientV3.cat files

crtpxd/root:/usr/tivoli/tsm/client/api/bin/en_US> ls -al
total 616
drwxr-sr-x   2 root     sys          512 Jun 11 16:24 .
drwxr-sr-x   5 root     sys          512 Jun 11 18:27 ..
-rwxrwxrwx   1 root     sys       304751 Jun 11 16:21 dsmclientV3.cat
y ...
y ...

crtpxd/root:/usr/lib/nls/msg/en_US> ls -al dsmclientV3.cat
lrwxrwxrwx   1 root     system        52 Jun 12 11:57 dsmclientV3.cat ->
/usr/tivoli/tsm/client/api/bin/en_US/dsmclientV3.cat



3.- The last log sent to TSM

NODE_NAME: crtpxd_DB2
FILESPACE_NAME: /TJD
  FILESPACE_ID: 1
          TYPE: FILE
       HL_NAME: /NODE0000/
       LL_NAME: S0000226.LOG
     OBJECT_ID: 790688
  ARCHIVE_DATE: 2002-06-07 11:26:42.000000
         OWNER: db2TJD
   DESCRIPTION: Log file for DB2 database TJD
    CLASS_NAME: DEFAULT


4.- The last online backup done with TSM

NODE_NAME: crtpxd_DB2
 FILESPACE_NAME: /TJD
   FILESPACE_ID: 1
          STATE: ACTIVE_VERSION
           TYPE: FILE
        HL_NAME: /NODE0000/
        LL_NAME: FULL_BACKUP.20020607015907.1
      OBJECT_ID: 788236
    BACKUP_DATE: 2002-06-07 02:00:16.000000
DEACTIVATE_DATE:
          OWNER: db2TJD
     CLASS_NAME: DEFAULT



5.- More:

crtpxd/root:/> /usr/lpp/db2_07_01/adsm/db2adutl query full db TJD
--- Database directory is empty ---
Query for database TJD
Query for database TJD


Retrieving FULL DATABASE BACKUP information.
    1 Time: 20020607015907  Oldest log: S0000222.LOG  Node: 0    Sessions: 1
    [...]
    8 Time: 20020530183503  Oldest log: S0000000.LOG  Node: 0    Sessions: 1


6.- And more


crtpxd/root:/usr/lpp/db2_07_01/adsm> ./db2adutl verify full

Query for database TJD
Retrieving FULL DATABASE BACKUP information.  Please wait.

 FULL DATABASE BACKUP image:
./TJD.0.db2TJD.NODE0000.CATN0000.20020607015907.001, Node: 0

   Do you wish to verify this image (Y/N)?  y

==================
BUFFER 1
==================

[...]

==================
BUFFER 1823
==================

WARNING only partial image read, bytes read: 28672 of 4194304


Read 0 bytes, assuming we are at the end of the image

Image Verification Complete - successful.


7.-

I've tried deinstalling TSM and installig version 4.2 --> Error persists
And

After upgrading to 5.1. --> Error persists



8.- Environment variables for root


crtpxd/root:/> env| grep DSMI
DSMI_CONFIG=/usr/tivoli/tsm/client/api/bin/dsm.opt
DSMI_LOG=/usr/tivoli/tsm/client/api/bin
DSMI_DIR=/usr/tivoli/tsm/client/api/bin


9.- Environment variables for db2TJD (db administrador)

crtpxd/root:/> su - db2TJD
crtpxd:db2TJD 1> env| grep DSMI

DSMI_DIR=/usr/tivoli/tsm/client/api/bin
DSMI_LOG=/usr/tivoli/tsm/client/api/bin
DSMI_CONFIG=/usr/tivoli/tsm/client/api/bin/dsm.opt


I hope this helps.

Un saludo / Best regards,
____________________________

Borja Borrego Caro
ERP IT Systems Division
mailto: borja.borrego AT cromion-it DOT com

Cromion IT - Outsourcing Services for Business
Parque Tecnolsgico de Zamudio - Edificio 101 D
48170  ZAMUDIO - SPAIN
Office:  (+34) 94 601 9485
Fax:      (+34) 94 601 9731



Dear all!


Our db2 v7.1 online backups on AIX have been working succesfully for 7 days,
but now, we get the following error:

db2 => backup db swp online use adsm
SQL2062N  An error occurred while accessing media
"/db2/db2tjd/sqllib/adsm/libtadsm.a".  Reason code: "610".

The problem doesn't seem to be due to
unavailabilty of the dsmclientV3.cat file (everythig had worked fine for
seven days,
and the specified linked file exist).

Following, the explanation of this API error message

****************************+
Explanation: The system is unable to open the message txt file
     (dscameng.txt or dsmclientV3.cat for AIX). On the AS/400 platform this
file is QANSAPI/QAANSAMENG(TXT).

     System Action: The system returns to the calling procedure.

     User Response: Verify that the dscameng.txt file is in the directory
pointed to by DSMI_DIR. For AIX, verify that the dsmclientV3.cat file has a
symbolic link /usr/lib/nls/msg/<locale>/dsmclientV3.cat .
******************************

Thanks in advance

Can somebody help?

Borja Borrego