Re: Re-organisation of tablespace

I'm going to have to leave a specific answer to the SQP gurus in the group. If maxnext does indeed correspond to the systables column nextsize then you are setting the table to grow by 10MB at a time which should not explain a 320MB increase in size after a reorg. I just do not know enough about what sapdba is doing. As to the courses, yes it will be useful to take the Admin class and the Tuning class. In addition you may want to take the Interals class to get a better understanding of what's going on under the hood and if you write applications or serious utilities, or have to advise or code review those who do, the Application Development course. And yes, play with your development server by all means. Art S. Kagel Steven wrote: > > 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