INF: Sytos Tape Errors Returned by SQL Server for OS/2

  - Microsoft SQL Server version 4.2 for OS/2

SUMMARY

When an error occurs while dumping to tape on an OS/2 SQL Server, an error message similar to the following is written to the SQL Server error log:

   Sytos tape error 11 in module
   S:\dbms\os2\ksource\strmio\tbs.c at line 1978.

MORE INFORMATION

The Sytos error codes returned by the SQL Server software in the error log are from the OS/2 tape subsystem. The following table contains the error number (in decimal) and a short description. In many cases, finding the error returned by the driver will allow you to narrow down the problem.

For example, the error message above indicates that the tape is write- protected. The module name and line number refers to the location in the SQL Server source file where the error occurred.

   Code    Description or Possible Problem

    00     Command completed successfully
    01     Another application has already opened the device
    02     An error occurred while opening the device
    03     No device exists or a device hardware error has
           occurred.
    04     A command was issued to a device without properly
           opening the device
    05     Attempted to use a nonexistent unit
    06     Parameter Buffer pointer is invalid
    07     A media read error occurred
    08     A media write error occurred
    09     The tape is not properly inserted in the device or
           the device may be running diagnostics.
    10     A physical or logical end of media has been detected
           by the tape device.
    11     The media is write protected.
    12     A filemark has been detected on the media
    13     No data is detected at the media's current position
    14     An error occurred during the lock process
    15     An error occurred during the unlock precess
    16     An error occurred trying to locate a specific block
           number
    17     The tape device or driver detected an illegal
           command.
    18     A general error has occurred.
    19     A failure occurred during a media formatting.
    20     A read or write with an invalid block length may
           have occurred.
    21     Not currently used
    22     A request was issued with too many data blocks
    23     An DrvActDir needs to be issued or the media needs
           formatting.
    24     The media needs to be formatted
    25     The media has no partitions setup
    26     The driver has insufficient memory to carry out the
           command requested.
    27     A DosClose is received while a device is still in
           use.
    28     Not currently used
    29     Not currently used
    30     Not currently used
    31     Not currently used
    32     The maximum number of tape drives currently
           supported have already been opened
    33     Not currently used
    34     Not currently used
    35     Invalid Parameter Buffer Length
    36     An IOCTL or request was received that is not
           supported.
    37     No media is detected in device.
    38     A media change has occurred.
    46     Not currently supported
    49     The tape device's firmware needs to be updated.