General table behavior

WMQ metadata tables operate in specified ways.

For every table created, the following applies:
  • The PUBLIC group is limited to SELECT privileges. Only the database administrator and the table creator have INSERT privileges.
  • When a function is first invoked in each user session, WMQ metadata tables are read and their values are cached in the PER_SESSION memory. The cache is not refreshed until the session closes or the database is closed and reopened.