Type II storage and High Water Mark

A

anoobbhaskar

New Member
My progress database (10.1B) has a size of 56 GB in data area and the same is following Type 1 storage area. I am planning to move the tables from Type 1 to Type 2 by moving tables one by one. I heard that 62 GB is the maximum limit of Type 1 and I would like to know whether the value of HWM will change if I move the larger tables to another storage area. Lets say , If I move 2 tables of having 12 GB to another storage area , Is it possible to minimise the overhead of Type 1 temporarily?
Also I would like to know which option is good? Table move or Dump and Load? The purpose is to minimise the down time.
 
Each area has its own HWM. High water marks only go up. They never go down.

A type 1 area with 8k blocks and 256 rows per block is limited to 64GB -- other combinations of block size and rows per block have different size limits.

In current releases of OpenEdge 64 bit rowids in type 2 areas make it unlikely that you need to worry about maximum area size.

Moving large amounts of data from one area to another is best done via dump & load. Table move requires anywhere from 3 to 10 times the table size in bi space. And it takes *forever*.
 
Table moves also lock the table while they're running. I'm with Tom; unless the table is infrequenly-used and tiny, or empty, dump and load it.
 
You must log in or register to reply here.
Back
Top