Environment:  CLM 3.0.1.3 consisting of 3 JTS (2 WAS, 1 TC), numerous CCM applications registered to the 3 JTS.   AIX 6.1; DB2 v9.7 FP6.   DB2 FP6 applied Sept 2, 2012.

Situation:  Customer reports data points being added to warehouse data only on alternate days.  I have confirmed this via looking at the Data Collection Job status.  I've checked several of the CCM applications and this right now only appears to be associated with those that are registered to "jts02" in our environment.

I checked the settings in the Advanced settings on the application admin page; the value for the snapshot delays are their default of 86400.   

But wait  the infamous Star warehouse job on the JTS is over 24h in duration:

Succeeded    Common    Sep 12, 2012 11:59 PM    Sep 13, 2012 12:00 AM    4 seconds
Succeeded    Star    Sep 11, 2012 3:00 AM    Sep 12, 2012 6:54 AM    1 day, 3 hours
Succeeded    Common    Sep 10, 2012 11:59 PM    Sep 11, 2012 12:00 AM    3 seconds
Succeeded    Star    Sep 9, 2012 2:45 AM    Sep 10, 2012 5:27 AM    1 day, 2 hours
Succeeded    Common    Sep 8, 2012 11:59 PM    Sep 9, 2012 12:00 AM    3 seconds
Succeeded    Star    Sep 7, 2012 3:14 AM    Sep 8, 2012 5:28 AM    1 day, 2 hours
Succeeded    Common    Sep 6, 2012 11:59 PM    Sep 7, 2012 12:00 AM    4 seconds
Succeeded    Star    Sep 5, 2012 3:28 AM    Sep 6, 2012 3:30 AM    1 day, 2 minutes
Succeeded    Common    Sep 5, 2012 12:10 AM    Sep 5, 2012 12:10 AM    4 seconds
Succeeded    Star    Sep 3, 2012 2:43 AM    Sep 4, 2012 1:14 AM    22 hours, 31 minutes

So, I'm thinking I've answered my own question ...  

However, this JTS has no QM or RM registered so is the Star job really needed ?   I reported poor performance of this job last year (I think fix is out in v4), but we're not there yet. 

TIA,

Kevin