we have sybase cluster 12.5 on hp-ux , we want to re-create with
striping the logical volume and then re-create the tempdb required
devices, alter tempdb on the new devices with the same sizes as
before.

Can you give me some idea how pratical is this idea and what's steps
are involve. I think we need to delete all temp db device except the
master or reduce the size and recreate it in new device ( in strip
volume ), but I am not sure. Any link and script in this regard also
appreciated.

Frank wrote:

Frank,

I don't know about striping, but to reduce the size of tempdb so that it
occupies only the original 2 MB on the master device, try something like
this:

sp_configure allow, 1
go
select * from master..sysusages where dbid=2 and lstart !=0
go
begin tran
delete master..sysusages
where dbid=2 and lstart !=0
go
/* not sure if the following is necessary */
update master..sysusages set segmap = 7 where dbid = 2
go
/* in any case do the following */
select * from master..sysusages where dbid=2
go

/* You should see the following output, if not rollback the transaction: */
dbid segmap lstart size vstart
2 7 0 1024 2564

/*otherwise*/

commit tran
go
sp_configure allow, 0
go
reconfigure with override
go
shutdown
go
recycle the server.
disk init new devices
alter tempdb onto the new devices

Tom

soal6570 (AT) yahoo (DOT) com (Frank) wrote in message news:<42601b2.0406291919.7c937c83 (AT) posting (DOT) google.com>...

Hi Frank,

If you are recreating the devices exactly then your best bet is to
mirror the tempdb devices to the striped volume and then break the
mirrors by removing the primary devices (on the old volume). This
moves the tempdb devices without having to bring the system down and
is super easy to do.

Alternatively, there is a good write-up on resizing tempdb in the
"Troubleshooting Guide" under "Encyclopedia of Useful Tasks".

Good Luck!!

Sara ...