dbchck - a useful Siebel utility
dbchck is an underused (and underrated) Siebel supplied utility to compare the logical schema in the Siebel Repository against the reality stored in the physical Oracle database. dbchck should be run regularly to check the status of the Siebel Enterprise, particularly following a release. dbchck can be useful to to identify custom indexes added by the development team but not added to the Repository using Siebel Tools. A example of real-life usage may be usefulD:\sea78\siebsrvr\BIN>dbchck /s SiebSrvr_Sieb78 /u sadmin /p **** /t siebel /d /aThe log file is generated in <siebsrvr>/bin/dbchck.log
2007-03-26 23:25:31
2007-03-26 23:28:32 +0100 000001d8 001 0018 0001 09 dbchck 3044 5428 .\dbchck.log 7.8.2.4 [19224] ENU
2007-03-26 23:25:31 Siebel Enterprise Applications DBCHCK, Version 7.8.2.4 [19224] LANG_INDEPENDENT
2007-03-26 23:25:31 dbchck /s SiebSrvr_Sieb78 /u sadmin /p ***** /t siebel /d /a
2007-03-26 23:25:31
2007-03-26 23:25:31 SQLstyle is 'Oracle' 2007-03-26 23:25:31 SARM is OFF -change param SARMLevel to enable
2007-03-26 23:27:11 Failure: Dictionary for S_CONTACT different from physical schema
2007-03-26 23:27:11 1 Physical column X_HI_VALUE not in the dictionary.
2007-03-26 23:27:11 2 Physical index X_CONTACT_WORK_PH not in the dictionary.
In this example, there is a column defined in the physical database which does not appear in the Siebel Repository. Similarly, a custom index has been added directly to the Oracle database.