Using dataserver Build Servers

dataserver is the executable form of the SAP ASE program.

SAP ASE does not use the buildmaster binary to build the master device. Instead, Sybase has incorporated the buildmaster functionality in the dataserver binary. This chapter discusses how to use dataserver to build your server.

Note: The dataserver binary in Windows is called sqlsrvr.exe. If you are using the Windows platform, substitute all reference to dataserver in this chapter with sqlsrvr.

The dataserver command allows you to create master devices and databases with logical pages of size 2K, 4K, 8K, or 16K. Larger logical pages allow you to create larger rows, which can improve your performance because the SAP ASE server accesses more data each time it reads a page. For example, a 16K page can hold eight times the amount of data as a 2K page, an 8K page holds four times as much data as a 2K page, and so on, for all the sizes for logical pages.

The logical page size is a server-wide setting; you cannot have databases with varying size logical pages within the same server. All tables are appropriately sized so that the row size does not exceed the current page size of the server. That is, rows cannot span multiple pages.

Related reference