Re: Reason codes for Access Plan not Updated - help please!

Thank you Stefan!

Clare


----- Original Message ----- 
From: "Stefan Tageson" <Stefan.Tageson@xxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Wednesday, May 25, 2005 2:08 PM
Subject: Re: Reason codes for Access Plan not Updated - help please!


"Can anyone point me in the direction of reason code meanings for field
QVC24
(Access plan not saved) "

Please ignore my previous post - this one should be a better match.

http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/rzajq/rzajqmst182.htm


Access plan not saved reason code. Possible reasons are:
A1 - Failed to get a LSUP lock on associated space of program or package.
A2 - Failed to get an immediate LEAR space location lock on first byte of
associated space of program.
A3 - Failed to get an immediate LENR space location lock on first byte of
associated space of program.
A5 - Failed to get an immediate LEAR space location lock on first byte of
ILE associated space of a program.
A6 - Error trying to extend space of an ILE program.
A7 - No room in program.
A8 - No room in program associated space.
A9 - No room in program associated space.
AA - No need to save. Save already done in another job.
AB - Query optimizer could not lock the QDT.
B1 - Saved at the end of the program associated space.
B2 - Saved at the end of the program associated space.
B3 - Saved in place.
B4 - Saved in place.
B5 - Saved at the end of the program associated space.
B6 - Saved in place.
B7 - Saved at the end of the program associated space.
B8 - Saved at the end of the program associated space.



Regards,

Stefan Tageson
Informatikk Sverige AB
Propellergatan 1, SE-211 19 Malmö, Sweden
Cell :     +46 (0) 733 913 813
stefan.tageson@xxxxxxxxxxxxxx

http://www.informatikk.se/

-------------------- Internet e-Mail Disclaimer --------------------
This e-mail and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. If you are not the intended recipient you are notified that any
use, disclosure, copying or distribution of the information is prohibited.
In such case, you should destroy this message and kindly notify the sender
by reply e-mail.The views expressed in this e-mail and any attachments are
personal and, unless stated explicitly, do not represent the views of
Informatikk. Furthermore, Informatikk will not be bound by this e-mail.