Output Logs

SAP Sybase IQ 16.0 Engine Logs

Use the -new_startline " -z -zr all" argument to start iqsrv16 with extra logging:

iqunload -au -c "UID=DBA;PWD=SQL;DBF=W:\\iq-15\\unload\\127\\db\\iq127db.db" -new_startline "-z -zr all" -o d:\\iq15db.out

SAP Sybase IQ 12.7 Engine Logs

See the Utility Guide for details about the -z and -zr all parameters.

Server Not Found

A message similar to this indicates that iqunload started the database but could not connect to the server:

SQL error:Database server not found

Check to see if iqunlspt is running and stop the process before retrying iqunload.

In Task Manager, click Processes, right-click iqunlspt, choose End Process.

Trying to run iqunload without ending an orphaned iqunlspt process, may generate this error:

SQL error: Unable to start specified database: autostarting database failed.

Obsolete Stored Procedures

Migration replaces 12.7 login procedures with new login management functions.

sp_login_environment replaces the 12.7 default login procedure DBA.sp_iq_process_login and dbo.sa_post_login_procedure replaces the 12.7 default post-login procedure DBA.sp_iq_process_post_login. iqunload generally replaces obsolete options with new defaults, but if the 12.7 option is set on a specific user instead of PUBLIC (the default), the log file may report errors:

E. 10/31 16:53:40. Login procedure
'DBA.sp_iq_process_login' caused SQLSTATE '52W09' 
E. 10/31 16:53:40. Procedure 'sp_iq_process_login' not
found