Priqty = 172800
Secqty leave the same or make it 100 cylinders = 72000

Wayne Stevens
Wayne.[Email address protected]

-----Original Message-----
From: JAMES PARK
[mailto:db2udbdba-ezmlmshield-x97582525.[Email address protected]
Sent: Tuesday, November 27, 2007 8:01 AM
To: LazyDBA Discussion
Subject: Increasing PQTY and SQTY

Hi, Listers.


I work on DB2 V8 on z/OS.


A QMF tablespace was defined with PQTY of 57600(80 cyls.) and SQTY
28800(40 cyls.).

This tablespace dataset has 5 extents. I want to make the extent to 1.
What could be the right PQTY and SQTY?


Always thanks for your help.

Thanks,

James Park
Database Specialist II
Annapolis Data Center
410-260-7489
[Email address protected]




------------------------------------------------------------------------
------
This email and any file transmitted with it may be confidential and are
intended solely for the use of the individual or entity to whom they are
addressed. If you received this email in error, please notify the
Comptroller's System Manager by forwarding this message to [Email
address protected]
========================================================================
======



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page