ACF2 DB2 PLN access

[Shrishti Kala]

Hello,
User is getting error:

ACF04056 ACCESS TO RESOURCE DB2YIDBSPLAN TYPE DPLN BY DB2YIDB2 NOT AUTHORIZED                                                            

 DBG37034E DB2T 01:51:57 DATA COLLECTOR UNABLE TO ALLOCATE THREAD USING PLAN NAME IDBSPLAN AND AUTHORIZATION ID DB2YIDB2      

   What should I do to resolve this?

[Ross Decent]

Hello Shrishti,
The resolution to this problem is to write a rule.

ACF

SET DB2(PLN) SYSID(DB2Y)
RECKEY IDBSPLAN ADD( UID(<uid for DB2YIDB2>) SERVICE(EXECUTE)

END
I suggest that you view the violation in ACFRPTRV to see what the SERVICE should be.
regards,
Ross

CA ACF2 for DB2 support @ Broadcom
 

​

[Ross Decent]

Hello Shrishti,
a slight change to the rule format..

ACF

SET DB2(PLN) SYSID(DB2Y)
RECKEY IDBSPLAN ADD( UID(<uid for DB2YIDB2>) SERVICE(EXECUTE)) SYSID(DB2Y)

END

regards,
Ross