How and When Temporary Tables are Re-used and Removed?
How and when Temporary Tables are Re-used Concurrent Runs of the same Application Engine (AE) program will have different Parameters and each will use it's own respective set of Dedicated Temporary Tables - If a dedicated set is available. If no dedicated set of temp tables are available, then the Base Table is used, as long as the Program Properties are set to 'Continue', not 'Abort' in Application Designer for the specific AE program. Any AE that goes No Success keeps it's dedicated set of Tempoary Tables locked and unavailable for subsequent use until the original AE has either been Restarted and has run to Success, or if the row is deleted from Process Monitor. If the AE program was run outside of the Process Scheduler at command prompt, then the navigation of; PeopleTools, Application Engine, Manage Abends can be used to free up (delete) the set of dedicated temp tables. How to manually remove Temporary Tables Occasionally it is not poss...