Sort DBAKEYS file in root key sequence order

Products

• Database Analyzer for IMS for z/OS

Issue/Introduction

Is there an option to automatically sort the DBAKEYS file in root key sequence? 

FUNCTION=ANALYZE, 
INDEXKEYCHECK=YES,
DBDNAME=dbname,       
KEYREPORTS=YES,   
RAPKEYS=YES,      
REPORTS=(YES)     

Environment

Release : 20.0

Component : Database Analyzer for IMS

Resolution

There is no option to sort the DBAKEYS file in root key sequence order in Database Analyzer.

We do provide sample JCL to invoke the SORT program, see member PICKKEYS in the hlq.CIMTSAMP library.

This is primarily provided to assist in identifying potential partition boundary keys when converting a database to HALDB. 

The additional SORT step is required.