search cancel

RC/EXTRACT : RX190I: There are no relationships to display.

book

Article ID: 19339

calendar_today

Updated On:

Products

RC/Extract for DB2 for z/OS

Issue/Introduction

After selecting a Start table to create a new Source Definition all child tables are missing on the RC/EXTRACT Source Definition panel.

Using command MODESW results in message 'RX190I: There are no relationships to display'.

 ---------------- RC/EXTRACT Source Definition --------------- yyyy/mm/dd hh:mm
 Command ===>                                                  Scroll ===> CSR

  SELALL: Select all                 EXCALL: Exclude all
  EXCLSW: Show Excluded Objects      MODESW: Relationship Display Mode
  INSERT: Insert unrelated             PLAN: Display plan report
Source Definition: authid1.TBEMP               Source SSID: ssid
Description  ===> TBEMP                        Share Option ===> U
 Start Object Parameters: -----------------------------------------------------
  Sampling Ratio ==> ____ of ____             Initial no. Rows ==> _______
  WHERE Clause   ==> N ________
  Key File Input ==> N ________________________________________________________
  TDM MAPCSV File => N ________________________________________________________
Registry SSID: ssid ------ Display Mode: Object       -------------- authid1
                                                 TOTAL      CHILD
 CMD STATUS    OBJECT             CREATOR  TYPE  LIMIT   WHERE CLAUSE
___ START     TBEMP              authid1  T    _______   N ________
 ******************************* BOTTOM OF DATA *******************************



 RX190 RX190I: There are no relationships to display.  Press HELP for more
 info.



Environment

Release: R20 
Component: RCX

Resolution

Check the RC/Extract Profile and make sure option 'Select Entire R/I Set' is set to Y

--------------------- RC/Extract Profile -------------------- yyyy/mm/dd hh:mm
COMMAND ===>

RC/Extract Parameters:
  Display Hint Wizard           ===> N         ( Y - Yes, N - No )
  Optimize Extract              ===> Y         ( Y - Yes, N - No )
  Uppercase Output              ===> N         ( Y - Yes, N - No )
  Select Entire R/I Set         ===> Y         ( Y - Yes, N - No )
  Load Utility                  ===> PFL       ( IBM or PFL      )
  Display Batch Progress Report ===> Y         ( Y - Yes, N - No )
    Progress Report Increment   ===> 2000      ( 1000 - 99999 )
  Matchcase                     ===> ON        ( ON, OFF, CAPS )
                                   ON,  - Enables matchcase
                                   OFF, - Disables matchcase (SQL intensive)
                                   CAPS - Force object names to upper case.
  Extract view max column width ===> 0         ( 0-99999 )
  Extract view max records      ===> 0         ( 0-999999999 )

Update the profile from RC/EXTRACT Main Menu or by command PROFILE.
Then create a new Source Definition.
All child tables should be listed when the MODESW command is used.

---------------- RC/EXTRACT Source Definition --------------- yyyy/mm/dd hh:mm
Command ===>                                                  Scroll ===> CSR

 SELALL: Select all                 EXCALL: Exclude all
 EXCLSW: Show Excluded Objects      MODESW: Relationship Display Mode
 INSERT: Insert unrelated             PLAN: Display plan report
Source Definition: authid1.TBEMP1              Source SSID: ssid
 Description  ===> TBEMP                        Share Option ===> U
Start Object Parameters: -----------------------------------------------------
 Sampling Ratio ==> ____ of ____             Initial no. Rows ==> _______
 WHERE Clause   ==> N ________
 Key File Input ==> N ________________________________________________________
 TDM MAPCSV File => N ________________________________________________________
Registry SSID: ssid ------ Display Mode: Object       -------------- BASLU02
                                                TOTAL      CHILD
CMD STATUS    OBJECT             CREATOR  TYPE  LIMIT   WHERE CLAUSE
___ START     TBEMP             authid1  T    _______   N ________
___ SELECT    TBDEPT             authid1  T    _______   N ________
___ SELECT    TBEMP_TASK_ROLE   authid1  T    _______   N ________
___ SELECT    TBPROJECT         authid1  T    _______   N ________
___ SELECT    TBROLE             authid1  T    _______   N ________
___ SELECT    TBTASK             authid1  T    _______   N ________
___ SELECT    TBWORK_GROUP       authid1  T    _______   N ________
******************************* BOTTOM OF DATA ********************************