Description:
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:
com.ibm.db2.jcc.am.SqlException: An SQL OPEN for a held cursor was issued on a XA connection ERRORCODE=-4496, SQLSTATE=null
Note:
This does not apply to Tomcat and JBOSS Application Server environments
Solution:
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.
https://www-304.ibm.com/support/docview.wss?uid=swg21386486
The alternative is to revert to a 'connection pooled' datasource where the error does not occur.