Step 2: Copying the required files

Your installer should copy a subset of the files that are installed by the SQL Anywhere installer. You must keep the same directory structure. All files must be installed below the /opt/sqlanywhere11/ directory.

You should preserve the permissions on the files when you copy them from your reference SQL Anywhere installation. In general, all users and groups are allowed to read and execute all files.

The following table lists the files required for each of the software bundles. Make a list of the files you need, and then copy them into the directory structure outlined above. In general, you should take the files from an already-installed copy of SQL Anywhere.

File Interactive SQL Sybase Central with the SQL Anywhere plug-in Sybase Central with the MobiLink plug-in Sybase Central with the QAnywhere plug-in SQL Anywhere Console
java/jodbc.jar X X X X X
java/JComponents1100.jar X X X X X
java/jlogon.jar X X X X X
java/SCEditor600.jar X X X X X
java/jsyblib600.jar X X X X X
lib32/libjsyblib600_r.so.1 X X X X X
sun/javahelp-2_0/jh.jar X X X X X
jre_1.6.0_linux_sun_i586/... (Linux only) X X X X X
jre_1.6.0_solaris_sun_sparc/... (Solaris only) X X X X X
lib32/libdblib11_r.so.1 X X X X X
lib32/libdbjodbc11.so.1 X X X X X
lib32/libdbodbc11_r.so.1 X X X X X
lib32/libdbodm11.so.1 X X X X X
lib32/libdbtasks11_r.so.1 X X X X X
res/dblg[en]11.res X X X X X
lib32/libdbtool11_r.so.1 X X X
bin32/dbisql X X
java/isql.jar X X X
bin32/scjview X X X
bin32/scvw[en]600.jar X X X
java/sybasecentral600.jar X X X
java/salib.jar X X X
java/saplugin.jar X
java/debugger.jar X
lib32/libdbput11_r.so.1 X
java/apache_files.txt X X
java/apache_license_1.1.txt X X
java/apache_license_2.0.txt X X
java/log4j.jar X X
java/mlplugin.jar X
java/mldesign.jar X
java/stax-api-1.0.jar X
java/wstx-asl-2.0.5.jar X
java/velocity.jar X
java/velocity-dep.jar X
drivers/... X
java/qaplugin.jar X
java/qaconnector.jar X
java/mlstream.jar X
bin32/qaagent X
lib32/libdbicu11_r.so X
lib32/libdbicudt11.so X
bin32/dbinit X
bin32/dbconsole X
java/DBConsole.jar X

The table above shows a number of files with the designation [en]. For Linux, these files are available in a number of different languages with English (en) being just one of them. For more information, see the following section International message and context-sensitive help files.

Some file paths above end with "...". This indicates that the entire tree, including subdirectories, should be copied.

Note that on Mac OS X, shared objects have a .dylib extension, and symlink (symbolic link) creation is not necessary.

The administration tools require the 32-bit version of JRE 1.6.0. You should not substitute a later patch version of the JRE unless you have a specific need to do so. Not all platform versions of the JRE are bundled with SQL Anywhere. The platforms that are included with SQL Anywhere support Linux on x86/x64 and Solaris SPARC. Other platforms versions must be obtained from the appropriate vendor. For example, if you are working with a Linux install, copy the entire jre_1.6.0_linux_sun_i586 tree, including subdirectories.

If the platform that you require is included with SQL Anywhere, copy the JRE files from an installed copy of SQL Anywhere 11. Copy the entire tree, including subdirectories.

The sqlanywhere.jpr file contains a list of the required component files for the SQL Anywhere plug-in of Sybase Central.

The mobilink.jpr file contains a list of the required component files for the MobiLink plug-in of Sybase Central.

The qanywhere.jpr file contains a list of the required component files for the QAnywhere plug-in of Sybase Central. When deploying the QAnywhere plug-in, dbinit is required. For information about deploying database tools, see Deploying database utilities.

All five bundles in the table above require a number of links to be created. The following sections provide details.

Base component files

All five bundles require the links listed in this section.

Create the following symbolic links in /opt/sqlanywhere11/lib32:

libdbicu11_r.so -> libdbicu11_r.so.1
libdbicudt11.so -> libdbicudt11.so.1
libdbjodbc11.so -> libdbjodbc11.so.1
libjsyblib600_r.so -> libjsyblib600_r.so.1
libdbodbc11_r.so -> libdbodbc11_r.so.1
libdbodm11.so -> libdbodm11.so.1
libdbtasks11_r.so -> libdbtasks11_r.so.1

Create a symbolic link in /opt/sqlanywhere11/sun. The symbolic link for Linux is jre160_x86 for the 32-bit JRE. The symbolic link for other systems is jre_160.

jre160_x86 -> /opt/sqlanywhere11/sun/jre_1.6.0_linux_sun_i586 (Linux)
jre160 -> /opt/sqlanywhere11/sun/jre_1.6.0_solaris_sun_sparc (Solaris)
Interactive SQL files

Create the following symbolic links in /opt/sqlanywhere11/lib32:

libdblib11_r.so -> libdblib11_r.so.1
libdbtool11_r.so -> libdbtool11_r.so.1
Sybase Central with the SQL Anywhere plug-in

Create the following symbolic links in /opt/sqlanywhere11/lib32:

libdblib11_r.so -> libdblib11_r.so.1
libdbput11_r.so -> libdbput11_r.so.1
libdbtool11_r.so -> libdbtool11_r.so.1
Sybase Central with the MobiLink plug-in

Create the following symbolic links in /opt/sqlanywhere11/lib32:

libdblib11_r.so -> libdblib11_r.so.1
libdbmlput11_r.so -> libdbmlput11_r.so.1
libdbtool11_r.so -> libdbtool11_r.so.1

Create an additional symbolic link in /opt/sqlanywhere11/sun for 64-bit Linux. The symbolic link for Linux is jre160_x64 for the 64-bit JRE.

jre160_x64 -> /opt/sqlanywhere11/sun/jre_1.6.0_linux_sun_x64 (Linux)
Sybase Central with the QAnywhere plug-in

Create the following symbolic link in /opt/sqlanywhere11/lib32:

libdblib11_r.so -> libdblib11_r.so.1

Create an additional symbolic link in /opt/sqlanywhere11/sun for 64-bit Linux. The symbolic link for Linux is jre160_x64 for the 64-bit JRE.

jre160_x64 -> /opt/sqlanywhere11/sun/jre_1.6.0_linux_sun_x64 (Linux)
The SQL Anywhere Console

Create the following symbolic link in /opt/sqlanywhere11/lib32:

libdblib11_r.so -> libdblib11_r.so.1
International message and context-sensitive help files

For Linux systems only, all displayed text and context-sensitive help for the administration tools have been translated from English into German, Japanese, and Simplified Chinese. The resources for each language are in separate files. The English files contain en in the file names. German file names contain de, Japanese file names contain ja, and Chinese files contain zh.

If you want to install support for different languages, you have to add the message files for those other languages. The translated files are as follows:

dblgen11.res
English
dblgde11_iso_1.res
dblgde11_utf8.res
German (Linux only)
dblgja11_eucjis.res
dblgja11_sjis.res
dblgja11_utf8.res
Japanese (Linux only)
dblgzh11_cp936.res
dblgzh11_eucgb.res
Simplified Chinese (Linux only)

You must also add the context-sensitive help files for those other languages. The available translated files are as follows:

scvwen600.jar English
scvwde600.jar German
scvwfr600.jar French
scvwja600.jar Japanese
scvwzh600.jar Simplified Chinese

These files are included with localized versions of SQL Anywhere.