Slowness in fetching data from DB2



IBM's flagship relational database management system

Slowness in fetching data from DB2

Postby coolsaurabh » Tue Jun 06, 2017 9:49 am

Hi,

Currently we are facing one issue in which there is slowness in fetching the data from DB2.We have configured reports in cognos to fetch the data from DB2 which is taking approx 12-14 hours to fetch one day data from table which contains 45 days of data.

During the preliminary investigation I found that the table is containing approx 9Cr rows. Could it be the reason for the slowness ??

If yes,than what are the best possible alternatives can be implemented to overcome this slowness.(Pls keep in mind that this is customer data so cant delete it).

Is it feasible to rename this table or to move whole data from one table to another table???

Pls advice.

Thanks,
Saurabh
coolsaurabh
 
Posts: 1
Joined: Tue Jun 06, 2017 9:45 am
Has thanked: 0 time
Been thanked: 0 time

Re: Slowness in fetching data from DB2

Postby enrico-sorichetti » Tue Jun 06, 2017 10:33 am

I found that the table is containing approx 9Cr rows.

translate to an understandable measure unit
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Slowness in fetching data from DB2

Postby prino » Tue Jun 06, 2017 2:26 pm

enrico-sorichetti wrote:
I found that the table is containing approx 9Cr rows.

translate to an understandable measure unit

one hundred lakhs :mrgreen:

And given the origins of the TS, a "Wij runderen, wij glunderen" is not out of place. :mrgreen:
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
User avatar
prino
 
Posts: 635
Joined: Wed Mar 11, 2009 12:22 am
Location: Vilnius, Lithuania
Has thanked: 3 times
Been thanked: 28 times

Re: Slowness in fetching data from DB2

Postby Robert Sample » Tue Jun 06, 2017 6:08 pm

It is possible that the size of the table is slowing it down some. However, it is MUCH more likely that the query is coded poorly and does not use the index(es) to retrieve the data. 90 million rows is not a huge DB2 table -- I've heard of tables with 2 billion or more rows which don't seem to have any significant delays in retrieval.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: Slowness in fetching data from DB2

Postby Terry Heinze » Tue Jun 06, 2017 6:36 pm

.... Terry
Terry Heinze
 
Posts: 239
Joined: Wed Dec 04, 2013 11:08 pm
Location: Richfield, MN, USA
Has thanked: 12 times
Been thanked: 11 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post