Tuesday, January 11, 2011

How to set the environment variable ??

Right Click on My Computer --> Properties--> Advanced -->Environment Variables--> Add and set the value of the new environment variables: SIEBEL_LOG_EVENTS = 4 and SIEBEL_FACAP_LOG_EVENTS = 5

How to improve performance of Siebel Tool/Client/Hangs ???

1.Always Close siebel tool/client from file->Exit, Because improper close of siebel tool, Kept log of all transaction and don't delete all after tool close. When you close tool from file->Exit, it removes/ deletes all transaction log saved in S_DOCK_TXN_LOG
2.Truncate table S_DOCK_TXN_LOG .It will delete all transaction log that has not been deleted automatically because of improper exit of siebel tool.
S_DOCK_TXN_LOG : Keep tracks of all DB changes(field level) through application.

3.Make AutoStopDB = TRUE in tool.cfg and client.cfg
4.Don't remove server name from odbc,that is readyment server.
5.Remove additional parameter of local ConnectString
ConnectString = C:\PROGRA~1\Siebel\8.0\Tools\LOCAL\sse_data.dbf -q -m -x NONE
6.In ODBC, Supply user id and password of SIEBEL