Saving database files

Edit online

This information describes what the system does when you save a database file.

Use the SAVOBJ command to save individual database files. You can use the FILEMBR (file member) parameter to save:

  • A list of members from one database file.
  • The same group of members from multiple files.

Here is what the system does when you save a database file:

Table 1. Saving database files
Type of File What is saved
Physical file, TYPE(*DATA), keyed access path1 Description, data, access path
Physical file, TYPE(*DATA), access path not keyed Description, data
Physical file, TYPE(*SRC), keyed access path Description, data
Logical file2 Description
1
The following types of access paths are included as keyed access paths: keyed access paths, primary key constraints, unique constraints, referential constraints.
2
You can save the access path for a logical file by saving the associated physical files using the SAVLIB, SAVOBJ, or SAVCHGOBJ command and specify the ACCPTH parameter..

The description for a file might include the following:

  • Definitions of triggers and the programs that are associated with the file, but not the programs themselves. You must save the programs separately.
  • Definitions of any constraints for the file.

Special considerations apply when you restore a file that has trigger programs or referential constraints defined.