ASNA Knowledge Base
Technical references, how-tos, and trouble-shooting for ASNA products

How do I find ASNA DataGate for IBM i active end-user jobs?

To find all ASNA DataGate for IBM i active end-user jobs use the IBM i WRKACTJOB (or WRKSBSJOB) command and look for DG8_NET .NET jobs. The green rectangle in the screenshot below shows DataGate for IBM i active end-user jobs. End user jobs are the DG8_NET jobs.

Seeing DataGate end-user jobs with WRKACTJOB
Figure 1.

Note: All DataGate end-user jobs must be ended before ending the DataGate server. As shown above, end-user jobs are the DG8_NET jobs. Do not end DataGate server if any DG8_NET jobs are present. Those jobs need to be ended before you end DataGate server—otherwise you could have trouble restarting DataGate.

To see what version of DataGate a DG8_NET job is running

  • Use Option 5 to work with the job
  • Use Option 11 to see the call stack
  • Scroll through the list and you’ll see the active DG library listed

Here are a couple of other things to remember about DataGate end-user jobs:

  • DataGate end-user jobs (DG8_NET jobs) do not end when DataGate is ended-they continue to run. DataGate does not reach out and end end-user jobs on its own.
  • When you look at an active end-user job with WRKACTDJOB (or other says such as WRKSBSJOB), the user shown is the user identified in the database name. In the screenshot above the multiple WEBDEMO1 users are a pretty good clue that this is a Web app where all users are using the same database name.
  • If DataGate end-user jobs are running when DataGate restarts, your licensed user counts may be wrong. When DataGate ends, so does its license manager. When the license manager goes down it loses the count of seats. Then when it comes back up, there’s likely to be an over-count at recovery. For example, suppose you are running something that is using two DG400 jobs from your PC. Before the license manager goes down, that counts as one seat. When it comes back on a restart, the license manager can’t tell what job is which seat, so it counts your jobs as two seats. To resolve this, affected users need to end their jobs and restart them.
  • Ending DataGate versions earlier than 14.x with running jobs often causes problems restarting DataGate. DataGate won’t restart until those jobs are ended because of an “error binding socket” issue.
  • As you can see, while DataGate can be ended with active end-user jobs, the best practice is to not do that. Generally, you’ll want to make sure all users are logged and their jobs have ended before ending DataGate.
Published: Jan 5, 2024
datagate-ibm-i