Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

identify which are all the jobs using my tables

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sivatechdrive

Active User


Joined: 17 Oct 2004
Posts: 190
Location: hyderabad

PostPosted: Tue Jun 05, 2007 9:24 am    Post subject: identify which are all the jobs using my tables
Reply with quote

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
Back to top
View user's profile Send private message

pingte

Active User


Joined: 03 Dec 2005
Posts: 120
Location: india

PostPosted: Tue Jun 05, 2007 4:05 pm    Post subject: Re: identify which are all the jobs using my tables
Reply with quote

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 icon_idea.gif
Back to top
View user's profile Send private message
pingte

Active User


Joined: 03 Dec 2005
Posts: 120
Location: india

PostPosted: Tue Jun 05, 2007 4:15 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
munikumar
Currently Banned

New User


Joined: 18 Apr 2007
Posts: 24
Location: India

PostPosted: Thu Jun 07, 2007 10:07 am    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
sumannaidu

New User


Joined: 21 May 2005
Posts: 13
Location: Bangalore

PostPosted: Thu Jun 07, 2007 7:43 pm    Post subject: Re: identify which are all the jobs using my tables
Reply with quote

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.
Back to top
View user's profile Send private message
look123

New User


Joined: 20 Apr 2007
Posts: 9
Location: pune

PostPosted: Thu Jun 07, 2007 8:16 pm    Post subject: Re: identify which are all the jobs using my tables
Reply with quote

What is 'OMEGAMON'?I hear first time.

Please give me advise.

Regards

suresh
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Jun 07, 2007 9:17 pm    Post subject:
Reply with quote

Hello,

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

If you do a web search, you will find many hits.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts To know activities on db2 tables ashek15 DB2 4 Fri Mar 03, 2017 11:23 pm
No new posts Determine Region with max bandwidth f... seahawk789 COBOL Programming 3 Mon Feb 27, 2017 8:26 pm
No new posts ERM-Diagram of SysIBM-Catalog-Tables Auryn DB2 2 Fri Feb 17, 2017 6:22 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us