If you use the iqunload command line argument -ms_size during migration and specify a size smaller than the required size that Sybase IQ calculates internally, an error similar to the following message may be returned near the end of the migration process:
Reload of new IQ_SYSTEM_MAIN Dbspace failed. Expected values in SYS.SYSIQDBFILE ( 25600, 0, T, T, T, new_main_store.iq ), actual values are ( 32512, 0, T, T, T, new_main_store.iq ).
To correct or avoid this problem:
Do not specify -ms_size, if the new IQ_SYSTEM_MAIN dbfile is a raw device. Sybase IQ always retrieves the size from a raw device.
If the new dbfile is a file system file and you have already received this error message, run iqunload again and specify a size greater than the size calculated for your system, as in the example below.
If you have not run iqunload yet, follow the IQ_SYSTEM_MAIN sizing guidelines in the section “Sizing guidelines for main and temporary store” in Chapter 1, “New Features in Sybase IQ 15.0” in the New Features Guide.
The iqunload utility determines that the new_main_store.iq needs to be larger than the size specified using the -ms_size option in the command line.
The first number in the list of “actual values” returned in the message above represents the number of blocks required for the migrated database. You can calculate the required size in megabytes (MB) for IQ_SYSTEM_MAIN by performing the following two steps:
Determine the existing Sybase IQ 12.7 block size:
SELECT block_size FROM sysiqinfo block_size 8192
Multiply the block size times the actual number of blocks required, then divide by the number of bytes per megabyte:
( 8192 * 32512 ) / (1024 * 1024 ) = 254MB
IQ_SYSTEM _MAIN in the migrated database must be at least 254MB, which is larger than the size originally specified in the iqunload -ms_size command line option.