Direct links to fixes
APAR status
Closed as program error.
Error description
When you have an IBM Business Process Manager (BPM) deployment environment that uses an IBM DB2 for z/OS database and you run the SchemaGenerator tool, the database connection fails because the schema name in the database URL is null. You receive the following information: Jan 16, 2018 9:19:58 AM INFO: com.lombardisoftware.tools.optimization.search.SchemaGenerator$M ainDriver - dbdriver : com.ibm.db2.jcc.DB2Driver Jan 16, 2018 9:19:58 AM INFO: com.lombardisoftware.tools.optimization.search.SchemaGenerator$M ainDriver - dburl : jdbc:db2://DB.ACME.COM:6551/BPMDB:currentSchema=null; Jan 16, 2018 9:19:58 AM INFO: com.lombardisoftware.tools.optimization.search.SchemaGenerator$M ainDriver - dbuser : DBUSER Jan 16, 2018 9:19:58 AM INFO: com.lombardisoftware.tools.optimization.search.SchemaGenerator$M ainDriver - dbschema : BPMS Jan 16, 2018 9:19:58 AM FINE: com.lombardisoftware.tools.optimization.search.SchemaGenerator$M ainDriver - Connecting to url "jdbc:db2://DB.ACME.COM:6551/BPMDB:currentSchema=null;" as user "DBUSER" with password "<not shown>"
Local fix
NA
Problem summary
The database schema for the IBM Process Server database is stored in the currentSchema data source property of a DB2 for z/OS database. The SchemaGenerator tool doesn't consider this property when constructing the database URL.
Problem conclusion
An interim fix is available that considers the currentSchema data source property when constructing the database URL. This problem is already fixed in IBM BPM V8.5.7 CF2017.03 and later versions.
Temporary fix
Comments
APAR Information
APAR number
JR59000
Reported component name
BPM ADVANCED
Reported component ID
5725C9400
Reported release
857
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-01-18
Closed date
2018-03-19
Last modified date
2018-03-19
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
BPM ADVANCED
Fixed component ID
5725C9400
Applicable component levels
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"857","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
19 March 2018