SAKETHREDDY
asked on
TABLESPACE CREATION in DB2 V9.1 on Z/Os
1) what is the best way to create a tablespace in Z/os
2) kindly give me the more details on PRIQTY -1 and SECQTY -1
if did not mention , how can we know the default values for PRIQTY ?
2) kindly give me the more details on PRIQTY -1 and SECQTY -1
if did not mention , how can we know the default values for PRIQTY ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
.
CREATE TABLESPACE ts_name IN db_name; where in default values for all options are chosen.
A specific way is:
CREATE TABLESPACE fdbkdbts IN fdbkdbnameonzos USING STOGROUP SYSDEFLT PRIQTY 5000 SECQTY 500;
Refer to link for types of tablespaces in z/os:
http://it.toolbox.com/blogs/db2luw/tablespaces-in-linux-unix-windows-6524
Refer to link for DB2 UDB for z/OS table space properties:
http://publib.boulder.ibm.com/infocenter/rdahelp/v7r5/index.jsp?topic=/com.ibm.datatools.db2.zseries.storage.ui.doc/topics/rztablespace_prop.html
PRIQTY: Specifies the primary space allocation for DASD data sets in ALCUNITs. The value must be greater than zero. The default is 4 320.