Results 1 to 4 of 4

Thread: device status

  1. #1
    Join Date
    Nov 2003
    Location
    Belgium
    Posts
    25

    Angry Unanswered: device status

    Hello all,

    We need to know what is the status of a device when the file or the raw partition doesn't exist anymore.

    e.g.:
    sp_helpdevice results:
    dbadev01 /home/sybase/Devices/dba_dev01.dd

    The /home/sybase/Devices/dba_dev01.dd doesn't exist anymore.
    Is there a special status in sysdevices to see that this device is not anymore accessible ?

    Someone has an idea ?

    Xavier

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524

    Red face

    At startup, you will see the status per device (in the errorlog)
    Else, you will receive a WRITE error / stacktrace

    Why do you remove a used device ??? Enjoy rm without check !

  3. #3
    Join Date
    Nov 2003
    Location
    Belgium
    Posts
    25
    Hi,

    I didn't remove the file. This question is part of a "disaster recovery" from scratch with a entire recover of Sun Solaris. The sybase server runs actually on Fiber Channel disk in a separate box. We want only recovered one database (+/- 100Gb).

    I know that we can retrive this information in the errorlog of the server.

    Do we retrieve this information in other place that in the errorlog ? (especially in the comumn status of sysdevice table)

    Regards,

    Xavier

  4. #4
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208

    Re: device status

    Originally posted by xavier_urbain
    Is there a special status in sysdevices to see that this device is not anymore accessible ?
    I don't think there is anyway of knowing that a device is unavailable using standard documented commands. There is no status bit available in any of the system tables that tell the server the health of a device at all times.

    This is done only during startup and then again if server requests a page that is hosted on that particular device.

    Check with Sybase Support, they might have some un-documented dbcc's

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •