Replication Guide and Reference
From the DB2 Control Center, you have the option to run a replication task
immediately or save the generated SQL file to run at a later time. From
DJRA, you can run or edit SQL files from the main window. The SQL files
can be customized for large scale replication actions such as defining
subscription sets, or customized for an application beyond implementations
supported by either the Control Center or DJRA.
You might want to save and customize the SQL files to:
- Create multiple copies of the same replication action, customized for
multiple servers.
- Customize CD table names.
- Define the location for CD tables (DB2 for OS/390 database, DB2 Universal
Database table spaces, DB2 for VSE & VM dbspaces).
- Set the size of the table spaces, databases, or dbspaces of the CD
tables.
- Define site-specific standards.
- Combine definitions together and run as a batch job.
- Defer the replication action until a specified time.
- Create libraries of SQL files for backup, site-specific customization, or
to run stand-alone at distributed sites, such as for a mobile
environment.
If you save the definitions of a large replication subscription set in an
SQL file, you can rerun the definitions as necessary.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]