MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

How to find the link between a transaction & database fi

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> IMS
View previous topic :: View next topic  
Author Message
gore
Beginner


Joined: 10 Dec 2002
Posts: 46
Topics: 20
Location: Providence, RI

PostPosted: Fri Dec 19, 2003 7:33 am    Post subject: How to find the link between a transaction & database fi Reply with quote

I have an IMS online region which is executing a transaction(IMS DC) that updates a particular database with some values.

I wan't to check if the values updated are correct or not.

Corresponding to each DBD we have a DD name & a physical file where the data resides. this file name has only the last qualifier.

My installation does not have a very good naming conventions and there are multiple physical files corresponding to a single database. When I browse thru those different files using IMS fileaid i see the data residing on them. Now the question is on which database file is the data actually being updated so that I can check it thru IMS fileaid.

Is there some way by which i can find the link between transaction in a particular IMS region & the actual physical database file corresponding to it. DBD as i told before has only the last qualifier. Please do not suggest ask DBA as that is the last resort, but I beleive there must be some way of finding this relationship.

I have mainview in my installation. Can we use any particular option in it to find this relationship? I am new to mainview os please be elaborate if possible.
_________________
Gore
Back to top
View user's profile Send private message
Bithead
Advanced


Joined: 03 Jan 2003
Posts: 550
Topics: 23
Location: Michigan, USA

PostPosted: Fri Dec 19, 2003 9:52 am    Post subject: Reply with quote

In my experience, the probability is that either different segments or groups of segments reside in the seperate files OR the database organization is OSAM which allows it to be defined over several files. If the former is true, then you need to determine which segment is being updated and that gives you the file. If it is OSAM, then it is harder.

If you are using FileAid for IMS, you do not need to know which dataset the data is in. It should allocate it based on the PSB or DBD being used. If you are not using dynamic allocation, add all the datasets that apply to the DBD.
Back to top
View user's profile Send private message
Surendra
Beginner


Joined: 02 Sep 2004
Posts: 3
Topics: 1

PostPosted: Tue Mar 22, 2005 12:49 am    Post subject: Reply with quote

Hi Kolusu,

I want to further describe my problem. I have updated an IMS DB Database through a transaction in test region IMST. I want to verify the updated records through fileaid. I know the name of DBD but I don't know which physical datasets has been updated. There are several datasets for the same DBD lying in my shop in test region. We need to specify dataset names to browse through file aid.

Please tell me where in IMS transaction definition, we specify the datasets being accessed.

Thanks
Surendra
Back to top
View user's profile Send private message Send e-mail
Bithead
Advanced


Joined: 03 Jan 2003
Posts: 550
Topics: 23
Location: Michigan, USA

PostPosted: Tue Mar 22, 2005 9:17 am    Post subject: Reply with quote

There is nowhere in the transaction that specifies DS name. It is defined to the IMS control region.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> IMS All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group