We use a piece of code called stcreate.p to work out which storage area to put tables into based on a calculation of the block size needed from dbanalys output. We're not sure we trust this code anymore as it seems to make assumptions about things, in particular smaller tables. In particular we have 2 tables that are almost carbon copies of each other, but one holds a lot of records the other doesn't and one is pushed into a size 32 blocked area, the other is put in a 64. This makes little sense. We have noticed some storage areas growing very quickly and suspect some tables are in the wrong block sized area. We are unsure of which though. Are there any other tools out there that we might use to analyse where to put things?
Or is there an easy way of manually deciding where to put things?
Thanks in advance.
Or is there an easy way of manually deciding where to put things?
Thanks in advance.