search cancel

CA RC/Migrator for DB2 for z/OS (RCM): Does the RCM IBM Unload (IBMULD) model support a 'Where' clause based on an EQF?

book

Article ID: 200029

calendar_today

Updated On:

Products

Database Management for DB2 for z/OS - Administration Suite RC/Migrator for DB2 for z/OS

Issue/Introduction

 A Migration Strategy is created using an EQF (Extended Query Facility) to unload a subset of records based on the EQF.  The EQF 'Where' is found on the Implode/Explode Services Screen.

          20.0   --------- RC/M Implode/Explode Services -------- yy/mm/dd hh:mm

 COMMAND ===>                                                  SCROLL ===> PAGE

                                                                               

 STRATEGY ===> MIGEMP5              DESCRIPTION  ===> TEST SELECT A FEW ROWS  

 CREATOR  ===> authid                     SHARE OPTION ===> U (U,Y,N,X,L)            

 SRC SSID ===> ssid                            NEW OBJECTS  ===> N (U,Y,N)                

 ------------------------------------------------------------------ authid  < >

                                                                               

    + >-EXPL OPT-+ AUX RTN MQT SEQ      SECU ALL         NUMBER                       

 S      A   TG     IMP IMP IMP IMP   RI          RITY  ROWS    OF ROWS                  WHERE              

 _      A   A      _   _   _   _     _  _       _          _         _              ________              S MODELS__         

 ******************************* BOTTOM OF DATA ********************************

 

The Migration strategy is analyzed using the Exclusive Analysis Option 'D' to generate data only movement,  no objects.

The IBM Unload Utility model is used; IBMULD.  The generated analysis output does not include a 'where' clause in the unload parameters, why?

Environment

Release : 20.0

Component : CA RC/Migrator for DB2 for z/OS

Resolution

RC/Migrator for DB2 for z/OS IBM Unload Model (IBMULD) does not support a 'Where' clause. 

Both the RBP(Batch Processor) Unload(UNLOAD) and CA Fast Unload(FUNLD) utility models do support an EQF being specified in the Strategy definition which generates a 'where' clause based on the EQF specified.  Change the unload utility model being used in the analysis to UNLOAD or FUNLD if the Where clause is needed by using the “X” line command when the model is updated, to activate UNLOAD or FUNLD.

Additional Information

Please refer to our documentation below for more detail:

Utilities referenced by the @Default Model ID

Extended Query Facility

 

 

Attachments