Hi All,
We have been reviewing our Delete / Archive procedures, or non use of the
exisitng programs, in order to determine what strategies to employ in
setting up automated delete / archives.
Currently we have the following large tables, consisting of data that in
some cases is over two years old.
<BLOCKQUOTE><font size="1" face="Arial, Verdana">quote:</font><HR>
# ---Record Size--- ---Fragments--- Scatter
#Table Records Bytes Min Max Mean Count Factor Factor
qad_wkfl 121093 10529364 70 227 86 121093 1.0 3.5
wr_route 132245 34410173 217 364 260 132463 1.0 5.6
ps_mstr 174750 18737162 97 162 107 174750 1.0 3.3
iro_det 264017 21244328 57 117 80 264017 1.0 3.2
schd_det 285714 22756646 66 116 79 285714 1.0 3.1
sct_det 408126 22488365 44 116 55 408126 1.0 3.0
opgl_det 608718 46179884 54 94 75 608718 1.0 2.8
gltw_wkfl 827990 75793537 74 112 91 827990 1.0 2.1
grig_mtx 1124546 51200110 25 60 45 1124569 1.0 3.6
spt_det 2040650 95995962 36 69 47 2040650 1.0 2.3
tr_hist 2405342 571027256 193 332 237 2405344 1.0 2.3
trgl_det 2819681 204386948 38 93 72 2819681 1.0 2.1
op_hist 3740308 728556425 158 251 194 3740308 1.0 1.8
gltr_hist 6386949 808121109 83 159 126 6386949 1.0 1.8
# ------------------------------------------------------------
#Totals: 23163698 2856224k 10 1147 126 23164769 1.0 3.9
<HR></BLOCKQUOTE>
The databse is:
HP/UX 10.20
Progress 8.2b
MFG/Pro 8.5g
What we are trying to determine is:
What do other MFG/Pro users do with regard to doing delete/archives on the
GL history detail?
How often are the archives done?
How many months are kept un-archived?
How are the archives stored?
I have suggested keeping them in gzipped format and having a script
available to allow data to be extracted automatically, by unzipping the
files, grepping for the data and extracting into a temp file which would be
emailed to the user. Then zipping the files again (brief overview).
How easily is it to get at archived data?
Is data archived in monthly groups or more / less?
What about the other files, specifically op_hist and tr_hist.
What rules are applied to these (above questions)?
Any other strategies of information would be apprreciated. We are trying to
build a case for doing mothly archives and keeping at most 13 months worth
of gltr_hist + summarised data. The op_hist and tr_hist I would like to cut
down to less than a year, perhaps only 6 months.
TIA
Robert Cohen
Fisher Gauge Limited
Peg # 1999081601
We have been reviewing our Delete / Archive procedures, or non use of the
exisitng programs, in order to determine what strategies to employ in
setting up automated delete / archives.
Currently we have the following large tables, consisting of data that in
some cases is over two years old.
<BLOCKQUOTE><font size="1" face="Arial, Verdana">quote:</font><HR>
# ---Record Size--- ---Fragments--- Scatter
#Table Records Bytes Min Max Mean Count Factor Factor
qad_wkfl 121093 10529364 70 227 86 121093 1.0 3.5
wr_route 132245 34410173 217 364 260 132463 1.0 5.6
ps_mstr 174750 18737162 97 162 107 174750 1.0 3.3
iro_det 264017 21244328 57 117 80 264017 1.0 3.2
schd_det 285714 22756646 66 116 79 285714 1.0 3.1
sct_det 408126 22488365 44 116 55 408126 1.0 3.0
opgl_det 608718 46179884 54 94 75 608718 1.0 2.8
gltw_wkfl 827990 75793537 74 112 91 827990 1.0 2.1
grig_mtx 1124546 51200110 25 60 45 1124569 1.0 3.6
spt_det 2040650 95995962 36 69 47 2040650 1.0 2.3
tr_hist 2405342 571027256 193 332 237 2405344 1.0 2.3
trgl_det 2819681 204386948 38 93 72 2819681 1.0 2.1
op_hist 3740308 728556425 158 251 194 3740308 1.0 1.8
gltr_hist 6386949 808121109 83 159 126 6386949 1.0 1.8
# ------------------------------------------------------------
#Totals: 23163698 2856224k 10 1147 126 23164769 1.0 3.9
<HR></BLOCKQUOTE>
The databse is:
HP/UX 10.20
Progress 8.2b
MFG/Pro 8.5g
What we are trying to determine is:
What do other MFG/Pro users do with regard to doing delete/archives on the
GL history detail?
How often are the archives done?
How many months are kept un-archived?
How are the archives stored?
I have suggested keeping them in gzipped format and having a script
available to allow data to be extracted automatically, by unzipping the
files, grepping for the data and extracting into a temp file which would be
emailed to the user. Then zipping the files again (brief overview).
How easily is it to get at archived data?
Is data archived in monthly groups or more / less?
What about the other files, specifically op_hist and tr_hist.
What rules are applied to these (above questions)?
Any other strategies of information would be apprreciated. We are trying to
build a case for doing mothly archives and keeping at most 13 months worth
of gltr_hist + summarised data. The op_hist and tr_hist I would like to cut
down to less than a year, perhaps only 6 months.
TIA
Robert Cohen
Fisher Gauge Limited
Peg # 1999081601