AC return code in GHU call

Umeshrath · New User Joined: 28 Feb 2006 Posts: 2 Location: Hyderabad

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

Karthigaiselvan · New User Joined: 11 Dec 2006 Posts: 35 Location: India

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.

Devzee · Posted: Thu Sep 13, 2007 11:57 pm

Sandy Zimmer · Posted: Fri Sep 14, 2007 7:20 pm

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.

Sandy Zimmer · Posted: Fri Sep 14, 2007 7:26 pm

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?.

Bitneuker · Posted: Mon Sep 17, 2007 3:58 am

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.