IBM Mainframe Forum

Hi

Can anybody pls let me know the way to find out which batch job is accessing a tablespace? Thanks.

Regards
Panda15

Hello and welcome to the forum,

Suggest you work with your dba and/or system support people. They will know what tools are available on your system.

Hi

I my self am a DBA. New to DB2. Can you please give me some pointers on how to find this info. Are there any catalog tables present to indicate this. At least, if I know where to start from, I will try to find it out. Can you also suggest, if you are reffering to tools like BMC catalog manager etc?

Thanks.

Regards
Panda15

for batch programs and subroutines : in sysbm.syspackdep or in sysibm.systabauth where granteetype = 'P'
Now you have to match program to batch job. which can be easy or difficult depending on the setup on your site, but is outside DB2.

for DB2 utilities you'll have to do a scan of some kind.