Hi TomBascom. Thanks for your quickly answer...
If it has not been used then you remove it and create a fixed extent as indicated. Otherwise you can make it fixed at its current size and add additional extents (usually one fixed and one variable).
You do not need to recompile after making these sorts of changes.
Ok. We use the traditional way as well, one fixed and one variable. But we would like that the Database not use Variable Extent because we know when the database use Variable Extent it needs request blocks to SO to keep data, different of Fixed, so, the Database works faster with Fixed Extents.
Our intention is add new Fixed Extents when the last Fixed Extent is nearly full. So when the Last Fixed Extent been nearly full the Variable Extent will be empty. Ok? Do you know what I mean?
Actual Situation
---------------
d "Data Area":7,256 com1_7.d1 f 2048000 (Last Fixed)
d "Data Area":7,256 com1_7.d2 (Last Variable)
-rwxrwxrwx 1 root root 2097152000 Apr 19 16:58 com1_7.d1
-rwxrwxrwx 1 root root 131072 Apr 19 16:58 com1_7.d2
Expected Situation
------------------
d "Data Area":7,256 com1_7.d1 f 2048000
d "Data Area":7,256 com1_7.d2 f 2048000
d "Data Area":7,256 com1_7.d3 f 2048000 (Last Fixed)
d "Data Area":7,256 com1_7.d4 (Last Variable)
-rwxrwxrwx 1 root root 2097152000 Apr 19 16:58 com1_7.d1
-rwxrwxrwx 1 root root 2097152000 Apr 19 16:58 com1_7.d2
-rwxrwxrwx 1 root root 2097152000 Apr 19 16:58 com1_7.d3
-rwxrwxrwx 1 root root 131072 Apr 19 16:58 com1_7.d4
In this moment wich proceed is better? Remove the Last Extent that as Variable (com1_7.d2) and re-create as Fixed?
I checked the documentation and I tried delete a variable extent to recriate as fixed, but I saw that command "prosctrct remove" remove storages areas and not extent files...Sorry,let me explain better.
We use the same Storage Area in many Extent Files... Can I remove using another way?
Regards.
Thanks.
