Over time, you may notice your Gentran install does not run as smooth as it once did. The likely culprit is a database that has become corrupt with bad data. The bad data is referred to as “orphan records.” Why? When you delete entries outside of the Interchange Summary section, you create orphan records in the database that will affect performance over time. These records have lost their connection with Gentran and cause read and writes to the database from Gentran to slow causing delays in production.
Fortunately, IBM/Sterling provides a tool called GICheck to help keep your database running smoothly and free from orphan records. This tool is intended to be used in conjunction with your normal database maintenance.
Here are few tips regarding GICheck:
- The GICheck.exe program should be stored in your \Bin directory
- It is version specific
- Take note of the Recommended System Limitations. Gentran:Director sits on an Access Database and IBM/Sterling suggest keeping your InDrawer and OutDrawer counts below 7500 each to avoid database problems.
- You should run it at the prescribed time intervals detailed in the document referenced below
A white paper with instructions for Gentran:Server can be found at: https://www-01.ibm.com/support/docview.wss?uid=swg27048333&aid=1
A white paper with instructions for Gentran:Director can be found at: https://www-01.ibm.com/support/docview.wss?uid=swg21535665&aid=2
If you need assistance maintaining your database or with Gentran, contact your DCS EDI Specialist or e-mail us at [email protected].
Let us know what other concerns to you have with Gentran:Director or Gentran:Server?
Contact Us
Got questions? Need EDI support or development? Facing a challenge or decision and want honest advice from experts? Looking for tailored training? You are in the right place. We take the time to understand what you need and give clear, helpful guidance to get you on the right track. Complete the form and we will be in touch soon to see how we can help. Let’s make EDI work for you!