logo  
Google
 

DB2 SQL-Error: -495

SQLState: 57051

Short Description: ESTIMATED PROCESSOR COST OF PROCESSOR SECONDS SERVICE UNITS IN COST CATEGORY EXCEEDS A RESOURCE LIMIT ERROR THRESHOLD OF SERVICE UNITS C RLFASUERR RLST I RLFASUERR S T INSERT UPDATE DELETE SELECT P I SQLCODE B M RUNSTATS I UDF INSERT UPDATE DELETE C DSNSTATEMNTTABLE IFCID SQL B I RLFCATEGORYB RLST Y W U I SQL A RLST

The prepare of a dynamic INSERT, UPDATE, DELETE, or SELECT SQL statement resulted in a cost estimate that exceeded the error threshold value specified in the resource limit specification table (RLST). This error is also issued if DB2’s cost category value was “B”, and the default action specified in the RLF_CATEGORY_B column in the RLST is to issue an error. estimate_amount1 The cost estimate (in processor seconds) if the prepared INSERT, UPDATE, DELETE or SELECT statement were to be executed. estimate_amount2 The cost estimate (in service units) if the prepared INSERT, UPDATE, DELETE or SELECT statement were to be executed. cost-category DB2’s cost-category for this SQL statement. The possible values are A or B. limit-amount The error threshold (in service units) specified

 <-  BACK TO INDEX