What is PRIQTY and SECQTY allocated for Tablespace

Escapa · Posted: Sat Mar 28, 2009 11:59 am

Hi,
how can i check what is PRIQTY and SECQTY allocated for Tablespace?
and how much is actually occupied?

Raghu navaikulam · Posted: Sat Mar 28, 2009 11:49 pm

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

Escapa · Posted: Mon Mar 30, 2009 2:19 pm

Thanks Raghu.

I got it.

dick scherrer · Posted: Mon Mar 30, 2009 8:30 pm

Hello,

As suggested before, you should talk with your dba. . .

Raghu navaikulam · Posted: Mon Mar 30, 2009 11:32 pm

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

Escapa · Posted: Tue Mar 31, 2009 12:03 pm

Hey thanks a lot Raghu...

That clarified my doubt..