Increase the cache memory to migrate large and extremely large schemas.
Default cache settings for large schemas may be too small and can exhaust dynamic memory in the iqsrv16 server. Use the -c switch to increase the server cache memory and -new_startline to pass the switch to the server.
-ca 1 – enables dynamic catalog cache sizing, and logs memory cache statistics to the console.
-c 1000m – sets the initial catalog cache at 1GB.
-o d:\iq16console.out – specifies the log file for console output.
Running iqunload in schema unload mode (iqunload -n) generates a single script (reload.sql ) that includes the entire legacy schema. In some cases, you may need to break a very large reload.sql file into pieces that can be executed sequentially. This also helps the server manage the cache.
If iqunload fails in migration mode (iqunload -au) because dynamic memory is exhausted, set the cache settings as high as your hardware and operating system limitations allow. If the failure continues, contact SAP Sybase for assistance.