Check the output logs to isolate migration problems.
iqunload -au -c "UID=DBA;PWD=SQL;DBF=/iq-15/ unload/127/db/iq127db.db" -new_startline "-z -zr all" -o iq15db.out
iqunload -v -au -c "UID=DBA;PWD=SQL;DBF=/iq-15/ unload/127/db/iq127db.db;START=-z -zr all -o iq127db.out"
See the Utility Guide for details about the -z and -zr all parameters.
SQL error:Database server not found
Check to see if iqunlspt is running and stop the process before retrying iqunload.
load averages: 1.45, 1.19, 0.80; up 3+16:22:31 10:2 172 processes: 168 sleeping, 2 zombie, 2 on cpu CPU states: 79.1% idle, 18.9% user, 1.9% kernel, 0.0% iowait, 0.0% swap Memory: 16G phys mem, 13G free mem, 16G swap, 16G free swap PID USERNAME LWP PRI NICE SIZE RES STATE TIME CPU COMMAND 21223 ybrown 1 59 0 2908K 1844K cpu 0:00 0.12% top 21172 ybrown 476 59 0 319M 264M sleep 0:01 0.05% iqunlspt 24890 ybrown 14 29 10 79M 43M sleep 0:49 0.03% java 20103 ybrown 1 59 0 7916K 2080K sleep 0:00 0.00% sshdTo stop the process, enter the command kill -9 and supply the process ID:
kill –9 21172
SQL error: Unable to start specified database: autostarting database failed.
Migration replaces 12.7 login procedures with new login management functions.
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