Can RECKEY ACF subcommand be used to update the access for a DB2 table? If so, how is the SYSID specified on the RECKEY command. RECKEY command for DB2 rule gets ACF60217 ERROR - NO SYSID SPECIFIED - PROCESSING TERMINATING
Release : 1.3
Component : ACF2 Option for Db2
The RECKEY command can be used for DB2 resource rules.
The syntax of the RECKEY subcommand is as follows:
RECKEY ruleid {ADD(rule-entry)|DELETE(rule-entry) |MOD(rule-entry, rule-entry)}
[CLASS(class)]
[TYPE(type)]
[SYSID(sysid)]
[LIST|NOLIST]
[NOVERIFY|VERIFY]
So the SYSID(DSNT) would be after the rule ADD|DEL|MOD( rule-entry ). For example, the following does two RECKEY ADDs, a DEL and a MOD:
SET DB2(TBL) SYSID(DSNT)
DB2
RECKEY TEST ADD( TABLE.ONE UID(1234569XX) SERVICE(DELETE,INSERT,UPDATE) ALLOW) SYSID(DSNT)
ACFD2102 DB2 RULE TEST FOR SYSID DSNT STORED BY USER002 ON 07/12/22-11:33
ACFD2010 DB2 COMPILER ENTERED
******** DB2 RULE TEST FOR SYSID DSNT STORED BY USER002 ON 07/12/22-11:33
$KEY(TEST) TYPE(TBL) SYSID(DSNT)
TABLE.TWO UID(1234569XX) SERVICE(DELETE) ALLOW
TABLE.ONE UID(1234569XX) SERVICE(DELETE,INSERT,UPDATE) ALLOW
ACFD2051 TOTAL RECORD LENGTH= 292 BYTES, 1 PERCENT UTILIZED
ACF60207 RULE D TBL DSNTTEST REPLACED
ACF60039 Issue the F ACF2,REBUILD(TBL),CLASS(D) command to activate the rule
DB2
RECKEY TEST ADD( TABLE.TWO UID(1234569XX) SERVICE(DELETE,UPDATE) ALLOW) SYSID(DSNT)
ACFD2102 DB2 RULE TEST FOR SYSID DSNT STORED BY USER002 ON 07/12/22-11:34
ACFD2010 DB2 COMPILER ENTERED
******** DB2 RULE TEST FOR SYSID DSNT STORED BY USER002 ON 07/12/22-11:34
$KEY(TEST) TYPE(TBL) SYSID(DSNT)
TABLE.ONE UID(1234569XX) SERVICE(DELETE,INSERT,UPDATE) ALLOW
TABLE.TWO UID(1234569XX) SERVICE(DELETE) ALLOW
TABLE.TWO UID(1234569XX) SERVICE(DELETE,UPDATE) ALLOW
ACFD2051 TOTAL RECORD LENGTH= 333 BYTES, 2 PERCENT UTILIZED
ACF60207 RULE D TBL DSNTTEST REPLACED
ACF60039 Issue the F ACF2,REBUILD(TBL),CLASS(D) command to activate the rule
DB2
RECKEY TEST DEL( TABLE.ONE UID(1234569XX) SERVICE(DELETE,INSERT,UPDATE) ALLOW) SYSID(DSNT)
ACFD2102 DB2 RULE TEST FOR SYSID DSNT STORED BY USER002 ON 07/12/22-11:34
ACF60202 THE FOLLOWING RULE LINE(S) WILL BE DELETED
TABLE.ONE UID(1234569XX) SERVICE(DELETE,INSERT,UPDATE) ALLOW
ACFD2010 DB2 COMPILER ENTERED
******** DB2 RULE TEST FOR SYSID DSNT STORED BY USER002 ON 07/12/22-11:34
$KEY(TEST) TYPE(TBL) SYSID(DSNT)
TABLE.TWO UID(1234569XX) SERVICE(DELETE) ALLOW
TABLE.TWO UID(1234569XX) SERVICE(DELETE,UPDATE) ALLOW
ACFD2051 TOTAL RECORD LENGTH= 277 BYTES, 1 PERCENT UTILIZED
ACF60207 RULE D TBL DSNTTEST REPLACED
ACF60039 Issue the F ACF2,REBUILD(TBL),CLASS(D) command to activate the rule
DB2
RECKEY TEST MOD( TABLE.TWO UID(1234569XX) SERVICE(DELETE,UPDATE) ALLOW, TABLE.TWO UID(1234569XX) SERVICE(DELETE) ALLOW) SYSID(DSNT)
ACFD2102 DB2 RULE TEST FOR SYSID DSNT STORED BY USER002 ON 07/12/22-11:34
ACF60202 THE FOLLOWING RULE LINE(S) WILL BE REPLACED
TABLE.TWO UID(1234569XX) SERVICE(DELETE,UPDATE) ALLOW
ACFD2010 DB2 COMPILER ENTERED
******** DB2 RULE TEST FOR SYSID DSNT STORED BY USER002 ON 07/12/22-11:34
$KEY(TEST) TYPE(TBL) SYSID(DSNT)
TABLE.TWO UID(1234569XX) SERVICE(DELETE) ALLOW
TABLE.TWO UID(1234569XX) SERVICE(DELETE) ALLOW
ACFD2043 DUPLICATE RULES SPECIFIED - 3/4 - COMPILER TERMINATING
ACF60215 ERROR DURING COMPILE OF RULE SET - PROCESSING TERMINATING
DB2
decomp *
ACFD2102 DB2 RULE TEST FOR SYSID DSNT STORED BY USER002 ON 07/12/22-11:34
$KEY(TEST) TYPE(TBL) SYSID(DSNT)
TABLE.TWO UID(1234569XX) SERVICE(DELETE) ALLOW
TABLE.TWO UID(1234569XX) SERVICE(DELETE,UPDATE) ALLOW
ACFD2101 TOTAL RECORD LENGTH= 277 BYTES, 1 PERCENT UTILIZED
DB2