Miscellaneous Facilities

Following commands, utilities or configuration options extend the capabilities of DB2/VM and SQL/MF:

- a low-level trace facility for the DB2/VM dispatcher, to be used when problems are suspected during agent dispatching
- a utility program that explains and analyzes SQL statements, based upon their real-time execution characteristics
- a number of DB2/VM operator command extensions that allow:
  - to force all active agents with a single command
  - to start a DB2 checkpoint
  - to temporarily prevent users from accessing the database
- a configuration option to reduce scheduling delays caused by long-running agents, thereby improving concurrent agent execution
- a configuration option to prevent a user from filling up a storage pool
- a configuration option to automatically rebind dependent packages after creating a new index
- an EXEC for executing DB2/VM operator commands, CP, CMS and SQL/MF commands in a monitored database