identify which are all the jobs using my tables

sivatechdrive · Posted: Tue Jun 05, 2007 9:24 am

Hi all,

1. i have 5 tables & there are multiple jobs running
How to identify which are all the jobs using my tables

is there any command \tool to identify them

2. if there is a deadlock how to identfy which resources re in lock

in my project we have the following
SPUFI,QMF,PLATINUM for DB2, OMEGAMON for DB2

Can some one please help me

Regards
Prasasd

pingte · Active User Joined: 03 Dec 2005 Posts: 120 Location: india

Step 1:
U can use option 3.14 to search the table name in the PDS containing all COBOL-DB2 source codes (give table name in search string)
Step 2:
U can use this program name again in 3.14 and search the JCL or cataloged PROC PDS to search which all jobs are using it.

If table is directly used in Control cards, then u can use 3.14 to search th econtrol card PDS.

Hope this solves ur problem

pingte · Active User Joined: 03 Dec 2005 Posts: 120 Location: india

Please note 3.14 is ISPF main menu option.

If there is a deadlock, Ur program will abend and SQLCODE will be -911 and SQLSTATE of 40502. Look at the dump and c where that program has abended. By this u will have a idea which resource in deadlock state.

Hope this helps.

munikumar · New User Joined: 18 Apr 2007 Posts: 24 Location: India

Hi,

Sometime deadlocks can abend with -913 also. When -913, we need to rollback LUW exclusively. When -911, system will do it automatically.

After looking into the logs you will get the resource name. If you want to see whether this resource is still using or not, you can use DISPLAY command in DB2I commands.

Regards
Munikumar G

sumannaidu · New User Joined: 21 May 2005 Posts: 13 Location: Bangalore

Hi Siva,
By using OMEGAMON you can find which table is being used by a specific job. it will also tell u till that time how many rows have been fetch or updated...browse for the different options in omegamon.

look123 · New User Joined: 20 Apr 2007 Posts: 9 Location: pune

What is 'OMEGAMON'?I hear first time.

Please give me advise.

Regards

suresh

dick scherrer · Posted: Thu Jun 07, 2007 9:17 pm

Hello,

Omegamon (or OMON as it is sometimes called) is a monitoring tool.

If you do a web search, you will find many hits.