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.

  1. Log in to the Data Virtualization head pod.
    oc rsh c-db2u-dv-db2u-0 bash
  2. Switch to the Data Virtualization database instance owner db2inst1.
    su - db2inst1
  3. 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.