![]() ![]() We know that all these jobs, by default, are managed in the QUSRWRK subsystem through jobs that go under the name of QZDASOINIT or QRWTSRVR and we don’t have great granular control possibilities. Increasingly we find ourselves having to manage and control the performance and activities of the jobs that access DB2 for i via JDBC / ODBC: connections from external applications or from open source languages such as PHP-Java-Node.js-Python, interactive SQL managed by RunSQL Script by ACS / Rdi etc. IAdmin-FAQ-011: Better control of JDBC / ODBC jobs (QZDASOINIT JOBs) iAdmin-FAQ-020 Take control of your Subsystems and Memory Pools (WRKACTJOB join WRKSYSSTS)!.iAdmin-FAQ-019 WRKSYVAL with SQL (QSYS2.SYSTEM_VALUE_INFO).iAdmin-FAQ-018: WRKACTJOB with SQL (QSYS2.ACTIVE_JOB_INFO).iAdmin-FAQ-017: WRKOBJLCK with SQL (QSYS2.OBJECT_LOCK_INFO).iAdmin-FAQ-016: Which files have set the “Reuse deleted records” flag?. ![]()
0 Comments
Leave a Reply. |