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 the difference between replication server and sql remote in sybase?

944

---

Differentiate between ltm and repagent?

996

---

What is sybase used for?

963

---

How do I connect to sybase?

879

---

How to delete unix files which are more than 3 days old?

900

---

Alternative to row at a time processing in sybase?

784

---

How do I tell which tables have identities in sybase?

875

---

How do I add a sybase driver to sql developer?

870

---

What is the equivalent of oracle/db2 coalesce function in sybase?

876

---

Explain autosys. Why do you need it.

967

---

What measures are there to increase the db space?

905

---

Explain defncopy and it's usage?

977

---

You need to remove duplicate rows from a sybase table. How would you do that?

887

---

What is sybase infomaker?

965

---

Explain intimate shared memory(ism)

908

---