ACF2/DB2 nextkey rules for plans gets ACFD2049

Products

• ACF2
• ACF2 - DB2 Option
• ACF2 for zVM
• ACF2 - z/OS
• ACF2 - MISC

Issue/Introduction

When creating rules for plan validation with ACF2 for DB2 i tried to use a key like these

 

$KEY(DB2PLANX) TYPE(PLN) ROLESET

 ROLE(-) SERVICE(BIND,EXECUTE) PREVENT NEXTKEY(DB2PLAN.XX)

 

$KEY(DB2PLANX.XX) TYPE(PLN)   

$PREFIX(DB2PLANX) 

UID(*) SERVICE(BIND,EXECUTE) ALLOW

 

Got the following error during rukle compile

 

            00001000 $KEY(DB2PLANX.XX) TYPE(PLN) SYSID(DB2X)                                    

            00002000 $PREFIX(DB2PLANX)                                                          

            00003000  UID(***********LOGONID) SERVICE(EXECUTE) ALLOW 

                          

            ACFD2049 KEY TOO LONG FOR THIS RULE TYPE - COMPILER TERMINATING                       

  

Environment

Release : 16.0

Component : CA ACF2 Option for DB2

Resolution

ACF2 For DB2 rules for DB2 resources may be restricted in length.

The length of a plabn is restricted to 8 bytes so you cannot extend the length of the key beyond 8 bytes.

Create the nextkey rule  with $KEY beginning with #,$ or @ then it will not be confused for a real db2 resource.

For example

$KEY(DB2PLANX) TYPE(PLN)   

$PREFIX(DB2PLANX) 

UID(*) SERVICE(BIND,EXECUTE) ALLOW