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
 

 

Logical Relationship

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

Active User


Joined: 31 Jan 2008
Posts: 148
Location: Chennai, India

PostPosted: Mon Aug 03, 2009 10:29 pm    Post subject: Logical Relationship
Reply with quote

Hi all,
I am pretty new to IMS and having some doubts on logical relationship.
How to find out the wheher the logical relation is uni-directional or Bi-directional by viewing the DBD?
Will there be any separate DBD defined for this logical relationship?
Back to top
View user's profile Send private message

Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Tue Aug 04, 2009 6:01 pm    Post subject:
Reply with quote

An IMS database is defined first as a physical database. It then has the same logical definition. They match. However, you can define that physical database with a different view - a separate logical view. There are very specific rules for these separate logical database views. Yes, it will have it's own DBD.
Back to top
View user's profile Send private message
murugan_mf

Active User


Joined: 31 Jan 2008
Posts: 148
Location: Chennai, India

PostPosted: Wed Aug 05, 2009 11:06 pm    Post subject: Reply to: Logical Relationship
Reply with quote

Sandy,
Thanks for your reply.
Can you please provide me any links/manuals which explain logical
relationship with detailed examples.
I tried but unlucky!!
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Wed Aug 05, 2009 11:22 pm    Post subject:
Reply with quote

Well, I do not have any. Let me look thru some of my "old" manuals. Is this a job issue (need to know) or just curiosity? Many high transaction processing installations do not allow a logical definition that differs from the physical. Nor do these installations allow "search fields".
Back to top
View user's profile Send private message
murugan_mf

Active User


Joined: 31 Jan 2008
Posts: 148
Location: Chennai, India

PostPosted: Wed Aug 05, 2009 11:32 pm    Post subject:
Reply with quote

Sandy,
As of now I am testing online screens..so It will be better to know.
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Wed Aug 05, 2009 11:39 pm    Post subject:
Reply with quote

If you are testing online screens, then you should already have the DBD. What is your SPECIFIC question and/or problem?

Please post the DBD and what you are trying to do.
Back to top
View user's profile Send private message
murugan_mf

Active User


Joined: 31 Jan 2008
Posts: 148
Location: Chennai, India

PostPosted: Wed Aug 05, 2009 11:48 pm    Post subject:
Reply with quote

As of now there were no problems with my testing.
I have seen a DBD having LCHILD
LCHILD NAME=(XYZ,DB1),POINTER=INDX
If I go view thru File-Aid for ims I could not see the segment XYZ.
How to get the information about this segment?
If i want to write a program with GU call on that segment which database
is requied and how the psb should look like and How can prepare the call statement?
this is totally confusing..
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Thu Aug 06, 2009 12:02 am    Post subject:
Reply with quote

If i want to write a program with GU call on that segment which database is requied and how the psb should look like and How can prepare the call statement?

Does your current program look at the same logical database as the physical definition?

I have seen a DBD having LCHILD LCHILD NAME=(XYZ,DB1),POINTER=INDX

The database statement that you provided is looking at the logical child. The first thing you should do is take a look at that database - you could not see the segment because it is a pointer. Think back on how IMS works. It has pointers - for instance physical twin forward and backward pointers. These are defined at inception of the database and how they are defined dictates performance. So, you need to look at the REAL matching physical/logical database.
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Thu Aug 06, 2009 12:25 am    Post subject:
Reply with quote

Rather than me going thru all of my "OLD" manuals, I found this - it may help.....or at least give you some ideas.......remember having problems and researching is a great way to learn something someone else may not know - and you will never forget it!

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.ims9.doc.adb/ie0a1cho1625982.htm
Back to top
View user's profile Send private message
murugan_mf

Active User


Joined: 31 Jan 2008
Posts: 148
Location: Chennai, India

PostPosted: Thu Aug 06, 2009 1:11 pm    Post subject:
Reply with quote

Thanks a Ton Sandy
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2433
Location: Netherlands, Amstelveen

PostPosted: Fri Nov 06, 2009 10:55 am    Post subject:
Reply with quote

Manual SC19-2479-00
IBM IMS Library Integrity Utilities for z/OS User’s Guide Version 2 Release 1
describes a utility FABNRVRS that will output all DBD/PSB/ACB information
you are interested in.
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 FileAid to compare(logical operations... anand1204 Compuware & Other Tools 3 Wed Apr 06, 2016 2:55 am
No new posts Logical Processors vasanthz All Other Mainframe Topics 4 Mon Sep 08, 2014 11:49 pm
No new posts What's the relationship between DB2 t... dejunzhu DB2 7 Fri Aug 22, 2014 8:28 am
No new posts DD name access using multiple logical... chandraBE COBOL Programming 1 Wed Apr 30, 2014 2:45 pm
No new posts Logical Processors - LPARs Max limit vasanthz All Other Mainframe Topics 6 Sat Oct 26, 2013 12:49 am


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