How to set ASUTIME limit

Khwairakpam Raju Singh · New User Joined: 05 Dec 2007 Posts: 29 Location: Bangalore

Hi ,

I saw in QMF Error messages

Even I am facing same -905 error and I am very new to DB2.

Could anybody suggest me how to set or increase the ASUTIME limit ?

Thanks in advance.

enrico-sorichetti · Posted: Wed Apr 01, 2009 10:27 pm

work it out with Your support

ajeshrn · New User Joined: 25 Mar 2009 Posts: 78 Location: India

CREATE PROCEDURE SYSPROC.application (
IN TABLE_NAME CHAR(10),
OUT REC_COUNT INT
)
ASUTIME LIMIT 500000
LANGUAGE COBOL
COLLID collection_id
EXTERNAL NAME application

through asutime limit parameter in the above query we can change the time

Terry Heinze · Posted: Wed Apr 08, 2009 8:54 pm

As Enrico says, consult with your DB support folks before blindly going ahead. They may have something to say about that modification.

dick scherrer · Posted: Thu Apr 09, 2009 12:51 am

Hello,

One way this is prevented in well-run shops is that stored procedures must be signed off by the dba - which prevents sneaking something in that will use an unacceptable amount of resource.

IMHO, it depends on if the process needs more time because of the amount of real work it does rather than being inefficiently implemented. Better to improve a poor process once than to run it "forever" wasting resources.

This often happens when a "simplest for the programmer" solution is used rather than a proper solution.

It is far more important to learn to implement good code than to learn to get around safeguards. . .

Terry Heinze · Posted: Thu Apr 09, 2009 6:52 am

"It is far more important to learn to implement good code than to learn to get around safeguards. . ."
Totally agree.