The Server Administrator plug-in module allows you to monitor and manage database servers. For example you can monitor user session activities, physical space allocation, run specific DBA reports, re-organize tables, start and stop servers, create and delete DB spaces and chunks, kill user sessions, run any of ON-utilities, such as ONSTAT and ONMODE, and perform other server management functions.
The Table Extent Size Calculator helps you to estimate the table data size based on provided estimated number of rows. It also recommends optimal values for table FIRST EXTENT and NEXT EXTENT sizes to provide best performance.
Server Administrator also includes a client component for the Sentinel server that allows you to create performance monitors, define alert criteria, execute and schedule jobs, graphically analyze historical performance data, and capture SQL statements from server sessions.
| Data Storage Explorer | You can explorer and watch detailed information for DB Spaces, Blob Spaces, Temp Spaces and Chunks. It shows percentage of filled and free spaces, allocation of data for tablespaces and other data storage related information.You can also create and delete DB Spaces, BLOB Spaces and chunks. |
| User Sessions Explorer | You can explorer connected user session information, including last executed SQL statement, locks, placed by the session, session I/O statistics, and other parameters. The list of user sessions can be sorted by a database, host computer, max number of locks and I/O activity to bring attention to sessions, which create server bottlenecks. SQL statements can be captured for performance tuning in the Execution Plan Analyzer. You can also kill user sessions. |
| Table Data Explorer | You can see individual table data size, db space allocations and allocation of data between extents. |
| Update Statistics | You can run UPDATE STATISTICS statement for entire database, selected group of objects and individual objects. All UPDATE STATISTICS options are supported. |
| Reorganize Tables | You can reorgnize tables, for example to compact deleted table rows or modify table structure to optimize physical table data allocation. All wasted space consumed by the table is compressed during this operation. |
| Reports | You can run a number of pre-defined DBA reports designed to monitor a server performance, efficent data allocation, and to highlight problems with locks and user sessions. Each report allows you to specify a specific filter and sort criteria. |
| Table Extent Size Calculator | The Table Extent Size Calculator helps you to estimate the table data size based on provided estimated number of rows. It also recommends optimal values for table FIRST EXTENT and NEXT EXTENT sizes to provide best performance. It takes into consideration data pages as well as attached index pages and small blob data located in the table's tablespace. |
| Server Properties Explorer | You can view the server ONCONFIG parameters, server profile and I/O statistics, and logical file details. |
| Change Server Mode | You can change server mode by switching it to ONLINE, OFFLINE or QUESCEND. |
| Run On-Utilities | You can execute any On-Utilities, such as ONSTAT, ONMODE, ONTAPE, ONBAR, as well as any server-side script or schell command using integrated telnet terminal panels. These console panels automatically connect to the selected server host and set all required Informix environment variables to speed up the process of configuring your console environment. |
.