KBA1558 Error SQL10004C While Linking a DB2 dSource
Applicable Delphix Versions
|
Major Release |
All Sub Releases |
| 5.2 | 5.2.2.0, 5.2.2.1, 5.2.3.0 |
|
5.1 |
5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0 |
Issue
The following error is returned while trying to link a DB2 dSource:
SQL10004C An I/O error occurred while accessing the database directory. SQLSTATE=58031
Troubleshooting
The error has been noted when the Delphix OS user is unable to mount the required NFS share, or the NFS share has been mounted but not working properly.
As the Delphix platform uses NFSv3 for mounting staging/target host filesystems, the prerequisite packages to support NFSv3 client communication are required for normal operation, and the required services to support NFS client communications (including file locking) must be running.
This includes:
- portmapper / rpcbind
- status daemon (rpc.statd)
- NFS lock manager (rpc.lockd/lockmgr)
Resolution
Verify that the staging/target host has the required NFSv3 services, based on the OS host environment.