Investigating (and avoiding) IBM i spurious jobs with AVR

Careless database connection handling in your Visual RPG for .NET code can lead to spurious jobs on your IBM i. Especially for Visual RPG Web ASP.NET Web apps, the presence of these jobs are a symptom of a performance-sucking issue.

This video explains a scenario for spurious jobs and explains what you can do about them.

These other ASNA.com articles provide information that may also be helpful for effectively mangaging IBM i jobs in your AVR ASP.NET Web apps:

• AVR ASP.NET connection pooling
• How to avoid IBM i orphan jobs with your AVR ASP.NET Web apps
• How to use the singleton DB pattern to pass the AVR DB object by reference to secondary classes
• How to understand DataGate IBM i end-user jobs