Solution : https://service.sap.com/sap/support/notes/1536572 (SAP Service marketplace login required)
Summary :
SAP Note addresses the issue of dynamic SQL statements crowding SQL packages, causing SQL0904 errors. Statements are stored in packages for efficiency, but overuse leads to congestion. Solutions include increasing package size (SAP Note 54028), using discardable packages for transient statements (SAP Note 1109771), and distributing statements across multiple packages (this Note). To implement, apply the designated LIB_DBSL patches and, if required, delete existing SQL packages (SAP Note 63037). Enable package dispersion through profile parameters. For diagnostics, utilize specific commands to list and manage dispersed SQL packages.
Key words :
terms hints dbsl conditional statement hints single_execution single execution db4, filling sql packages causing resource limit exceeded errors, dbs/db4/dbsl_tablehint0 = table = 'ztab' & nostmtid = true, dbs/db4/dbsl_tablehint0 = table = ', singleexecution conditional statement hints, dbs/db4/dbsl_tablehint1 = table = ', bc-db-db4 queue, packagedispersion conditional statement hint, form r3<sid>z0nn, libraries r3<sid>z000
Related Notes :
| 1109771 | DB4: Conditional Statement Hints |
| 1109573 | DB4: Auto SingleExecution for Package Overflow |
| 63037 | AS/400: Deleting SQL Packages |
| 54028 | IBM i: SQL0 904 reason code 7, overflow in SQL package |