Administration tool deployment

Subject to your license agreement, you can deploy a set of administration tools including Interactive SQL, Sybase Central, and the SQL Anywhere Console utility.

The simplest way to deploy the administration tools is to use the Deployment Wizard.

For information about system requirements for administration tools, see [external link] http://www.sybase.com/detail?id=1002288.

Initialization files can simplify the deployment of the administration tools. Each of the launcher executables for the administration tools (Sybase Central, Interactive SQL, and the SQL Anywhere Console utility) can have a corresponding .ini file. This eliminates the need for registry entries and a fixed directory structure for the location of the JAR files. These ini files are located in the same directory and with the same file name as the executable file.

  • dbconsole.ini   This is the name of the Console utility initialization file.

  • dbisql.ini   This is the name of the Interactive SQL initialization file.

  • scjview.ini   This is the name of the Sybase Central initialization file.

The initialization file will contain the details on how to load the database administration tool. For example, the initialization file can contain the following lines:

  • JRE_DIRECTORY=path   This is the location of the required JRE. The JRE_DIRECTORY specification is required.

  • VM_ARGUMENTS=any-required-VM-arguments   VM arguments are separated by semicolons (;). Any path values that contain blanks should be enclosed in quotation marks. VM arguments can be discovered by using the -batch option of the administration tool and examining the corresponding batch file that is created. For example, on Windows, launching Sybase Central with scjview -batch at a command prompt generates scjview.bat and launching Interactive SQL with dbisql -batch generates dbisql.bat. The VM_ARGUMENTS specification is optional.

  • JAR_PATHS=path1;path2;...   A delimited list of directories which contain the JAR files for the program. They are separated by semicolons (;). The JAR_PATHS specification is optional.

  • ADDITIONAL_CLASSPATH=path1;path2;...   Classpath values are separated by semicolons (;). The ADDITIONAL_CLASSPATH specification is optional.

  • LIBRARY_PATHS=path1;path2;...   These are paths to the DLLs/shared objects. They are separated by semicolons (;). The LIBRARY_PATHS specification is optional.

  • APPLICATION_ARGUMENTS=arg1;arg2;...   These are any application arguments. They are separated by semicolons (;). Application arguments can be discovered by using the -batch option of the administration tool and examining the corresponding batch file that is created. For example, on Windows, launching Sybase Central with scjview -batch at a command prompt generates scjview.bat and launching Interactive SQL with dbisql -batch generates dbisql.bat. The APPLICATION_ARGUMENTS specification is optional.

Here are the contents of a sample initialization file for Sybase Central.

JRE_DIRECTORY=c:\JDK\JRE160_x86
VM_ARGUMENTS=-Xmx200m
JAR_PATHS=c:\scj\jars;c:\scj\jhelp
ADDITIONAL_CLASSPATH=
LIBRARY_PATHS=c:\scj\bin
APPLICATION_ARGUMENTS=-screpository=c:\Users\Public\Documents\Sybase Central 6.1.0;-installdir=c:\scj

This scenario assumes that a copy of the 32-bit JRE is located in c:\JDK\JRE160_x86. As well, the Sybase Central executable and shared libraries (DLLs) like jsyblib610 are stored in c:\scj\bin. The SQL Anywhere JAR files are stored in c:\scj\jars. The JavaHelp 2.0 JAR files are stored in c:\scj\jhelp.

Note

When you are deploying applications, the personal database server (dbeng12) is required for creating databases using the dbinit utility. It is also required if you are creating databases from Sybase Central on the local computer when no other database servers are running.

 See also

Administration tool deployment on Windows
Administration tool deployment on Linux, Solaris, and Mac OS X
Administration tools configuration
dbisqlc deployment