Does IQ16.1 change the utility_db behavir?

[former_member232292]

Dear All,

I'm just researching the new IQ16.1 SP02 on my test lab and I find the utility_db is something different to before , so that I can't create database on it now. Please kind help.

Here's my steps:

1. start the utility_db --

asiq160@bigDataHadoop:~> start_iq -n utility_db -x tcpip{port=2638}

Starting server utility_db on bigDataHadoop at port 2638 (07/03 11:35:52)

....

I. 07/03 11:36:00. TCPIP link started successfully
I. 07/03 11:36:00. Now accepting requests
New process id is 22562

Server started successfully

It looks all good.

2. But when I'm trying to connect to it -- error raised as the "utility_db" database can't be started --

asiq160@bigDataHadoop:~> dbisql -c "uid=dba;pwd=sql;eng=utility_db;dbn=utility_db;links=tcpip{port=2638}" -nogui
Could not connect to the database.
Unable to start specified database: unable to start database
"utility_db"
SQLCODE=-82, ODBC 3 State="08001"


(Not Connected)> exit

If I'm right -- before 16.1 -- the database name in utility_db should be utility_db too. But this time -- I can't login to it. Is the utility_db changed in this version? And if yes. -- then how to create new database or perform restoration?

Thanks in advance for your help.

Regards

Eisen

[former_member232292 · Accepted solution]

Oh... Got it... It's due to the default "dba/sql" canceled from 16.1 ...

So I need to start utility_db with "-su" then it's OK.

🙂

[Gisung]

Yes, Here is a KBA regarding a changed behavior of utility in IQ16.1.

2534299 - Failed to start utility db in IQ16.1 due to Invalid database server command line error.

[fockewulf190]

I tripped over this one too. You are correct, the -su to set the DBA password is required.