Progress/400
Product Guide


Copying a Single Library or ALTLIB Database

This section explains how to create a database by copying all data files (physical files and logical files) and server schema to one OS/400 library. This method works whether all data files reside in the server schema library or in one or more alternate libraries. When you complete the database copy, all of the files will reside in the library that you specify.

To use this method, follow these steps:

  1. Run the DUPPRODB utility to copy the server schema and data files to the new library. Table A–4 notes DUPPRODB parameter values to use.
  2. Table A–4: DUPPRODB Parameter Values for a Library Copy 
    Parameter
    Option
    NEWDB(new library name)
    Enter a library name or *CURLIB.
    FRMDB(old library name)
    Enter the library name containing the existing server schema.
    COPYOPT(copy selection)
    Enter *FULLCOPY to copy data files with data, or enter *EMPTYCOPY to copy data files with no data. Either option creates all copies in the server schema library, regardless of where the original copies are located.
    OBJLIB(*NEWLIB)
    Locate your Progress/400 Data Dictionary data files here. Select the default option, *NEWDB, which places the data files in the same library as the server schema.

  3. Create a client schema holder for the server schema. See "Remote Client DB2/400 Utilities," for more information on client utilities.

Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095