The information in this article applies to:
Product: MIM and PM4Data
Version: 8.x
Platform: iSeries
Issue
When trying to send a physical data file (PFDTA) from iSeries, you may get an error message if the system is out of space. The error is SQLCODE=-901. The message is written to the Process Monitor Auditor and the File Transfer Service log. Here is the error message in the Auditor:
34463131-0543-1d2a-3317-373e05391a23 5eea5267-1e99-44cb-898f-0bc456aef6a5 20 0 XMOFTS\_FILE\_READ\_ERROR Send FTF::readFileToQueue():103 An error occurred while trying to read a file. See 'message2' for more details. XMFile I/O Error occurred with driver:db. While accessing:TESTLIB/PROTEST. Using file mode:read. Using file IO:stream. Error Fetching first row. Error:ERROR occurred during OPENCURSOR; SQLCODE=-901. Driver specific error code:-901 Verify that the file exists and that it can be accessed Check permissions of the file and all directories
Resolution
When SQLCODE=-901 is encountered, look at the job log for the file transfer service. To do this, go to WRKACTJOB, find the subsystem in which the MIM components are running, and then select 5 on the file transfer service jobs. By default there are three jobs running, so you may need to view all of them to find the correct job log. When you are at the Work with Job page, select option 10 - Display Job Log. Hit F10 to get the detailed messages.
If you see the message below, work with your iSeries Administrator to provide more space on the system. Once that is done, you can resubmit your transfer successfully.
Machine storage limit overflow. \*\*\* DBOP open FAILED. Exception from call to SLIC! \*\*\*. Internal failure occurred in query processor. SQL system error.
