A few objects in the Database Analyzer extract procedure are bypassed because they are migrated
search cancel

A few objects in the Database Analyzer extract procedure are bypassed because they are migrated

book

Article ID: 54540

calendar_today

Updated On:

Products

Database Analyzer for DB2 for z/OS

Issue/Introduction

Extract Procedure processing that usually bypasses migrated objects can be made to wait on a recall of these objects.
This can be accomplished by setting the HRECALL_WAIT_TIME parameter in the PDA member of CDBAPARM to
a suitable value or using a JCL job card parm.

 

Environment

Release: R20
Component: PDA

Resolution

In an extract procedure, if there are objects that are migrated they will be bypassed. In the output, they are displayed as follows:

TS - creator.tsname                                   Migrated : Object bypassed
X2 - creator.indexname                                Migrated : Object bypassed

If the migrated objects should be recalled, the following options provide this ability:

The PDA member of hlq.CDBAPARM has a keyword called HRECALL_WAIT_TIME which allows for a number of seconds to wait for migrated objects to be recalled.

Number of seconds to wait for HRECALL (HRECALL_WAIT_TIME). The default is 0.

The default is 0 (zero), which means do not wait. The number can be 0, or between 2 and 32767.

A value of 1 means 'recall only', i.e., objects will be recalled without any other processing.

From PDA member this can be seen:

HRECALL_WAIT_TIME (00000)           /* Number of seconds to wait   */
                                    /* for the objects VSAM file   */
                                    /* to be recalled.  Values 0,  */
                                    /* 2 - 32767.  0 = don't wait. */
                                    /* 1 = Recall only and is used */
                                    /* when JCL PARM='HRECALL=R'.  */
                                    /* HRECALL=Y/N also available  */
                                    /* HRECALL=Y waits 300 secs    */
                                    /* Default is 0.               */

For example, specifying 'HRECALL_WAIT_TIME (120)' will instruct PDA to issue the HRECALL and wait up to 120 seconds.

This HRECALL_WAIT_TIME parameter can be overridden by a JCL PARM called HRECALL which indicates whether to wait for an IBM DFHSM migrated data set to be recalled.
HRECALL can have one of the following values:
. N (Default) - Do not wait.
. Y - Wait up to five minutes for each migrated object to be recalled.
. R - Force a recall of all migrated objects in an Extract Procedure without any other processing. Objects that are not migrated will be bypassed.
This option lets you recall all objects at once. Later a submission without this JCL PARM can be used to process all objects.

Following is an example of how HRECALL can be coded in the JCL PARM:

//STEP1 EXEC PGM=PTLDRIVM,PARM='SUFFIX=00,EP=RALMCTL/HRECALL=Y',REGION=5M

With this parameter, the migrated objects in the extract will be recalled. In the output, the recall process will be shown as follows:

TS - creator.tsname                                              Migrated : HRECALL issued
Collection of TS - creator.tsname                                              - Started
Collection of TS - creator.tsname                                              - Ended
X2 - creator.indexname                                          Migrated : HRECALL issued
Collection of X2 - creator.indexname                                          - Started
Collection of X2 - creator.indexname                                          - Ended