SQL interactive interface

You can use the SQL interactive interface command-line utility provided with Tivoli Netcool/OMNIbus to issue SQL commands to an ObjectServer.

To connect to an ObjectServer with the interface, a user account must belong to a user group that has the predefined ISQL role. To modify ObjectServer data with the interface, a user account must belong to a user group that has the predefined ISQLWrite role.

Secure mode

When an ObjectServer runs in secure mode, it requires clients, including the SQL interactive interface, to connect to it with valid user names and passwords. The login information is encrypted when it is transmitted between the client and the ObjectServer. Passwords are decrypted by the ObjectServer.

The SQL interactive interface runs in secure mode by default. If you do not require a secure connection, you can use the -nosecure command-line option when starting the interface.