Data definition files

Dumping and loading data definition (.df) files preserves buffer pool designations using the key word BUFFER-POOL. The data definition trailer contains a bufpool=yes entry to signal to the load process that the file contains Alternate Buffer Pool settings. The following excerpt from a data definition file shows the new keywords:

UPDATE TABLE "Customer"
  BUFFER-POOL "Alternate"

UPDATE INDEX "Comments" OF "Customer"
  BUFFER-POOL "Alternate"

UPDATE INDEX "Country-Post" OF "Customer"
  BUFFER-POOL "Alternate"

UPDATE INDEX "Cust-Num" OF "Customer"
  BUFFER-POOL "Alternate"

UPDATE INDEX "Name" OF "Customer"
  BUFFER-POOL "Alternate"

UPDATE INDEX "Sales-Rep" OF "Customer"
  BUFFER-POOL "Alternate"

UPDATE TABLE "Order"
  ENCRYPTION YES
  CIPHER-NAME AES_CBC_128

UPDATE TABLE "Order-Line"
  ENCRYPTION YES
  CIPHER-NAME AES_CBC_128
  BUFFER-POOL "Alternate"

.PSC
encpolicy=yes
bufpool=yes
cpstream=ISO8859-1

.0000018384