DSXchange

I am running a job which extract data from DB2 stage in which i am joining 3 tables, with a look up using hash file and finally loading into seq file. Table has 7 million records and hash file has 1 million.My job got aborted with this fatal after loading 4 million recs-

"src_cog005_ext_TW1tbl_DSN2..Trn: [IBM][CLI Driver][DB2] SQL0905N Unsuccessful execution due to resource limit being exceeded. Resource name = "ASUTIME", limit = "000000000253" CPU seconds ("000003333000" service units) derived from "SYSIBM.DSNRLST01". SQLSTATE=57014"

SQLFetch: Error retrieving results from server.



Can any one help me onthis. Thanks in advance.

Your query took too long and the database killed it automatically. Either optimize the query, remove impediments to the flow of data out of the database, or request more time on those tables to run the queries.

Thanks kcbland for your response. My query is just joining 3 tables and as you asked to increase the request time on that query, does it have to do from datastage job or from database side ?

totally database

Hi,

I remember reading somewhere that if the size of the lookup file is too high, the performance goes down.

Instead can you use join?

Thanks,
Saranya