Reconnecting After You Restore

SAP Sybase IQ requires the DBF parameter and database file name in order to connect to a database under certain circumstances.

This situation occurs when you use Interactive SQL and you have restored that database from backup while connected to utility_db.

For example, include the DBF parameter as follows:

CONNECT USING 'uid=DBA;pwd=sql;dbf=node1/users/fiona/mydb.db;
links=tcpip{host=serv1;port=1234};eng=serv1_iqdemo'

The following syntax returns a specified database not found error:

CONNECT DATABASE mydb USER DBA IDENTIFIED BY SQL

To avoid the error, enter a START DATABASE command while connected to utility_db, for example:

START DATABASE mydb

Use this method when connecting via Interactive SQL.