If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Sybase > Move tempdb to another device (not from master)

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: May 2005
Location: South Africa
Posts: 1,348
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
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Jan 2004
Location: The Hague/Utrecht, NL
Posts: 490
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!
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
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".
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On