Troubleshooting
Problem
MAX TABLE feature cannot be disabled for NZLOAD session
Symptom
MAX TABLE feature cannot be disabled for NZLOAD session
Diagnosing The Problem
In-house testing shows therepossible performance degradation in NZLOAD for large tables. We cannot disable this feature for NZLOAD at session level.
Resolving The Problem
1) For 7.2.1.3-P3 and onward releases:-
Enable/disable max table feature only for nzload session using nzload switch "enableRandomDistributionChunkSize ". This is effective only when max table feature is enabled at system level. To enable random chunk distribution/Max table feature refer below 2-A section.
Example with NZLOAD switch:-
nzload -t test -df /tmp/data.txt -enableRandomDistributionChunkSize 'false'
nzload -t test -df /tmp/data.txt -enableRandomDistributionChunkSize ‘true’
2) For 7.2.1.3-P1 and 7.2.1.3-P2:-
A) Enable the random chunk distribution feature, using one of the following approaches:
a) To enable the feature temporarily, perform the following steps:
1. Pause the system by issuing the following command:
nzsystem pause
2. Set the value of the system.enableRandomDistributionChunkSize registry
variable to yes or on by issuing the nzsystem set -arg command. An
example follows:
nzsystem set -arg system.enableRandomDistributionChunkSize=yes
3. Resume the system by issuing the following command:
nzsystem resume
b) To enable the feature so that it remains in effect after a NPS system restart, perform the following
steps:
1. Log in to the system as the root user.
2. Using a text editor such as vi, edit the /nz/data/config/system.cfg file.
3. Set the value of the system.enableRandomDistributionChunkSize registry variable to yes or
on. An example follows:
system.enableRandomDistributionChunkSize = yes
4. Save and close the system.cfg file.
The changes to the system configuration file take effect the next time that the NPS system
restarts.
B) Disable the random chunk distribution using the session variable at system wide by adding entry
in the postgresql.conf
1. Add following entry in the /nz/data/postgresql.conf
enable_random_dist_chunk=ON
To take this effect, we need to restart the system.
Was this topic helpful?
Document Information
Modified date:
17 October 2019
UID
swg21997656