Results 1 to 2 of 2

Thread: 251 extents

  1. #1
    Join Date
    Sep 2003
    Posts
    36

    Unanswered: 251 extents

    one of the tablespace defined with 18720 pqty and 18720 secqty is running out of extents and I am trying to incrse tge priqty and secty to bring the extent down, is there any space calculation to achive this. From the dataset of thetablespace I can find how much tracks used, I wsih to know how to proceed to arrive at the proposed priqty and secqty, If there is a formula calculation do let me know.

  2. #2
    Join Date
    May 2009
    Posts
    508
    Provided Answers: 1
    sahana, assuming you have standard 3390 devices, you can fit 12 4k pages on a track. Since Primary and Secondary quantities are give in 1k pages, this woulds out to 48 (4 * 12) per track.

    Your 18720 Primary (and Secondary since they are the same value) quantity works out to 390 tracks (18720 / 48). At 251 extents, that works out to about 97,890 tracks (390 * 251).

    At this point I will say that when any of my datasets are around 2,000-4,000 tracks, I partition the table space as very large single files are more difficult to deal with. Your 97,000 tracks surpasses this number by a VERY large amount.

    But to answer your question, you would multiple the number of tracks by 48 to get a Primary quantity of 4698720. I would NOT make the Secondary quantity the same size.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •