Support Article

Unable to execute migrate for upgrade



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.lang.IllegalStateException: Cannot continue with missing zos properties: wlmudf
[java] at
[java] at<init>(
[java] at
[java] Exception in thread "main" java.lang.IllegalStateException: Error generating ddl for db2zos, KBZFGCMG
[java] null
[java] at
[java] Caused by: java.lang.NullPointerException
[java] at

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


Perform the following local-change steps: 

1. Enable WLM to support UDF. Configure 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 and execute, dba to apply DDL script and again execute
4. Modify and execute generateDDLupgrade, after dba action execute
5. Update and execute
6. Modify and exec geneateDDL, after dba, to execute --dataonly = true.


Published November 4, 2016 - Updated November 14, 2016

Have a question? Get answers now.

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