invispix 10x10

Admin-Scout 3.1 - Highlights for Developers and Administrators

Security UpdateVersion 3.1 continues the journey to new functions for developers and administrators.
Development
  • Editing in multiple windows, parallel working with multi-tabs in the SQL-Editor.
  • SQL history accessible at any time.
  • Evaluation of dependencies and constraints for table objects.
  • Informix error numbers, direct access to IDs and descriptions.
Administration
  • Database Explorer, auto generation of archecker scripts for table restore.
  • Locked tables, which sessions keep locks and which are waiting.
  • SSH shell to the server, now simply open via "shell in a box".
Monitoring
  • Day- and Month-Reports, individual customization according to your personal requirements.
  • Performance checks, extended output with disk I/O per chunk.
  • Schema changes, logging with the new DDL-History2 Report.

Admin-Scout for Informix - Multitab SQL EditorEditing in multiple windows, parallel working with multi-tabs in the SQL-Editor

Edit, run, save or load - the multi-tabs allow you to edit several SQL statements in the SQL Editor at the same time.


Admin-Scout for Informix - SQL-HistorySQL-History accessible at any time

All SQL statements are stored in the history for up to 100 days. With SQL-History, this logging can be quickly retrieved at any time - an elegant alternative in addition to storage and access via files.


Admin-Scout for Informix - ConstraintsEvaluation of dependencies and constraints for table objects

Dependencies and constraints can now be identified when displaying database objects.


Informix error numbers, direct access to IDs and descriptionsInformix error numbers, direct access to IDs and descriptions

No detours via a shell. Even without an installed Informix or client SDK, Admin-Scout provides the direct reference to Informix error numbers. The helpful feature can be accessed globally via the menu bar and provides the description text matching the error ID.

The reference in the SQL editor is even easier. If an incorrect statement is reported, it is sufficient to navigate with the mouse pointer over the error number. A pop-up window automatically displays the description.

Admin-Scout for Informix - Informix error numbers


Database Explorer, auto generation of archecker scripts for table restore

We have already briefly introduced the Database Explorer with the launch of version 3.0. It is able to display all database objects including their dependencies and generates detailed object-related statistics. Completely reprogrammed, it replaces the old SQL Toolbox Database module.

Special mention should be given to is the extensive context menu for table objects, which can be opened by clicking the right mouse button. Here you can find the generation of the CREATE-SQL statements and the display of the update statistics Infos. The mentioned information includes storage, extend and page usage, I/O, table growth and the table level privileges are displayed.

A new highlight is the creation of a specific archecker script that allows to restore a table from a level 0 backup.

Admin-Scout for Informix - archecker Skripte


Locked tables, which sessions keep locks and which are waiting

Frequent question to the administration: who is currently locking table "xy"? The Find-Locks report, parameterized by database and table, provides details!

If a database object is locked, Find-Locks provides detailed information about the corresponding session, and - if possible - the blocking session can be cancelled directly from here.

Admin-Scout for Informix - Find Locks


SSH-Shell to the server, now simply open via "shell in a box"

Admin-Scout for Informix - SSH Shell in a boxBy integrating the AJAX terminal emulator "shellinabox" it is possible to open an SSH access to the shell of an instance with just a few clicks. The new menu option "Shell" shows all instances that can be acccessed by the Admin-Scout. A simple click on the link to an instance is sufficient to establish the SSH connection.Admin-Scout for Informix - SSH Shell in a box


Day- and Month-Reports, individual customization according to your personal requirements

With version 3.1. adjustments to the default setting can be configured for each instance. Especially in very large Informix environments, reports can contain several MB of information. The possibility to focus on what is individually important improves the overview and reduces the data volume significantly. In addition, the order of the reports can be adjusted as desired.

Admin-Scout for Informix - individuelle Anpassung


Performance-Checks, extended output with Disk-I/O per chunk

There is now a supplementary overview of the disk I/O performance. The display now shows the real server times for read and write accesses per chunk.

Admin-Scout for Informix - Disk-IO


Schema Changes, logging with the new DDL-History2 Report

Schema changes can now easily be logged with the DDL-History2 report. A list of databases which has to be tracked is entered in the associated task. The additional start of an SQL trace is not necessary.

While being included in the Day-Report, DDL-History2 shows the schema changes of the last 24 hours, if included in the Month-Report, it shows the changes of the last month.

Admin-Scout for Informix - Startpage


Is a feature missing? Do you have any questions or suggestions for Admin-Scout development?

Just write us a few lines in our Development-Request form - we are looking forward to your suggestions!

Your Admin-Scout development team.

Admin-Scout Anfrageformular


 

invispix 10x10
Request a guided tourRequest a guided tour

Request a guided tour

Start your demo sessionStart your demo session

Start your demo session

Additional ServicesAdditional Services

Get additional Services

All offers in our webshop

All offers in our webshop

This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.