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.

asked 27 Apr '15, 03:05

wayne's gravatar image

wayne
1222
accept rate: 0%


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.

link

answered 27 Apr '15, 10:15

Edgar%20Sherman's gravatar image

Edgar Sherman
5.4k13185
accept rate: 25%

Hi Edgar,

Do you know if there's way to maintain the block size of a local table (non-dictionary) when restructuring?

Cheers,

Wayne.

link

answered 07 May '15, 02:54

wayne's gravatar image

wayne
1222
accept rate: 0%

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
Your answer to the original question.
If responding to a request for additional information, please edit the question or use the comment functionality.
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×8

Asked: 27 Apr '15, 03:05

Seen: 1,823 times

Last updated: 07 May '15, 12:04

Advantage Developer Zone Contact Us Privacy Policy Copyright Info


Powered by Advantage Database Server and OSQA
Disclaimer: Opinions expressed here are those of the poster and do not necessarily reflect the views of the company.