Table of Contents

Search

  1. Preface
  2. Introduction
  3. Servers
  4. Console Client
  5. Search Clients
  6. Table Loader
  7. Update Synchronizer
  8. Globalization
  9. Siebel Connector
  10. Web Services
  11. ASM Workbench
  12. Cluster Merge Rules
  13. Forced Link and Unlink
  14. System Backup and Restore
  15. Batch Utilities

ssachdb Utility

ssachdb Utility

This utility is used to change the source or target database connection string, stored in the Rulebase, for a given system. The utility may also be used to change the schema name associated with the source database (defined in the User Source Tables section).
This is useful when the DBMS password has been changed, or when the entire Rulebase has been copied and moved to another database (example, Test to QA). The syntax is:
%SSABIN%\ssachdb -oOldName -nNewName [-z] | -xOldSchema -yNewSchema CommonParms
where
-oOldName
The old Database connection string
-nNewName
The new Database connection string
-z
Update IDS_2PC table (see Synchronizer Considerations below).
-xOldSchema
The old source database schema
-yNewSchema
The new source database schema
For example, the following three calls change the name of the source connection string, source schema from TEST to QA, and target database connection string respectively.
ssachdb -oodb:99:ssa/ssa@srcdb -nodb:99:ssa/ssa@newsrcdb ... ssachdb -xTEST -yQA ... ssachdb -oodb:1:ssa/ssa@tgtdb -nodb:1:ssa/ssa@newtgtdb ...
The utility updates the Rulebase by performing a simple text replacement of the old string with the new one. If it is necessary to change the source and target connection strings independently, it is necessary to use different names for them in the original system. For example, using a database number of 99 for the source database distinguishes it from the target database, which by default uses a database number of 1, even if they share the same connection parameters (uid/pwd@svc).

0 COMMENTS

We’d like to hear from you!