Datacom PREINIT followed by CREATE DATABASE forces Index Format to 1

Products

• Datacom
• Datacom/DB

Issue/Introduction

Performed DBUTLTY PREINIT with the Best Practice values as follows:

PREINIT DBID=nnn,AREA=IXX,BLKSIZE=8192,IXXAREA=IXX,
        OLDEP=NO,OPTION2=FORMAT2,TYPE_IO=VSAM

followed by SQL CREATE DATABASE/AREA/TABLE statements.

But the CXX report for the newly created database shows:

INDEX FORMAT   -      1

Resolution

The database must be opened (e.g. via an OPEN_BASE command) after the CREATE statements are executed to have the INDEX FORMAT correctly set to 2 in the CXX report:

INDEX FORMAT   -      2