Error In Db2 Estimated Processor Cost Of 000000545689 Processor Seconds
Events Forums DB2-LDB2-L ArchivesNA ConferenceEMEA Conference Resources BlogsIDUG eBulletinIDUG NewsroomCommunitiesRegional User Groups Articles&Content IDUG Content ArticlesTech ChannelBeginner's BlogDB2 Hot Topics BlogContent LibraryIDUG YouTubePast Conference ContentCodeplace Library GetInvolved Volunteering with IDUGVolunteer PositionsJoin a Regional User GroupBecome an IDUG MentorSponsorship OpportunitiesJoin a CommunitySpeaker Community Strange problem Pascal Plessis Strange problem August 14, 2003 04:19 PM Heeeeeelp!!!! When I set the resource limiter in predictive mode and run a SQL against it, I get the following message:- Error: SQL0495N Estimated processor cost of "000000000001" processor seconds ("000000005584" service units) in cost category "A" exceeds a resource limit error threshold of "000000000000" service units. SQLSTATE=57051 (State:57051, Native Code: FFFFFE11) I then run the same SQL in re-active mode (the resource limiter is set to 99000 service units) and I get the following error message:- Error: SQL0905N Unsuccessful execution due to resource limit being exceeded. Resource name = "ASUTIME", limit = "000000000026" CPU seconds ("000000099000" service units) derived from "SYSIBM .DSNRLST01". SQLSTATE=57014 (State:57014, Native Code: FFFFFC77) How is this possible? Regards Pascal International DB2 Users Group 330 North Wabash, Suite 2000 | Chicago, IL 60611-4267 Phone: (312) 321-6881 | Fax: (312) 673-6688 Copyright © 2016 IDUG. All Rights Reserved. All material , files, logos, and trademarks within this site are properties of their respective organizations. Terms of Service | Privacy Policy | Contact×OKCancel
be down. Please try the request again. Your cache administrator is webmaster. Generated Mon, 10 Oct 2016 04:23:48 GMT by s_ac5 (squid/3.5.20)
be down. Please try the request again. Your cache administrator is webmaster. Generated Mon, 10 Oct 2016 04:23:48 GMT by s_ac5 (squid/3.5.20)
be down. Please try the request again. Your cache administrator is webmaster. Generated Mon, 10 Oct 2016 04:23:48 GMT by s_ac5 (squid/3.5.20)