Welcome to the SRP Forum! Please refer to the SRP Forum FAQ post if you have any questions regarding how the forum works.
Frame Sizing
Hola all,
My client has had me working on remaking some tables with data that's 20+years old, and some of the OV files have actually crashed the LH service.
For the most part it's gone well; but I ran into a situation last night where copying to a temp table creates a GFE. It turns out I had the table's framesize set wrong. There is documentation that recommends using the avg record length * 20. In this case that results in a framesize of 110K. Other documentation recommends 4098 max. Today I've had success using a framesize of 24000.
Does anyone have any words of wisdom on this? Could a bogus frame size produce a GFE?
Thanks!
Michael
My client has had me working on remaking some tables with data that's 20+years old, and some of the OV files have actually crashed the LH service.
For the most part it's gone well; but I ran into a situation last night where copying to a temp table creates a GFE. It turns out I had the table's framesize set wrong. There is documentation that recommends using the avg record length * 20. In this case that results in a framesize of 110K. Other documentation recommends 4098 max. Today I've had success using a framesize of 24000.
Does anyone have any words of wisdom on this? Could a bogus frame size produce a GFE?
Thanks!
Michael
Comments
General wisdom nowadays is to use 2,048K or 4,096K.