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