Deploying database servers

You can deploy a database server by making the SQL Anywhere installer available to your end users. By selecting the proper option, each end user is guaranteed of getting the files they need.

The simplest way to deploy a personal database server or a network database server is to use the Deployment Wizard. For more information, see Using the Deployment Wizard.

To run a database server, you need to install a set of files. The files are listed in the following table. All redistribution of these files is governed by the terms of your license agreement. You must confirm whether you have the right to redistribute the database server files before doing so.

Windows Linux/Unix Mac OS X
dbeng11.exe dbeng11 dbeng11
dbeng11.lic dbeng11.lic dbeng11.lic
dbsrv11.exe dbsrv11 dbsrv11
dbsrv11.lic dbsrv11.lic dbsrv11.lic
dbserv11.dll libdbserv11_r.so, libdbtasks11_r.so libdbserv11_r.dylib, libdbtasks11_r.dylib
dbscript11.dll libdbscript11_r.so libdbscript11_r.dylib
dblg[en]11.dll dblg[en]11.res dblg[en]11.res
dbctrs11.dll N/A N/A
dbextf.dll 1 libdbextf.so 1 libdbextf.dylib 1
dbicu11.dll2 libdbicu11_r.so2 libdbicu11_r.dylib2
dbicudt11.dll2 3 libdbicudt11.so2 libdbicudt11.dylib2
sqlany.cvf sqlany.cvf sqlany.cvf
dbodbc11.dll 4 libdbodbc11.so 4 libdbodbc11.dylib 4
N/A libdbodbc11_n.so 4 libdbodbc11_n.dylib 4
N/A libdbodbc11_r.so 4 libdbodbc11_r.dylib 4
dbjodbc11.dll 4 libdbjodbc11.so 4 libdbjodbc11.dylib 4
java\jconn3.jar 4 java/jconn3.jar 4 java/jconn3.jar 4
java\jodbc.jar 4 java/jodbc.jar 4 java/jodbc.jar 4
java\sajvm.jar 4 java/sajvm.jar 4 java/sajvm.jar 4
java\cis.zip 5 java/cis.zip 5 java/cis.zip 5

1 Required only if using system extended stored procedures and functions (xp_*).

2 Required only if the database character set is multi-byte or if the UCA collation sequence is used.

3 On Windows Mobile, the file name to deploy is called dbicudt11.dat.

4 Required only if using Java in the database.

5 Required only if using Java in the database and remote data access.

Notes
  • Depending on your situation, you should choose whether to deploy the personal database server (dbeng11) or the network database server (dbsrv11).
  • You must include the separate corresponding license file (dbeng11.lic or dbsrv11.lic) when deploying a database server. The license files are located in the same directory as the server executables.
  • The Java VM jar file (sajvm.jar) is required only if the database server is to use the Java in the Database functionality.
  • The table does not include files needed to run utilities such as dbbackup.

    For information about deploying utilities, see Deploying administration tools.

Windows Registry entries

To ensure that messages written by the server to the Event Log on Windows are formatted correctly, create the following registry key.

HKEY_LOCAL_MACHINE\
   SYSTEM\
      CurrentControlSet\
         Services\
            Eventlog\
               Application\
                  SQLANY 11.0

Within this key, add a REG_SZ value named EventMessageFile and assign it the data value of the fully qualified location of dblgen11.dll, for example, C:\Program Files\SQL Anywhere 11\bin32\dblgen11.dll. The English language DLL, dblgen11.dll, can be specified regardless of the deployment language. Here is a sample registry change file.

REGEDIT4
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\SQLANY 11.0]
"EventMessageFile"="c:\\sa11\\bin32\\dblgen11.dll"

For the 64-bit version of the server, the registry key is SQLANY64 11.0.

To ensure that messages written by MESSAGE ... TO EVENT LOG statements to the Event Log on Windows are formatted correctly, create the following registry key.

HKEY_LOCAL_MACHINE\
   SYSTEM\
      CurrentControlSet\
         Services\
            Eventlog\
               Application\
                  SQLANY 11.0 Admin

Within this key, add a REG_SZ value named EventMessageFile and assign it the data value of the fully qualified location of dblgen11.dll, for example, C:\Program Files\SQL Anywhere 11\bin32\dblgen11.dll. The English language DLL, dblgen11.dll, can be specified regardless of the deployment language. Here is a sample registry change file.

REGEDIT4
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\SQLANY 11.0 Admin]
"EventMessageFile"="c:\\sa11\\bin32\\dblgen11.dll"

For the 64-bit version of the server, the registry key is SQLANY64 Admin 11.0.

You can suppress Windows event log entries by setting up a registry key. The registry key is:

Software\Sybase\SQL Anywhere\11.0\EventLogMask

and it can be placed in either the HKEY_CURRENT_USER or HKEY_LOCAL_MACHINE hive. To control event log entries, create a REG_DWORD value named EventLogMask and assign it a bit mask containing the internal bit values for the different Windows event types. The three types supported by the SQL Anywhere database server are:

EVENTLOG_ERROR_TYPE        0x0001
EVENTLOG_WARNING_TYPE      0x0002
EVENTLOG_INFORMATION_TYPE  0x0004

For example, if the EventLogMask key is set to zero, no messages appear at all. A better setting would be 1, so that informational and warning messages don't appear, but errors do. The default setting (no entry present) is for all message types to appear. Here is a sample registry change file.

REGEDIT4
[HKEY_LOCAL_MACHINE\SOFTWARE\Sybase\SQL Anywhere\11.0]
"EventLogMask"=dword:00000007

Registering DLLs on Windows
Deploying databases