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
 

 

AC return code in GHU call

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

New User


Joined: 28 Feb 2006
Posts: 2
Location: Hyderabad

PostPosted: Thu Sep 13, 2007 9:51 pm    Post subject: AC return code in GHU call
Reply with quote

My databse structure is like this.

Number -- parent
Member -- 1st Level
Address -- 2nd Level

I want to update all the address segment whics satisfies a specific condition.

First i am doing Getnext for number then again a get next for member and then again a get next for address.

Then i am checking for my condition if that is satisfied then i am issuing a GHU call with SSAs for all the 3 levels.

I am getting AC status code.

Since i am reading the database sequentially i am issuing GN call and after getting the data if my condition is getting satisfied then i am issuing GHU call and then doing a replace.

Is it ok or i have to issue another GU call inbetween the GN and GHU call.

Is this status code anywhere related to PCB or PSB?

Regards,
Umesh Rath
Back to top
View user's profile Send private message

Karthigaiselvan

New User


Joined: 11 Dec 2006
Posts: 35
Location: India

PostPosted: Thu Sep 13, 2007 10:41 pm    Post subject: Reply to: AC return code in GHU call
Reply with quote

Hi Umesh,

You get status code AC because of hierarchical structure mismatch. That is, when the IMS call tried to fetch the Address segment, it found a different segment other than Address as per the PSB structure.

Possible reasons could be -
1. The sequence of DBs followed in the program to get the IMS address pointers is not consistent with the order mentioned in your PSB.
2. Your PSB might have not defined to access the Address segment (provided you get AC as 2nd level status).

So correct the PSB and also make sure that PSB is updated with required access for the segments used in the program.
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Thu Sep 13, 2007 11:57 pm    Post subject:
Reply with quote

Quote:
i am issuing a GHU call with SSAs for all the 3 levels.


Are you using command code in this GHU call?
Do hold all 3 Segments and do update?

May be you should explain little more about the calls and what function any command codes used in this calls.
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


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

PostPosted: Fri Sep 14, 2007 7:20 pm    Post subject:
Reply with quote

Why are you reading all 3 levels? When you are issuing your GN calls, are you qualifying all 3 of them or once you have the root, are you qualifying all the way down?

Remember Number -- parent is unique
Member -- 1st Level --- you can have 1 to many under a number
Address -- 2nd Level --- you can have 1 to many under a member

If you tell us your requirement, we can help.
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


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

PostPosted: Fri Sep 14, 2007 7:26 pm    Post subject:
Reply with quote

One more thing - you do not need to read all three levels if all you need is the address segments. You would just do a GHN on the address - you can then take a look at your key feedback area and it will tell you the keys for the parents above it. Also, when you got your AC status code, what did your key feedback area say in the key value field and last segment received field?.
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: Mon Sep 17, 2007 3:58 am    Post subject:
Reply with quote

Sandy is right about the GHN for address; no use for this GN and GHU call with multiple SSA's. Besides this your application will (with or without GHU) take a considerable lot of time to retrieve and update all segments that meet the requirement. But.......did you consider to use secondary indexing? Don't know if you are allowed to change any DBD but SI allows you to look different at your database structure. To find out more about SI follow this link, search for secondary index and may be this SI might be a solution. Of course there's also the unload, modify and load possibility. If you consider SI post your situation as it is (at least the DBD's) and your requirements.
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 EXIT or RETURN cvnlynn CLIST & REXX 16 Wed Jul 19, 2017 2:50 am
No new posts UNIT=AFF for Easytrieve code gandikk JCL & VSAM 7 Wed Jul 12, 2017 11:42 pm
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm
No new posts Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 pm
No new posts COBOL Code Parsers and Lineage Establ... balimanja COBOL Programming 2 Tue May 02, 2017 3:30 am


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