Verifying file transfer operations

The next step in troubleshooting the replication queue manager is to check that file transfers are working properly. This applies only in the case of an activity that involves a load file (for example, INSERT INTO... SELECT FROM external...).

Procedure

To see whether the file transfer component is a problem, check for status and possible errors on the log server side. Possible issues include the following ones:

The replication queue manager is down. To check the status, use the rqmstatus command on the replication queue manager.
The replication queue manager is configured to listen on a different port than the port that is configured for the NPS® node. In the replpts.cfg file, check which port the NPS node is configured to expect the replication queue manager to listen on. You must also verify the configured port on the replication queue manager. To check the configured port, use the rqmconfigure -list command from inside the NPS host container.