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.

What is the use of sp_helprotect in sybase?

968

---

You need to purge data from audit database. What will you do?

891

---

What do you mean by deferred update in sybase?

930

---

What is replication in sybase?

884

---

How do the blocker processes exist internally in sybase?

904

---

How to connect sybase database from python?

1047

---

How to take backup in sybase database in sap?

892

---

Compare join and subquery in performance?

957

---

What is coalesce in sybase?

942

---

Explain intimate shared memory(ism)

906

---

What command helps you to know the process running on this port, but only su can run this command?

915

---

How to divide by zero and nulls in sybase?

951

---

Explain timestemp datatype in sybase.

970

---

How to view the log files in sybase?

936

---

How can I improve throughput in sybase?

926

---