When trying to STORE an ACF2 DB2 rule this message is seen:
ACF6D029 INVALID RECORD CLASS/TYPE - DCOL - FOR MODE
ACF2 R16
The "ACF6D029 INVALID RECORD CLASS/TYPE - DCOL - FOR MODE" can be a result of doing a SET DB2(xxx) and compiling a rule with a different TYPE. For example, doing a SET for DB2(PLN) and compiling a rule with TYPE(COL) will result in a ACF6D029:
ACF
SET DB2(PLN)
DB2
COMPILE
ACFD2010 DB2 COMPILER ENTERED
. $KEY(TEST****) TYPE(COL) SYSID(DBE1)
. UID(ASDFJKLQWERTYUIOZXCN) SERVICE(CREATEIN) ALLOW
.
ACFD2051 TOTAL RECORD LENGTH= 176 BYTES, 4 PERCENT UTILIZED
DB2
STORE
ACF6D029 INVALID RECORD CLASS/TYPE - DCOL - FOR MODE
The following example demonstrates how to correct the problem by doing a SET for DB2(COL) that corresponds to the TYPE field in the rule that is compiled.
ACF
SET DB2(COL)
DB2
COMPILE
ACFD2010 DB2 COMPILER ENTERED
. $KEY(TEST****) TYPE(COL) SYSID(SYSZ)
. UID(xxxxxxxxxxxxxxxxxxxx) SERVICE(CREATEIN) ALLOW
.
ACFD2051 TOTAL RECORD LENGTH= 176 BYTES, 4 PERCENT UTILIZED
DB2
STORE
ACF6D027 COMPILED RECORD SYSZ / TEST**** STORED
More information on Writing , Maintaining, and Compiling ACF2 DB2 Rules can be found in ACF2™ Option for Db2 1.3 Techdoc section Writing Rules