java.sql.SQLException: [SPSSOEM][DB2 JDBC Driver]No more available statements. Please recreate your package with a larger dynamicSections

Technote (FAQ)


When attempting to delete a job within SPSS Deployment Manager the above message is returned. Deleting old Labels/Versions up to current and removing job steps from within the job does not resolve the problem. Where can DynamicSections be altered in order to staisfy the error message request?


Add additional parameters to SPSSDataSource jdbc driver connection URL. For example, this can be found in the Web Sphere admin console under

JDBC->Data sources->SPSSDdataSource->Custom Porperties JDBC providers > SPSSDataDirect > Data sources > SPSSDataSource > Custom Properties

Add the following parameters to the JDBC URL DynamicSections=400;CreateDefaultPackage=TRUE;ReplacePackage=TRUE on the URL.
E.G. :

Rate this page:

(0 users)Average rating

Document information

More support for:

SPSS Collaboration and Deployment Services
Content Repository

Software version:


Operating system(s):


Reference #:


Modified date:


Translate my page

Machine Translation

Content navigation