The password for the utility database has been stored in the util_db.db file pre-SAP IQ 16.0.
But, the util_db.db file has been removed by the change of the specification from SAP IQ 16.1.
Therefore, you must set the password by using new database server option to start the utility database on SAP IQ 16.1.
If you have start the utility database without the set of the password, you cannot connect to the utility database with an error.
1. Start the utility database
C:\>start_iq -n utility
2. Connection failed with an interactive SQL (dbisql)
C:\>dbisql -c "uid=DBA;pwd=sql;eng=utility;dbn=utility_db" -nogui
Could not connect to the database.
Unable to start specified database: unable to start database "utility_db"
SQLCODE=-82, ODBC 3 State="08001"
- SAP IQ 16.1
utility_db , -82 , 08001 , create database , restore , restore database , load , load database , KBA , BC-SYB-IQ , Sybase IQ , How To
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.