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 my identity burn factor vulnerability right now in sybase?
What is open client in sybase?
How to start sybase database in windows?
Differentiate between ltm and repagent?
When you change a database option when will it come into effect?
How to take backup in sybase database in sap?
Why do my page locks not get escalated to a table lock after 200 locks?
How to connect to sybase database from linux?
How do I start sybase control center in windows?
Explain autosys. Why do you need it.
What are the main differences between 11.x and 12.x versions of sybase?
How to find the time taken for rollback of the processed?
Explain about the features of sybase iq?
What will you do if a replication thread goes down?
What is trace flags — 5101 and 5102 in sybase?