Good morning, Everyone!
If you have you ever upgraded to DB2 release 10 and experienced the following error:
** ASMA254I *** MNOTE *** 2+ 12,HOLD CURSOR NOT VALID FOR DB2 RELEASE LESS THAN 2.3
please know that this error occurs when your DB2RELparameter is set to to a value of '10' by coding DB2REL=10.
To resolve this,
1. please go to your OMSMCMD2 macro which overrides the values in your DQSMCMD macro.
2. These two are found in your CA Pan/SQL CAIMAC
3. Please set DB2REL=101.
This will resolve the above error.
Please have a wonderful Tuesday and let me know anytime you have a question or concern regarding CA Easytrieve product. I will be glad to help!
Diana Shaw
Principal Tech Support Engineer