SQL6031N error in the db2nodes.cfg file in Data Virtualization
Data
Virtualization requires the no_root_squash option to be set on all
NFS-based storage. If this option is not set, provisioning of Data
Virtualization fails and you see
the following error message SQL6031N Error in the db2nodes.cfg file at line number "2".
Reason code "14".
Symptoms
To confirm that you have this issue, run the following commands.
- Log in to the Data
Virtualization head pod.
oc rsh c-db2u-dv-db2u-0 bash - Switch to the Data
Virtualization database instance owner
db2inst1.su - db2inst1 - Look for the db2start
file.
ls -l ~/sqllib/adm/db2start
If the db2start file is owned by the user or group nobody
or 99, then no_root_squash is not enabled as shown in the
following example.
-r-sr-sr-x. 1 99 db2iadm1 43080 Nov 10 04:54 /mnt/blumeta0/home/db2inst1/sqllib/adm/db2start
Resolving the problem
To resolve the issue, enable no_root_squash and reprovision the Data
Virtualization instance. For more information, see the following resources.