Database changes for Java Batch in 16.0.0.4

The Java Batch job repository has new elements introduced with the 16.0.0.4 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 16.0.0.4, 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: http://www-01.ibm.com/support/docview.wss?uid=swg21994400