AIX stand-alone: Create the Java content repository database on DB2 for z/OS

View information on setting up Java™ Content Repository database to work with WebSphere Portal.

First, you need to create multiple databases for scalability.

The IBMJava Content Repository 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 you 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 quickly become constrained. See the Performance guides on the product documentation Web site for more information.

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.


Prerequisites


Install DB2 for z/OS
Modify database properties for DB2 for z/OS
Create users for DB2 for z/OS
Grant privileges to DB2 for z/OS users
Create remote database for DB2 for z/OS

A sample script of the commands that you can use to create the Java Content Repository database in DB2 for z/OS installation is shown 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. Find a template of these commands in the file $PORTAL_HOME/installer/wp.config/config/templates/db/db2_zos/jcr_sample.sql.
Notes:

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


The following tablespace command must be created in every database:

CREATE TABLESPACE ICMLFQ32 IN jcrdbnameX USING STOGROUP stogroup PRIQTY 50000 SECQTY 10000 DEFINE NO LOCKSIZE ROW SEGSIZE 32 LOCKMAX 0 CLOSE NO BUFFERPOOL 32kbp CCSID UNICODE


The following tablespaces are required in the first database only:

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


Parent

Prepare DB2 for z/OS


Previous

Create remote database for DB2 for z/OS


Next topic

Assign custom tablespaces on DB2 for z/OS

 


+

Search Tips   |   Advanced Search