Database changes for Java Batch in 126.96.36.199
What changes have been made to the database table structure for the Java Batch job repository in 188.8.131.52?
The Java Batch job repository has new elements introduced with the 184.108.40.206 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 220.127.116.11, 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
More support for:
WebSphere Application Server
Software version: 18.104.22.168
Operating system(s): AIX, HP-UX, IBM i, Inspur K-UX, Linux, OS X, Solaris, Windows, iOS, z/OS
Software edition: Liberty
Reference #: 1995665
Modified date: 14 December 2016