Accessing TSM from an other non-DB2 unix user

[Former Member]

Hello forum,

does anybody know how TSM could be access from an other unix user acount. The user is not a db2 instance owning user.

Following scenario:

DB2 instance owning user is db2<sid>. This user has a tsm configuration with opt-file and so on.

This user is able to access TSM with db2adutl and display or delete backups and archives in TSM.

How could be backups and archives displayed or deleted in TSM with db2adutl from an other user account not owing a DB2 instance?

db2adutl ..... nodename <nodename> password <password> ... does not work.

Thanks in advance.

Regards,

Gerhard Paulus

[Former Member · Accepted solution]

Hello Gerhard,

1. you can try to use UNIX s-bit to ensure that db2adutl always uses db2<dbsid> to execute the TSM commands. I have not tried this with db2adutl. This might not work because the s-bit can cause trouble because of security features of the OS (removal of library path,...).

The old db6adutl of the SAP log file management tools uses this trick to get the TSM commands done. db6adutl works. db6adutl is only support until SAP Kernel 6.40.

2. you can create a fenced stored procedure or UDF and execute the db2adutl from inside the SP/UDF. Because the fenced user is on SAP system always db2<dbsid> this works.

3. if you are only interested in the deletion of recovery objects(logs and backups) and you already have DB2 9.5 you think about using the auto_del_rec_obj db cfg.

Best regards,

Jens

Edited by: Jens Seifert on Feb 5, 2009 8:15 AM

[Former Member · Accepted solution]

Hello Jens,

I know the db cfg parameter AUTO_DEL_REC_OBJ. But we backup our large database using split mirror (SET WRITE SUSPEND) and backup this split mirror from another LPAR into TSM.

AUTO_DEL_REC_OBJ only works fine when the db2rhist.asc is updated with backups and archives. In our environment we cound not use backup USE SNAPSHOT because it is a fully virtualized environment using VIO servers. So the backups are not recoreded in the db2rhist.asc file. So AUTO_DEL_REC_OBJ does not work fine in such a environment.

I think the recommendation to implement a fenced routine is suitable.

Do you have a skeleton for such a fenced routine?

Regards,

Gerhard

[Former Member · Accepted solution]

Hello Gerhard,

SAP already ships such a UDF: db6pm_lst.

Try the following:

 db2 "select * from table(sap<sapsid>.db6pm_lst('db2adutl ....')) as t" 

Replace <sapsid> and ... accordingly.

Best regards,

Jens

[Former Member · Accepted solution]

Hello Jens,

Thanks, that's it I searched for.

Regards,

Gerhard