User upgraded DB2 v8 to V9.1 and used Spotlight for DB2 version 6.2 to connect to the database. User receives below error either on the SQL tab or on the History browser:
Message:
An error occurred while refreshing the table "DBaseHistory" in connection "EDT1D ( DB2EDT1D )".
* Click OK to continue,
* Click Ignore to ignore any further errors related to this table, or
* Click Disconnect to close this connection.
------------------------------------------------------------------------
--------
Details:
Table DBaseHistory
Error in SnapTableFunc.BuildResultSet SQL: -1476 Message: [IBM][CLI Driver][DB2/AIX64] SQL1476N
The current transaction was rolled back
because of error "-973". SQLSTATE=40506
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center