Progress/400
Product Guide
Creating Test and Production Environments
The Progress/400 Duplicate Dictionary (DUPPRODB) utility allows you to duplicate existing Progress/400 dictionaries. The user performing DUPPRODB operations should have *OBJEXIST, *OBJMGT, *OBJOPR, and *READ authority to all files in the source dictionary.
NOTE: DUPPRODB is the only technique you can use on the AS/400 to duplicate existing Progress/400 server schemas. To access database files, the Progress/400 DataServer uses server schema information to find where each file resides. Do not use OS/400 CL commands, such as backup/restore and copy, to copy the server schema.The DUPPRODB process follows:
There are several options for how DUPPRODB duplicates the server schema. You determine the way the DB2/400 database files are duplicated by your entry at the Duplicate Files (CPYOPT) parameter:
- The *FULLCPY option allows you to duplicate all of the files (including data) that are part of the server schema, regardless of the library where the files reside. This option creates an exact duplicate of the existing server schema, except that each duplicate file resides in the new library. Previously, the files might have resided in several libraries.
Use this option when you want to make an exact duplicate of a database so you can use one database for testing and one for production.
CAUTION: This command does not duplicate all objects in a library. It duplicates only the objects in a library that are defined in a server schema.- The *EMPTYCPY option operates identically to the *FULLCPY option except that it does not copy the data that the objects contain; that is, the new objects are empty.
- The *DCTONLY option allows you to duplicate only the server schema.
See "AS/400 Utilities," for a detailed description of DUPPRODB.
Figure 8–5 and Figure 8–6 illustrate the use of the *FULLCPY and *DCTONLY options.
- Figure 8–5 shows the results you get when you use DUPPRODB with the *FULLCPY option, as in the following command:
Figure 8–5 also applies to using DUPPRODB with the *EMPTYCPY option except that the data files contain no data.
- Figure 8–6 shows the results you get when you use DUPPRODB with the *DCTONLY option, as in the following command:
See "Tutorials for Managing Your Dictionary Library," for more examples on duplicating a Progress database.
Figure 8–5: How DUPPRODB Works with the *FULLCPY Option
![]()
Figure 8–6: How DUPPRODB Works with the *DCTONLY Option
![]()
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |