OpenAdmin Tool (OAT) Context Help
These topics describe the content of the pages in the IBM® OpenAdmin Tool (OAT) for Informix®.
- Admin
- Login
Use this page to connect to a database server or to retrieve database-server connection information from an OAT group. - OpenAdmin Tool (OAT) for Informix
- OpenAdmin Tool (OAT) for Informix
Use this page to view real-time status information about the database server, including space allocations, locks, memory usage, and the number of transactions. - Alerts
Use this page to review event alarms generated by the database server and alerts generated by the Task Scheduler or by built-in tasks and sensors. - Dashboard
Use this page to view real-time status information about the database server, including space allocations, locks, memory usage, and the number of transactions. - Group Summary Dashboard
Use this page to monitor all the database servers in an OAT group at the same time. - Logs
- Task Scheduler
Use this page to review scheduled tasks, add new tasks, and delete tasks. - New Task Setup
Add new tasks for the Scheduler by using the New Task Setup wizard. - Delete a Task
- Task Details: Cron Task List
This page displays all of the Scheduler tasks that run on the current database server. - Task Details
Use this page to update the description, time settings, and task parameter values of Scheduler tasks. - Edit Task Parameter
- Task Runtimes
This page displays a history of the Scheduler tasks by name. - Space
- Recovery Logs
- Backup
- Server Configuration
Use this page to review the current values of the configuration parameters for the database server. - Onconfig Parameter Details
Use this page to view more information about the configuration parameters and to change the values of the dynamic configuration parameters. - Trusted hosts
Configure trusted hosts to enable sharding for JSON data. - System Validation
Use this page to run a system validation check on databases and tables on the current database server. - Virtual Processors
- User Privileges
- Auto Update Statistics
Use this page to view the Auto Update Statistics (AUS) tasks, to refresh the statistics evaluation, and to clean up abnormal AUS runs. - Auto Update Statistics: Info
- Auto Update Statistics: Alerts
- Auto Update Statistics: List
- Auto Update Statistics: Configuration
Use this page to specify the values of the Auto Update Statistics (AUS) configuration parameters. - Trusted Context
- Memory Manager
Use this page to view information about server memory usage and to enable automatic low memory management. Configure the actions that the database server takes to continue processing when memory is critically low. - Warehouse Accelerator
- SQL Explorer
- Performance History
Use this page to review historical data on profiled fields, including auto checkpoints, disk and buffer activity, memory, virtual processors, and the B-tree scanner. - System Reports
- Session Explorer
- Session Explorer: Locks
- Session Explorer: Threads
- Session Explorer: Memory
- Session Explorer: Network
- Session Explorer - Environment
Use this page to view the values of the environment variables that the database server uses for the selected session. - Session Explorer: Profile
- Session Explorer - SQL
Use this page to view the SQL values statements that are run by the selected session. - onstat Utility
Use this page to display performance and status information for a database server by using the onstat utility. - Databases
Use this page to review the databases on the database server. - SQL ToolBox: Tables
A list of the tables for the selected database is shown. - SQL Toolbox - Stored Procedures
Use this page to view information about stored procedures and user-defined routines, including their argument count and argument types. - SQL Toolbox - Column Info
This page displays the column information for the table selected. - SQLToolbox: Browse Table
- SQLToolbox: Table Fragments
- SQL Editor
Use this page to run SQL queries. - Query Tree
Use this page to review a visual depiction of the execution plan of the query. - Query Result
- Tenancy