Answer Posted / prashant

when temp db gets filled
that means there are large number of open process that are
making log of temp db ful in this case we wont even able to
run sp_who
what we will do is :
lct_admin('abort',0,2)
it will kill all open transactions but still log remains
full
now we will alter & extend the database

Why am I running out of locks on the replicate side in sybase ?

1015

---

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

838

---

List similarities and differences between oracle & sybase.

973

---

Which version of open client works with which ase in sybase?

917

---

What are the catches?

886

---

How to remove row affected and dashes?

911

---

Explain defncopy and it's usage?

968

---

Can I use a named pipe to bcp/dump data out or in in sybase?

1007

---

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

915

---

What are the important features of sybase?

979

---

How to connect sybase database from python?

1044

---

How can I improve throughput in sybase?

925

---

Explain the advantages of data integration suite in sybase.

871

---

What is the command for quitting from sybase?

929

---

You need to add a notnull column in a table by using alter command (without using default command). How would you do that?

945

---