plan distserv and package authorization cache

Per Sorensen

plan distserv and package authorization cache

Hi

A question on Cache Not Used in Db2 v11 and v12.

 

                     PLAN PACKAGE ROUTINE

Allocate Attempts   90212 388669     N/A

Allocations         90212 335828     N/A

Invalid Rsrce IDs       0     N/A     N/A

Authorization Cks 425846 183230     127

Success Auth Chks 425846     N/A     N/A

Cache Auth Checks   66024   97087   8103

EXEC PUBLIC Chks       0       0       0

Repl Cache Authid     N/A       0       0

Repl Cache Entry     N/A       0       0

Add Cache Fail       N/A   N/A       0

Cache Not Used       N/A   86143     127

 

It is a very high number in cache not used.

Dsnzparm: Max storage for package authorization cache   CACHEPAC 5242880

A trace of ifcid 374 gives many records

                                         CACHE FUNC

COUNT   USER       COLL         PACKAGE     TYPE TYPE   PLAN  

------- -------- ------------ -------------- ----- ---- --------

     3 VP70INFO VPPRBIUR.... MSCS001....... K     S   DISTSERV

     1 VP01HGU. SYSIBM...... SQLCOLUMNS.... R     S   DISTSERV

3798 VP70IMS. NULLID...... SYSLH200...... K     S   DISTSERV

     14 VP70ONL. NULLID...... SYSLN100...... K     S   DISTSERV

     1 VP01HGU. NULLID...... SYSSTAT....... K     S   DISTSERV

 

It is all from remote sites.

We are using racf security in Db2.

 

What should I look for ?

In RACF ? in WLM ? in dsnzparm ?

in SYS2.DB2.SDSNEXIT DSN3ØATH ? in DB2.DIST ?