That strdbmon was a pretty good idea. You really want to start/stop that
pretty quick. On a development machine, with very few jobs running, I
only had it running for 13 seconds.
SELECT QQJOB concat QQUSER concat QQJNUM, count(*)
FROM rob/dbmon GROUP BY QQJOB concat QQUSER concat QQJNUM
....+....1....+....2....+....3....+....4..
CONCAT COUNT ( * )
ROBS1 ROB 249519 7
Q1ACPDST QBRMS 949427 90
RCV_RQS MIMIXOWN 245382 20
MXIFCMGR MIMIXOWN 245381 59
ROBS3 ROB 249840 2
CRTPFRDTA QSYS 245406 8
CST600B TRACIL 249829 112,377
******** End of data ********
I could see the full sql statement.
Rob Berendt
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
