Hi,

Please vote up the new ideas I logged for Server Enhancements

• https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-579 Add functionality level 
• https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-580 Add ability to control optimizer version
• https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-581 Add object names to onstat -k output 
• https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-582 Add ability to print deadlock information 
• https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-583 Add Query Store functionality to Informix and revert to Last Good Plan 
• https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-584 For sysprocplan add ability to view the plan 
• https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-585 For sysprocplan add reason for last change/recompile. 
• https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-586 Add sql causing change when dictionary entries become dirty.

Regards,
David.

Hi,

Also https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-587  When AUTO_REPREPARE is non zero only have 1 sessions recompile a stored procedure 

Regards,
David.