Answer / jayakumar

1.directio performs IO in the same manner as raw devices
and provides the same performance benefit as raw devices,
but has the ease of use and manageability of file system
devices.
2.directio is a static parameter that requires a restart of
Adaptive Server to take effect.

Answer / atish

directio is clause of disk init command, introduced in
ASE15, for file system devices.It allows to configure ASE to
transfer data directly to disk bypassing the O.S. buffer
cache.It can be set during device initialization.It mainly
removes read dependency.

How to check sybase database status in linux?

0 Answers  

---

How to start and stop sybase database in linux sap?

0 Answers  

---

Explain coalesce. What is the equivalent of oracle/db2 coalesce function in sybase?

0 Answers  

---

How do I open a sybase database?

0 Answers  

---

What is a natural key in sybase?

0 Answers  

---

---

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

0 Answers  

---

What is the stored procedure to view current lock and processes respectively?

0 Answers  

---

How to change varchar(m) to varchar(n) in sybase?

0 Answers  

---

What is table partitioning in sybase?

0 Answers  

---

Explain locking?

0 Answers  

---

How do I configure identities in sybase?

0 Answers  

---

Explain procedure cache and data cache in sybase.

0 Answers  

---