Shanmugam T
New Member
Hello All,
Users facing performance issue during month-end with progress database having Type 1 storage areas(all).
So, i am planning to do a maintenance for tr_hist table(binary dump and load followed by index rebuild).
Table tr_hist is in 25th storage area and its indexes in 26th area.
Kindly advice me, Is it good to migrate only these two areas to Type 2 storage area during maintenance period?
Will it improve the overall performance of the database? rest all tables will be in Type 1 storage area.
Any other parameters should i consider before proceeding to Type 2 storage area?
Also advice me about records per blocks for tr_hist i should choose and others if any.
Thanks in advance.
Background information:
-----------------------
Progress Version: 10.1B03
OS: IBM AIX 6.1
DB size: 100GB
DB block size: 8192
Some DB Parameters:
-B 50000
-L 100000
-c 350
-directio
Table analysis report:
RECORD BLOCK SUMMARY FOR AREA "TRHIST" : 25
-------------------------------------------------------
-Record Size (B)- ---Fragments--- Scatter
Table Records Size Min Max Mean Count Factor Factor
PUB.tr_hist 49931806 14.7G 223 405 316 50160485 1.0 4.7
DB Structure file(Few lines):
-------------------------------------
d "TRHIST":25,64;1 /db1/db_25.d1 f 819200
d "TRHIST":25,64;1 /db1/db_25.d2 f 819200
d "TRHIST":25,64;1 /db1/db_25.d3 f 819200
d "TRHIST":25,64;1 /db1/db_25.d4 f 819200
d "TRHIST_IDX":26,32;1 /db/db_26.d1 f 400000
d "TRHIST_IDX":26,32;1 /db/db_26.d2 f 400000
d "TRHIST_IDX":26,32;1 /db/db_26.d3 f 400000
d "TRHIST_IDX":26,32;1 /db/db_26.d4 f 400000
Users facing performance issue during month-end with progress database having Type 1 storage areas(all).
So, i am planning to do a maintenance for tr_hist table(binary dump and load followed by index rebuild).
Table tr_hist is in 25th storage area and its indexes in 26th area.
Kindly advice me, Is it good to migrate only these two areas to Type 2 storage area during maintenance period?
Will it improve the overall performance of the database? rest all tables will be in Type 1 storage area.
Any other parameters should i consider before proceeding to Type 2 storage area?
Also advice me about records per blocks for tr_hist i should choose and others if any.
Thanks in advance.
Background information:
-----------------------
Progress Version: 10.1B03
OS: IBM AIX 6.1
DB size: 100GB
DB block size: 8192
Some DB Parameters:
-B 50000
-L 100000
-c 350
-directio
Table analysis report:
RECORD BLOCK SUMMARY FOR AREA "TRHIST" : 25
-------------------------------------------------------
-Record Size (B)- ---Fragments--- Scatter
Table Records Size Min Max Mean Count Factor Factor
PUB.tr_hist 49931806 14.7G 223 405 316 50160485 1.0 4.7
DB Structure file(Few lines):
-------------------------------------
d "TRHIST":25,64;1 /db1/db_25.d1 f 819200
d "TRHIST":25,64;1 /db1/db_25.d2 f 819200
d "TRHIST":25,64;1 /db1/db_25.d3 f 819200
d "TRHIST":25,64;1 /db1/db_25.d4 f 819200
d "TRHIST_IDX":26,32;1 /db/db_26.d1 f 400000
d "TRHIST_IDX":26,32;1 /db/db_26.d2 f 400000
d "TRHIST_IDX":26,32;1 /db/db_26.d3 f 400000
d "TRHIST_IDX":26,32;1 /db/db_26.d4 f 400000