View previous topic :: View next topic |
Author |
Message |
gore Beginner
Joined: 10 Dec 2002 Posts: 46 Topics: 20 Location: Providence, RI
|
Posted: Fri Dec 19, 2003 7:33 am Post subject: How to find the link between a transaction & database fi |
|
|
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 |
|
|
Bithead Advanced
Joined: 03 Jan 2003 Posts: 550 Topics: 23 Location: Michigan, USA
|
Posted: Fri Dec 19, 2003 9:52 am Post subject: |
|
|
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 |
|
|
Surendra Beginner
Joined: 02 Sep 2004 Posts: 3 Topics: 1
|
Posted: Tue Mar 22, 2005 12:49 am Post subject: |
|
|
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 |
|
|
Bithead Advanced
Joined: 03 Jan 2003 Posts: 550 Topics: 23 Location: Michigan, USA
|
Posted: Tue Mar 22, 2005 9:17 am Post subject: |
|
|
There is nowhere in the transaction that specifies DS name. It is defined to the IMS control region. |
|
Back to top |
|
|
|
|