How do you troubleshoot if your tempdb gets filled
Answer Posted / kk07
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.
| Is This Answer Correct ? | 16 Yes | 8 No |
Post New Answer View All Answers
What is the difference between db-lib and ct-lib in sybase?
How can I tell the datetime my server started?
Can I partition any table in sybase ?
How do I create a partitioned table that spans multiple devices in sybase?
Explain relationship between jdbc and sybase.
Which version of open client works with which ase in sybase?
Is sybase a database? Explain.
What is the command for quitting from sybase?
What measures are there to increase the db space?
How would you fix a munged log in sybase ?
Explain about the mainframe connect tools from sybase?
What is open client in sybase?
What are the main differences between 11.x and 12.x versions of sybase?
How would you configure identities in sybase?
What are the best monitoring tools for the sybase database?