Re-organisation of tablespace

Hi, I have just done a re-org of 2 of my tablespaces, and noticed that for one of them, the freespace decreased after the re-org, whereas for the other, it increased. I had thought that after a re-org, some space should typically be freed up. This is in my SAP implementation, and the 2 tablespaces are psapclu & psapes40b. Had done the re-org as I had deleted off quite a fair bit of data in my DB (~6GB). thanks Steven

Steven wrote: > > Hi, > I have just done a re-org of 2 of my tablespaces, and noticed that for > one of them, the freespace decreased after the re-org, whereas for the > other, it increased. I had thought that after a re-org, some space > should typically be freed up. > > This is in my SAP implementation, and the 2 tablespaces are psapclu & > psapes40b. Had done the re-org as I had deleted off quite a fair bit of > data in my DB (~6GB). Details Steven. HOW did you reorg? ALTER FRAGMENT...INIT? Dbexport/drop/create/dbimport? If the latter, or something similar, did you create the indexes before or after loading the data? What is you setting for FILLFACTOR? What was/is the EXTENT SIZE and NEXT SIZE? How was the schema file created (ie if you used myschema did you pass the -a option to calculate ACTUAL extent size or did you let the default set the current size)? Don't forget platform and version info either. Art S. Kagel

Hope I can get the details right... SAP provides a tool "sapdba" to assist in managing the database. In my case, I noticed that it uses "ALTER FRAGMENT.." as shown onscreen details. The freespace results were Time Period psapclu(Data+Indices) psapes40b(Data) Before 412770KB 961446KB After 735550KB 875444KB There is a column mentioning "maxnext" which I had gathered from my reference to be the next extent size, and both are at "10240KB". Threshold settings for the reorg was only available, under sapdba, for the table size, and it was set to 10MB. There wasnt a choice on the schema, I would assume it was with default settings from the system. The system are currently running on 7.24UC4X1 on HP-UX 10.20. Appreciate very much the help given. Thanks Steven PS. Would the courses by Informix be a good way to improve my basic knowledge? Of course, would coupled the courses with experiments on my development machine. 8-) "Art S. Kagel" wrote: > Steven wrote: > > > > Hi, > > I have just done a re-org of 2 of my tablespaces, and noticed that for > > one of them, the freespace decreased after the re-org, whereas for the > > other, it increased. I had thought that after a re-org, some space > > should typically be freed up. > > > > This is in my SAP implementation, and the 2 tablespaces are psapclu & > > psapes40b. Had done the re-org as I had deleted off quite a fair bit of > > data in my DB (~6GB). > > Details Steven. HOW did you reorg? ALTER FRAGMENT...INIT? > Dbexport/drop/create/dbimport? If the latter, or something similar, did you > create the indexes before or after loading the data? What is you setting > for FILLFACTOR? What was/is the EXTENT SIZE and NEXT SIZE? How was the > schema file created (ie if you used myschema did you pass the -a option to > calculate ACTUAL extent size or did you let the default set the current > size)? Don't forget platform and version info either. > > Art S. Kagel