Work with Active SQL (WRKACTSQL)

Monthly iPad Drawing for IBM i (AS400, iSeries) users
Download your free WRKACTSQL command (for a limited time)

Get control of ODBC jobs on your IBM i (iSeries, AS/400, System i) servers with block, change, hold, end and alert features.

The "Work with Active Jobs (WRKACTJOB)" command from IBM shows all active jobs on the system. Systems administrators watch to see what is consuming the most resources and causing poor response time.

When it is remote SQL there are QZDASOINIT jobs consuming a lot of resources but systems administrators have no idea what these jobs are doing. These jobs are running SQL but they don't know what SQL requests are running or the code associated with it - only that the jobs are consuming a lot of resources. There is little visibility or control over these client/server, mobile and web based applications running SQL against the system.

Our "Work with Active SQL (WRKACTSQL)" command gives visibility and control over remote ODBC requests showing the actual SQL statements that are impacting the system in real time so systems administrators can react appropriately. They can hold, terminate, or change run priority for specific SQL requests that are actively and negatively impacting system performance. They can also set up alerts to automatically and immediately be notified when this user runs this SQL request again. If needed, specific users and specific SQL requests can be blocked and prevented from even executing again on the system.

Free 'Work with Active SQL (WRKACTSQL)' command for IBM i (AS400, iSeries)