Answer Posted / vineet pal

1. check error log to find the tempdb full.
2. find out the space free in tempdb usin select lct_admin('logsegment_freepages'dbid)
3. dum tran with truncate only if still full than..
4.dump tran with no_log still full than..
5.find process from syslogshold/sysprocesses. inform user about condition ask for killing if he says yes then
6 kill the preocess
if user says no than alter the tempdb
7 you can also use lct_admin('abort',0,2) to kill all suspended trans.
or last on recomendation restart the server

What is sybase infomaker?

500

---

There is no space in file system and you need to take a back up. What will you do?

449

---

Is sybase relational database?

481

---

Explain mirroring?

486

---

what is the difference between an ltm and a repagent in sybase?

473

---

---

What are the best monitoring tools for the sybase database?

421

---

How would you fix a munged log in sybase ?

530

---

How to check sybase database status in linux?

467

---

What is cmaxpktsz good for in sybase?

470

---

What is asa ultralite in sybase?

495

---

Given a table which contains some rows with duplicate keys, how would you remove the duplicates?

466

---

What is the depth of triggers?

506

---

What is this tds protocol in sybase?

479

---

How do I set a password to be null?

473

---

What do you mean by exception log in replication?

472

---