Large number of reads on sysibm.sysuserauth.

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Patrick Finnegan

    Large number of reads on sysibm.sysuserauth.

    I am getting a large number of reads on the sysibm.sysusera uth table
    over a relatively short period of time that correlates with a batch
    load. I assume that sysuserauth is read when a user connects to and
    authenticates with DB2. Does a large number of reads against this
    table indicate multiple connections to and authentications by DB2?





    SCHEMA TABLE_NAME ROWS_READ
    ROWS_WRITTEN OVERFLOW_ACCESS ES

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

    SYSIBM SYSUSERAUTH
    174661124 0 0

Working...