#1: SQL code -495 Author: aquarian, Location: MarsPosted: Mon Nov 21, 2005 6:39 am — Hi frnds,
I am geting SQL code -495 when trying to insert or browse tables through File-Aid for DB2 ?? what does this mean?
#2: Author: kolusu, Location: San JosePosted: Mon Nov 21, 2005 8:00 am — aquarian,
Check this link which explains in detail about the sql code -495
#3: Author: aquarian, Location: MarsPosted: Mon Nov 21, 2005 8:13 am — 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
#4: Author: aquarian, Location: MarsPosted: Mon Nov 21, 2005 8:15 am — 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."
#5: Author: kolusu, Location: San JosePosted: Mon Nov 21, 2005 11:57 am — aquarian,
You need to contact your DBA and ask him to raise the threshold limit
