Re: large number jobs in system-wrksyssts

I think you are not interpreting the meaning of each column correctly. The
values are different in each release of SERVICES_INFO. Since you are
running the query on 7.3, the service was available in the base for that
release so you get null returned for INITIAL_DB2_GROUP_LEVEL. When you
run the same query on 7.2, the value for INITIAL_DB2_GROUP_LEVEL is set to
9, since that is the 7.2 group where it was first available. And running
it on 7.1 returns a value of 38 for INITIAL_DB2_GROUP_LEVEL, since that is
the appropriate level on that release.

Here is text from the Knowledge center for this service, found here:
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/rzajq/rzajqtableservices_info.htm

LATEST_DB2_GROUP_LEVEL The DB2 for i PTF Group level which most recently
changed this service. Contains null if the service has not been enhanced
in a PTF in this release.
INITIAL_DB2_GROUP_LEVEL The DB2 for i PTF Group level where this service
was introduced. Contains null if this service was available in the base
for this release. The earliest release, in VxRxMx format, where a version
of this service is available.
EARLIEST_POSSIBLE_RELEASE The earliest release, in VxRxMx format, where
a version of this service is available.

Sue Romano
IBM i SQL Development

Hmm, something is lacking from this

SELECT *
FROM QSYS2.SERVICES_INFO
WHERE EXAMPLE LIKE '%utput%';
SELECT SERVICE_NAME, SQL_OBJECT_TYPE, initial_db2_group_level,
earliest_possible_release
FROM QSYS2.SERVICES_INFO
WHERE service_name = 'OUTPUT_QUEUE_ENTRIES';

SERVICE_NAME SQL_OBJECT_TYPE INITIAL_DB2_GROUP_LEVEL
EARLIEST_POSSIBLE_RELEASE
OUTPUT_QUEUE_ENTRIES VIEW - V7R1M0
OUTPUT_QUEUE_ENTRIES TABLE FUNCTION - V7R1M0

I wonder if that implies it should have came out with the base release?
<nope, you'll see later>
Try a newer cume and all the groups shown below
especially the DB2 group
see also WRKPTFGRP
http://www-912.ibm.com/s_dir/sline003.nsf/GroupPTFs?OpenView&Start=1&Count=30&Expand=3#3

http://www-912.ibm.com/s_dir/sline003.nsf/2d3aff1c6b4d6ce086256453000d971e/c69211d3133949f886257c1c00513742?OpenDocument

But you need to be at this level
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/DB2%20for%20i%20-%20Services

This should be updated into SERVICES_INFO

I wonder if it came out after 7.2 was already out therefore they get
confused which initial db2 group to use and just say to heck with it. Use

the website instead.

Rob Berendt