Creating a history database

You can create any number of history databases, but the system can write to only one at a time.

To create a history database, issue the nzhistcreatedb command as described in The nzhistcreatedb command. This command can take several minutes to complete, depending on how busy the system is.

For example, the following command creates a history database with the name histdb, version 3:

[nz@nzhost ~]$ nzhistcreatedb -d histdb -t query -v 3 -u jones
  -o smith -p password123
This operation may take a few minutes. Please wait...
Creating tables .................done
Creating views .......done
Granting privileges ....done
History database histdb created successfully !