Referencing
https://www.ibm.com/support/pages/database-file-opens-consuming-temporary-addresses
I am trying to make sense of the numbers below, which is for one job. JBNUS is "Full opens". The document above says "Field JBNUS reports the sum total of number of native database (non-SQL) file and SQL cursors which have been full opened. Subtracting the value within field JBLBO from JBNUS yields the number of native (non-SQL) database full opens." JBLBO is zero in all instances, so JBNUS is all native (non-SQL) database full opens. FWIW, the program at the bottom of the job's program stack (which appears to be doing the bulk of the work) is a Synon 2E generated program; I don't know 2E and I don't read Cobol very well, nor do I have the patience to understand 4000 lines of Cobol code.
I ran:
CREATE or REPLACE ALIAS qTemp.CurrentCol FOR QMPGDATA/QAPMJOBOS (*LAST) ;
select a.DATETIME, JBNUS from qTemp.CurrentCol a
where a.DATETIME > CURRENT TIMESTAMP - 1 HOUR
and jbName = 'ABE99 '
order by a.DATETIME ;
Timestamp Interval JBNUS
2026-03-14 14:36:00.000000 115520
2026-03-14 14:37:00.000000 116598
2026-03-14 14:38:00.000000 119966
2026-03-14 14:39:00.000000 55284
2026-03-14 14:40:00.000000 0
2026-03-14 14:41:00.000000 7786
2026-03-14 14:42:00.000000 17394
2026-03-14 14:43:00.000000 21524
2026-03-14 14:44:00.000000 26202
2026-03-14 14:45:00.000000 70256
2026-03-14 14:46:00.000000 99736
2026-03-14 14:47:00.000000 103395
2026-03-14 14:48:00.000000 79178
2026-03-14 14:49:00.000000 36525
2026-03-14 14:50:00.000000 88173
2026-03-14 14:51:00.000000 4565
2026-03-14 14:52:00.000000 18480
2026-03-14 14:53:00.000000 64468
2026-03-14 14:54:00.000000 73314
2026-03-14 14:55:00.000000 74592
2026-03-14 14:56:00.000000 117459
2026-03-14 14:57:00.000000 113093
2026-03-14 14:58:00.000000 101431
2026-03-14 14:59:00.000000 57241
2026-03-14 15:00:00.000000 41305
2026-03-14 15:01:00.000000 0
2026-03-14 15:02:00.000000 0
2026-03-14 15:03:00.000000 8960
2026-03-14 15:04:00.000000 63718
*** CONFIDENTIALITY NOTICE: The information contained in this communication may be confidential, and is intended only for the use of the recipients named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please return it to the sender immediately and delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. ***
midrange.com
