SA-1809

Summary

Installing CPM FS 7.1.2 on PRPC 7.1.5 using a backend database of DB2 running on z/OS: the DECIMAL=COMMA and PADIX ZPARMS are set; the generated DDL was found give errors on this platform.

Error Messages

N/A: Various Database Errors - which prevent the installation from completing.

Steps to Reproduce

Attempt installation of CPM FS 7.1.2 on PRPC 7.1.5 using a backend database of DB2 running on z/OS: the DECIMAL=COMMA and PADIX ZPARMS are set.
The installation process will fail when importing the file 'SCM_71_Install.zip': this found to be the case when using either the 'Automatic' or 'Manual' methods (see page 4 of the CPM FS installation manual : "Customer Process Manager Financial Services Installation Guide Version 7.1.2"

Root Cause

The root cause was found that the installation method (specifically the automatic generated of SQL DDL) was failing to create the correct DDL for the database platform DB2 running on z/OS.

Resolution

HFIX-9914 was used to generated DDL which is compatible with the DB2 database running on z/OS.
Note: HFIX-9914 is NOT a HFIX which can be installed by Update Manager: it contains a JAR file and a manual procedure, which utilizes the script 'GenerateDDL.bat/sh' which is present in the CPM Framework directory. (CPM is a pre-requisite for CPM FS and therefore the presence of the CPM installation directory is guaranteed for CPM FS installation).