Sets the password for the DBA user of the utility database (utility_db), or disable connections to the utility database.
iqsrv16 -su password ...
All operating systems and database servers.
This option specifies the initial password for the DBA user of the utility database. The password is case sensitive. You can specify none for the password to disable all connections to the utility database.
If you are using the network database server and do not specify the -su option, connections to the utility database are not allowed unless the util_db.ini file exists and the user ID is DBA with a password that matches the password in the util_db.ini file. On a network server, if both -su and util_db.ini are used, util_db.ini is ignored. The util_db.ini file is deprecated.
Specifying a password for the utility database for a network database server is useful for the cases when the database server is running, but it is not possible to connect to the database.
You can execute a CREATE USER DBA IDENTIFIED BY new-password statement while connected to utility_db to change the password for the DBA user of the utility database. The REVOKE CONNECT FROM DBA statement can be used to disable connections to the utility_db database. Not all SQL statements are supported for the utility database.
To avoid having the utility database password in clear text on the command line, you can use the dbfhide utility to obfuscate a file containing the password, and then reference the obfuscated file on the command line.
The following command disables all connections to the utility database:
iqsrv16 -su none c:\inventory.db
In the following example, the file named util_db_pwd.cfg that contains the utility database password is obfuscated using dbfhide and renamed util_db_pwd_hide.cfg:
dbfhide util_db_pwd.cfg util_db_pwd_hide.cfg
The util_db_pwd_hide.cfg file can then be used to specify the utility database password:
iqsrv16 -su @util_db_pwd_hide.cfg -n my_server c:\inventory.db