JR48878: "BAD SQL GRAMMAR" WHEN UPGRADING TO BPM 22.214.171.124 WITH DB2 9.5
Closed as program error.
If you upgrade to BPM 126.96.36.199 or install IFix JR46470 on top of BPM 188.8.131.52 while using DB2 9.5, a DB2 error "bad SQL grammar" / "SQLCODE=-104, SQLSTATE=42601" will prevent the system from working correctly.
Upgrading to BPM 184.108.40.206 with DB2 9.5 leads to "BAD SQL GRAMMAR" error in SystemOut.log PROBLEM DETAILED DESCRIPTION: In BPM 220.127.116.11, some queries were restructured. Especially, the query that retrieves alive Event Managers is now done with the 'WITH UR' clause to reduce locking behavior. Unfortunatly, this query is used as a sub query, and 'WITH UR' in sub queries is not supported by DB2 9.5.
This IFix introduces code changes that determine whether DB2 9.5 is in use, and if so, the code strips the 'WITH UR' clause from the sub query that retrieves the alive Event Managers. FIX AVAILABILITY: iFix for 18.104.22.168 is/will be available on Fix Central; search for APAR JR48878 at http://www.ibm.com/support/fixcentral/ iFix for 22.214.171.124 is/will be available on Fix Central; search for APAR JR48878 at http://www.ibm.com/support/fixcentral/ Fix is also targetted for inclusion in next fixpack for BPM 8.0.1 When obtaining any of the above fixes, be sure to download the accompanying readme, for itself, and any prerequisite fixes, and review them thorougly.
Reported component name
Reported component ID
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fixed component name
Fixed component ID
Applicable component levels
Translate this page: