Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Installation of CPM FS on DB2 on z/OS fails.

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).


 
Suggest Edit

Published January 31, 2016 - Updated December 2, 2021

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us