Fatal error

samsuf2002 · Post by **samsuf2002** » Tue Apr 22, 2008 1:09 pm

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.

kcbland · Post by **kcbland** » Tue Apr 22, 2008 1:33 pm

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.

samsuf2002 · Post by **samsuf2002** » Tue Apr 22, 2008 1:52 pm

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 ?

kcbland · Post by **kcbland** » Tue Apr 22, 2008 2:01 pm

totally database

savis · Post by **savis** » Tue Apr 22, 2008 3:23 pm

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