search cancel

I received message LDP6104E Unable to execute INSERT SQL statement when trying to save a new policy statement in compliance manager.

book

Article ID: 42205

calendar_today

Updated On:

Products

24X7 High-Availability Manager for DB2 for z/OS Batch Processor Compile QQF Data Compressor for DB2 for z/OS CA Unicenter NSM RC/Update for DB2 for z/OS DB2 TOOLS- DATABASE MISC

Issue/Introduction

Problem:

I am trying to save a new policy statement in CA Compliance Manager but I get an error ...

 LDP6104E Unable to execute INSERT SQL statement

What causes this error?

 

Cause:

This error message is caused by CA LDAP Server not having a correctly formatted
MAPDB or MAPDBJ file allocated.

 

Resolution:

The resolution is to run job CDT9PCHR from the CDT9JCL library.
There are 3 steps to this job.

1) CMGRPCRX - which formats the MAPDB file
2) CMGRPCRY - which formats the MAPDBJ file
3) CMGRPCRZ - which populates the MAPDB file

 

 

 

 

 

 

 

Environment

Release:
Component: GEN