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

When are stored procedures compiled in sybase?

792

---

What is the default table size in sybase?

824

---

How would you configure identities in sybase?

935

---

Explain relationship between jdbc and sybase.

845

---

What are the catches?

824

---

Differentiate between ltm and repagent?

930

---

How do I create a database in sybase central?

841

---

Using large raw partitions with replication server on unix in sybase?

901

---

How do I configure identities in sybase?

799

---

How do I exclude a column in sybase?

828

---

What do you mean by asa in sybase?

921

---

How do the blocker processes exist internally in sybase?

831

---

explain engines?

844

---

How does partition assignment relate to transactions in sybase?

783

---

Does sybase support row level locking?

824

---