Copying data to the staging database

To copy data from the production database to the staging database:

  1. Set the PATH environment variables.
  2. Configure the database.
  3. Change to the directory to which you want log files written.
  4. Type the following:
    • DB2
      • AIXi5/OSiSeriesSun Solaris Operating EnvironmentLinux
         stagingcopy.sh -scope _all_ -sourcedb production_database_name
            -destdb staging_database_name -sourcedb_user user -destdb_user user
        
      • Windows
        stagingcopy -scope _all_ -sourcedb production_database_name
           -destdb staging_database_name
        
    • Oracle
      • Windows
        stagingcopy -scope _all_ -sourcedb production_database_name
          -destdb staging_database_name -dbtype oracle -sourcedb_user
          user -sourcedb_passwd password -destdb_user
          user -destdb_passwd password
        
      • 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
        
  5. Examine the stagingcopy_yyyy.mm.dd_hh.mm.ss.zzz.log file.
  6. Stop and restart the staging server instance.

Feedback