Optional: Installing the sample database on a remote server

You can setup the sample data on a remote server by cataloging the remote database on your local computer and then running the setup script locally. You must manually create the database remotely first before you can install the data in it.

Procedure

  1. If the sample database is not yet installed on the remote server, create the target database by using the CREATE DATABASE command. The database requires a UTF-8 codeset and a default table space with a pagesize of 16 KB or larger. For example, on the remote server, create the database by running the following command:
    CREATE DATABASE GSDB USING CODESET UTF-8 TERRITORY US PAGESIZE 16 k 
  2. On your local computer, catalog the remote database:
    db2 catalog tcpip node nodename remote ipaddr server port_number
    db2 catalog database GSDB as GSDB at node nodename
  3. On your local computer, run the script:
    setupGSDB -database GSDB -userid administration_user_ID
    You are prompted for a password to connect to the database.

Feedback