SharePlex 12.0 - Installation and Setup guide

Generic SharePlex Demonstration for PostgreSQL

Contents

Prework for the demonstrations

Before you run the basic demonstrations, have the following items available.

Tables used in the demonstrations

You will replicate splex.demo_src from the source system to splex.demo_dest on the target system. These tables are installed by default into the SharePlex schema, which in these demonstrations is "splex." Your SharePlex schema may be different. Verify that these tables exist.

Description of the demo tables.

INSERT scripts

• Create a SQL script named insert_demo_src that inserts and commits 500 rows into the splex.demo_src table. You will run this script during some of the demonstrations.
• If you will be using the demonstration of named post queues, create a SQL script named insert_demo_dest that inserts and commits 500 rows into the splex.demo_dest table. You will run this script during some of the demonstrations.

Start SharePlex

Start SharePlex

The following are instructions for starting SharePlex and the sp_ctrl command-line interface on Unix, Linux, and Windows system. Start SharePlex on the source and target systems.

To start SharePlex on Unix, Linux, and Windows systems:

1. Log onto the system as a SharePlex Administrator (a member of the SharePlex Admin group).

2. From the bin sub-directory of the SharePlex product directory ( productdir in the following syntax), run sp_cop and sp_ctrl.

   $cd /productdir/bin

   $./sp_cop &

   $. /sp_ctrl

To start SharePlex on Windows systems

1. Log onto the system as a SharePlex Administrator (a member of the SharePlex Admin group).
2. From the Quest Software | SharePlex program menu, select SpUtils.
3. Select the SharePlex Services tab.
4. Under Port, select the SharePlex port number, then click Start.
5. When Current State shows that the service is running, close the dialog box.
6. From the Quest Software | SharePlex program menu, select sp_ctrl to run the SharePlex command line.

Create and activate a configuration for PostgreSQL

SharePlex gets its replication instructions from a configuration file, which defines the objects that are to be replicated. The file specifies following:

• The datasource (source database) — the identifier of the source database.
• The source objects — the names of the objects that contain the data to be replicated.
• The target objects — the names of the target objects that will receive the replicated data.
• The routing map — the name of the target system and, if the target is a database, its identifier.

Note: This demonstration demonstrates replication from one database to another. It does not cover replication to a file or a messaging container.

Create a configuration file

Perform these steps on the source system. The demonstration objects are assumed to be in the schema named splex.

Perform the following steps to create a configuration file:

1. Run sp_ctrl.

2. Issue the following command to create a configuration file named sample_config in the default text editor.

   sp_ctrl(source)>create config sample_config

3. In the text editor, build your configuration file based on the appropriate template, as shown in the Configuration templates. Allow no spaces between the characters in a component (source specification, target specification, routing map), and place at least one space between each component.

4. Save the file, then exit the editor. SharePlex automatically saves the file in the config sub-directory of the variable-data directory.

5. In sp_ctrl, verify that the configuration file will activate successfully.

   sp_ctrl(source)>verify config sample_config

Configuration templates

PostgreSQL source to PostgreSQL target

where:

• source_DB is the database name of the source database
• "qarun" is the database user of the source database
• "splex" is the database user of the target database
• "sp_ad" is the database name of the source database

Activate the configuration

Perform these steps on the source system. When you activate a configuration, SharePlex is ready to capture transactional changes that are made to the specified source data.

Perform the following steps to activate a configuration file:

1. Activate the configuration.

   sp_ctrl(source)>activate config sample_config

   Note: Configuration names are case-sensitive.

2. Confirm that the configuration activated successfully. The name sample_config should appear under File Name, and the word Active should appear under State.

   sp_ctrl(source)>list config

Troubleshooting tips

If your configuration activation fails, isue the view config sample_config command to view the file. Compare it to the template and make sure all of the information you entered is correct. Make certain you specified the correct database identifier. Check your syntax for extra spaces or missing components.

Because the configuration file is not active, you can edit it directly with the following command:

sp_ctrl(source)>edit config sample_config

Save the changes, then re-try the activation.

Note: To change an active configuration, you must copy it to a new file first, and then edit and activate the copy. For more information, see Add or Change Table Specifications in an Active Configuration in the SharePlex Installation and Setup Guide.