If the tempdb segments on master were initially dropped so that all segments
were on the non-master devices then if I was to drop the non-master devices
(delete from sysusages where lstart > 0) to reset the database size then
would tempdb function at all since it has no segments?

I cant run:
sp_addsegment "default",tempdb,master
and although I can run:
sp_extendsegment "default",tempdb,master
sp_extendsegment "system",tempdb,master
the following exclusively assigns the logsegment to master, i.e., removes
the previous 2 segments:
sp_extendsegment "logsegment",tempdb,master

Martin

"Martin Hanna" <postmaster (AT) SPAMIGNOREmovillaIGNOREplus (DOT) com> wrote


No, at least not after a reboot. You should add the segments
back before you delete the other devices.

You can recover from this situation by doing the following:

shutdown ASE
modify the .cfg file to "allow updates to system tables 1"
reboot ASE
update sysusages set segmap = 7 where dbid = 2
shutdown
reboot ASE

"Bret Halford" <bret (AT) sybase (DOT) com> wrote

Thanks Bret. That worked fine.

Martin