Question & Answer
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 18.104.22.168, 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
17 November 2019