Filter
Top Products
46
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
-ipcs command to check the
status of semaphores and shared memory.
The
ipcs –a command 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
–m parameter to specify the memory
segment id and the
–s command to specify the semaphore id number, in the
following format: