IBM Informix Server Administrator

IBM Informix Server Administrator (ISA) allows a DBA to manage Informix database servers by executing Informix commands from any web browser. You do not need to be familiar with the syntax and format of database server commands. ISA presents the command output in an easy-to-read format.

The database server CD-ROM distributed with your product includes ISA. For information on how to install ISA, see the following file on the CD-ROM.

With ISA, you can perform these database server administrative tasks:

• Change configuration parameters temporarily or permanently.
• Use Server Setup to configure or reconfigure the database server.
• Change the database server mode.
• Modify connectivity information in the sqlhosts file.
• Check dbspaces, blobspaces, and sbspaces.
• Manage logical logs and physical logs.
• Examine and modify memory usage.
• Read the message log.
• Back up and restore dbspaces, blobspaces, and sbspaces.
• Run various onstat commands to monitor performance.
• Enter SQL statements and examine database schemas.
• Add and remove chunks, dbspaces, blobspaces, sbspaces.
• Examine and manage user sessions.
• Examine and manage virtual processors (VPs).
• Use the High-Performance Loader (HPL), dbimport, and dbexport.
• Manage Enterprise Replication.
• Manage a MaxConnect server.
• Set up primary and secondary database servers for High-Availability Data Replication.
• Use the following utilities: dbaccess, dbschema, onbar, oncheck, ondblog, oninit, onlog, onmode, onparams, onspaces, onstat, onpladm.
• Enter any Informix utility, UNIX shell command, or Windows command.