Examples of copying data to the staging database

The following examples illustrate how you can copy tables from the production database to the staging database. It is important to remember that you cannot use the Stage Copy utility if RFQs are on your production system.

Note that you should type the entire utility in a single line. The utilities are shown here on more than one line for presentation purposes only.

Example 1

After cleaning the staging database, copy the production database to the staging database with the scope set to all:

  1. Set the PATH environment variables.
    i5/OSiSeriesNot applicable.
  2. Configure the database.
    i5/OSiSeriesNot applicable.
  3. Change to the directory to which you want log files written.
    i5/OSiSeriesNot applicable. The log files will default to the following directory:
    /QIBM/UserData/CommerceServer56/instances/stagingcopy_{sourcedb_user}
    _{destdb_user}_{timestamp}.log)
    
  4. Type the following:
    • DB2
      • AIXiSeriesSun Solaris Operating EnvironmentLinux. stagingcopy.sh -scope _all_ -sourcedb production_database_name -destdb staging_database_name -sourcedb_user user -destdb_user user
      • Windowsstagingcopy -scope _all_ -sourcedb production_database_name -destdb staging_database_name
    • Oracle
      • AIXSun Solaris Operating Environment. stagingcopy.sh -scope _all_ -sourcedb production_database_name -destdb staging_database_name dbtype oracle -sourcedb_user user -sourcedb_passwd password -destdb_user user -destdb_passwd password
      • Windowsstagingcopy -scope _all_ -sourcedb production_database_name -destdb staging_database_name-dbtype oracle -sourcedb_user user -sourcedb_passwd password -destdb_user user -destdb_passwd password
  5. Examine the stagingcopy_yyyy.mm.dd_hh.mm.ss.zzz.log file to verify that the utility was successful.

To specify the log file name and path, use the log file parameter:

Feedback