Bookshelf Home | Contents | Index | Search | PDF

Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse > Database Parameters and Requirements for Siebel Data Warehouse >

IBM DB2 UDB Windows 2000-Specific Database Requirements for Siebel Data Warehouse

---

The following requirements apply to DB2 relational database management system (RDBMS) usage:

• ODBC driver for all connections must use the IBM DB2 ODBC Driver.
• Make the appropriate connections using DB2 Client Configuration Assistant.
• Create the user accounts that access the database. They must have SSE_ROLE and be set so that the .dll commands can be run (permissions to create tables).
• One login user needs to be created in an empty database. The database objects will be created using this user login.
• The recommended baseline parameters are as follows:

  MON_HEAP_SZ = 90
  JAVA_HEAP_SZ = 2048
  SHEAPTHRES = 400000
  ASLHEAPSZ = 15
  RQRIOBLK = 32767
  QUERY_HEAP_SZ = 1000
  MAXAGENTS = 400
  NUM_POOLAGENTS = 200
  FCM_NUM_BUFFERS = 12288
  INTRA_PARALLEL = YES
  DBHEAP = 16384
  DBHEAP = 16384
  DATABASE_MEMORY = AUTOMATIC
  CATALOGCACHE_SZ = 5558
  LOGBUFSZ = 256
  UTIL_HEAP_SZ = 10000
  BUFFPAGE = 30000
  ESTORE_SEG_SZ = 65536
  NUM_ESTORE_SEGS = 16
  LOCKLIST = 50000
  APPGROUP_MEM_SZ = 30000
  GROUPHEAP_RATIO = 70
  APP_CTL_HEAP_SZ = 5000
  SHEAPTHRES_SHR = SHEAPTHRES)
  SORTHEAP = 40000
  STMTHEAP = 40960
  APPLHEAPSZ = 2560
  PCKCACHESZ = 800
  STAT_HEAP_SZ = 9000
  DLCHKTIME = 10000
  MAXLOCKS = 50
  LOCKTIMEOUT = 1200
  MAXAPPLS = 500
  AVG_APPLS = 10
  MAXFILOP = 500
  LOGFILSIZ = 63753
  LOGPRIMARY = 200
  LOGSECOND = 2
  SOFTMAX = 100
  LOGRETAIN = OFF

• All tables with a prefix of S_ETL need to be in a tablespace separate from the other OLTP tables. These ETL tables are used by the Siebel Data Warehouse and should not be part of the routine backup processes.

  A complete listing of these tables can be found in Siebel Data Warehouse Data Model Reference.

Bookshelf Home | Contents | Index | Search | PDF