Answer Posted / bindu

if the system temp db gets filled, even sa cannot get
connected to that temp db to check which processes are
blocking, in order to avoid this , a good concept of
multiple temp dbs can be implemented and we can create temp
dbs and assign newly created temp db to sa, so that sa
could get the info of the processes that is blocking temp
db, ab=nd by using lct_admin or some other commands we can
abort that blocking transaction.

How to check sybase database status in linux?

1086

---

Explain the difference between numeric and decimal data types in sybase.

932

---

Explain about the sybase group?

961

---

Is there a difference in storage type of numeric and decimal data types in sybase? If yes, what?

871

---

What is the default table size in sybase?

949

---

Tempdb is full. How would you clear it?

939

---

What is an advantage to using a stored procedure as opposed to passing an sql query from an application ?

969

---

Explain tds (tabular data streams).

950

---

State some of the products of sybase?

945

---

What are the catches?

942

---

What are the main differences between 11.x and 12.x versions of sybase?

884

---

Explain defncopy and it's usage?

1016

---

Why do my page locks not get escalated to a table lock after 200 locks?

909

---

What data types does sybase support?

935

---

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

947

---