Monitoring members 'stuck' within a physical file on an EDI system
I have an EDI system that moves members from physical files as part of the process. Sometimes, due to network failures or other issues, these members get 'stuck' in the file and the orders do not get processed.
Is there any way to monitor for members that remain in the file for an extended period of time? All member names are unique.
There are two things you can do to monitor for members that remain in the file for an extended period of time. You can periodically use the display file description (DSPFD) command to create an output file that could be analyzed.
Another option would be to periodically run queries against the SYSPARTITIONSTAT catalog view in the QSYS2 schema. The table partition column in that catalog view would contain your unique member name.
This was first published in June 2009