Limit on number of backup devices [CR 543249]

When using the BACKUP command of Sybase IQ, users can parallelize the operation to multiple devices by specifying multiple TO clauses. Backups created using a backup statement with more than 36 TO clauses create backup archives that may be unreliable. While these archives appear to be correctly written, they may contain invalid headers and cannot be restored. The Sybase IQ BACKUP command provides no diagnostics or alerts that indicate that the archives have been written incorrectly. There is no current method to test the validity of the archives without performing a restore using the archives.

Future versions of Sybase IQ will enforce a limit of 36 devices in a BACKUP command.

This alert affects all versions of Sybase IQ up to and including Sybase IQ 12.6 ESD #10.

This alert also affects all versions of Sybase Risk Analytics Platform and Sybase RAP - The Trading Edition™.