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.