Skip to content

Queryhistory stopped collecting data – Netezza

ISSUE:

Queryhistory stopped collecting data and all the directories under /nz/data/hist are empty.

CAUSE:

This can happen when the max storage limit is reached.

/nz/kit/log/alcapp->more alcapp.log
2016-01-23 20:32:08.759330 EDT (8231) Error: History Stored Data size: 1000 exceeds STORAGELIMIT (1000).
2016-01-23 20:32:08.765248 EDT (8231) Error: Disabling History Capture.

RESOLUTION:

To fix the issue you have to increase the maximum storage limit from 1000 MB (in this case) to a higher value. Maximum size allowed is 100GB.

HereĀ are the steps that you can follow to increase the storage limit.