Create an audit database. Ensure that you have already dropped the history database since the two cannot co-exist on the same system. There is no reason that you cannot have the audit database on another system, but this makes things harder, not least that you require a second netezza system.
Create the user who owns the audit database.
SYSTEM(ADMIN)=> create user audit with password ‘audit’;
CREATE USER
SYSTEM(ADMIN)=> grant create database to audit;
GRANT
SYSTEM(ADMIN)=> grant list on user to audit;
GRANT
Now you cannot create the same database name as an existing user. Therefore you will be unable to create a database called audit if the owner or user audit exists.
Example: nzhistcreatedb -d qhist -t q -o histusr2 -p histpw2 -u histusr1 -v 1
[nz@BITaniumDW adm]$ nzhistcreatedb -d audit -t a -u audit -p audit -o audit -v 1
This operation may take a few minutes. Please wait…
[nzhistcreatedb] ERROR: History database audit not created:
ERROR: createdb: object “AUDIT” already exists.
nzhistcreatedb -d auddb -t a -u audit -p audit -o audit -v 1
The system obviously has to be online also, else you’ll get another error.
[nz@netezza ~]$ nzhistcreatedb -d audit -t a -u audit -p audit -o audit -v 1
This operation may take a few minutes. Please wait…
[nzhistcreatedb] ERROR: System must be online to create the database.
System State: discovering
See also: nzhistcreatedb -h
So we’ll create a database type audit on this system.
Firstly however, we have to enable ROW_SECURITY. This you can find here.
This is the type of error you will get if you do not enable this.
[nz@BITaniumDW adm]$ nzhistcreatedb -d auddb -t a -u audit -p audit -o audit -v 1
This operation may take a few minutes. Please wait…
Creating tables ……………..done
Creating views …….done
[nzhistcreatedb] ERROR: History database auddb not created:
4,16c4,16
< create table
< create table
< create table
< create table
< create table
< create table
< create table
< create table
< create table
< create table
< create table
< create table
< create table
—
> nzsql:/tmp/temp.10921.0:26: ERROR: ROW SECURITY is not currently supported
> nzsql:/tmp/temp.10921.0:37: ERROR: ROW SECURITY is not currently supported
> nzsql:/tmp/temp.10921.0:69: ERROR: ROW SECURITY is not currently supported
> nzsql:/tmp/temp.10921.0:77: ERROR: ROW SECURITY is not currently supported
> nzsql:/tmp/temp.10921.0:91: ERROR: ROW SECURITY is not currently supported
> nzsql:/tmp/temp.10921.0:102: ERROR: ROW SECURITY is not currently supported
> nzsql:/tmp/temp.10921.0:113: ERROR: ROW SECURITY is not currently supported
> nzsql:/tmp/temp.10921.0:129: ERROR: ROW SECURITY is not currently supported
> nzsql:/tmp/temp.10921.0:147: ERROR: ROW SECURITY is not currently supported
> nzsql:/tmp/temp.10921.0:170: ERROR: ROW SECURITY is not currently supported
> nzsql:/tmp/temp.10921.0:184: ERROR: ROW SECURITY is not currently supported
> nzsql:/tmp/temp.10921.0:192: ERROR: ROW SECURITY is not currently supported
> nzsql:/tmp/temp.10921.0:201: ERROR: ROW SECURITY is not currently supported
18,24c18,24
< create view
< create view
< create view
< create view
< create view
< create view
< create view
—
> nzsql:/tmp/temp.10921.0:261: ERROR: Relation ‘$hist_query_prolog_1′ does not exist
> nzsql:/tmp/temp.10921.0:272: ERROR: Relation ‘$v_hist_queries’ does not exist
> nzsql:/tmp/temp.10921.0:284: ERROR: Relation ‘$v_hist_queries’ does not exist
> nzsql:/tmp/temp.10921.0:315: ERROR: Relation ‘$hist_query_prolog_1′ does not exist
> nzsql:/tmp/temp.10921.0:342: ERROR: Relation ‘$hist_table_access_1′ does not exist
> nzsql:/tmp/temp.10921.0:368: ERROR: Relation ‘$hist_column_access_1′ does not exist
> nzsql:/tmp/temp.10921.0:562: ERROR: Relation ‘$hist_query_prolog_1′ does not exist
See also: nzhistcreatedb -h
Now, having restarted, let’s create the audit database.
[nz@netezza ~]$ nzhistcreatedb -d auddb -t a -u audit -p audit -o audit -v 1
This operation may take a few minutes. Please wait…
Creating tables ……………..done
Creating views …….done
Creating Audit Only tables .done
Creating Audit Only views ………….done
History database auddb created successfully !
Done. The audit database has been created. How to use it to follow 
***UPDATE***
I could not get this working properly, but I did get it functioning and loading on the simulator. Here’s the update.
Auditing, when is it enabled ?
Auditing on a user is enabled when they connect, if the following items are set correctly.
The user and the database must BOTH have collect history on for a user to have collection performed. This is the default for user and database creation.
The history collection is decided at the connect time to the system. Changes will not reflect until the user reconnects to the system.
History collection for user.
The following dictate if history information is collected for a session:
1) If the session user has history collection on.
2) If any group the session user belongs to has history collection on.
3) If the database has history collection on.
The users settings are decided by the following:
1) If the user’s COLLECT HISTORY is explicitly set.
2) If not, if any of the user’s groups COLLECT HISTORY is explicitly set.
3) If the user has no groups, the COLLECT HISTORY defaults to ON.
The session settings overwrite any database settings, so if the session setting is defined then the database setting is ignored.
=====================
create user dso with password ‘dsodso’ security label ‘::’ auth local;
grant manage security, create database to dso;
/nz/kit/bin/adm/nzhistcreatedb -d auddb -n localhost -t audit -o dso -u dso -p dsodso -v 1
[nz@netezza adm]$ /nz/kit/bin/adm/nzhistcreatedb -d auddb -n localhost -t audit -o dso -u dso -p dsodso -v 1
This operation may take a few minutes. Please wait…
Creating tables ……………..done
Creating views …….done
Creating Audit Only tables .done
Creating Audit Only views ………….done
History database auddb created successfully !
Now, as dso, I’ll create the configuration.
CREATE HISTORY CONFIGURATION DSOAUDIT
HISTTYPE AUDIT
NPS LOCALHOST
DATABASE auddb
USER dso
PASSWORD ‘dsodso’
COLLECT query, plan, table, column, service, state
INCLUDING ALL
LOADINTERVAL 1
LOADMINTHRESHOLD 0
LOADMAXTHRESHOLD 0
STORAGELIMIT 1024
LOADRETRY 2
ENABLEHIST true
ENABLESYSTEM true
VERSION 1
KEY NONE;
SYSTEM(DSO)=> show history configuration all;
CONFIG_NAME | CONFIG_DBNAME | CONFIG_DBTYPE | CONFIG_TARGETTYPE | CONFIG_LEVEL | CONFIG_HOSTNAME | CONFIG_USER | CONFIG_PASSWORD | CONFIG_LOADINTERVAL | CONFIG_LOADMINTHRESHOLD | CONFIG_LOADMAXTHRESHOLD | CONFIG_DISKFULLTHRESHOLD | CONFIG_STORAGELIMIT | CONFIG_LOADRETRY | CONFIG_ENABLEHIST | CONFIG_ENABLESYSTEM | CONFIG_NEXT | CONFIG_CURRENT | CONFIG_VERSION | CONFIG_COLLECTFILTER | CONFIG_KEYSTORE_ID | CONFIG_KEY_ID | KEYSTORE_NAME | KEY_ALIAS | CONFIG_NAME_DELIMITED | CONFIG_DBNAME_DELIMITED | CONFIG_USER_DELIMITED
————-+—————+—————+——————-+————–+—————–+————-+—————————+———————+————————-+————————-+————————–+———————+——————+——————-+———————+————-+—————-+—————-+———————-+——————–+—————+—————+———–+———————–+————————-+———————–
DSOAUDIT | AUDDB | 2 | 1 | 126 | localhost | DSO | PHwdoJPNHs1p$GlsyDeEnjxo= | 1 | 0 | 0 | 0 | 1024 | 2 | t | t | f | f | 1 | 1 | 0 | 0 | | | f | f | f
(1 row)
SYSTEM(DSO)=> set history configuration dsoaudit;
SET HISTORY CONFIGURATION
[nz@netezza adm]$ nzstop
[nz@netezza adm]$ nzstart
WARNING: NPS fabric interface ‘eth1′ has a sub-optimal MTU: 1500
WARNING: NPS fabric interface ‘eth1′ tx queue length is low: 1000
(startupsvr) Info: NZ-00022: — program ‘startupsvr’ (8114) starting on host ‘netezza’ … —
The two files to watch are alcloader.log and alcapp.log. These will give information regarding the processing of audit and history files.
alcloader.
2011-08-03 13:51:46.995306 EDT Info: NZ-00022: — program ‘alcloader’ (8271) starting on host ‘netezza’ … —
alcapp.
2011-08-03 13:51:47.001770 EDT Info: NZ-00022: — program ‘alcapp’ (8272) starting on host ‘netezza’ … —
2011-08-03 13:51:47.002182 EDT Info: Extending RLIM_NOFILE limit to 9600
2011-08-03 13:51:47.002278 EDT Info: Initialized Interface Settings: BurstSendInterval:10; BurstSendRetries:1; LongSendInterval:1000; LongSendRetries:-1; LongSendOnQhist:0; SocketReadyTimeout:2000.
2011-08-03 13:51:47.023709 EDT Info: initialized
alcloader.
2011-08-03 13:52:58.596709 EDT Info: Schema version matches the version in the history database AUDDB
2011-08-03 13:52:58.596709 EDT Info: Schema version matches the version in the history database AUDDB
2011-08-03 13:53:36.787829 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_135147.023329
From the hist directory, you can see what is being loaded into the database.
[nz@netezza hist]$ cd /nz/data/hist
[nz@netezza hist]$ ls -lrt *
error:
total 0
staging:
total 4
drwxr-xr-x 2 nz nz 4096 Aug 3 13:53 alc_20110803_135347.037723
loading:
total 4
drwxr-xr-x 2 nz nz 4096 Aug 3 13:54 alc_20110803_135247.023033
And we can see another being placed in the loading directory.
[nz@netezza hist]$ ls -lrt *
error:
total 0
staging:
total 4
drwxr-xr-x 2 nz nz 4096 Aug 3 13:54 alc_20110803_135447.037506
loading:
total 8
drwxr-xr-x 2 nz nz 4096 Aug 3 13:53 alc_20110803_135347.037723
drwxr-xr-x 2 nz nz 4096 Aug 3 13:54 alc_20110803_135247.023033
And a third.
error:
total 0
staging:
total 4
drwxr-xr-x 2 nz nz 4096 Aug 3 13:55 alc_20110803_135547.036879
loading:
total 12
drwxr-xr-x 2 nz nz 4096 Aug 3 13:53 alc_20110803_135347.037723
drwxr-xr-x 2 nz nz 4096 Aug 3 13:54 alc_20110803_135247.023033
drwxr-xr-x 2 nz nz 4096 Aug 3 13:54 alc_20110803_135447.037506
Wed Aug 3 13:55:53 EDT 2011
These sit and wait in loading until the alcloader pickes them up. This is defined with the LOADINTERVAL 1 parameter, meaning it should check every 1 minute. However this does not appear to happen, and indeed I waited a while for the alcloader to process these files. LOADMINTHRESHOLD and LOADMAXTHRESHOLD were set to zero, meaning these should not be considered for the processing of audit files.
error:
total 0
staging:
total 4
drwxr-xr-x 2 nz nz 4096 Aug 3 14:00 alc_20110803_140047.039942
loading:
total 32
drwxr-xr-x 2 nz nz 4096 Aug 3 13:53 alc_20110803_135347.037723
drwxr-xr-x 2 nz nz 4096 Aug 3 13:54 alc_20110803_135247.023033
drwxr-xr-x 2 nz nz 4096 Aug 3 13:54 alc_20110803_135447.037506
drwxr-xr-x 2 nz nz 4096 Aug 3 13:55 alc_20110803_135547.036879
drwxr-xr-x 2 nz nz 4096 Aug 3 13:56 alc_20110803_135647.037612
drwxr-xr-x 2 nz nz 4096 Aug 3 13:57 alc_20110803_135747.037790
drwxr-xr-x 2 nz nz 4096 Aug 3 13:58 alc_20110803_135847.038661
drwxr-xr-x 2 nz nz 4096 Aug 3 13:59 alc_20110803_135947.038925
drwxr-xr-x 2 nz nz 4096 Aug 3 14:00 alc_20110803_140047.039942
Wed Aug 3 14:01:38 EDT 2011
Apart from the load problem experienced below, the following registered in the log files.
alcapp.
2011-08-03 14:27:43.480338 EDT Info: NZ-00022: — program ‘alcapp’ (17569) starting on host ‘netezza’ … —
2011-08-03 14:27:43.480748 EDT Info: Extending RLIM_NOFILE limit to 9600
2011-08-03 14:27:43.480850 EDT Info: Initialized Interface Settings: BurstSendInterval:10; BurstSendRetries:1; LongSendInterval:1000; LongSendRetries:-1; LongSendOnQhist:0; SocketReadyTimeout:2000.
2011-08-03 14:27:43.480943 EDT Info: Staging directory not empty. Attempting cleanup.
2011-08-03 14:27:43.481681 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_135247.023033
2011-08-03 14:27:43.481696 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_135347.037723
2011-08-03 14:27:43.481706 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_135447.037506
2011-08-03 14:27:43.481715 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_135547.036879
2011-08-03 14:27:43.481723 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_135647.037612
2011-08-03 14:27:43.481732 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_135747.037790
2011-08-03 14:27:43.481740 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_135847.038661
2011-08-03 14:27:43.481748 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_135947.038925
2011-08-03 14:27:43.481756 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_140047.039942
2011-08-03 14:27:43.481764 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_140147.039334
2011-08-03 14:27:43.481772 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_140247.039733
2011-08-03 14:27:43.481784 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_140347.040479
2011-08-03 14:27:43.481791 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_140447.041168
2011-08-03 14:27:43.481799 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_140547.042019
2011-08-03 14:27:43.481806 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_140647.042300
2011-08-03 14:27:43.481814 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_140747.043402
2011-08-03 14:27:43.481821 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_140847.043263
2011-08-03 14:27:43.481839 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_140947.045225
2011-08-03 14:27:43.481847 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_141047.046419
2011-08-03 14:27:43.481855 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_141147.046565
2011-08-03 14:27:43.481862 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_141247.046388
2011-08-03 14:27:43.481870 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_141417.194643
2011-08-03 14:27:43.481877 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_141517.193724
2011-08-03 14:27:43.481884 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_141617.193866
2011-08-03 14:27:43.481892 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_141717.194636
2011-08-03 14:27:43.481899 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_141817.194858
2011-08-03 14:27:43.481907 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_141917.194182
2011-08-03 14:27:43.481914 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_142017.193884
2011-08-03 14:27:43.481922 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_142117.194586
2011-08-03 14:27:43.481929 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_142217.195416
2011-08-03 14:27:43.481936 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_142317.196207
2011-08-03 14:27:43.481944 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_142417.196032
2011-08-03 14:27:43.481951 EDT Info: [leftover] /nz/data.1.0/hist/loading/alc_20110803_142517.196757
2011-08-03 14:27:43.486477 EDT Info: initialized
alcloader.
2011-08-03 14:28:57.123544 EDT Info: Schema version matches the version in the history database AUDDB
2011-08-03 14:29:18.624975 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_135247.023033
2011-08-03 14:29:45.839413 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_135347.037723
2011-08-03 14:30:16.850329 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_135447.037506
2011-08-03 14:30:25.448550 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_135547.036879
2011-08-03 14:30:34.171851 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_135647.037612
2011-08-03 14:30:45.562637 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_135747.037790
2011-08-03 14:30:54.255109 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_135847.038661
2011-08-03 14:31:04.764846 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_135947.038925
2011-08-03 14:31:14.444081 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_140047.039942
2011-08-03 14:31:24.263269 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_140147.039334
2011-08-03 14:31:33.000427 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_140247.039733
2011-08-03 14:31:42.528837 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_140347.040479
2011-08-03 14:31:51.546956 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_140447.041168
2011-08-03 14:32:02.127547 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_140547.042019
2011-08-03 14:32:12.997383 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_140647.042300
2011-08-03 14:32:23.089132 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_140747.043402
2011-08-03 14:32:32.170332 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_140847.043263
2011-08-03 14:32:43.236391 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_140947.045225
2011-08-03 14:32:53.543702 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_141047.046419
2011-08-03 14:33:04.111389 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_141147.046565
2011-08-03 14:33:12.830767 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_141247.046388
2011-08-03 14:33:23.328215 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_141417.194643
2011-08-03 14:33:32.917023 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_141517.193724
2011-08-03 14:33:41.581176 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_141617.193866
2011-08-03 14:33:49.878084 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_141717.194636
2011-08-03 14:33:59.029493 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_141817.194858
2011-08-03 14:34:08.217633 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_141917.194182
2011-08-03 14:34:16.662925 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_142017.193884
2011-08-03 14:34:25.682294 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_142117.194586
2011-08-03 14:34:35.751075 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_142217.195416
2011-08-03 14:34:45.619872 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_142317.196207
2011-08-03 14:34:57.483824 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_142417.196032
2011-08-03 14:35:07.184839 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_142517.196757
2011-08-03 14:35:17.819042 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_142743.481295
2011-08-03 14:35:30.417901 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_142843.482658
2011-08-03 14:35:44.797990 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_142943.482984
2011-08-03 14:35:56.847138 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_143043.482248
2011-08-03 14:36:09.634199 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_143143.501546
2011-08-03 14:36:22.703775 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_143243.501036
2011-08-03 14:36:34.817588 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_143343.501159
2011-08-03 14:36:46.704635 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_143443.502447
2011-08-03 14:36:58.758141 EDT Info: Loaded Recorded Data from: /nz/data.1.0/hist/loading/alc_20110803_143543.524186
During this load time you can see the items moving from loading to staging before being loaded.
error:
total 0
staging:
total 4
drwxr-xr-x 2 nz nz 4096 Aug 3 14:35 alc_20110803_143543.524186
loading:
total 4
drwxr-xr-x 2 nz nz 4096 Aug 3 14:36 alc_20110803_143443.502447
Wed Aug 3 14:36:38 EDT 2011
So, the loader process is now working for auditing.
======================================================================================
I did hit this error in the alcloader log file.
2011-08-03 14:01:41.425867 EDT Info: Cancelling load due to system state transition
And the nps was paused.
[nz@netezza alcapp]$ nzstate
System state is ‘Pausing Now’.
The reason for this is probably that the STORAGELIMIT has been reached.
In this case, you will require to unpause the system to resume processing.
[nz@netezza bin]$ nzsystem resume
You can see this in the sysmgr.log
2011-08-03 14:07:34.237222 EDT Info: processing system operation: Resume (4), arg = 0
