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:

  1. DUPPRODB creates a new object library and a new server schema. The object library is the destination for all the files that you want to duplicate.
  2. DUPPRODB copies the physical and logical files from the existing server schema that you specify into the new server schema and object library.

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:

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.

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