Question

What are 4 environment variables that are required. What are the different states on Netezza?

Answer 1

Environment variables: NZ_HOST, NZ_DATABASE, NZ_USER, and NZ_PASSWORD

• Online: Normal or usual state.
• Stopped: Netezza will shutdown after completing current queries, no new queries allowed.
• Offline: Waits for completion of current queries, new or queries in queue receive an error.
• Paused: Same as above, but no error displayed. Typically caused during Netezza bootup or startup.
• Down: Just plain down, could be due to Netezza server problem or user-initiated.