HCL OneDB administrative utilities and applications
HCL OneDB™ includes utilities and applications that you can use to perform administrative tasks and capture information about configuration and performance.
| Utility name | Description |
|---|---|
| archecker | Verifies backups and performs table-level restores. |
| chkenv | Checks the validity of shared or private environment-configuration files. The chkenv utility validates the names of the environment variables in the file, but not their values. |
| cdr | Controls Enterprise Replication operations. |
| ClassGenerator | Generates a Java™ class for a named row type that is defined in the system catalog. |
| clusterIT_a.exe | Deprecated - Configures HCL OneDB on the primary node for use in a cluster environment. |
| clusterIT_b.exe | Deprecated - Configures HCL OneDB on the secondary node for use in a cluster environment. |
| dbaccess | Provides a user interface for entering, running, and debugging Structured Query Language (SQL) statements and Stored Procedure Language (SPL) routines. |
| dbexport | Unloads a database into text files for later import into another database and create a schema file. |
| dbimport | Creates and populates a database from text files. Use the schema file with the dbimport utility to re-create the database schema. |
| dbload | Loads data into databases or tables. |
| dbschema | Creates a file that contains the SQL statements that are needed to replicate a specified table, view, or database, or view the information schema. |
| finderr | Looks up a specific error code and displays the corresponding error text. |
| GenMacKey | Generates MAC key files for encrypting network communications. |
| genoncfg | Expedites the process of customizing a database server instance's onconfig file to a host environment. |
| glfiles | Generates a list of GLS-related files on the UNIX operating system. |
| ifxclone | Creates a snapshot of a database server. |
| ifxdeploy | Deploys a snapshot or removes a snapshot. |
| ifxdeployassist | Creates and customizes a snapshot. |
| ifx_getversion | On the UNIX operating system: outputs the complete version name of an HCL OneDB library. |
| ILOGIN | On the Windows operating system: tests the connection to a database server. The ILOGIN utility is in the %INFORMIXDIR%\demo directory. |
| imcadmin | Starts or stops HCL OneDB MaxConnect, or gather statistics on HCL OneDB MaxConnect. |
| infoshp | Reports information that is extracted from headers of the .shp, .shx, and .dbf files that make up ESRI shapefiles. |
| ipload | Manages the onpload database and creates the components of High-Performance Loader load and unload jobs through a UNIX GUI. |
| ISM command-line utilities | Manage HCL OneDB Storage Manager (ISM), storage devices, and media volumes. |
| ixpasswd.exe | On the Windows operating system: Changes the logon password for all services that log on as user informix. |
| ixsu.exe | On the Windows operating system: Opens a command-line window that runs as the specified user. |
| loadshp | Loads spatial features and associated attributes from an ESRI shapefile into a table in an HCL OneDB database. |
| ntchname.exe | On the Windows operating system: Changes the registry entries for HCL OneDB from the old host name to the new host name. |
| onaudit | Manages audit masks and auditing configurations. |
| onbar | Backs up and restores storage spaces and logical logs. |
| oncheck | Checks specified disk structures for inconsistencies, repair inconsistent index structures, and display information about disk structures. |
| onclean | Forces a shutdown of the database server when normal shutdown from the onmode utility fails or when you cannot restart the server. |
| oncmsm | Starts, stops, installs, or uninstalls a Connection Manager; reloads a Connection Manager configuration file; or converts and earlier format Connection Manager configuration file to a current format configuration file. |
| ondblog | Changes the logging mode. |
| onconfig_diff | Compares two different onconfig files. |
| oninit | Starts the database server. |
| onkstore | Creates and manages keystore files for use with storage space encryption. |
| onload | Loads data that was created with the onunload utility into the database server. |
| onlog | Displays the contents of logical-log files. |
| onmode | Changes the operating mode of the database server, and performs various other operations on shared memory, sessions, transactions, parameters, and segments. |
| ON-Monitor | Performs administrative tasks through the ON-Monitor menus. |
| onparams | Modifies the configuration of logical logs or physical logs. |
| onpassword | Encrypts and decrypts password files that are used by Connection Managers or the CDR utility. |
| onperf | Monitors database server performance. |
| onpladm | Writes scripts and create files that automate data load and unload jobs. |
| onpload | Manages load and unload jobs directly from the command line. |
| onpsm | Manages HCL OneDB Primary Storage Manager, which controls backup and restore devices for the ON-Bar utility. |
| onrestorept | Restores a server instance back to its original state just before the start of an upgrade. |
| onsecurity | Checks the security of a file, directory, or path and troubleshoots any existing problems. |
| onshowaudit | Extracts information from an audit trail. |
| onsmsync | Synchronizes the sysutils database and emergency boot file with the storage-manager catalog. |
| onspaces | Manages storage spaces. |
| onstat | Monitors the operation of the database server. |
| ontape | Logs, backs up, and restores data. |
| onunload | Unloads data from the database server. |
| OpenAdmin Tool (OAT) for HCL OneDB | Provides a web application for administering and analyzing the performance of one or more HCL OneDB database servers. |
| setnet32 | On the Windows operating system: Sets or modifies environment variables and network parameters that HCL OneDB products use at run time. |
| snmpdm | On the UNIX operating system: Ensures that both the SNMP master agent and the onsrvapd server-discovery daemon are running on a host. |
| SqlhDelete | Deletes the sqlhosts entries from the LDAP server. |
| SqlhUpload | Loads the sqlhosts entries from a flat ASCII file to the LDAP server in the prescribed format. |
| syncsqlhosts | Converts the connection information between the sqlhosts file format and the Windows registry format. |
| unloadshp | Copies spatial features and associated attributes from a table in an HCL OneDB database into an ESRI shapefile. |
| w4gl | Publishes, deploys, packages, and subscribes to 4GL web services. |