Skip to main content
Delphix

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.