|
Hi All, We have a particular table which we have defined to have a 128 memo block size (from the default of 8). It would appear that calls to AdsRestructureTable on the table causes a temporary table to be created but with the default block size of 8 which then fails to restructure due to 7073 errors (when the temporary file reaches around 32gb). How can we make calls to AdsRestructureTable maintain the 128 memo block size? Cheers, Wayne. |
|
Is your table part of A Data Dictionary? If so, login to the Data Dictionary. Find the table and look at the Table Properties. Under Table Properties there is a Property named Memo Block Size. Check that this is not blank and set to 128 then call AdsRestructureTable. |
|
Hi Edgar, Do you know if there's way to maintain the block size of a local table (non-dictionary) when restructuring? Cheers, Wayne. On a free table (non-dictionary) the server will read the block size from the table / file itself. It is only with a Dictionary one where it would read the block size from the Meta-data in the dictionary and cause the issue if the meta-data was not set correctly.
(07 May '15, 12:04)
Edgar Sherman
|