Page 1 of 1
How to find batch job info
Posted:
Sun Feb 27, 2011 8:12 pmby Panda15
Hi
Can anybody pls let me know the way to find out which batch job is accessing a tablespace? Thanks.
Regards
Panda15
Re: How to find batch job info
Posted:
Mon Feb 28, 2011 1:01 amby dick scherrer
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.
Re: How to find batch job info
Posted:
Mon Feb 28, 2011 9:53 amby Panda15
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
Re: How to find batch job info
Posted:
Mon Feb 28, 2011 1:31 pmby GuyC
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.