These instructions are for upgrading SharePlex when configured for an open target database running on a Linux or Unix system.
Important!
|
Pre-requisite for Snowflake database setup: If any user has used Snowflake setup utility of a version prior to 11.4, they should first perform the following cleanup steps:
|
To run the upgrade:
Log in to the system as the user that will be named as the SharePlex Administrator during this installation. This user will own the installation files and binaries.
Grant executable permissions to the file.
# chmod 555 installation_file
Run the .tpm file. If installing SharePlex in a cluster, run the installer from the primary node (the one to which the shared disk is mounted)
# ./installation_file
You are prompted for the following:
Prompt for: | Input |
---|---|
Installation type |
Select <New Installation>. |
Product directory location (path) |
Enter the path to the existing SharePlex installation directory. |
Variable data directory location |
Enter the name of the existing variable-data directory. |
SharePlex Admin group |
Enter the DBA-privileged group to which the SharePlex Administrator user belongs, which owns the SharePlex binaries. |
TCP/IP port for SharePlex |
Enter the port number of the SharePlex instance you are upgrading. |
License key (do you want to upgrade?) |
Press Enter to accept the default of N (no) to keep the existing license, or enter Y to specify a new license key if required for this upgrade. |
Please specify platform for license key (select a number): |
Please select the appropriate number from the following list of platforms to install the license key: 1) Oracle 2) File
3) JMS 4) Kafka 5) SQL Server 6) Postgres 7) MySQL 8) Snowflake 9) Event Hubs 10) All Platforms q) Quit License Utility Note: To install a trial version of SharePlex, users need to select the All Platforms option. |
License key |
(If Y was selected) Enter the new license key that you received from Quest. |
The installer displays the location of the install log file and then quits.
Run the appropriate Database Setup utility for your database to upgrade the SharePlex database account. See SharePlex Utilities
If you are upgrading from a SharePlex version earlier than 9.0, the method of creating and storing partition schemes and row partitions for horizontal partitioning has changed. 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 theSharePlex Reference Guide.
To view row partitions:
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
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center