Direct link to fix
APAR status
Closed as program error.
Error description
DB2 z/OS reports an error "Reason code: "24". SQLSTATE=56090 SQLCODE=-650" when the following sql statement is executed: ALTER TABLE ZPSV17E.BPM_ASSET_CACHE_SAVE_INSTR DROP "DATA_SEQ" DROP"DATA" PRODUCTS AFFECTED IBM Business Automation Workflow
Local fix
Problem summary
The mentioned SQL statement does not have the correct syntax for DB2 for z/OS.
Problem conclusion
A fix is available or will be available that corrects the SQL syntax issue in the upgrade script.
Temporary fix
Comments
APAR Information
APAR number
JR63980
Reported component name
BUS AUTO WORKFL
Reported component ID
5737H4100
Reported release
L00
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-07-26
Closed date
2021-10-01
Last modified date
2021-10-01
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":"21.0.2"}]
Document Information
Modified date:
02 October 2021