IBM Support

Updates to IMS Solution Packs Data Sensor User's Guide

Product Documentation


Abstract

Updates that apply to IMS Solution Packs Data Sensor User's Guide (SC19-3283-03). These updates apply to IMS Database Solution Pack users, IMS Fast Path Solution Pack users, IMS Recovery Solution Pack users, and IMS Database Utility Solution users unless otherwise indicated in each Change description.

Content

Most recent updates appear at the top of the list.


Update 7

Date of change: October 2018

Change description: Documentation changes by APAR PH01390. These documentation changes affect IMS Database Solution Pack and IMS Database Utility Solution users only.

Topics: Changes apply to multiple topics.

Topic: Using FF Stand-alone Database Sensor > FF Stand-alone DB Sensor JCL and control statements > EXEC and DD statements for FF Stand-alone DB Sensor

 

DD statement summary

 

Table BBESENSR DD statements has been updated as follows:

 

Table. BBESENSR DD statements

(Table 2 in PDF)

DD name Use Required or Optional Format
... ... ... ...
IMS Input Optional RECFM=FB,LRECL=80
... ... ... ...

 

 

DD statements for input


STEPLIB DD and IMS DD have been changed as follows:


STEPLIB DD

This required DD statement specifies the following load module libraries. All of these libraries must be APF-authorized.

  • IMS Database Solution Pack product load module library or IMS Database Utility Solution product load module library (SHPSLMD0 data set, which includes DB Sensor)
  • DB Sensor site default library
  • IMS RESLIB, IMS user exit library (randomizer), and DFSMDA members
  • SCI exit library for parallel RECON access (if used)
  • Tools Base product library (SHKTLOAD, SGLXLOAD, and SFOILOAD data sets)

Notes:

  • The SFOILOAD data set is required when you specify the TOSIXCFGRP keyword on the BBESIN control statement.
  • The SGLXLOAD data set is required when you specify the IMSCATHLQ keyword on the BBESIN control statement.


IMS DD

This DD statement specifies the DBDLIB data set. APF-authorization is not required for the DBDLIB data set. You can omit this DD statement when you specify the IMSCATHLQ keyword on the BBESIN control statement.

==========

Topic: Using FF Stand-alone Database Sensor > FF Stand-alone DB Sensor JCL and control statements > GLOBAL command keywords for FF Stand-alone DB Sensor

 

IMSCATHLQ keyword has been added as follows:

image-20181012100008-1


IMSCATHLQ=

This keyword specifies whether to obtain the information about the database structure (DBD) from the IMS directory instead of from the DBD library. If you specify the IMS bootstrap data set HLQ (IMS system data set HLQ) for this keyword, FF Stand-alone DB Sensor obtains the DBD from the IMS directory.

This keyword is an optional keyword. If you omit this keyword, IMSCATHLQ=*NO is used as the default value.

IMS_bootstrap_data_set_HLQ

    Specify the high-level qualifier (HLQ) of the IMS bootstrap data set.

*NO

    FF Stand-alone DB Sensor acquires the DB structure information from DBD library which is specified in the IMS DD statement. In this case, IMS DD is required.

==========

Topic: Using FF Stand-alone Database Sensor > Output from FF Stand-alone DB Sensor > Runtime Summary report from FF Stand-alone DB Sensor

 

Report example has been updated as follows:

 

Figure. Runtime Summary report (FF Stand-alone DB Sensor)

(Figure 8 in PDF)

image-20181012100316-2

==========

Topic: Using FF Stand-alone Database Sensor > Setting site default values for FF Stand-alone DB Sensor > Keywords for the FF Site Default Generation utility

 

Table Keywords for the FF Site Default Generation utility has been updated as follows:

 

Table. Keywords for the FF Site Default Generation utility

(Table 4 in PDF)

Keyword DB Sensor Default value
ADXCFGRP ...
... ...
HPIO ...
IMSCATHLQ *NO
...

...

 

==========

Topic: Using FF Stand-alone Database Sensor > Setting site default values for FF Stand-alone DB Sensor > Output from the FF Site Default Generation utility

 

Report example has been updated as follows:

 

Figure. Site Default report (FF Site Default Generation utility)

(Figure 16 in PDF)

image-20181012100544-3

==========

 

Topic: Troubleshooting > Messages and codes > FF DB Sensor messages

 

The following new messages have been added:

BBE3218E IMS DIRECTORY ACCESS FAILED: FUNCTION=func RC=rc RSN=rsn.


Explanation: DB Sensor failed to access the IMS directory.
System action: DB Sensor processing ends with return code 8.
User response: Contact IBM Software Support.


----

BBE3219E dbdname IS NOT FOUND IN THE IMS DIRECTORY.


Explanation: The DBD resource indicated by dbdname is not found in the IMS directory.
System action: DB Sensor processing ends with return code 8.
User response: Ensure that the correct DBD resource name is specified in the BBESIN data set. Then rerun the job.


Update 6

Date of change: September 2018

Change description: Documentation change by APAR PH02047. This documentation change affects IMS Database Solution Pack and IMS Database Utility Solution users only.

Topic: Using FF Stand-alone Database Sensor > FF Stand-alone DB Sensor JCL and control statements > GLOBAL command keywords for FF Stand-alone DB Sensor

 

A restriction item has been added to the explanation of the SENSOR_HOME keyword as follows:

 

SENSOR_HOME=

This keyword specifies whether to collect the data elements that are related to root segment distribution. If you omit this keyword, SENSOR_HOME=YES is used as the default value.

YES

Collects the following data elements and stores them in the Sensor Data repository of IMS Tools KB:

  • DB_NUM_ROOT_NOHOME
  • DB_PCT_NUM_ROOT_NOHOME
  • DB_AVG_LEN_SYNONYM_CHAIN

 

Restrictions:

  • If the key compression option of the Segment Edit/Compression exit routine is specified for the root segment, these data elements are not collected even when SENSOR_HOME=YES is specified.
  • If you specify RMNAME=(rand,rap,0,bytes) or if you omit the third operand of the RMNAME parameter in the DBD macro, the number of root addressable area (RAA) blocks is defined as zero in the HDAM or PHDAM DBD. In this case, these data elements are not collected even when SENSOR_HOME=YES is specified.

 


Update 5

Date of change: July 2018

Change description: Documentation changes by APAR PH00451. New messages have been added. These documentation changes affect IMS Database Solution Pack and IMS Database Utility Solution users only.

Topic: Troubleshooting > Messages and codes > FF DB Sensor messages

BBE1333I DB SENSOR IS RETRYING SENSOR DATA COLLECTION FOR INDEX DATABASE dbdname DD ddname.


Explanation: DB Sensor is retrying to collect sensor data because some of the VSAM statistics information retrieved from the z/OS catalog has inconsistencies. The possible cause could be that the database is being updated by an IMS application and, therefore, VSAM statistics in the z/OS catalog is also being updated.

System action: DB Sensor continues processing.

User response: None. This message is informational.

---


BBE1453W DB SENSOR COULD NOT COLLECT DATA FOR data_element FOR DATABASE dbdname [, PARTITION partname].


Explanation: DB Sensor failed to collect information for the indicated data element for the indicated database or the HALDB partition.

System action: DB Sensor continues processing without storing the data element in the IMS Tools KB Sensor Data repository. When the process is complete, DB Sensor ends with return code 4.

User response: See the description for message BBE1332I. If message BBE1332I is not issued, contact IBM Software Support.



Update 4
Date of change: February 2018
Change description: Documentation change by APAR PI93606.

Topic: Troubleshooting > Messages and codes > FF DB Sensor messages

The following new message has been added:

BBE1429E PARTITION partname IS DISABLED OR NOT FOUND IN THE RECON DATA SETS.

Explanation: The indicated HALDB partition is either disabled or not found in the RECON data sets.
System Action: DB Sensor processing ends with return code 8.
User response: Specify the correct partition name for the PART keyword in the BBESIN data set and rerun the job.

 

 

 



Update 3
Date of change: April 2017
Change description: Documentation change by APAR PI79036. This documentation change affects IMS Database Solution Pack and IMS Database Utility Solution users only.

Topic: Troubleshooting > Messages and codes > FF DB Sensor messages

The following new message has been added:

BBE1332I SOME OF SENSOR DATA ELEMENTS ARE NOT STORED BECAUSE OF INVALID VSAM STATISTIC.

Explanation: The following sensor data elements are not stored because VSAM statistic values in the catalog are invalid.

  • DB_UNUSED_BYTES
  • DB_PCT_UNUSED_BYTES
  • DB_NUM_CI_SPLIT
  • DB_PCT_NUM_CI_SPLIT
  • DB_NUM_CA_SPLIT
  • DB_PCT_NUM_CA_SPLIT
  • DBX_NUM_IPS
  • DBX_NUM_IPS_OVFL
  • DBX_PCT_IPS_OVFL
  • DBX_UNUSED_BYTES
  • DBX_PCT_UNUSED_BYTES
  • DBX_NUM_CI_SPLIT
  • DBX_PCT_NUM_CI_SPLIT
  • DBX_NUM_CA_SPLIT
  • DBX_PCT_NUM_CA_SPLIT

For more information about invalid values in VSAM statistics, refer to the description of APAR II14008 in the IBM Support Web site.
Another BBE1332I message follows this message. The second BBE1332I message identifies the data set whose VSAM statistics values are invalid.
System action: DB Sensor stores sensor data elements except for the listed sensor data elements and continues processing.
User response: To store the listed sensor data elements, refer to the description of APAR II14008 and correct the statistic values of the VSAM data set.

 

 



Update 2
Date of change: March 2017
Change description: User's guide update.
Topics: Introduction to Data Sensor > Data Sensor overview > Data Sensor terminology

Product short names
These topics use the following abbreviations for product short names.
Table. Product short names

 

Short name Product name
IMS
    • IBM IMS Version 15 Release 1 Database Manager (5635-A06)

 



Update 1
Date of change: January 2017
Change description: Documentation changes by APAR PI70018. This APAR adds support for IMS Catalog API. These documentation changes affect IMS Fast Path Solution Pack users only.
Topics: Changes apply to multiple topics.

 

 

 

Topic: Using FP Stand-alone Database Sensor > FP Stand-alone DB Sensor JCL and control statements > EXEC and DD statements for FP Stand-alone DB Sensor

The “Required or optional” column for IMSACB, IMSACBA, and IMSACBB has been updated as follows:

Table. HFPSENSR DD statements
DD name Use Required or optional Format
IMSACB, IMSACBA, IMSACBB Input Required when IMSCATHLQ=*NO PDS

DD statements for input


IMSACB DD
This optional DD statement specifies the library that contains the DMB for the database. The IMSACB DD statements (IMSACB, IMSACBA, IMSACBB, MODSTAT, MODSTAT2, and OLCSTAT) can be used to identify the active ACB library. When both OLCSTAT or MODSTAT and MODSTAT2 are found, FP Stand-alone DB Sensor checks the time stamp and determines which one is the latest.
DB Sensor determines the active IMSACB library according to the following rules:
  • 1. Check the IMSACB DD statement in the JCL statement.
    2. Check the OLCSTAT DD statement in the JCL statement.
    3. Check the MODSTAT and MODSTAT2 DD statements in the JCL statement.
    4. Allocate the OLCSTAT data set dynamically and check the OLCSTAT member.
    5. Allocate the MODSTAT and MODSTAT2 data sets dynamically and check the MODSTAT and MODSTAT2 members.
If you specify the IMSCATHLQ keyword, IMSACB DD statements are not used. The IMS directory is used instead of the ACB library.
Topic: Using FP Stand-alone Database Sensor > FP Stand-alone DB Sensor JCL and control statements > GLOBAL command keywords for FP Stand-alone DB Sensor

New keywords, IMSCATACB_INPUT and IMSCATHLQ, have been added as follows:

The GLOBAL command keywords control the behavior of the job. You must specify the GLOBAL command and its keywords in the HFPSYSIN DD.
The following syntax diagram shows the GLOBAL command keywords for FP Stand-alone DB Sensor.




IMSCATACB_INPUT=
  • This keyword specifies whether to retrieve the currently active ACB definition or the pending ACB definition from the IMS directory. IMSCATACB_INPUT keyword is effective only when IMSCATHLQ=bsdshlq option is specified on the GLOBAL command.
    • If you omit this keyword, IMSCATACB_INPUT=CURRENT is used as the default value.
    • CURRENT
      • FP Stand-alone DB Sensor retrieves the currently active ACB member from the IMS directory data sets.
    • PENDING
      • FP Stand-alone DB Sensor retrieves the pending ACB member from the staging data set.


IMSCATHLQ=
    • This keyword specifies the high level qualifier of the bootstrap data set of the IMS directory, which is an extension of the IMS catalog.

      You must enable the IMS catalog and the IMS management of ACBs when you specify the high level qualifier of the bootstrap data set of the IMS directory.

      If you omit this keyword, IMSCATHLQ=*NO is used as the default value.

      bsdshlq
      • FP Stand-alone DB Sensor reads the ACB from the IMS directory instead of the ACB library by using IMS Tools Catalog Interface. bsdshlq specifies the high level qualifier of the bootstrap data set of the IMS directory.
      *NO
      • FP Stand-alone DB Sensor reads the ACB from the ACB library.
Topic: Using FP Stand-alone Database Sensor > Output from FP Stand-alone DB Sensor > Runtime Summary report from FP Stand-alone DB Sensor

Report example has been replaced with the following figure:

Figure. Runtime Summary report (FP Stand-alone DB Sensor)


Topic: Using FP Stand-alone Database Sensor > Output from FP Stand-alone DB Sensor > Processing report from FP Stand-alone DB Sensor

Description has been updated as follows:

DATABASE PROCESSING OPTION
    • This part shows the keywords and parameters that the command process used.
      IMSACB shows the name of the data set that is assigned to the DD statement. If you specify IMSCATHLQ=bsdshlq, either IMS CATALOG (CURRENT) or IMS CATALOG (PENDING) is printed instead of the data set name.
Topic: Using FP Stand-alone Database Sensor > Setting site default values for FP Stand-alone DB Sensor > EXEC and DD statements for the FP Site Default Generation utility

Description has been updated as follows:

IMSACB DD
This optional DD statement specifies the library that contains the DMB for the database. The IMSACB DD statements (IMSACB, IMSACBA, IMSACBB, MODSTAT, MODSTAT2, and OLCSTAT) can be used to identify the active ACB library. When both OLCSTAT or MODSTAT and MODSTAT2 are found, the FP Site Default Generation utility checks the time stamp and determines which one is the latest. DB Sensor determines the active IMSACB library according to the following rules:
  • 1. Check the IMSACB DD statement in the JCL statement.
    2. Check the OLCSTAT DD statement in the JCL statement.
    3. Check the MODSTAT and MODSTAT2 DD statements in the JCL statement.
    4. Allocate the OLCSTAT data set dynamically and check the OLCSTAT member.
    5. Allocate the MODSTAT and MODSTAT2 data sets dynamically and check the MODSTAT and MODSTAT2 members.
If you specify the IMSCATHLQ keyword, IMSACB DD statements are not used. The IMS directory is used instead of the ACB library.
Topic: Using FP Stand-alone Database Sensor > Setting site default values for FP Stand-alone DB Sensor > Keywords for the FP Site Default Generation utility

New keywords, IMSCATACB_INPUT and IMSCATHLQ, have been added as follows:

Table. Keywords for the FP Site Default Generation utility
Keyword DB Sensor default value
ADXCFGRP *NO
IMSCATACB_INPUT CURRENT
IMSCATHLQ *NO
Topic: Using FP Stand-alone Database Sensor > Setting site default values for FP Stand-alone DB Sensor > Output from the FP Site Default Generation utility

Report example has been replaced with the following figure:

Figure. Site and System Default report (FP Site Default Generation utility)


 

 

Publication Number

SC19-3283-03

Copyright Date

2011,2017


Cross reference information
Product Component Platform Version Edition
IMS Tools IMS Database Solution Pack z/OS 2.2.0, 2.1.0
IMS Tools IMS Recovery Solution Pack z/OS 2.1.0, 1.1.0
IMS Tools IMS Database Utility Solution z/OS 1.1.0, 2.1.0

Document information

More support for: IMS Tools

Component: IMS Database Solution Pack, IMS Database Utility Solution, IMS Fast Path Solution Pack, More...

Software version: 1.1.0, 1.3.0, 2.1.0, 2.2.0

Operating system(s): z/OS

Reference #: 7049340

Modified date: 12 October 2018