Need documentation clarification on RETIX MINIMAL=YES
search cancel

Need documentation clarification on RETIX MINIMAL=YES

book

Article ID: 72155

calendar_today

Updated On:

Products

Datacom DATACOM - AD CIS COMMON SERVICES FOR Z/OS 90S SERVICES DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS COMMON PRODUCT SERVICES COMPONENT Common Services CA ECOMETER SERVER COMPONENT FOC Easytrieve Report Generator for Common Services INFOCAI MAINTENANCE IPC UNICENTER JCLCHECK COMMON COMPONENT Mainframe VM Product Manager CHORUS SOFTWARE MANAGER CA ON DEMAND PORTAL CA Service Desk Manager - Unified Self Service PAM CLIENT FOR LINUX ON MAINFRAME MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME GRAPHICAL MANAGEMENT INTERFACE WEB ADMINISTRATOR FOR TOP SECRET Xpertware

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.