MVSFORUMS.com

aquarian · Posted: Mon Nov 21, 2005 6:39 am Post subject: SQL code -495

Hi frnds,
I am geting SQL code -495 when trying to insert or browse tables through File-Aid for DB2 ?? what does this mean? Embarassed

_________________
cheers,
Aquarian

kolusu · Posted: Mon Nov 21, 2005 8:00 am Post subject:

aquarian,

Check this link which explains in detail about the sql code -495

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNMCH11/2.1.6.188?SHELF=&DT=20010718150520&CASE=

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

aquarian · Posted: Mon Nov 21, 2005 8:13 am Post subject:

Thanks kolusu ,
I am giving some more desc about the error

SQLCODE = -495, ERROR: ESTIMATED PROCESSOR COST OF 000000002047
PROCESSOR SECONDS (000038618432 SERVICE UNITS) IN COST CATEGORY A
EXCEEDS A RESOURCE LIMIT ERROR THRESHOLD OF 000018774000 SERVICE
UNITS
_________________
cheers,
Aquarian

aquarian · Posted: Mon Nov 21, 2005 8:15 am Post subject:

Thanks for the link kolusu, as i am new to DB2 coulld u please eloborate this in a defined way

"ask the administrator to increase the error threshold value in the RLST."
_________________
cheers,
Aquarian

kolusu · Posted: Mon Nov 21, 2005 11:57 am Post subject:

aquarian,

You need to contact your DBA and ask him to raise the threshold limit

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu