Answer Posted / karthik

tempdb space issues
===================

we will try to clear the tran log by using no_log(or)trunket_only(or)normal backup
>dump tran <databasename> to "/path/<file.txt>"
>go
ofter using this command try to exe some sql quray
if it is not working
>dump tran <databasename> with trunket_only
>go
or
>dump tran <databasename> with no_log
>go
the difference between trunket_only and no_log is check point
trunket_only will wait for checkpoing and no_log is execute with out check point
even tho quary is not executed
>select lct_admin(abort,0,2)
>go

What is the relationship between jdbc and sybase?

489

---

What you need to do is issue an ase kill command on the connection then un-suspend the db?

529

---

How do I remove duplicate rows from a table in sybase?

484

---

What is the difference between 'dump tran database to physical name' 'dump tran database with truncate_only' and dump tran database with no_log'and in real time when we go to truncate the log?

501

---

What is replication in sybase?

454

---

---

Explain open server?

488

---

How do you check database space?

516

---

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

535

---

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

464

---

How to find the time taken for rollback of the processed?

513

---

How to connect sybase database from python?

478

---

Is sybase owned by sap?

465

---

What is procedure cache and data cache in sybase?

453

---

How do I pipe the output of isql to a file in sybase?

500

---

How do I create a partitioned table that spans multiple devices in sybase?

389

---