Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

What is PRIQTY and SECQTY allocated for Tablespace

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Sat Mar 28, 2009 11:59 am    Post subject: What is PRIQTY and SECQTY allocated for Tablespace
Reply with quote

Hi,
how can i check what is PRIQTY and SECQTY allocated for Tablespace?
and how much is actually occupied?
Back to top
View user's profile Send private message

Raghu navaikulam

Active User


Joined: 27 Sep 2008
Posts: 186
Location: chennai

PostPosted: Sat Mar 28, 2009 11:49 pm    Post subject: Reply to: What is PRIQTY and SECQTY allocated for Tablespace
Reply with quote

Hi Sambhaji

As a programmer there is no need to know these information. These are the responsibility of DBA. For a DBA is concerned, DBA will be well aware of these things.
You can refer the cataloge table SYSIBM.SYSTABLEPART for getting the PQTY and SQTY. There it will be displayed in terms of 4 KB. For getting the usage of storage, SPACE column gives the information in terms of KB.

Hope this will help you
Regards
Raghu
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Mon Mar 30, 2009 2:19 pm    Post subject:
Reply with quote

Thanks Raghu.

I got it.

Quote:
As a programmer there is no need to know these information


Just Curious....

But just one quick question is I have, PQTY given is 400000 while creating tablespace in my test region but in SYSIBM.SYSTABLEPART it is showing PQTY=100000 only.
What could be issue?
Below is SQL used.
Code:

 DSNTIAD  - SAMPLE DYNAMIC SQL PROGRAM 2.0         
                                                   
           SET CURRENT SQLID = 'DEX004'           
DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION     
                                                   
           COMMIT                                 
DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION     
                                                   
           CREATE TABLESPACE     WEX20400         
                  IN             BEXBATCH         
                  LOCKSIZE       PAGE             
                  BUFFERPOOL     BP1               
                  CLOSE          NO               
                  USING STOGROUP GEX001           
                  PRIQTY         400000           
                  SECQTY         40000             
                  ERASE          NO                                         
DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION                               
                                                                           
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Mar 30, 2009 8:30 pm    Post subject:
Reply with quote

Hello,

As suggested before, you should talk with your dba. . .
Back to top
View user's profile Send private message
Raghu navaikulam

Active User


Joined: 27 Sep 2008
Posts: 186
Location: chennai

PostPosted: Mon Mar 30, 2009 11:32 pm    Post subject: Reply to: What is PRIQTY and SECQTY allocated for Tablespace
Reply with quote

Hi
This is because when creating a Tablespace the PRIQTY and SECQTY is given in terms of KB only. But when you query it, DB2 will give the result in terms of page size. From your post, your page size is 4KB( BP1). That is why 400000 became 100000. Here you are having 100000 pages of 4 KB size.

Hope you got it.
Regards
Raghu
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Tue Mar 31, 2009 12:03 pm    Post subject:
Reply with quote

Hey thanks a lot Raghu...

That clarified my doubt.. icon_smile.gif icon_smile.gif icon_smile.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Data set is allocated to another job ... Seppe CLIST & REXX 2 Wed Aug 03, 2016 4:31 pm
No new posts Image Copy of a tablespace that conta... Robin Sulsona DB2 4 Thu Jun 02, 2016 1:47 am
No new posts IBMHPU - Tablespace and Imagecopy chaitanya bharath DB2 1 Fri Apr 15, 2016 5:54 pm
No new posts Query on Image Copy Tablespace and QU... vickey_dw DB2 3 Fri Oct 23, 2015 10:55 am
No new posts UNLOAD from Image Copy Tablespace wit... alluri12 DB2 5 Wed Sep 23, 2015 7:00 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us