IBM Support

Database changes for Java Batch in

Question & Answer


What changes have been made to the database table structure for the Java Batch job repository in


The Java Batch job repository has new elements introduced with the fixpack. The JOBINSTANCE table has a new column UPDATETIME, and there is a new table named JOBPARAMETER.

Updating the job repository database to include these new elements will enable additional search and sort options when querying job instances using the REST API. Attempting to utilize the new search and sort options without upgrading the database will result in the following message:

CWWKY0153E: The job repository database doesn't support search or delete by job parameters because no JOBPARAMETER table exists in database.

There are two ways to update the database to include these new elements:

1. In the server configuration, for the databaseStore element associated with the batchPersistence configuration object, ensure that the createTables attribute has a value of "true". This will automatically bring the database up-to-date on the next server start.
2. If the createTables attribute is set to "false" instead, the user must manually update their database. The DDL statements for the new table structure can be generated using the ddlGen script located in the [wlp_home]/bin directory.

NOTE: In fixpack, an issue exists when attempting to use the ddlGen script while the createTables attribute is not set to "false". Please see the following for more details:

[{"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Batch applications","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF012","label":"IBM i"},{"code":"PF016","label":"Linux"},{"code":"PF014","label":"iOS"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"},{"code":"PF013","label":"Inspur K-UX"},{"code":"PF022","label":"OS X"}],"Version":"","Edition":"Liberty","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
17 November 2019