When you have a database that is distributed across more
than one database partition, the database configuration file should
be the same on all database partitions.
About this task
Consistency is required since the SQL compiler compiles
distributed SQL statements based on information in the database partition
configuration file and creates an access plan to satisfy the needs
of the SQL statement. Maintaining different configuration files on
database partitions could lead to different access plans, depending
on which database partition the statement is prepared. Use
db2_all to
maintain the configuration files across all database partitions.