IBM Mainframe Forum

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

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

translate to an understandable measure unit

enrico-sorichetti wrote:

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

translate to an understandable measure unit

one hundred lakhs

And given the origins of the TS, a "Wij runderen, wij glunderen" is not out of place.

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.

Have you used the EXPLAIN DB2 statement to assist you?
https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/db2z_sql_explain.html