Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2006
    Posts
    4

    Move tempdb to another device (not from master)

    Hi,

    Background : Solaris 10 with ASE 12.5

    I have already moved tempdb out of master and pointed it to :

    > sp_helpdevice

    tempdb_device_dat
    /tmp/AAA_tempdb.dat
    special, dsync on, physical disk, 300.00 MB


    How can I move the tempdb from /tmp (Solaris temp file system) to say
    /sybdata00/tempdb_dev_dat ?

    Regards!

    Pig

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,353
    Quote Originally Posted by piggy915
    special, dsync on, physical disk, 300.00 MB
    You should not dsync on a tempdb devices
    Code:
    sp_deviceattr tempdb_device_dat, dsync, false
    Quote Originally Posted by piggy915
    move the tempdb from /tmp
    It is OK to have tempdb on tempfs (/tmp)
    just ensure you touch the file in you RUN_server file
    but can move it like this
    Code:
    sp_configure 'update',1
    update sysdevices set phyname='/sybdata00/tempdb_dev_dat'
    where name='tempdb_device_dat'
    shutdown with nowait
    $ touch /sybdata00/tempdb_dev_dat # No need to copy/move
    $ startserver -f RUN_...
    $ rm /tmp/AAA_tempdb.dat
    sp_configure 'update',0

  3. #3
    Join Date
    Jan 2004
    Location
    The Hague/Utrecht, NL
    Posts
    517
    Or, you can use mirroring to move the device.
    Mirror on /sybdata00/tempdb_dev_dat, disable the primary side (/tmp), delete the mirror, and you have the new destination of your device.
    I'm not crazy, I'm an aeroplane!

  4. #4
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    If it is in tmpfs the root should create it and chown to sybase. This should bve part of your rc at startup.

    "and that'll do Pig, that'll do".

Posting Permissions

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