Direct links to fixes
APAR status
Closed as program error.
Error description
If you are upgrading to IBM Business Automation Workflow V20.0.0.1 with IBM Db2 for z/OS, the upgradeSchema[version_number]_ProcessServer.sql database script might fail with an error similar to the following message: call sysproc.admin_cmd('reorg table @SCHEMA@.BPM_HISTORICAL_DATA_PLAYBACK') This statement produces the error: Exception: [IBM][CLI Driver][DB2] SQL0440N No authorized routine named "SYSPROC.ADMIN_CMD" of type "" having compatible arguments was found. SQLSTATE=42884 SQLCODE=-440
Local fix
Remove all the reorg table sqls from the pgradeSchema[version_number]_ProcessServer.sql script and run the database script again.
Problem summary
No additional information is available.
Problem conclusion
A fix is available or will be available that ensure the Db2 z/OS scripts run successfully.
Temporary fix
Comments
APAR Information
APAR number
JR62766
Reported component name
BUS AUTO WORKFL
Reported component ID
5737H4100
Reported release
K00
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-09-01
Closed date
2020-11-09
Last modified date
2020-11-09
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
BUS AUTO WORKFL
Fixed component ID
5737H4100
Applicable component levels
[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS8JB4","label":"IBM Business Automation Workflow"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"20.0.0.1"}]
Document Information
Modified date:
14 December 2020