Implementing Siebel Business Applications on DB2 UDB for z/OS > Preparing for Implementation on the DB2 Host > Setting Up the DB2 Subsystem >

Required DSNZPARM Parameter Settings


The DSNZPARM values that are required by Siebel Business Applications varies, depending on the version of DB2 for z/OS that you are using:

  • If you are using DB2 for z/OS v7, the following parameter values are required:
    • CACHEDYN=YES
    • CDSSRDEF=1
    • EXTSEC=YES
    • PARTKEYU=YES
    • RETVLCFK=NO
    • MXTBJOIN=128
    • OPTCCOS1=ON
    • OPTSUBQ1=YES
  • If you are using DB2 for z/OS v8, the following parameter values are required:
    • CACHEDYN=YES
    • CDSSRDEF=1
    • EXTSEC=YES
    • PARTKEYU=YES
    • RETVLCFK=NO

NOTE:  PARTKEYU is only required if partitioning is used with the Siebel Schema.

Implementing Siebel Business Applications on DB2 UDB for z/OS