Q
Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Monitoring members 'stuck' within a physical file on an EDI system

To monitor members stuck within a physical file on AS/400, you can periodically use the display file description (DSPFD) command to create an output file that can be analyzed, or occasionally run queries against the SYSPARTITIONSTAT catalog view in the QSYS2 schema.

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 last published in June 2009

Dig Deeper on DB2 UDB (universal databases)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close