Try OpenEdge Now
skip to main content
Database Administration
Maintaining and Monitoring Your Database : Managing Performance : Alternate Buffer Pool : Designating objects to the Alternate Buffer Pool : Data definition files
 
Data definition files
Dumping and loading data definition (.df) files preserves buffer pool designations. The key word, BUFFER-POOL is present from Release 10.2B forward. Clients earlier than 10.2B will not be able to load a 10.2B or higher data definition file with an object assigned to the Alternate Buffer Pool unless you choose to commit with errors. The data definition trailer also 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