Operational assists
From the OPERTUNE Operational Assist Menu, you can access assistance with any of the items listed in the following menu:
OPRX DBDC+ Operational Assist Menu
Command ===>
Choose one of the following OPERTUNE Operational Assist functions by number. Then press Enter.
1. Active log manipulation
2. Cancel threads/connections
3. Update archive log BSDS entries
4. Initiate a subsystem checkpoint
5. Free form commands
6. Free up table spaces
7. Reload user exits
8. Change DDF parameters
9. Group buffer pool operations
10. Open data component operations
11. Reload DSNHDECP option default module
12. Peer Log Operations
13. Tablespaces in exception status
14. Utility Job Status
Command ===>
Choose one of the following OPERTUNE Operational Assist functions by number. Then press Enter.
1. Active log manipulation
2. Cancel threads/connections
3. Update archive log BSDS entries
4. Initiate a subsystem checkpoint
5. Free form commands
6. Free up table spaces
7. Reload user exits
8. Change DDF parameters
9. Group buffer pool operations
10. Open data component operations
11. Reload DSNHDECP option default module
12. Peer Log Operations
13. Tablespaces in exception status
14. Utility Job Status
For example, you can use the Cancel threads/connection option to cancel any of the following types of threads:
- Any thread or connection executing within Db2
- IMS or CICS threads that are inactive in Db2 (that is, canceled on the next call to Db2)
- TSO and batch threads (canceled whether they are active or inactive in Db2)
You might also need to prepare a table space for utility maintenance. You can use the Free up table spaces option to perform the following tasks:
- Cancel all users of a specific table space
- Stop a table space before canceling all of its users
- Selectively cancel users of a table space
For a complete description of each operational assist, see Operational Assists.
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*