SA-29985

Summary

Unable to execute migrate for upgrade in DB2 zOS environment with Pega 7.2.

Error Messages

[java] 2016-09-27 23:43:59,380 ( SchemaGenerator) SEVERE - Cannot continue with ddl generation due to misssing properties
[java] 2016-09-27 23:43:59,443 ( SchemaGenerator) INFO - Missing property: wlmudf
[java] 2016-09-27 23:43:59,443 ( SchemaGenerator) SEVERE - Error while creating Zos Schema Generator
[java] Cannot continue with missing zos properties: wlmudf
[java]
[java] java.lang.IllegalStateException: Cannot continue with missing zos properties: wlmudf
[java] at com.pega.pegarules.data.ddl.ZosSchemaGenerator.validateZosProperties(ZosSchemaGenerator.java:77)
[java] at com.pega.pegarules.data.ddl.ZosSchemaGenerator.<init>(ZosSchemaGenerator.java:64)
[java] at com.pega.pegarules.data.ddl.SchemaGenerator.main(SchemaGenerator.java:1793)
[java] Exception in thread "main" java.lang.IllegalStateException: Error generating ddl for db2zos, KBZFGCMG
[java] null
[java] at com.pega.pegarules.data.ddl.SchemaGenerator.main(SchemaGenerator.java:1818)
[java] Caused by: java.lang.NullPointerException
[java] at com.pega.pegarules.data.ddl.SchemaGenerator.main(SchemaGenerator.java:1814)
 

Steps to Reproduce

Executing Migrate.bat to generate DDL for the DB2 zOS system. 

Root Cause

Configuration issue in which missing WLM related properties in db2sitedependant.properties file.

Resolution

Perform the following local-change steps: 

1. Enable WLM to support UDF. Configure db2sitedependant.properties with missing WLMUDF and other properties related to Work Load Manager (WLM).
2. For Pega 7.2, Deployment guide (Refer Page 109, 33) suggested to use db2jcc4.jar

To Follow the series of steps sequentially:

3. Update MigrateSystem.properties and execute migrate.sh, dba to apply DDL script and again execute migrate.sh.
4. Modify setupDatabase.properties and execute generateDDLupgrade, after dba action execute upgrade.sh.
5. Update MigrateSystem.properties and execute migrate.sh.
6. Modify setupDatabase.properties and exec geneateDDL, after dba, to execute upgrade.sh --dataonly = true.