CA IDMS Tuesday Tip by Edward Gorga, Principal Support Engineer for November 26, 2013.
Database procedures run in system mode so if there is an abend in a database procedure it will cause the whole IDMC CV to abend.Any error handling routine in the procedure should avoid doing anything that will cause a failure. If you are issuing DML calls do not call the ABORT routine for unexpected error status codes as this will abend the whole CV. More details on this are available in TEC600624. For details on coding database procedures see the Database Administration Guide, Chapter 16 "Writing Database Procedures".