A few objects in the Database Analyzer extract procedure are bypassed because they are migrated
Article ID: 54540
Updated On:
Products
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
Feedback
