S&P performance DB/2 vs. SQL Server as TDWH
<[email protected]> Mon, 19 Aug 2013 12:08:01 +0000
| Newsgroups | gmane.comp.sysutils.tivoli.general |
|---|---|
| Message-ID | <EA5FD7F404DE694BB310D050B12764961E971270__4052.49487744204$1376914113$gmane$org@WFS0138A.corp1.ad1.seb.net> |
Hi. We recently changed DB engine from SQL server to DB/2 for our Windows TDWH. S&P has always been run on the same box which is hosting the DB. On the same W2K8 12 GB ram Quad 2.28Ghz box, we went from 9 hours S&P to 9 minutes!! How can this be possible? Has IBM tuned the S&P agent extremely well for DB/2. Initally I thought that times would increase along with the DB content, but now we have been running as long as our longest summarization and we still see around 10 min.s /Gus _______________________________________________ TME10 mailing list [email protected] Unsubscribe:[email protected]