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 
    Note:

    The default character set for CHAR/VARCHAR types will be latin9. Unicode/UTF-8 character string data must be stored in NCHAR/NVARCHAR columns.

  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;
    GRANT ALL ADMIN TO myadmin;
  6. Create the application tables.
    Convert Informix® data types to Netezza data types. See SQL types mapping: IBM Netezza for more details.
  7. If you plan to use the SERIAL emulation, you must prepare the database.
    See SERIAL and BIGSERIAL data types for more details.