HCL OneDB Server Administrator

HCL® OneDB® Server Administrator (ISA) allows a DBA to manage HCL OneDB database servers by executing HCL OneDB 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.

ISA is available for download at http://www.HCL.com/software/data/informix/downloads.html.

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 an OneDB 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 HCL OneDB utility, UNIX™ shell command, or Windows command.