Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: kevinwang on August 23, 2012, 02:55:04 AM

Title: WHY GIDB TABLE CAN NOT BE PURGED
Post by: kevinwang on August 23, 2012, 02:55:04 AM
The following is from GIm log:

02:45:02.921 Trc 30000 Purge parameters:
EXTRACT_HWM            : 2011-04-15 00:30:24(1302827424)
purge-gidb-facts      : 2011-04-15 00:00:00(1302825600), days-to-keep=1
purge-gim-facts        : 2010-03-12 00:00:00(1268352000), days-to-keep=400
purge-active-facts    : 2009-08-24 00:00:00(1251072000), days-to-keep=600
NOW                          : 2012-05-25 02:45:02(1337913902)
purge-discards-and-job-history: 2010-10-04 00:00:00(1286150400), days-to-keep=600
02:45:02.953 Trc 30000 Purge Tree:

as Log indicates NOW is 2012-05-25, and I set the option days-to-keep-gidb-facts = 1.

why record of  2011-05-01 to 2011-05-31 of table GIDB_G_IR_V can not be purged?

Besides, Where does this EXTRACT_HWM time come from? Does GIM use this time to calculate retention period?


Title: Re: WHY GIDB TABLE CAN NOT BE PURGED
Post by: kevinwang on August 23, 2012, 08:39:11 PM
Does anybody know how  EXTRACT_HWM is related to retention period?
Title: Re: WHY GIDB TABLE CAN NOT BE PURGED
Post by: kevinwang on September 03, 2012, 11:13:05 AM
[quote author=kevinwang link=topic=7379.msg31554#msg31554 date=1345690504]
The following is from GIm log:

02:45:02.921 Trc 30000 Purge parameters:
EXTRACT_HWM            : 2011-04-15 00:30:24(1302827424)
purge-gidb-facts      : 2011-04-15 00:00:00(1302825600), days-to-keep=1
purge-gim-facts        : 2010-03-12 00:00:00(1268352000), days-to-keep=400
purge-active-facts    : 2009-08-24 00:00:00(1251072000), days-to-keep=600
NOW                          : 2012-05-25 02:45:02(1337913902)
purge-discards-and-job-history: 2010-10-04 00:00:00(1286150400), days-to-keep=600
02:45:02.953 Trc 30000 Purge Tree:

as Log indicates NOW is 2012-05-25, and I set the option days-to-keep-gidb-facts = 1.

why record of  2011-05-01 to 2011-05-31 of table GIDB_G_IR_V can not be purged?

Besides, Where does this EXTRACT_HWM time come from? Does GIM use this time to calculate retention period?
[/quote]

why using EXTRACT_HWM to calculate retention period, not current date?
How EXTRACT_HWM is calculated? or where does it come from?

No body knows it?

Thanks in advance.