Managing ICH70001I messages

Data Gate instances call several Db2 for z/OS stored procedures to check the system status and to obtain information about tables. This happens at a high frequency, that is, each of the stored procedures is run every 10 to 60 seconds. The result is a flood of ICH70001I messages in the Db2 for z/OS SYSLOG.

Symptoms

You see an abundance of messages in the Db2 for z/OS SYSLOG. See the following example, in which messages generated by two stored procedures are listed:

QSLXR43 23010 19:43:32.47 XGR01322 00000010  ICH70001I SYSADM   LAST ACCESS AT 19:43:32 ON TUESDAY, JANUARY 10, 2023
QSLXR43 23010 19:43:32.66 XGR01322 00000010  ICH70001I SYSADM   LAST ACCESS AT 19:43:32 ON TUESDAY, JANUARY 10, 2023
QSLXR43 23010 19:43:33.01 XGR01322 00000010  ICH70001I SYSADM   LAST ACCESS AT 19:43:32 ON TUESDAY, JANUARY 10, 2023
QSLXR43 23010 19:43:33.07 XGR01322 00000010  ICH70001I SYSADM   LAST ACCESS AT 19:43:33 ON TUESDAY, JANUARY 10, 2023
QSLXR43 23010 19:43:33.35 XGR01322 00000010  ICH70001I SYSADM   LAST ACCESS AT 19:43:33 ON TUESDAY, JANUARY 10, 2023
QSLXR43 23010 19:43:33.38 XGR01322 00000010  ICH70001I SYSADM   LAST ACCESS AT 19:43:33 ON TUESDAY, JANUARY 10, 2023
QSLXR43 23010 19:43:33.76 XGR01322 00000010  ICH70001I SYSADM   LAST ACCESS AT 19:43:33 ON TUESDAY, JANUARY 10, 2023
QSLXR43 23010 19:43:42.08 XGR01322 00000010  ICH70001I SYSADM   LAST ACCESS AT 19:43:33 ON TUESDAY, JANUARY 10, 2023
QSLXR43 23010 19:43:42.46 XGR01322 00000010  ICH70001I SYSADM   LAST ACCESS AT 19:43:42 ON TUESDAY, JANUARY 10, 2023
QSLXR43 23010 19:43:42.67 XGR01322 00000010  ICH70001I SYSADM   LAST ACCESS AT 19:43:42 ON TUESDAY, JANUARY 10, 2023
QSLXR43 23010 19:43:43.02 XGR01322 00000010  ICH70001I SYSADM   LAST ACCESS AT 19:43:42 ON TUESDAY, JANUARY 10, 2023
.
.
.

Causes

Messages of this type are generated and written to the SYSLOG each time one of the Db2 for z/OS stored procedures is called.

Resolving the problem

You can ignore these messages. However, if that is not acceptable for you, you can also suppress these messages:

Set the z/OS OPT parameter SUPPSAFINFOMSG=YES in the IEAOPTxx member of SYS1.PARMLIB. For more information, see IEAOPTxx (OPT parameters).