Synchronizing component parameters

Compverify.pl is an Perl script which enables you to extract, compare, present and correct component parameters between multiple systems running Siebel components. It can executed in two different modes; "Extract" and "Compare".

Extract mode
When ran in "Extract" mode, the script generates an referencefile, which contains components and component-parameters from a specified Siebel server. This referencefile can be used in "compare" mode when comparing components and componentparameters between different Siebel servers.

Compare mode
In "Compare" mode component parameters are compared between different Siebel servers or against a specified reference file. When using a referencefile the definitions in the file are considered as the master data to where all other servers are compared. When comparison is done between the servers all differences between component parameters are reported.

When comparing component parameters between servers the script can generate different types of output files. The probably most used output file is the report in Excel 2003 XML format. This Excel workbook gives you an instance overview of all parameters per component and the differences. The parameters in the workbook are presented in multiple worksheets, one worksheet per component, to keep it readable. The workbook opens with an index worksheet which gives you an instant view of the number of differences found per component. Clicking one component, opens the corresponding worksheet.
Each worksheet with component parameters initially only shows the parameters which do differ, the filter in the column with the label 'identical' enables you to show all or equal parameter values. The names of parameters which are printed in italics are hidden parameters. To illustrate how the output can look like, some screenshots can be selected below.


Compverify can also generate the necessary srvrmgr instructions to correct the parameters which do differ from the reference-file or server you are comparing the values to. Compverify generates a plain text file which contains instructions how to use the file and ensures you that a backup is made before changing any parameter. Each step in the file is documented so you exactly know what the srvrmgr instructions will correct. During the execution of the srvrmgr instructions file, spooling is enabled. This way you will always have a logfile showing the executed instructions and responses from srvrmgr. An example file is shown below.

# correctasmaster.sin
# This file is generated by ./compverify.pl version 0.95 at Thu Jun 28 08:09:59 2007
#
# This file can be used to correct all differences in component parameter values
# which are reported in the Microsoft Excel file aom_vs_lathaan_as_ref.xml
#
#
# Usage ;
# srvrmgr /g sblgw /e siebel /u sadmin /i correctasmaster.sin
#
# IMPORTANT! Restart the Siebel server process on all applicable systems to
#            apply the changes made by this servermanager script
#
#
# Spool all actions to the file correctasmaster.sin_srvrmgrspool.txt
spool correctasmaster.sin_srvrmgrspool.txt
# Backup the nameserver configuration for rollback purposes
backup nameserver "correctasmaster.sin_nsbackup_0628_08:09:59"
# Correct Paramlevel for Comp FINSAdminObjMgr_nld Param CFGApplicationSplashText on server mangaan
delete parameter override for comp FINSAdminObjMgr_nld server mangaan param CFGApplicationSplashText
change parameter CFGApplicationSplashText="Siebel Financial Services" for compdef FINSAdminObjMgr_nld
# Correct Paramlevel for Comp FINSAdminObjMgr_nld Param CFGApplicationTitle on server mangaan
delete parameter override for comp FINSAdminObjMgr_nld server mangaan param CFGApplicationTitle
change parameter CFGApplicationTitle="Siebel Financial Services" for compdef FINSAdminObjMgr_nld
# Correct Paramlevel for Comp FINSAdminObjMgr_nld Param ConnIdleTime on server chroom
delete parameter override for comp FINSAdminObjMgr_nld server chroom param ConnIdleTime
change parameter ConnIdleTime="3500" for compdef FINSAdminObjMgr_nld
# Correct Paramlevel for Comp FINSAdminObjMgr_nld Param MinSharedDbConns on server kwik
delete parameter override for server "kwik" param MinSharedDbConns
delete enterprise parameter override param MinSharedDbConns
# Correct Paramlevel for Comp FINSAdminObjMgr_nld Param SecAdptMode on server mangaan
delete parameter override for comp FINSAdminObjMgr_nld server mangaan param SecAdptMode
delete parameter override for compdef FINSAdminObjMgr_nld param SecAdptMode


Besides the previously mentioned, Compverify has the following features;

- Comparing parameter values on value only or including level whereon the value is set.
- Parameters exclusion during comparison.
- Comparing hidden component parameters


I can write another page or two about this tool, but you just should download it and try. Compverify can be downloaded here.



blog comments powered by Disqus