Db2 database administrator

A Db2 for z/OS® database administrator can start and stop text search support on a Db2 subsystem, and create, drop, and change indexes.

This role corresponds to the Db2 DBADM authorization level, which allows the manipulation of all database objects.

The main tasks of a database administrator include:

• Starting Db2 text search functions
• Stopping Db2 text search functions
• Creating tables
• Deleting tables
• Creating an index, and defining and altering its characteristics
• Updating a full-text index
• Dropping an index
• Granting the required privileges to text search users
• Clearing the event table periodically
• Maintaining the text search server information in the SYSIBMTS.SYSTEXTSERVERS administration table
• Maintaining the Db2 for z/OS connection information in the SYSIBMTS.SYSTEXTCONNECTINFO administration table