If your tempdb gets full you can do one of following:
you can expand your tempdb or you can use
select lct_admin(0,2)
go
It will abort all open transactions.But be sure the task by
confirming with the concern users.
Restarting the server is not recommanded.
lct_admin (0,2) would abort all open transactions, or you
can go for altering the tempdb space. Multiple tempdb's is
a feature which can be implemented to minimize such issues
of tempdb getting full.
if the system temp db gets filled, even sa cannot get
connected to that temp db to check which processes are
blocking, in order to avoid this , a good concept of
multiple temp dbs can be implemented and we can create temp
dbs and assign newly created temp db to sa, so that sa
could get the info of the processes that is blocking temp
db, ab=nd by using lct_admin or some other commands we can
abort that blocking transaction.
If the transaction log of tempdb is full then you call
login through sa and type following command.
> dump tran tempdb with trancate_only
> go
If the database is full then you can increase the size of
the database on a free device.
> alter database tempdb on device_name = size
> go
In sybase, we can have multiple users associated to same
login ,each corresponds to different databases, right? how
can we login to one database with corresponding user id?