Axional DBStudio

Monitor your database
servers from a single point

Axional DBStudio was originally built to take care of large Informix database systems. It was finally extended to operate with heterogeneous environments where Informix can work together with Oracle, DB2, PostgreSQL, SQLServer or even MySQL databases.

Axional DBStudio can be viewed as a web database administrator console, that is much more powerful than the old tty dbaccess (on Informix DBs). It contains a JDBC-compliant heterogeneous schema explorer, a multi-database SQL console and an XML database-independent scripting language. With Axional DBStudio, you can manage and script in your database servers to make them run more efficiently.


  • dbstudio26
  • dbstudio3


System architecture

Deal with your system databases architecture using a graphical User Interface (UI).

Server explorer

The server explorer offers a comprehensive view of your servers, the databases they contain, and all tables and objects contained inside them.

A rich set of functions for monitoring any Informix database server includes the ability to check storage status and data distribution, active session profile, virtual processors & memory usage. A useful group of common reports are ready to be run at any time. These include:

  • Chunk IO activity
  • Tables IO activity
  • Users IO activity
  • Queries by cost
  • Queries with poor optimization
  • Users waiting resources
  • Users waiting locks
  • Database locks
  • Table/Index extents
  • Temp table usage
  • SQL caches
  • Memory pools
  • Network usage
  • Waiting session

Database explorer

The database explorer gives a detailed view of all objects contained in a database. It can show information on the following object types:

  • Tables
  • Synonyms
  • System tables
  • Views
  • Indexes
  • Constraints
  • Functions
  • Procedures
  • Triggers
  • Sequences
  • Attributes
  • Datatypes
  • Dictionaries
  • Security
  • Disk layout

Additionally, it contains a set of reports to monitor and optimize table/index extents and index uniqueness.


  • dbstudio5
  • dbstudio-database


Data manipulation

Table explorer

The main database explorer node is the table explorer. It will show detailed information including columns, indexes, primary keys, foreign keys, check constraints privileges in a tabular view.


  • dbstudio4
  • dbstudio21


Table loader & unloader

The Informix tool that was a missing tool —the tool for creating tables while loading new data— is now available. Axional DBStudio supports the import and export of data in various file formats, including CSV, delimited and Excel.


  • dbstudio15
  • dbstudio29


SQL editor

A flexible SQL command line console provides a comfortable interface for performing database queries while performance is measured for optimization. The editor has a view of running statements, a command history and a favorite list of statements.

The administrator can determine command pattern restrictions for users to limit risky DDL or DML operations.


  • dbstudio7
  • dbstudio9


dbstudio27

XSQL grammar

The XSQL grammar allows you to write your DDL, DML statements or even stored procedures or triggers in an XML-independent language. The SQL editor will translate all XML statements to the appropriate database engine dialect. Now you can simply rewrite a complex trigger as an XML and view how it moves, for example, from Informix to Oracle, or viceversa.

Read more about database migration…

XSQL-Script (database operation)

XSQL Scripting language

What if you needed to make scripts to process data from different databases at the same time? Or if you needed to interact with mail and cryptography in any other Java library? Very often, a classic 4GL language or a stored procedure can do some complex jobs. Axional DBStudio contains a middle-tier scripting engine. Similar to a stored procedure, but much more powerful, this engine provides a way to bypass these limitations. You can now write database-independent scripts to interact with your data by using a flexible XML scripting SQL language.

dbstudio11

Geometric data types

Do you work with Informix Spatial Data Blade, Oracle Spatial, DB2 Spatial Extender or PostgreSQL PostGIS? If you have geometric data types in your database, the table explorer will provide a dynamic map representation of rows contained in a table. By Using this feature, you can query your database and view the geometric representation of the query. In each geometry, you will have a link to the tuple with non-geometric data types. You can even edit this data online with the required privileges.

This post/page is also available in: French, German, Spanish, Catalan