Updates to IMS Solution Packs: Database Sensor User's Guide (SC19-3283-00)

Product documentation


Abstract

Updates that apply to IMS Solution Packs: Database Sensor User's Guide (SC19-3283-00).

Content

These updates apply to both IMS Database Solution Pack users and IMS Fast Path Solution Pack users unless otherwise indicated in each Change description.

Most recent updates appear at the top of the list.



Update 10
Date of change: April 2014
Change description: Documentation changes by APAR PI06716. These documentation changes apply only to IMS Fast Path Solution Pack users.
Topics: Changes are made to the following topics.
> 3.0 Using FP Stand-alone DB Sensor
>> 3.4 FP Stand-alone DB Sensor JCL and control statements
>>> 3.4.1 EXEC and DD statements for FP Stand-alone DB Sensor

Description of the HFPAPARM DD has been updated as follows:

HFPAPARM DD
This DD statement is an optional DD statement that contains execution control parameters.

Start of changeIf you want the Online Space Management utility to obtain values for the RBASEFS keyword, the RDOVFFS keyword, or both from the Sensor Data repository, specify a valid value for these keywords with this DD statement. End of change

The HFPAPARM DD statement can be coded as a sequential data set or as a PDS member. LRECL=80 is required for the DCB of this data set. Start of change This data set must contain only one statement. The HFPAPARM keywords must be written on one line. End of change It can be coded as follows:
Start of change

//HFPAPARM DD *
  ARDIGIT=5 RBASEFS=30 RDOVFFS=50  RGROUP=IMS1
/*

End of change

Start of change There is only one statement type in the HFPAPARM file. End of change You can specify the keywords that are listed in the following table.

Table. HFPAPARM keywords
(Table 8 in PDF and BookManager formats)
Keyword Description
ARDIGIT ...
Start of changeRBASEFSEnd of change Start of changeThis keyword defines the value for data element DB_THRESHOLD_RBASEFS. The defined value is read by the Online Space Management utility and used as the RBASEFS keyword value in the reorganization process during the Online Expert Reorganization utility process.

The value specifies the criterion to select UOWs to reorganize. It specifies the percentage of free space in each RAP CI. If a RAP CI contains free space that is greater than the specified percentage, and the RAP CI also uses overflow CIs, the UOW is selected as a candidate for the reorganization.

Specify an integer value in the range of 0 - 100. The maximum value 100 has a special meaning; if RBASEFS=100 is specified, the RBASEFS condition is not used to select an initial set of UOWs.End of change
Start of changeRDOVFFSEnd of change Start of changeThis keyword defines the value for data element DB_THRESHOLD_RDOVFFS. The defined value is read by the Online Space Management utility and used as the RDOVFFS keyword value in the reorganization process during the Online Expert Reorganization utility process.

The value specifies the criterion to select UOWs to reorganize. It specifies the percentage of free space in the dependent overflow area in each UOW. If the free space percentage in the dependent overflow area in a UOW is greater than the specified percentage, and the UOW also uses IOVF CIs, the UOW is selected as a candidate for the reorganization.

Specify an integer value in the range of 0 - 100. The maximum value 100 has a special meaning; if RDOVFFS=100 is specified, the RDOVFFS condition is not used to select an initial set of UOWs.End of change
RGROUP ...

=================
Topics:
>> 3.5 Output from FP Stand-alone DB Sensor
>>> 3.5.3 Sensor Data Statistics report from FP Stand-alone Database Sensor

>> 3.7 Printing sensor data by using the FP DB Sensor Printing utility
>>> 3.7.3 Output from the FP DB Sensor Printing utility
>>>> 3.7.3.2 Sensor Data Statistics report from the FP DB Sensor Printing utility

In the sample reports, the following data elements and their values have been added to the UOW STATISTICS INFORMATION section:
(In PDF and BookManager formats, figures 29, 31, 35, 47, 49, and 53.)

Start of change

==============================================
   UOW STATISTICS INFORMATION                
==============================================
Data Element Name                        Value
------------------------  --------------------
...
DB_THRESHOLD_RBASEFS                       30%
DB_THRESHOLD_RDOVFFS                       50%
DB_NUM_UOW_RFS_COND                         50
DB_PCT_NUM_UOW_RFS_COND                    10%

End of change



Update 9
Date of change: February 2014
Change description: Documentation change by APAR PI08979. This documentation change applies only to IMS Database Solution Pack users and IMS Database Reorganization Expert users.
Topic:
> 2.0 Using FF Stand-alone Database Sensor
>> 2.4 FF Stand-alone DB Sensor JCL and control statements
>>> 2.4.3 GLOBAL command keywords for FF Stand-alone DB Sensor

Description of the SENSOR_HOME= keyword has been updated 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
      • Start of changeDB_AVG_LEN_SYNONYM_CHAINEnd of change
    NO
      ...

Start of change Restriction: 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. End of change

Considerations for SENSOR_HOME and the policy evaluation process:
    Start of changeThe data elements that are additionally collected when SENSOR_HOME=YES are useful factors for determining the need of database reorganization. End of change

    Start of changeDB_NUM_ROOT_NOHOME and DB_PCT_NUM_ROOT_NOHOME show how many root segments are placed in the different block from the blocks in which their RAP (Root Anchor Points) are placed. End of change If the number of DB_PCT_NUM_ROOT_NOHOME is large, extra I/O operations can occur for reading root segments. If the number of DB_PCT_NUM_ROOT_NOHOME is large and if you reorganize the database, the amount of I/O might be decreased because the root segments will be moved into the home blocks.

    Start of changeDB_AVG_LEN_SYNONYM_CHAIN shows how many root s segments are assigned to the same RAP by a randomizer. If the number of DB_AVG_LEN_SYNONYM_CHAIN is large, extra I/O operations can occur for reading root segments. To improve this situation, change the randomizing parameters, such as increasing RAA blocks or the number of RAPs, or changing the randomizer, and then reconstruct the database. End of change

    If you specify SENSOR_HOME=NO, Policy Services and Autonomics Director cannot evaluate these factors, and they might not provide adequate information about the state of the database and the actions that you must take. Consider specifying SENSOR_HOME=YES unless you have performance concerns.

    Start of changeWhen you specify SENSOR_HOME=YES, a randomizer is called to collect data for these data elements. End of change Consequently, when SENSOR_HOME=YES is specified, the CPU time and the elapsed time increase compared to when SENSOR_HOME=NO is specified.



Update 8
Date of change: December 2013
Change description: Documentation change by APAR PI05155 (for IMS Fast Path Solution Pack V1.3) and APAR PI06811 (for IMS Fast Path Solution Pack V1.2). This documentation change applies only to IMS Fast Path Solution Pack users.
Topic:
> 3.0 Using FP Stand-alone Database Sensor
>> 3.5 Output from FP Stand-alone DB Sensor
>>> 3.5.3 Sensor Data Statistics report from FP Stand-alone Database Sensor

The header of the SYNONYM CHAIN LENGTH STATISTICS sections in the Sensor Data Statistics reports has been changed as follows:

Before change:

    ==============================================
       SYNONYM CHAIN LENGTH STATISTICS
    ==============================================

After change:

    ==============================================
       RANDOMIZING STATISTICS
    ==============================================

(In PDF and BookManager formats, figures 29, 31, 33, 35, 37, 47, 49, 51, 53, and 55.)



Update 7
Date of change: April 2013
Change description: Documentation change by APAR PM79336. This documentation change applies only to IMS Fast Path Solution Pack users.
Topic:
> 3.0 Using FP Stand-alone DB Sensor
>> 3.4 FP Stand-alone DB Sensor JCL and control statements
>>> 3.4.1 EXEC and DD statements for FP Stand-alone DB Sensor

The following restriction item has been deleted from the area ddname DD description:

area ddname DD
    Start of change Restriction: You cannot specify an image copy data set for this DD. End of change



Update 6
Date of change: December 2012
Change description: Documentation change by APAR PM76414. This documentation change applies only to IMS Fast Path Solution Pack users.
Topic:
> 3.0 Using FP Stand-alone Database Sensor
>> 3.4 FP Stand-alone DB Sensor JCL and control statements
>>> 3.4.3 GLOBAL command keywords for FP Stand-alone DB Sensor

New keyword, MSTIMESTAMP, has been added as follows:


___MSTIMESTAMP=_______NO________________________><  
                    |_LOCAL_|

Start of change MSTIMESTAMP=
    This keyword specifies whether to include the timestamp with the messages. If you omit this keyword, MSTIMESTAMP=NO is used as the default value.

    LOCAL
      Includes a local timestamp in the messages.
    NO
      Does not include a timestamp in the messages. End of change

-----------------
>>> 3.4.4 DATABASE command keywords for FP Stand-alone DB Sensor

Description of IAREA has been modified as follows:


IAREA=
    This keyword specifies the DEDB area names. If you omit this keyword, IAREA=*ALL is used as the default value.
    area_name
      FP Stand-alone DB Sensor processes the specified areas. You can specify multiple areas by surrounding the area names with parentheses and using a comma to delimit each area name.
      Start of changeYou can also use certain wildcard characters to specify areas. These wildcard characters are the asterisk (*), which represents from 0 to 8 characters, and the percent sign (%), which represents any single character. For example, IAREA=area* matches area, area1, area1234, and so on; IAREA=area% matches area1, area2, and so on. End of change

    Start of change n1-n2
      FP Stand-alone DB Sensor processes the areas that are found in the specified range. Specify the range of areas by area numbers. n1 and n2 are area numbers, which are decimal numbers assigned sequentially to the areas within a database. The value for n1 and n2 can be in the range of 1 - 2048. n2 must be equal to or greater than n1. At least one area must exist in the specified range. End of change

    Start of change area_name1-area_name2
      FP Stand-alone DB Sensor processes the areas that are found in the specified range. area_name1 and area_name2 must be specified in alphabetical order. At least one area must exist in the specified range. End of change

    *ALL
      FP Stand-alone DB Sensor processes all the areas of the DEDB.



Update 5
Date of change: December 2012
Change description: Documentation change by APAR PM73363. This documentation change applies only to IMS Fast Path Solution Pack users.
Topic:
> 3.0 Using FP Stand-alone Database Sensor
>> 3.4 FP Stand-alone DB Sensor JCL and control statements
>>> 3.4.3 GLOBAL command keywords for FP Stand-alone DB Sensor

An exception note has been added to the description of DBRC=NO, and a description about the new parameter, DBRC=IGNORE, has been added as follows:

DBRC=
    This keyword specifies whether to activate DBRC. If you omit this keyword, DBRC=NO is used as the default value.
    YES
      Activates DBRC. When you specify DBRC=YES, FP Stand-alone DB Sensor stores sensor data in the Sensor Data repository by using the RECON ID (locale) that is associated with the RECONx data set names.
      Requirement: To specify DBRC=YES, you must specify the RECONx DD statements or specify a DFSMDA member in the STEPLIB or IMSDALIB data set. For more information about specifying a DFSMDA member, see the topic about the DFSMDA macro in IMS System Definition for the version of IMS that you are using.

    NO
      Does not activate DBRC. FP Stand-alone DB Sensor stores sensor data in the Sensor Data repository without using a RECON ID.
      Start of changeException: When DBRC=FORCE is set for IMS, DBRC is activated even if DBRC=NO is specified in DB Sensor JCL. End of change

    Start of changeIGNORE
      Does not activate DBRC. FP Stand-alone DB Sensor stores sensor data in the Sensor Data repository without using a RECON ID.
      Even when DBRC=FORCE is set for IMS, DBRC is not activated if DBRC=IGNORE is specified in DB Sensor JCL. End of change



Update 4
Date of change: March 2012
Change description: User's guide update. This documentation change applies only to IMS Database Solution Pack users.
Topic:
> 4.0 Troubleshooting
>> 4.1 Messages and codes
>>> 4.1.2 FF DB Sensor messages
>>>> BBE1451E

The Explanation and the User response sections of the BBE1451E message have been changed as follows:

SENSOR DATA SERVICE FAILED. FUNC= function , RC= return_code , RSN= reason_code [, ELEM= data_element xxxx/yyyy ]

Explanation: One or more errors were detected when the function function of the sensor data service was running. Hexadecimal values return_code and reason_code show the return and reason codes of the error, respectively. If the errors are detected in specific data elements, data_element shows the name of the data element, and hexadecimal values xxxx and yyyy show the return and reason codes of the error, respectively.

Start of changeIf this message contains FUNC=INIT, RC=4, and RSN=X'52', the message indicates that the Sensor Data repository is not initialized. End of change

System action: DB Sensor processing ends with return code 8.

User response: Determine if the correct load module library for Policy Services is specified in your JCL. See the Tools Base Policy Services User's Guide to determine the meaning of the return code and reason code. Correct the error and rerun the job.

Start of changeWhen FUNC=INIT, RC=4, and RSN=X'52', follow the instructions in the topic "Initializing the repositories" in the Tools Base: IMS Tools Knowledge Base User's Guide and initialize the Sensor Data repository. Rerun the job. End of change

If the problem persists, contact IBM Software Support.


Update 3
Date of change: January 2012
Change description: Documentation change by APAR PM55324. This documentation change applies only to IMS Fast Path Solution Pack users.
Topic:
> 3.0 Using FP Stand-alone DB Sensor
>> 3.6 Setting site default values for FP Stand-alone DB Sensor
>>> 3.6.1 Creating a site default table for FP Stand-alone DB Sensor

The JCL for creating a site default table (for FP Site Default Generation utility) has been replaced with the following figure. (The changes are made to the instructions part. No change has been made to the job itself.)

Figure x. JCL for creating the site default table (FP Site Default Generation utility)
(Figure 39 and 40 in PDF and BookManager formats)
Start of change

//HFPSCTL0 JOB                                                        
//*-------------------------------------------------------------------*
//* JOB NAME = HFPSCTL0                                               *
//*-------------------------------------------------------------------*
//*       LICENSED MATERIALS - PROPERTY OF IBM                        *
//*                                                                   *
//*       5655-W14                                                    *
//*                                                                   *
//*       COPYRIGHT IBM CORP. 2011                                    *
//*                                                                   *
//*       THE SOURCE CODE FOR THIS PROGRAM IS NOT PUBLISHED OR        *
//*       OTHERWISE DIVESTED OF ITS TRADE SECRETS, IRRESPECTIVE       *
//*       OF WHAT HAS BEEN DEPOSITED WITH THE U.S. COPYRIGHT OFFICE.  *
//*                                                                   *
//*-------------------------------------------------------------------*
//*                                                                    
//*===================================================================
//* Description: This JCL generates a site default module,    
//*              HFPSCTL0, which can be used by FP Stand-alone
//*              DB Sensor.                                    
//*                                                                    
//*===================================================================
//*                                                                    
//*  A) Make the following global changes for this job:                
//*                                                                    
//*     1. Modify the job statement to suit your environment.  
//*                                                                    
//*     2. Substitute your dsname high level qualifier (HLQ) for      
//*        IMS FP Solution Pack  data sets for the string              
//*        "$hfphlq.SHFPLMD0".                                        
//*        'change $hfphlq.SHFPLMD0 your_hfp_hlq.SHFPLMD0 all'
//*                                                                    
//*     3. Substitute your dsname high level qualifier (HLQ) for your  
//*        user library to store the site default module (HFPSCTL0)    
//*        for the string "$hfphlq.userlib".                          
//*        'change $hfphlq.userlib your_userlib all'          
//*                                                                    
//*     4. Substitute your group-name or unit number for UNIT          
//*        parameters for the group-name "$sysda", if applicable.      
//*        'change $sysda your_sysda all'                    
//*                                                                    
//*  B) Specify commands and keywords to define the site              
//*     default values on HFPCRE.HFPSYSIN DD statement.                
//*                                                                    
//*  C) Submit the job.                                                
//*                                                                    
//*  D) Confirm all return codes are zero.                            
//*                                                                    
//*  E) Concatenate your_userlib TO JOBLIB OR STEPLIB.                
//*                                                                  
//*===================================================================
//*                                                                    
//SITEMOD  PROC                                                        
//*                                                                    
//HFPCRE  EXEC PGM=HFPSTGEN,PARM='GEN',REGION=2M                      
//STEPLIB  DD  DISP=SHR,DSN=$hfphlq.SHFPLMD0                          
//SYSPRINT DD  SYSOUT=*                                                
//SYSMSG   DD  SYSOUT=*                                                
//SYSPUNCH DD  DISP=(NEW,PASS,DELETE),                                
//           SPACE=(TRK,(1,1)),UNIT=$sysda,DSN=&&SOURCE                
//*                                                                    
//ASM      EXEC PGM=ASMA90,PARM='OBJECT,NODECK',COND=(4,LT,HFPCRE)    
//SYSLIB   DD  DISP=SHR,DSN=SYS1.MACLIB                                
//SYSLIN   DD  DSN=&&OBJLIB,DISP=(NEW,PASS,DELETE),                    
//             UNIT=$sysda,SPACE=(TRK,(1,1))                          
//SYSPRINT DD  SYSOUT=*                                                
//SYSUT1   DD  UNIT=$sysda,SPACE=(TRK,(1,1))                          
//SYSIN    DD  DISP=(OLD,DELETE,DELETE),DSN=&&SOURCE                  
//*                                                                    
//LKED     EXEC PGM=IEWL,COND=(4,LE,ASM)                              
//SYSPRINT DD  SYSOUT=*                                                
//SYSLIN   DD  DSN=&&OBJLIB,DISP=(OLD,DELETE,DELETE)                  
//SYSUT1   DD  UNIT=$sysda,SPACE=(TRK,(1,1))                          
//SYSLMOD  DD  DISP=OLD,DSN=$hfphlq.userlib(HFPSCTL0)                  
//*                                                                    
//         PEND                                                        
//*                                                                    
//*===================================================================
//* <<< DEL/DEF SITE DEFAULT LOAD MODULE LIBRARY >>>                  
//*===================================================================
//SITECRE EXEC SITEMOD                                                
//HFPCRE.HFPSYSIN DD *                                                
  GLOBAL                                                              
         ITKBSRVR=FPQSRV01                                            
/*                                                                    
//*      

End of change



Update 2
Date of change: January 2012
Change description: User's Guide updates. The first change applies to IMS Database Solution Pack users, and the second change applies to IMS Fast Path Solution Pack users.
Topics: Changes are made to the following topics.

> 2.0 Using FF Stand-alone DB Sensor
>> 2.7 Printing sensor data by using the FF DB Sensor Printing utility
>>> 2.7.2 FF DB Sensor Printing utility JCL and control statements
>>>> 2.7.2.4 DATABASE command keywords for the FF DB Sensor Printing utility

The description of IAREA= has been changed as follows:

IAREA=
    Start of changeThis keyword specifies the DEDB area name. Specify this keyword only if the database to be processed is a DEDB. You can specify only one area name. End of change

=================
> 3.0 Using FP Stand-alone DB Sensor
>> 3.7 Printing sensor data by using the FP DB Sensor Printing utility
>>> 3.7.2 FP DB Sensor Printing utility JCL and control statements
>>>> 3.7.2.4 DATABASE command keywords for the FP DB Sensor Printing utility

The description of IAREA= has been changed as follows:

IAREA=
    This required keyword specifies the DEDB area name. Start of changeYou can specify only one area name. End of change




Update 1
Date of change: January 2012
Change description: Documentation changes by APAR PM50736. These documentation changes apply only to IMS Fast Path Solution Pack users.
Topics: Changes are made to the following topics.

> 3.0 Using FP Stand-alone DB Sensor
>> 3.4 FP Stand-alone DB Sensor JCL and control statements
>>> 3.4.1 EXEC and DD statements for FP Stand-alone DB Sensor

The following description has been added to the HFPAUOWC DD description:

Start of changeWhen you specify UOW ranges of multiple areas, the records must be in ascending order of their area number. End of change

-----------------
>>> 3.4.3 GLOBAL command keywords for FP Stand-alone DB Sensor

The following item has been added to the SENSOR_UOW=YES description:

Start of changeWhen you specify SENSOR_UOW=YES, you must specify SENSOR_DBREC=YES. End of change

The following item has been added to the SENSOR_UOW_REPORT=YES description:

Start of changeWhen you specify SENSOR_UOW_REPORT=YES, you must specify SENSOR_UOW=YES. End of change

-----------------
>>> 3.4.4 DATABASE command keywords for FP Stand-alone DB Sensor

IAREA=area_name description has been changed as follows:

Start of changeWhen you specify the HFPAUOWC DD and if you want to process multiple areas, specify the area names in ascending order of their area number. End of change

Publication number

SC19-3283-00

Copyright date

2011

Original publication date

2012/1/19

Cross reference information
Segment Product Component Platform Version Edition
Information Management IMS Tools IMS Fast Path Solution Pack z/OS 1.2.0, 1.3.0

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IMS Tools
IMS Database Solution Pack

Software version:

1.2.0, 2.1.0

Operating system(s):

z/OS

Reference #:

7023916

Modified date:

2014-07-02

Translate my page

Machine Translation

Content navigation