Db2 Sql Error Sqlcode=-905
Contents |
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 Question on sqlcode -905 sqlstate
Sqlcode 905 Sqlstate 57014 In Db2
57014 Mera Nadu Question on sqlcode -905 sqlstate 57014 December 18, 2008 10:23 AM
Db2 Sql Error Sqlcode List
Cobol stored procedure that MESH has informed me abended on a -905 Sqlcode -905 A resource limit as determined from the db2 sql error sqlcode 305 active resource limit specification table has been exceeded. Sqlstate 57014 Processing was canceled as requested. I have sqlcode checking in the Cobol stored procedure which should trap any error and write a row to a http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n905.html stats table. However, it looks like the stored proc is not trapping the error in this case and execution was cancelled (per the sqlstate). I just wanted to make sure this is a normal behavior: sometimes control isn't given back to a stored procedure and there's no way of trapping those sqlcodes I appreciate all your comments.. Thanks Mera ______________________________________________________________________ * IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://www.idug.org/p/fo/et/thread=33225 http://IDUG.ORG/lsNA * ______________________________________________________________________ The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms Phil Grainger Re: Question on sqlcode -905 sqlstate 57014 December 18, 2008 11:12 AM (in response to Mera Nadu) As far as I understand the workings of a -905, is that DB2 says "I don't trust you any more - you are using too much resources, so I will terminate you" - I don't think the application gets a chance to trap the -905, I think the thread itself is terminated by DB2 Phil Grainger CA Senior Principal Product Manager Phone: +44 (0)1753 577 733 Mobile: +44 (0)7970 125 752 eMail: [login to unmask email] Ditton Park Riding Court Road Datchet Slough SL3 9LL CA plc a company registered in England and Wales under company registration number 1282495 with its registered office at the address set out above. VAT numbe
for empty file If the VSAM is empty then copy job abends Copying files from Tapes to DASD Low values to Spaces using SORT Difference Between Catalog and http://mainframewizard.com/content/sql-code-905 Instream Procs Maximum Exec Statements in a JCL COBOLSmallest Program RENAME CLAUSE REDEFINE CLAUSE EDITED PICTURE ACCEPT and DISPLAY ADD VERB SUBTRACT VERB MULTIPLY VERB DIVIDE VERB Initialize a filler in cobol COBOL Allowed Moves COBOL PERFORM PARA EVALUATE ARITHMETIC EXPRESSION EVALUATE CONDITIONAL EXPRESSION EVALUATE FALSE EVALUATE IDENTIFIER EVALUATE LITERAL EVALUATE TRUE EVALUATE TRUE ALSO TRUE GO TO DEPENDING ON INLINE PERFORM INSPECT REPLACING db2 sql ALL SPACES BY LITERAL INSPECT REPLACING CHARACTERS BY LITERAL BEFORE INITIAL LITERAL INSPECT REPLACING LEADING SAPCES BY LITERAL INSPECT TALLYING FOR ALL IDENTIFIER INSPECT TALLYING FOR ALL LITERAL INSPECT TALLYING FOR ALL SPACES INSPECT TALLYING FOR CHARACTER INSPECT TALLYING FOR CHARACTER AFTER INITIAL SPACES INSPECT TALLYING FOR CHARACTER BEFORE INITIAL SPACES INSPECT TALLYING FOR LEADING SPACES INSPECT TALLYING FOR LEADING ZEROES JUST RIGHT db2 sql error CLAUSE PERFORM THRU PERFORM TIMES PERFORM UNTIL PERFORM VARYING UNTIL PERFORM WITH TEST BEFORE PERFORM WITH TEST AFTER DIFFERENCE BETWEEN STRING and MOVE STRING DELIMITED BY IDENTIFIER STRING DELIMITED BY LITERAL STRING DELIMITED BY SIZE STRING DELIMITED ON OVERFLOW STRING DELIMITED WITH POINTER UNSTRING DELIMITED BY IDENTIFIER UNSTRING DELIMITED BY LITERAL UNSTRING DELIMITED ON OVERFLOW UNSTRING DELIMITED WITH POINTER OPTION COBOL TO RECEIVE DATA FROM JCL DIFFERENCE BETWEEN SEARCH AND SEARCH ALL DB2DB2 query to select first or last N rows Description of a DB2 Table Difference in number of days CONTOKEN Verification Update Table using other Table Update a column using other column in Table Adding Primary Key on exisitng DB2 Table Alias of DB2 Table Changing the primary key on existing DB2 Table Compile and Link JCL for COBOL Create a DB2 Table Creating Primary Key while creating DB2 Table Delete Duplicate Rows from DB2 Table Drop Index of a DB2 Table Drop Primary Key on DB2 Table Drop Table DB2 How to Find the Length of a DB2 Table SELECT INTO Synonym of DB2 Table What is a db2 package? What is db2 plan What