Performance

 

There are some guidelines that you can follow to improve the performance of your copy operations.

Apart from the guidelines discussed in the preceding topics, when you copy distributed files, you should be familiar with the various factors that affect the performance of the copy command. The DB2^® Multisystem feature provides support for distributed files, or files that are spread across multiple systems. When you copy distributed files, you should be familiar with the various factors that affect the performance of the copy command. You should be aware of restrictions that apply when you copy to and from distributed files. For information about copying distributed files, see the DB2 Multisystem topic.

• Avoiding keyed sequence access paths
  A copy that requires maintenance of a keyed sequence access path is slower than a copy from or to an arrival sequence access path.

• Specifying fewer parameters
  In general, you can improve copy performance if you specify fewer optional copy parameters.

• Checking record format level identifiers
  You can also improve copy performance by correctly setting the record format level identifiers in the CPYF command.

• Preventing errors when copying files
  You can prevent many copy errors when you plan for certain conditions and situations ahead of time.

 

Parent topic:

Database file management