Invoking Impact Analysis ERRORCODE=-4496

Document ID : KB000050261
Last Modified Date : 14/02/2018
Show Technical Document Details


If you are running CA Repository for z/OS WebStation Option r7.2 in a Websphere Application Server environment, and using a 'XA' Data Source connection, any attempt to click on the Impact Analysis Icon for any given row in a result set will produce the following error: An SQL OPEN for a held cursor was issued on a XA connection ERRORCODE=-4496, SQLSTATE=null

This does not apply to Tomcat and JBOSS Application Server environments


IBM has a solution for this error when using a 'XA' DataSource connection with your application(s) defined within Websphere.

Please refer to the following url.
The alternative is to revert to a 'connection pooled' datasource where the error does not occur.