Fixes are available
APAR status
Closed as fixed if next.
Error description
There is a problem with the DECIMAL=COMMA setting in DB2 for z/OS which impacts the following files in a BPM configuration: BPM/Lombardi/process-server/configTemplates/db/DB2zOS/60Database .xml./dbscripts: scripts/BusinessSpace/DB2zOS/createTable_BusinessSpace.sql scripts/BusinessSpace/DB2zOS/migrateBusinessSpaceSchema700.sql scripts/BusinessSpace/DB2zOS/preMigrateBusinessSpace700.sql scripts/BusinessSpace/DB2zOS/upgradeSchema612_BusinessSpace.sql scripts/BusinessSpace/DB2zOS/upgradeSchema620_BusinessSpace.sql scripts/BusinessSpace/DB2zOS/upgradeSchema750_BusinessSpace.sql scripts/BusinessSpace/DB2zOS/upgradeSchema751_BusinessSpace.sql scripts/CommonDB/DB2zOS/createTable_customization.sql scripts/PerformanceDW/DB2zOS/createTable_PerformanceDW.sql scripts/PerformanceDW/DB2zOS/wle_upgradeSchema_PerformanceDW.sql scripts/ProcessChoreographer/DB2zOS/createSchema_BPC.sql scripts/ProcessChoreographer/DB2zOS/upgradeSchema620.sql scripts/ProcessChoreographer/DB2zOS/upgradeSchema620DB2zOSV7.sql scripts/ProcessChoreographer/DB2zOS/upgradeSchema700.sql scripts/ProcessChoreographer/DB2zOS/upgradeSchema7003.sql scripts/ProcessChoreographer/DB2zOS/upgradeSchema7003DB2zOSV7.sq l scripts/ProcessChoreographer/DB2zOS/upgradeSchema700DB2zOSV7.sql scripts/ProcessChoreographer/DB2zOS/upgradeSchema7500.sql scripts/ProcessChoreographer/DB2zOS/upgradeSchema7500DB2zOSV7.sq l scripts/ProcessServer/DB2zOS/admin_Data_ProcessServer.sql scripts/ProcessServer/DB2zOS/admin_GroupMemberRefData_ProcessSer ver.sq l scripts/ProcessServer/DB2zOS/admin_RefData_ProcessServer.sql scripts/ProcessServer/DB2zOS/bpmAuthor_GroupMemberRefData_Proces sServe r.sql scripts/ProcessServer/DB2zOS/createProcedure_ProcessServer.sql scripts/ProcessServer/DB2zOS/createTable_ProcessServer.sql scripts/ProcessServer/DB2zOS/twadmin_GroupMemberRefData_ProcessS erver. sql scripts/ProcessServer/DB2zOS/twauthor_GroupMemberRefData_Process Server .sql scripts/ProcessServer/DB2zOS/twportaladmin_GroupMemberRefData_Pr ocessS erver.sql scripts/ProcessServer/DB2zOS/twuser_GroupMemberRefData_ProcessSe rver.s ql scripts/ProcessServer/DB2zOS/twwebservice_GroupMemberRefData_Pro cessSe rver.sql scripts/ProcessServer/DB2zOS/wle_upgradeSchema_ProcessServer.sql There are guidelines in the BPM Development Wiki on how to code to accommodate the DECIMAL=COMMA setting DB2 for z/OS has a setting to accommodate the practice common to many Eastern European countries of using a period "." to separate groups of integers in large numbers, while the comma "," is used to represent the decimal point. For example, the number 12,345,678.90 might appear as 12.345.678,90. DB2 subsystems with this setting active sometimes encounter problems with SQL when numeric parameters are concerned, because in SQL the comma is also used as a parameter separator. The string "1,2" in systems which do not use decimal=comma is interpreted as two separate parameters, 1 and 2. In a decimal=comma system, this is interpreted as 1 parameter, 1,2 (or 1.2). The solution is to make sure that when the comma is being used as a parameter separator, it is always followed by a space. A comma which has no space following it will be interpreted as a decimal separator in decimal=comma system, and attempts to run the SQL could result in a variety of SQL errors. We know of these SQL clauses which have caused issues with customers: DECIMAL VALUES IN DEFAULT
Local fix
As a workaround the impacted files can be corrected manually by changing the decimal separator for all occurrences.
Problem summary
This problem will be resolved in a future release of Business Process Manager.
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PM77928
Reported component name
BPM ADV FOR Z/O
Reported component ID
5655Y0200
Reported release
800
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-11-28
Closed date
2013-03-29
Last modified date
2013-03-29
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
R801 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSNJFY","label":"IBM Business Process Manager Advanced for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
07 January 2022