We need more details on Data reservation functionality. Can you clarify below questions.
Release : 4.9, 4.10
Component : CA Test Data Manager
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;