This task will have to be done individually on each of the loggers and any HDSs that exist. This doesn't really answer your question though.
ICM/IPCC v5.0 requires that Webview reporting option be installed on top of a Distributor AW that has the HDS option enabled. ALL _historical_ reporting queried by users to any HDS server will stay local and use the ‘instance’_HDS Db as its source. Under no circumstances will a Webview historical report query use the logger for its source. Modifying the HDS retention values will impact how much data exists for the Webview query to run with. Obviously this gets complicated with more than one HDS/Webview server (i.e. retention periods being equal, replication feed sources – sideA or sideB, etc.).
ICM/IPCC v5.0 default retention values are 14 days for the Logger Dbs (‘instance’_SideX) and 365 days for HDS Dbs (‘instance’_HDS Dbs). The suggestion is to be extremely cautious in modifying the Logger Db retention periods as the logger has other jobs in life – don’t cut his leg off with a monster size Db.
You mention that you made a change but there is still only 2 weeks of data (which is matching the Logger retention periods). Any chance that you’re using a version of ICM/IPCC prior to v5.0? Also, just to cover the obvious, any changes to HDS retention to a greater value only starts from that point forward. An already running HDS won’t go back in time even if the data exists on the logger. For example, HDS has 30 days of retention and the logger has 100 – you change the HDS to 100. Tomorrow the HDS will have 31 days in the Db, the next day – 32 and so on. It won’t go grab the ‘missing’ 70 past days from the logger.
Prior to ICM/IPCC v5.0, one could install Webview without the requirement of installing it onto an HDS; it just had to be a Distributor AW. This confuses things.
Say for example that HDS1 (Distributor AW w/ Webview and HDS options) is pointed to LoggerA for the replication feed and AW1 (Distributor AW w/ Webview option) is pointed to LoggerB for its feed (obviously no replication). The same query run against HDS1 (which is using the local ‘instance’_HDS Db for the report) and AW1 (which is using LoggerB’s ‘instance’_SideB Db for the report) will most certainly have different [typically slight] results since their sources are from different roots.
I find that most customers are satisfied with 15 day retention on the Loggers (this way we know that they can run a 2 week report if they had to – say via ODBC if there was a major HDS failure). Then set a 65 day retention on all HDSs (again, easily covers 2 full months). It all depends upon the volume of data being collected – an ICM/IPCC user that has 5,000 calls a day will have a much different database signature verses one with 1,000,000 calls per day (which is a discussion for a different post). Leave the loggers alone and increase the HDSs to your needs (watch your available space though and mind the 80%).
/Jeff
Jeffrey.marshall@us.didata.com
P.S. Retention is just registry keys, this doc explains the map: http://www.cisco.com/en/US/partner/products/sw/custcosw/ps1001/products_tech_note09186a008014f8b9.shtml
