Index database example
This shows how to partition an Index database with three partitions:
DBDNAME=INDXDB,ACCESS=INDEX
PARTDD1=INDXDD01,,HIGHKEY=3999999999
PARTDD1=INDXDD02,HIGHKEY=7999999999
PARTDD1=INDXDD03
SEGMNAME=IX,BYTES=10
LCHILDNAME=(ROOT,PARTDB),INDEX=ROOTKEY
FIELDNAME=(IXKEY,SEQ,U),BYTES=10,START=1
DBDGEN
FINISH
END
PARTDD1=INDXDD01,,HIGHKEY=3999999999
PARTDD1=INDXDD02,HIGHKEY=7999999999
PARTDD1=INDXDD03
SEGMNAME=IX,BYTES=10
LCHILDNAME=(ROOT,PARTDB),INDEX=ROOTKEY
FIELDNAME=(IXKEY,SEQ,U),BYTES=10,START=1
DBDGEN
FINISH
END
Indexes are partitioned using HIGHKEYs, like HIDAM databases. The important difference to remember is that the HIGHKEY is for the index database. In the case of a HIDAM primary index or secondary index on a HDAM root key, as would be the case in this example, the key of the index is the same as the HIDAM/HDAM root segment. However, most all secondary indexes have a different key than the root; therefore, the HIGHKEY selection and order in the secondary index are different than the target database.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*