Installing and setting up the sample database

Learn how to download, install, and set up the sample database on your Netezza Performance Server.

1. Download sample-databases.tar from Fix Central.
   1. Go to Find Product, and in the Product Selector field type IBM Cloud Pak for Data System.
   2. Select your Netezza Performance Server version and platform.
   3. Download sample-databases.tar.
2. Unpack sample-databases.tar:

   tar -xvf sample-databases.tar

   The sample-databases.tar file contains a database schema, data, and queries, which you can run, and a README file, which includes these installation steps.

   For more information about the package itself, see The sample-databases.tar package.

3. As root, install pip:

   yum install python3-pip

   The command installs Python3, pip and all of the dependencies that are necessary to build Python modules.

4. As root, install pytest:

   pip3 install pytest

5. When pip and pytest are installed, switch to the nz user:

   su nz

6. Add the following two lines to the /export/home/nz/.bashrc file:

   1. NZ_USER=admin export

   2. NZ_PASSWORD=password

7. Change ownership of the sample-databases directory:

   chown -R nz:nz sample-databases

8. Go to the sample-databases directory.
9. Run the python3 test_sample_test_cases.py script.
   To get more information about the script, you can run the following command:

   python3 test_sample_test_cases.py --help