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
 

 

How to see which job is holding the IMS database

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
damuonmail

New User


Joined: 07 Mar 2005
Posts: 12

PostPosted: Fri Apr 06, 2007 2:46 pm    Post subject: How to see which job is holding the IMS database
Reply with quote

Hi All,

Incase of IMS database contention, how to see which job is holding the IMS database. What is the procedure for solving this?
Back to top
View user's profile Send private message

Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Wed Apr 11, 2007 11:39 am    Post subject:
Reply with quote

Are you referring Update or Inquiry Jobs.

Most of the time if there is any contention of the DB dataset then the DB will be displayed in Job log with messag like which job it's waiting and reason ..etc.

The contention can happen with design flaws or batch jobs overlapping. Just make sure the timing of batch jobs doesnt overlap.
Back to top
View user's profile Send private message
rajatbagga

Active User


Joined: 11 Mar 2007
Posts: 188
Location: india

PostPosted: Wed Apr 11, 2007 5:18 pm    Post subject: Re: How to see which job is holding the IMS database
Reply with quote

In your IMS region issue the following command:

/DIS REG A

This is provide you with the information your require.

After getting this information you can do the take nessesary actions to release the database.
Back to top
View user's profile Send private message
girias

New User


Joined: 09 Feb 2007
Posts: 26
Location: Chennai

PostPosted: Fri May 04, 2007 7:58 pm    Post subject:
Reply with quote

Hi,

I am not getting what do mean by IMS region. I also have a similar issue. Pls tell me whr should I isue this command.
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Tue May 08, 2007 8:05 am    Post subject:
Reply with quote

IMS Region - IMS DC
If you are working in IMS DB/DC then Im sure you have IMS online screens. Where do you see your IMS DC Screens?
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Wed May 09, 2007 2:10 am    Post subject:
Reply with quote

girias wrote:
Hi,

I am not getting what do mean by IMS region. I also have a similar issue. Pls tell me whr should I isue this command.


If you don't know what an IMS region is I'm afraid you also won't be able to issue the dis reg command. Any system operator around to help you out? BTW, is this one related to your ITEM-problem in another topic? If so please combine them so we all understand the complete problem icon_wink.gif
Back to top
View user's profile Send private message
girias

New User


Joined: 09 Feb 2007
Posts: 26
Location: Chennai

PostPosted: Wed May 09, 2007 9:52 am    Post subject:
Reply with quote

George,

Thanks for ur reply on both the topic.

Both are different issues. Actually we dont have access to IMS Online Screens in our system. We have access only to IMS File-aid to browse.

The thing is, the job is getting abended with Abend code of U850 (IMS Contention). So, I need to analyse with which resource/Job is it getting contented with. Is there any other method to find that.

Please advise. Thanks for all Ur replies in advance.
Back to top
View user's profile Send private message
rahulkolhe2003

New User


Joined: 06 Mar 2007
Posts: 12
Location: columbus

PostPosted: Wed May 09, 2007 8:49 pm    Post subject: Re: How to see which job is holding the IMS database
Reply with quote

Do you know the IMS control region job name running on system? That could help you to find out the resources holding the IMS database. :?:
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Thu May 10, 2007 12:02 am    Post subject:
Reply with quote

Since an IMS database is plain VSAM you could try to find out using TSO if you know the DSNAME.
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 -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
No new posts Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am
No new posts Database access from COBOL amitmahalkar DB2 1 Wed Jan 27, 2016 11:33 am
No new posts Database backup on IMS DB HABBIE IMS DB/DC 1 Wed Aug 12, 2015 9:02 pm
No new posts Database name in Z/OS HABBIE DB2 6 Fri Aug 07, 2015 5:52 pm


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