Writing Rules › How Do You Maintain Rules? › TEST: Testing CA ACF2 Option for DB2 Rules › Extent of CA ACF2 Option for DB2 Rule Testing › Examples

Examples

To test the CA ACF2 Option for DB2 rule set with the $KEY of FINANCE.QTLY_INVEST and the $SYSID of PROD, enter the following.

set db2(tbl) sysid(prod)
 DB2
decomp finance.qtly_invest
 ACFD2102 DB2 RULE FINANCE.QTLY_INVEST FOR SYSID PROD STORED BY HUMMA03 ON 06/21/05‑13:28
 $KEY(FINANCE.QTLY_INVEST) TYPE(TBL) SYSID(PROD)
  UID(C**FINMGR) SERVICE(UPDATE) ALLOW
  UID(C**FIN) SERVICE(SELECT) ALLOW
 ACFD2101 TOTAL RECORD LENGTH= 206 BYTES, 5 PERCENT UTILIZED
 DB2
test finance.qtly_invest

To test whether this rule set gives all finance employees the ability to view data in this table, enter:

test finance.qtly_invest
 .  u(c**fin) se(select)

CA ACF2 Option for DB2 responds with:

DB2
test finance.qtly_invest
 .  u(c**finjoE FOLLOWING PARAMETERS ARE IN EFFECT:
  $TYPE=TBL     $SYSID=PROD $KEY=FINANCE.QTLY_INVEST
  DATE=06/09/05 TIME=1330 UID=C**FINJOE
  SERVICE=(SELECT)   COLUMN=(****)

  TARGET RESOURCE: DTBL FINANACE.QTLY_INVEST

  VALIDATED RULE LINE FROM FINANCE.QTLY_INVEST TYPE TBL SYSID PROD
  U I D(C**FIN) SERVICE(SELECT) ALLOW

  RESULT: ACCESS WOULD BE ALLOWED
  REASON: RESOURCE RULE

  .e) se(select)
 ACFD2214 TH

If you want to test another parameter of this rule set, you can then enter another TEST subcommand keyword. If you are finished with this rule set, enter END to terminate the TEST subcommand. To test another rule set, enter the TEST subcommand again with another resource name.