Install IBM Netezza and create a database - database configuration/design tasks

If you are tasked with installing and configuring the database, here is a list of steps to be taken:

  1. An IBM® Netezza® appliance (the server) must be available.
  2. Install the IBM Netezza client software with the IBM Netezza ODBC driver on the application server.
  3. Create an IBM Netezza database with the nzsql utility. You must connect to the system database:

    $ nzsql -h hostname system username password

  4. Create your database with the following SQL command:

    CREATE DATABASE mydatabase ...

  5. Create a database user dedicated to the administration of the new database and grant privileges:
    CREATE USER myadmin WITH PASSWORD 'password' ... 
    GRANT ALL PRIVILEGES on mydatabase TO myadmin 
  6. Create the application tables. Do not forget to convert Informix® data types to Netezza data types. See Data type conversion table for more details.
  7. If you plan to use the SERIAL emulation, you must prepare the database. See SERIAL data types for more details.