<div>
You can create in a simple way as:<br />
CREATE TABLESPACE ts_name IN db_name; where in default values for all options are chosen.<br />
<br />
A specific way is:<br />
CREATE TABLESPACE fdbkdbts IN fdbkdbnameonzos USING STOGROUP SYSDEFLT PRIQTY 5000 SECQTY 500; <br />
<br />
Refer to link for types of tablespaces in z/os:<br />
<a href="http://it.toolbox.com/blogs/db2luw/tablespaces-in-linux-unix-windows-6524" rel="ugc">http://it.toolbox.com/blogs/db2luw/tablespaces-in-linux-unix-windows-6524</a><br />
<br />
Refer to link for DB2 UDB for z/OS table space properties:<br />
<a href="http://publib.boulder.ibm.com/infocenter/rdahelp/v7r5/index.jsp?topic=/com.ibm.datatools.db2.zseries.storage.ui.doc/topics/rztablespace_prop.html" rel="ugc nofollow">http://publib.boulder.ibm.com/infocenter/rdahelp/v7r5/index.jsp?topic=/com.ibm.datatools.db2.zseries.storage.ui.doc/topics/rztablespace_prop.html</a><br />
<br />
PRIQTY: Specifies the primary space allocation for DASD data sets in ALCUNITs. The value must be greater than zero. The default is 4 320.<br />

</div>


<div>
<div class="content wysiwyg-content">
1) what is the best way to create a tablespace in Z/os <br />
2) kindly give me the more details on &nbsp;PRIQTY -1 and SECQTY -1 <br />
if did not mention , how can we know the default values for PRIQTY ? <br />
&nbsp;
</div>
</div>


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 ? 
 

TABLESPACE CREATION in DB2 V9.1 on Z/Os

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.