search cancel

Queries on - DB2 Prefetch -Off option

book

Article ID: 201689

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We need more details on Data reservation functionality. Can you clarify below questions.

  • What should be the data type for the reservation id column ?
  • Should it have any default value?
  • What index should we have on this reservation table in if we create in DB2?

Environment

Release : 4.9, 4.10

Component : CA Test Data Manager

Resolution

1) What should be the data type for the reservation id column ?
Reservation_ID - varchar (36)

2) Should it have any default value?
No default value required

3) What index should we have on this reservation table in if we create in DB2?

And here's what the Index looks like:

CREATE INDEX "SCHSC12"."PEOPLE_RESERVATIONS_IDX1"
ON "SCHSC12"."PEOPLE_RESERVATIONS"
("$RESERVATION_ID" ASC)
NOT CLUSTER
NOT PADDED
DEFINE NO
USING STOGROUP SYSDEFLT
PRIQTY -1
SECQTY -1
BUFFERPOOL BP2
PIECESIZE 4194304 K;

Additional Information

https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-9/provisioning-test-data/configure-test-data-reservation-service/configure-dynamic-test-data-reservation-service/data-prefetch.html