How do you troubleshoot if your tempdb gets filled
Answer Posted / ajith prabhakaran
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.
| Is This Answer Correct ? | 23 Yes | 4 No |
Post New Answer View All Answers
How to swap a db device with another?
How to start and stop sybase database in linux sap?
What is sybase ?
How to check sybase database status in linux?
How do I choose which tables to partition in sybase?
Who owns sybase?
What is replication in sybase?
What does –i option do in sybase tools?
How do I find the oldest open transaction in sybase?
Can I run any transact-sql command on a partitioned table in sybase?
Can two tasks be assigned to the same partition in sybase?
How to clear tempdb when the tempdb gets filled in sybase?
Explain coalesce. What is the equivalent of oracle/db2 coalesce function in sybase?
What do you mean by mainframe connect tool in sybase?
What is replication server? What is its role in sybase?