icon purging

[lekie]

Dear All,

Have someone use to do puring?
I have problem about purging on icon 7.5.000.22
I try to purge data but when I do purging the store procedure as below
[b]declare @COUNT_DAYS int
set @COUNT_DAYS = 15
exec gsysPurgeIR @COUNT_DAYS[/b]
the data is not gone...but it didn't show an error anything.

In document, There are 4 procedure I have to do.
• gsysPurgeIR—Purges Interaction Records (IRs).
• gsysPurgeUDH—Purges User Data History (UDH) data
• gsysPurgeLS—Purges Agent Login Session (ALS) data
• gsysPurgeOS—Purges Outbound data

I can do just only this "gsysPurgeLS" procedure.
How can I check it? and I have to do Merge before right?
There is an icon a site.

Thank you in advance,
Lekie

[eugene]

Lekie, it's pretty easy actually not sure how you'll implement yours but I scheduled mine via DBMS_JOB package to run daily as such:

gsysPurgeIR(14);
gsysPurgeUDH(14);
gsysPurgeLS(14);
gsysPurgeOS(14);

In your case, just change to 15 for 15 days.

Try running the below sql from your IDB instance and see if the purging went okay:

select * from G_LOG_MESSAGES
where appname like '%Purge%'
order by 3 desc

Yes you need to have the merging procedure ran so the old data can become valid for purging.

eugene