Migrating with nz_migrate

Deployment options: Netezza Performance Server for Cloud Pak for Data

You can use the nz_migrate command to migrate database table or tables from one Netezza Performance Server for Cloud Pak for Data server to another, or to make a copy of a database or table on the same server.

Use the nz_migrate command to migrate data from IBM® PureData® System for Analytics to Netezza Performance Server for Cloud Pak for Data.

Before you begin

You cannot migrate or connect to Netezza Performance Server for Cloud Pak for Data from Mako 7.2.1.9-P2 when SSL is enabled on the target Netezza Performance Server for Cloud Pak for Data system. Make sure you are on Mako 7.2.1.9-P1 or lower OR Mako 7.2.1.10 or later.

Make sure you have Software Support Tools 11.1.0.0 or higher.

About this task

nz_migrate is separate tool in the general-purpose scripts that are supplied in the Software Support Tools package. To learn more about the nz_migrate command, you can run nz_migrate -h.
Note: For more information and help, contact IBM Support.

Procedure

  1. On IBM PureData System for Analytics, as the nz user, run the command: 
    cd /nz/support/bin
  2. Run the nz_migrate command.
    You can invoke this script from the source host, or from a Linux client. Invoking nz_migrate from the Linux client is not recommended as that option does not provide the best performance since the data has to flow from the source to or through the client and then back out to the target.
    Example:
    ./nz_migrate -sdb SRCDB -tdb TargetDB -thost <NPS on Cloud external endpoint> -CreateTargetDatabase yes -tuser <user>  -tpassword <password>
    Note: For more details, contact IBM Support.
    -sdb
    Source database.
    The server or database containing the data which you want to copy.
    -tdb
    Target database.
    The server or database which is to receive the copied data. The database and table or tables must already exist on the target database or server.
    Optionally, the nz_migrate command can automatically create the entire target database, or just the target table(s) if you assign YES to the -CreateTargetDatabase and -CreateTargetTable parameters.
    -CreateTargetDatabase
    If set to YES, the script automatically creates the target database.
    -CreateTargetTable
    If set to YES, the script automatically creates the target table(s).
    -tuser <user>
    Target username.
    -tpassword <password>
    Target username password.
    -suser
    Source username.
    -spassword
    Source username password.
    Note: If source user and password are not set in the environment, it's recommended that you use the -suser and -spassword parameters.