Sybase IQ 12.4.0 Changes to Backup statement, Cleaning up after abnormal exit

9.5.14 Changes to BACKUP statement

In the Adaptive Server IQ Reference, the SIZE and STACKER option descriptions in the BACKUP statement should read:

SIZE option Specifies maximum tape or file capacity (some platforms do not reliably detect end-of-tape markers). No volume used on the corresponding device should be shorter than this value. This value applies to both tape and disk files but not 3rd party devices. Units are KB so, for example, for a 3.5 GB tape you specify 3500000. Default for disk files is 2GB. No default exists for tape on UNIX platforms.

For tape devices on Windows NT:

•The value of SIZE must be a multiple of 64.

•If you specify a SIZE that is not a multiple of 64, it is automatically rounded down to a multiple of 64.

•If you do not specify SIZE explicitly, it is automatically set to 1.5GB.

STACKER option Specifies that the device is automatically loaded, and specifies the number of tapes it is loaded with. This value is not the tape position in the stacker, which could be zero. When ATTENDED is OFF and STACKER is ON, Adaptive Server IQ will wait for a pre-determined amount of time waiting for the next tape to be auto-loaded. The number of tapes supplied along with the SIZE option will be used to determine whether there is enough space to store the backed up data. Do not use this option with 3rd part media management devices.

9.5.15 Cleaning up after abnormal exit

Killing processes may result in semaphores or shared memory being left behind instead of being cleaned up automatically. To eliminate unneeded semaphores, you should periodically run the -ipcscommand to check the status of semaphores and shared memory.

The ipcs –acommand lists the ID numbers, owners, and create times of semaphores and shared memory segments. When all Adaptive Server IQ instances are started by the same user (as Sybase recommends), you can search the OWNER column for that username. Identify shared memory segments and semaphores that have a very old create date but have not been used recently.

After verifying with the owner that these are indeed unused, run ipcrm command to remove them. Use the –mparameter to specify the memory segment id and the –scommand to specify the semaphore id number, in the following format:

46