Maintaining a DB2 subsystem on OS/390

Note: Except where noted, this section provides information about DB2 for MVS/ESA.

You can maintain multiple databases with multiple table spaces.

Workstation database server users: Each server (a named location) is a single database. You can maintain multiple table spaces in that single database.

You might assign specialized administration tasks to users to perform under their own authorization IDs. Give these users just enough DB2 authority to run the queries and utilities required for their tasks. For example, a person would need:

• The INSERT privilege on the table Q.PROFILES to insert QMF profiles for new users
• DBADM authority on a given database to administer the associated tables, indexes, and table spaces
• STATS and REORG privileges on the database for the Q.OBJECT tables to monitor these tables and, if necessary, reorganize them