CA ACF2 for DB2 error message *CADB2090 - Internal error - invalid DB2CLASS - G 0076

Products

• ACF2 - DB2 Option

Issue/Introduction

DSNT408I SQLCODE = -551, ERROR:  USER001 DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION CREATE OR REPLACE ON OBJECT trigger.name

Job also received this message:

*CADB2090 - Internal error - invalid DB2CLASS - G 0076        

                                                   

Environment

Release : 1.3

Component : CA ACF2 Option for Db2

Resolution

LU01287/LT01287
LU01288/LT01288 and
LU01074/LT01074 
(plus pre-reqs) will resolve this problem.
It will also be necessary to setup DB2(TRG) rules with ownership details for each trigger.

Here is an example of the TRG rules

ACF
SET DB2(TRG) SYSID(dsna)
COMP *
$KEY(full_trigger_name) TYPE(TRG) SYSID(dsna)
$LIDOWNER(logonid)  or
$UIDOWNER(uid_string) or
$ROLOWNER(role) 

and that is all that the rule has - it is used for ownership only - just select which option is best for your needs.

There is also an additional CONTROL(GSO) appldef record required.

INSERT APPLDEF.DB2TRG TYPE(TRG/TRG) APPLDIV(-) APPLDLEN(4) COMPILE -
  CLASS(D/DB2) EXTCOMP RECID(ACFD2CDI/-) -                          
  RECIDLEN(252) BLANKS SYSID(****)