Running the Stage Check utility

To check potential unique index key confliction between the staging database to the production database:

To run the Stage Check utility to ensure there is no unique index key conflict:

  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
      • Windows
        stagingcheck -scope _unique_index_ -sourcedb staging_database_name 
          -destdb production_database_name
        
      • AIXi5/OSiSeriesSun Solaris Operating EnvironmentLinux
        . stagingcheck.sh -scope _unique_index_ -sourcedb staging_database_name
            -destdb production_database_name -sourcedb_user user -destdb_user user 
        
    • Oracle
      • Windows
        stagingcheck -scope _unique_index_ -sourcedb staging_database_name 
           -destdb production_database_name -dbtype oracle -sourcedb_user 
           user -sourcedb_passwd password -destdb_user
           user -destdb_passwd password
        
      • AIXSun Solaris Operating Environment
        
        . stagingcheck.sh -scope _unique_index_ -sourcedb staging_database_name 
          -destdb production_database_name dbtype oracle -sourcedb_user 
          user -sourcedb_passwd password -destdb_user 
          user -destdb_passwd password
        
  5. Examine the stagingcheck_yyyy.mm.dd_hh.mm.ss.zzz.log file.

Feedback