Need documentation clarification on RETIX MINIMAL=YES
book
Article ID: 72155
calendar_today
Updated On:
Products
DatacomDATACOM - ADCISCOMMON SERVICES FOR Z/OS90S SERVICESDATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OSCOMMON PRODUCT SERVICES COMPONENTCommon ServicesCA ECOMETER SERVER COMPONENT FOCEasytrieve Report Generator for Common ServicesINFOCAI MAINTENANCEIPCUNICENTER JCLCHECK COMMON COMPONENTMainframe VM Product ManagerCHORUS SOFTWARE MANAGERCA ON DEMAND PORTALCA Service Desk Manager - Unified Self ServicePAM CLIENT FOR LINUX ON MAINFRAMEMAINFRAME CONNECTOR FOR LINUX ON MAINFRAMEGRAPHICAL MANAGEMENT INTERFACEWEB ADMINISTRATOR FOR TOP SECRETXpertware
Issue/Introduction
Please clarify for me; below in the RETIX documentation “When to Use” you write: “… Using MINIMAL= requires that the tables in the area all have their URI index set to loaded. The CXX REPORT must therefore not have an INDEX LOADED status of NO.”
Is it correct that we cannot use RETIX MINIMAL=YES when the INDEX LOADED status is NO?
Environment
z/OS CA Datacom
Resolution
RETIX with MINIMAL=YES cannot execute after an index has been initialized, and to use MINIMAL=YES the area must be in URI format. Use MINIMAL=NO with the RETIX function if there is no URI index present. The MINIMAL=YES option is designed to more quickly add an index for a new key that is defined to a loaded table with a loaded index and to more quickly delete index entries for a key definition that has been deleted.
So if your CXX report shows INDEX LOADED - No or when not URI then you cannot use the MINIMAL=YES option on the RETIX.