Create the DB2 Content Manager Runtime Edition database

Create multiple databases for scalability

The DB2 Content Manager Runtime Edition database grows in size as the IBM WebSphere Portal server is used. To support this growth, which includes the dynamic creation of many new tables within the database, the WebSphere Portal server allows us to create multiple databases within a single IBM DB2 Universal Database for z/OS subsystem. A minimum of two databases is recommended, but more can be created if necessary. A single database setup is not recommended; it will become constrained.

Each database that is created must begin with a common prefix; there is no convention required for the remainder of the name. For example, to create "xx" number of databases, you may choose to use the following commands:

CREATE DATABASE JCRDB01
CREATE DATABASE JCRDB02
...     
CREATE DATABASE JCRDBxx

In this case, JCR is the common prefix. You also have to select a maximum number of user-defined tables (UDT) that each database will be allowed to hold; the recommended value is 400.

Create databases

A sample script of the commands that can be used to create the DB2 Content Manager Runtime Edition database in the DB2 for z/OS installation is below. The sample demonstrates the creation of a single database; to follow the recommendation of creating at least two databases, duplicate the commands for each additional database as indicated below. A template of these commands can be found in the file jcr_sample.sql, in the Portal/config/templates/db/db2_zos directory.

Notes:

It is not necessary to duplicate every tablespace definition in every database.
In order to execute the following lines, know the database name and the IDs of the MVS volumes where the DB2 Content Manager Runtime Edition database tables will be stored.
Edit the template file for the installation environment before running the following commands.

Replace jcrdbnameX with the name of the database. Remember that each database name must begin with a common prefix.
Replace stogroup with the name of the storage group.
Replace icmvolumes with the IDs of the MVS volumes where the DB2 Content Manager Runtime Edition database tables will be stored. This value is assigned by the database administrator.
Replace icmvcat with the name of the virtual catalog.
Replace 4kbp with the name of the 4K bufferpool.
Replace 32kbp with the name of the 32K bufferpool.
Replace jcrschema with the schema name of the jcr domain.

--DROP DATABASE jcrdbnameX
--DROP STOGROUP stogroup --DROP ALIAS jcrschema.ICMFICTITIOUS
CREATE STOGROUP stogroup VOLUMES (icmvolumes)   VCAT icmvcat GRANT USE OF STOGROUP stogroup to icmadmin
CREATE DATABASE jcrdbnameX STOGROUP stogroup BUFFERPOOL 4kbp INDEXBP 4kbp CCSID UNICODE

The following two tablespace commands must be created in every database:

CREATE TABLESPACE ICMLFQ32 IN jcrdbnameX USING STOGROUP stogroup PRIQTY 50000 SECQTY 10000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 32kbp CCSID UNICODE
CREATE TABLESPACE ICMTSQ04 IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE

The following tablespaces are required in the first database only:

CREATE TABLESPACE ICMVFQ04 IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE ICMSFQ04 IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE ICMTSQ04 IN jcrdbnameX USING STOGROUP stogroup PRIQTY 10000 SECQTY 1000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE ICSTADO IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE PRIDLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 10000 SECQTY 1000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE PRSCLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE PRISLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE PRGCLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE PRIGLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE ICSTDPV IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE ACCCLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE ICSDOAC IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE RESMLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE COLNLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE USERLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 10000 SECQTY 1000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE USEGLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 10000 SECQTY 1000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE ACCLLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE SYSCLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE CACLLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 50000 SECQTY 10000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE CPERLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 50000 SECQTY 10000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE ATTDLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE ATTGLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE NLSLLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE MAXKLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE NLSKLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE ITTDLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE ITVDLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE ITVILSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE COMDLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE COMALSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE COMFLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE COVDLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE COVALSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE ITALLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE IT11LSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 50000 SECQTY 10000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE IV11LSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 50000 SECQTY 10000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE LI11LSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 50000 SECQTY 10000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE ITTRLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE RMATLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE CHEOLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE MIMTLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE ITEELSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 50000 SECQTY 10000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE SYAELSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 50000 SECQTY 10000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE TEICLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE IDELLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 10000 SECQTY 1000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE XDOOLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE XDOFLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE RI11LSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 50000 SECQTY 10000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE REPRLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE REPLLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 50000 SECQTY 10000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE TIELLSTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE TS00200 IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE TS00201 IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 32kbp CCSID UNICODE
CREATE TABLESPACE TS00209 IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE TS00202 IN jcrdbnameX USING STOGROUP stogroup PRIQTY 50000 SECQTY 10000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE TS00210 IN jcrdbnameX USING STOGROUP stogroup PRIQTY 50000 SECQTY 10000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE TS00203 IN jcrdbnameX USING STOGROUP stogroup PRIQTY 50000 SECQTY 10000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE TS00204 IN jcrdbnameX USING STOGROUP stogroup PRIQTY 50000 SECQTY 10000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE TS00205 IN jcrdbnameX USING STOGROUP stogroup PRIQTY 10000 SECQTY 1000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE TS00206 IN jcrdbnameX USING STOGROUP stogroup PRIQTY 10000 SECQTY 1000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE TS00207 IN jcrdbnameX USING STOGROUP stogroup PRIQTY 50000 SECQTY 10000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE TS00208 IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE ICMACTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE ICMACLC IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE ICMACLS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE ICUT301 IN jcrdbnameX USING STOGROUP stogroup PRIQTY 50000 SECQTY 10000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE ICUT311 IN jcrdbnameX USING STOGROUP stogroup PRIQTY 50000 SECQTY 10000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE ICUT321 IN jcrdbnameX USING STOGROUP stogroup PRIQTY 50000 SECQTY 10000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE ICUT331 IN jcrdbnameX USING STOGROUP stogroup PRIQTY 50000 SECQTY 10000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE ICUT341 IN jcrdbnameX USING STOGROUP stogroup PRIQTY 50000 SECQTY 10000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE ICUT601 IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE ADDPJRTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 50000 SECQTY 10000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 32kbp CCSID UNICODE
CREATE TABLESPACE DWSLJRTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 50000 SECQTY 10000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 32kbp CCSID UNICODE
CREATE TABLESPACE GENDJRTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 50000 SECQTY 10000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 32kbp CCSID UNICODE
CREATE TABLESPACE GLBPJRTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE LINKJRTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 50000 SECQTY 10000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 32kbp CCSID UNICODE
CREATE TABLESPACE MAXSJRTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE NODDJRTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE NODTJRTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE NODRJRTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE NSPRJRTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE NSURJRTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE PRPDJRTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE ROOTJRTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE NODEJRTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE TABLESPACE SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 32kbp CCSID UNICODE
CREATE TABLESPACE RWSJRTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE SPRTJRTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE TIMEJRTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE TSERJRTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE TSINJRTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE TSPEJRTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE TSTAJRTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE RIDSJRTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE WSNOJRTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 50000 SECQTY 10000 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 32kbp CCSID UNICODE
CREATE LOB TABLESPACE ICMLOBT1 IN jcrdbnameX LOG NO
CREATE LOB TABLESPACE ICMLOBT2 IN jcrdbnameX LOG NO
CREATE LOB TABLESPACE ICMLOBT3 IN jcrdbnameX LOG NO
CREATE ALIAS jcrschema.ICMFICTITIOUS FOR SYSIBM.SYSDUMMY1
CREATE TABLESPACE DLKRJRTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE
CREATE TABLESPACE LKRLJRTS IN jcrdbnameX USING STOGROUP stogroup PRIQTY 500 SECQTY 200 FREEPAGE 1 PCTFREE 5 LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 4kbp CCSID UNICODE

Parent Topic

Creating databases and users