How to find batch job info



IBM's flagship relational database management system

How to find batch job info

Postby Panda15 » Sun Feb 27, 2011 8:12 pm

Hi

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

Regards
Panda15
Panda15
 
Posts: 9
Joined: Sun Feb 27, 2011 8:05 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to find batch job info

Postby dick scherrer » Mon Feb 28, 2011 1:01 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: How to find batch job info

Postby Panda15 » Mon Feb 28, 2011 9:53 am

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
Panda15
 
Posts: 9
Joined: Sun Feb 27, 2011 8:05 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to find batch job info

Postby GuyC » Mon Feb 28, 2011 1:31 pm

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.
I can explain it to you, but i can not understand it for you.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post