210 Siebel 7.8 with IBM DB2 UDB V8.2 Handbook
– Avoid calculated fields that do COUNT or SUM.
– Control Predefined Queries (PDQs): Either do not allow users to create
their own PDQs or if you do, add indexes to optimize performance of slow
PDQs.
– Set granular positions and responsibilities for Siebel users. This can
substantially limit the amount of data retrieved from the database.
8.4 Operating system configuration considerations
Before installing Siebel software and DB2 UDB, a carefully planned architecture
of servers and the network must be in place, based on the planned number of
users who will use the application. The number of servers necessary, their
capacity in terms of number and speed of CPUs, and the amount of memory are
important ...