Answer / Sudil Kumar

"A blocker process is a transaction that holds locks on data needed by another transaction, thereby preventing the other transaction from proceeding. In Sybase, a blocked process appears in the syslockinfo system table and can be identified using tools like isql or Interactive SQL. "

How would you lock a table in sybase? What text command will you use for it?

1 Answers  

---

Explain tds (tabular data streams).

1 Answers  

---

What do you mean by mainframe connect tool in sybase?

1 Answers  

---

what is the difference between an ltm and a repagent in sybase?

1 Answers  

---

How would you improve throughput in sybase?

1 Answers  

---

How do I make isql secure in sybase?

1 Answers  

---

How to start sybase database in windows?

1 Answers  

---

How do I force an index to be used in sybase?

1 Answers  

---

Is there any advantage of last_name varchar(50) over this last_name varchar(255)?

1 Answers  

---

How would you configure burn factor in sybase?

1 Answers  

---

How does partition assignment relate to transactions in sybase?

1 Answers  

---

Explain procedure cache and data cache in sybase.

1 Answers  

---