Converting report studio reports from Cognos 8.1 using DB2 to 8.4 using teradata. Noticing same reports and basic table/view structure are slower on teradata. Anyone know of any tuning settings to pay attention to or adjust? Afinity settings have been set accordingly, have tried to set up concurrent queries which may or may not be helping (not sure), Connection Pool and timeout (which helps some), but still fairly slower than DB2 (10 seconds vs. 45 seconds generally)
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Cognos 8.4 using Teradata
- Thread starter derdor
- Start date
Similar threads
- Locked
- Question
- Locked
- Question