Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Implementing Siebel Business Applications on DB2 UDB for z/OS > Configuring the Database Layout > About Siebel Objects > Database Objects in Storage Control FilesIn the Siebel database storage layout, each table resides in its own table space, and each table space resides in its own database. The number of databases you receive depends on which modules your organization purchases. You can regroup table spaces in databases, as required for your enterprise. NOTE: The maximum number of databases is 64,000 for each DB2 subsystem. The following example illustrates what a Database object looks like in the storage control file: [Object 4] The Database object illustrated in this topic translates into the following DDL output: CREATE DATABASE SIDB2532 CCSID ASCII BUFFERPOOL BP1 / In Siebel Business Applications, CCSID is defined on the database level only. CCSID is always taken from the Defaults object. LockSize is not used in the CREATE DATABASE statement, because LockSize is a default value for all table spaces that belong to a given database. The names of databases in storage control files are comprised of two parts. The first part of the name is a variable, |
![]() |
![]() ![]() |
Implementing Siebel Business Applications on DB2 UDB for z/OS | Copyright © 2008, Oracle. All rights reserved. | |