Chat now with support
Chat with Support

SharePlex 8.6.6 - Upgrade Guide

Verify_Partitions



The method of creating and storing partition schemes and row partitions for horizontal partitioning has changed in this release. This information no longer is stored in the database.

When you run database setup during an upgrade, it converts the data from the SHAREPLEX_PARTITION table to the new internal storage format. After the conversion, you can view the partitions with the view partitions command in sp_ctrl to ensure that the partitions converted properly.

Note: For more information about the view partitions command, see the.

To view row partitions

  1. Run sp_ctrl on the source system.
  2. Issue the following command with either option, depending on whether you want to view all partitions or just those for a particular partition scheme.

    sp_ctrl> view partitions for {scheme_name | all}

The following is an example of converted partition schemes. Note that the conversion program populates the Name field with the name of the queue from the Route column.

Scheme        Name           Route                            Hash     Condition
-----------   -------------  ------------------------------   ------   ---------------
HASH4         hash           sys02:hash|#@o.ora112            4        ROWID
TEST_CT       highvalues     sys02:highvalues@o.ora112                 sales>=10000
TEST_CT       lowvalues      sys02:lowvalues@o.ora112                  sales<10000

Target upgrade for SAP ASE

Target upgrade for SAP ASE

This section applies to upgrades from SharePlex version 8.5 to the current release.

Version 8.6 changed the way that SAP ASE is defined in the routing map in the configuration file and the way that connection settings are defined for Post.

  • In the configuration file, the routing map now requires r.database_name, where database_name is the actual name of the target database, not a DSN.
  • The connection information for Post to connect to SAP ASE is now configured through the connection command, rather than in the target configuration created by the target command.

To complete the upgrade from version 8.5 to the current version of SharePlex for an SAP ASE target, while keeping the current configuration active so that replication can continue, use the following procedure.

Note: This upgrade keeps the routing map as configured in version 8.5 and only changes the Post connection settings.

  1. From the Unix command line of the operating system, run the following command, where database_name is the actual name of the target database (not a DSN).

    export SP_TARGET_DATABASE=database_name

  2. Start sp_cop.

    /product_dir/bin/sp_cop

  3. In sp_ctrl, issue the show post command. The state should be "stopped-due to error." If Post did not stop, stop it with the stop post command.

    stop post [for datasource-datadest]

  4. Issue the following commands, using the new connection command, but this time substitute the DSN of the database for DSN. Do not specify the actual database name in this case.

    connection r.DSNset user=name_of_Post_database_user

    connection r.DSNset password=password

  5. Start Post.

    start post [for datasource-datadest]

 

SharePlex utilities

SharePlex utilities
Contents

EDB Postgres Advanced Server Setup (ppas_setup)

SharePlex utilities > EDB Postgres Advanced Server Setup (ppas_setup)

Overview

Run the pg_setup program on a PostgreSQL system to establish a user account, schema, and tables for use by SharePlex.

Supported databases

All implementations of the PostgreSQL open-source database on supported platforms

Guidelines for using pg_setup

  • Run pg_setup on all target PostgreSQL instances in the SharePlex replication configuration.
  • Within a server cluster, run pg_setup on the node to which the shared disk that contains the SharePlex variable-data directory is mounted.
  • For consolidated replication, run pg_setup for each variable-data directory.
  • You can provide a connection string or a DSN. Note the following:

    Connection Type What to do
    Connection string You do not need to provide a user, password, or default database in a connection string. These will be added when you run the setup program. The connection string must have the port, server and driver defined. This is an example: Port=5444;server=localhost;driver=/u01/PostgresPlus/connectors/odbc/lib/edb-odbc.so;database=edb;
    DSN

    If you have a DSN defined, and you want to use it for the SharePlex connection, copy or link the ODBC files in which that DSN is defined (odbc.ini and odbcinst.ini) to the odbc subdirectory of the SharePlex variable-data directory. This prevents connection errors when the SharePlex processes connect to the database.

    If you do not have a DSN defined but want to use one, you can create it in the template files provided in the odbc subdirectory.

Required privileges to run pg_setup

Review the following requirements to ensure that the setup succeeds.

  • The setup utility must be run as a PostgreSQL Administrator in order to grant SharePlex the required privileges to operate on the database and to create the SharePlex database account.
  • (Symfoware only) If the person who is running the setup is not a Fujitsu Enterprise Postgres owner, set the environment variable LD_LIBRARY_PATH to include the path to the lib subdirectory in the Fujitsu Enterprise Postgres installation directory. The LD_LIBRARY_PATH is set in the .bash_profile file of the Fujitsu Enterprise Postgres owner.

    Example:

    export LD_LIBRARY_PATH= /opt/symfoserver64/lib:$LD_LIBRARY_PATH

    If you do not set this path, the following error occurs:

    symbol lookup error: /opt/fsepv95client64/odbc/lib/psqlodbca.so: undefined symbol: PQconnectdbParams

  • Cloud installations:
    • Common restrictions on privileges in cloud-hosted database services make it difficult for the setup utility to succeed in every possible type of scenario. To ensure that the database setup succeeds, use the setup utility only to set up replication to the following: A new database, to be created by the setup utility, where the SharePlex user is also created by the setup utility.An existing database, where the SharePlex user is an existing user that is either the owner of the database or has access privileges to the database.

Run pg_setup

  1. Shut down any running SharePlex processes and sp_cop on the target system.
  2. Run the pg_setup utility from the bin subdirectory of the SharePlex product directory.

    Important! If you installed the SharePlex instance on any port other than the default of 2100, use the -p option to specify the port number. For example, in the following command the port number is 9400.

    $ /users/splex/bin> pg_setup -p9400

Table 1: Setup prompts and responses

Prompt Response

Enter the PostgreSQL DSN name or connection string [] :

Enter a connection string or a data source name (DSN) that connects to the PostgreSQL target.

Enter the PostgreSQL Administrator name :

Enter the name of the PostgreSQL Administrator. This user will perform the work on the SharePlex account.

Enter the password for the Administrator account :

Enter the password of the Administrator.

Enter the replication target database name:

Enter the name of the database that you want to contain the SharePlex tables and other objects for use by SharePlex. You can enter the name of a new or existing database.

Database name database does not exist. Would you like to create it? [y] :

If this prompt is displayed, the specified database does not exist. Press Enter to have the setup program create it for you.

Would you like to create a new SharePlex user [y]:

Press Enter to accept the default to create a new SharePlex database user account and schema of the same name in the specified database, or enter n to use an existing SharePlex account.

Enter the name of the new SharePlex user:

Enter the name of the existing SharePlex user:

One of these prompts is displayed depending on whether you elected to create a new user or use an existing user. Enter the name of the SharePlex user.

 

Enter the password of the SharePlex user :

Enter the password of the SharePlex user account.

Re-enter the password for the SharePlex user :

This prompt is only shown if you created a new user. Enter the SharePlex password again.

A successful setup terminates with a message similar to the following:

Completed SharePlex for PostgreSQL database configuration

SharePlex User name: splex

Database name: ndb5

Target specification in SharePlex configuration: r.ndb5

Related Documents