TDM: Product should create indices on the Fk_BIIN_ID,Bundle_ID of each table where FK_BIIN_ID exists

book

Article ID: 210597

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

 
 
 

Product should create indices on the Fk_BIIN_ID,Bundle_ID of each table where FK_BIIN_ID exists 

This is reduce I/O when creating the Sequential File from DB2 Tables. It reduced CPU time a great deal.

Cause

N/A

Environment

Release : 4.9

Component : CA Test Data Manager - Mainframe

Resolution

This should be done by Customer editing the template file TEMPLDS and adding something like 

{PARENT_EXISTS_START}
CREATE UNIQUE INDEX {TABLE_OWNER}.CDM{TABLE_NO}1
  ON {TABLE_OWNER}.{TABLE_NAME}(
     BUNDLE_ID ASC, FK_BIIN_ID ASC)
  USING STOGROUP INDXSTOGRP
  PRIQTY 12960 SECQTY 1440
  FREEPAGE 0 PCTFREE 10
  GBPCACHE CHANGED
  CLUSTER
  COMPRESS NO
  BUFFERPOOL BP12
  CLOSE NO
  COPY NO
  DEFER NO
  DEFINE YES;
{PARENT_EXISTS_END}