Running the aserep script the first time

Running the aserep script the first time

Use aserep to start and initialize ASE Replicator. When you run this script the first time, with a unique set of parameters, it performs the following tasks:

Creates the ASE Replicator instance subdirectories in the directory where ASE Replicator is installed

Creates a configuration (.cfg) file in the subdirectory for the specified instance.

Creates ASE Replicator system tables and procedures in the Distribution Database

Creates a RUN script that you can use as a shortcut to start ASE Replicator

Creates the sp_helpddb.sql script

Starts the ASE Replicator process on the primary Adaptive Server host

The aserep script is provided as a shell script (.sh) for UNIX operating systems and a batch file (.bat) for Windows NT and Windows 2000 operating systems.

ASE Replicator depends on Adaptive Server Enterprise to set the $SYBASE and $SYBASE_JRE environment variables appropriately. These variables are defined in SYBASE.csh or SYBASE.sh (on UNIX platforms), or in SYBASE.bat (on Microsoft Windows platforms). If the $SYBASE or $SYBASE_JRE variable has not been set, ASE Replicator does not run and exits with a message like the following:

The env_variable environment variable is not set. 
Please execute the appropriate SYBASE.suffix script.

where env_variable is the $SYBASE or $SYBASE_JRE variable, and suffix is .sh or .csh for UNIX platforms and .bat for Microsoft Windows platforms.

Command line parameters that you provide the first time you run aserep define the configuration of the ASE Replicator process.

To run the aserep script the first time

On UNIX platforms, you must log in to the primary Adaptive Server host with a user ID that has authority to set execute permissions in the ASE Replicator instance subdirectory.

Make sure that the $SYBASE and $SYBASE_JRE environment variables are defined.

If it is not, set the current directory to the Sybase installation directory, and source SYBASE.csh or SYBASE.sh (on UNIX platforms), or execute SYBASE.bat (on Microsoft Windows platforms).

Set the current directory to the $SYBASE/RPL-15_0/bin directory:

cd $SYBASE/RPL-15_0/bin

Run the aserep script and specify all of the following command line parameters:

-m ASE_host where ASE_host is the name of the host machine where Adaptive Server is installed.
-a ASE_port where ASE_port is the port number used to connect to the Adaptive Server.
-s my_ASERep where my_ASERep is the server instance name of the ASE Replicator process. This name must be unique on the ASE Replicator host machine.
-r my_ASERep_port where my_ASERep_port is the port number ASE Replicator uses to listen for incoming connections. This port number must be unique on the ASE Replicator host machine.
-d DDB_name where DDB_name is the name of the Distribution Database you created.
-u rep_user where rep_user is the ASE Replicator system user login you created.
-p passwd where passwd is the password for the ASE Replicator system user login. If you omit the -p argument at the command line, ASE Replicator prompts you for a password.

After you run the aserep script, the ASE Replicator process starts and displays the Sybase copyright and disclosure statements in the operating system window. A configuration file called my_ASERep.cfg is created in the $SYBASE/RPL-15_0/my_ASERep directory, where my_ASERep is the ASE Replicator instance that has just started.

If the process starts successfully, the operating system prompt does not return in that window until you shut down the ASE Replicator process.

If an error message appears shortly after the copyright and disclosure statements, and the operating system prompt returns, then the ASE Replicator process failed to start successfully.

If the ASE Replicator process does not start successfully after you run the aserep script, verify that:

You entered all of the command line parameters correctly, and
You completed all of the other setup procedures in this chapter.