Managing databases

Creating new databases

Use the create_inza_db.sh script to create and enable a new database, or to enable an existing database. To run this script, go to /nz/export/ae/utilities/bin and issue the following command:

$./create_inza_db.sh dbname

Creating new databases on a subordinate node within a replication system

If the database you are creating is on a subordinate node within a replication system, extra steps are necessary:

On the subordinate node, run the following command to create the database:
```
/nz/export/ae/utilities/bin/create_inza_db.sh dbname
```
This displays a list of SQL statements.
On the master node, manually run the SQL statements that are displayed in the previous step.
On the subordinate node, run the following command again:
```
/nz/export/ae/utilities/bin/create_inza_db.sh dbname
```

Disabling a database

Use the revoke_inza_db.sh script to disable Netezza Performance Server Analytics capability for the specified database. Running the script does not remove the specified database but instead revokes the permissions that are assigned to the groups in the database so that Netezza Performance Server Analytics functions cannot be used in that database.

To run this script, go to /nz/export/ae/utilities/bin and issue the following command:

$./revoke_inza_db.sh dbname

Updating user databases

To update and re-enable a user database that is enabled for Netezza Performance Server Analytics, use the create_inza_db.sh script. To update and re-enable all user databases that are enabled for Netezza Performance Server Analytics, use the update_inza_db.sh script.

A user database update might be necessary, for example, for the following reasons:

If you upgrade your Netezza Performance Server Analytics version to Version 3.0.
If you turn on the full schema support by setting the enable_schema_dbo_check postgres variable to 1 or 2.
If you turn off the full schema support by setting the enable_schema_dbo_check postgres variable to 0.

This upgrade changes the definition of system views.

To run the update_inza_dbs.sh script, do the following steps:

Go to the /nz/export/ae/utilities/bin directory.
Enter the following command:
```
./update_inza_dbs.sh
```