Db2 Database Error 904
Contents |
-904, ERROR: UNSUCCESSFUL EXECUTION IBM's flagship relational database management system Post a reply Previous topic • Next topic • 8 posts • Page 1 of 1 SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION by thiagorr » Wed Nov 26, 2008
Db2 Sql Error Sqlcode=-803
9:47 am Hi!I'm creating 6 tables on a DB, with a few indexes and constraints...When I'm db2 sql error sqlcode=-922 almost finishing, I can't use nothing else on these tables!Not the INSERT, neither INSERT commands are allowed!This is the return when a try db2 sql error sqlcode=-913 de SELECT command, for example:Select allDSNE610I NUMBER OF ROWS DISPLAYED IS 0 DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n904.html CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00C900A3, TYPE OF RESOURCE 00000200, AND RESOURCE NAME SMDB026 .SMTS026 DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXRRC SQL PROCEDURE DETECTING ERROR http://www.ibmmainframeforum.com/db2/sqlcode-unsuccessful-execution-t1321.html DSNT416I SQLERRD = 102 13172746 0 13223106 -974970878 12714050 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'00000066' X'00C9000A' X'00000000' X'00C9C4C2' DSNE618I ROLLBACK PERFORMED, SQLCODE IS 0 DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0 ---------+---------+---------+---------+---------+---------+-----DSNE601I SQL STATEMENTS ASSUMED TO BE BETWEEN COLUMNS 1 AND 72 DSNE620I NUMBER OF SQL STATEMENTS PROCESSED IS 1 DSNE621I NUMBER OF INPUT RECORDS READ IS 4 DSNE622I NUMBER OF OUTPUT RECORDS WRITTEN IS 26 I tried to use the CHECK DATA utility, but I think I must be doing something wrong.Could someone help me, please! thiagorr Posts: 12Joined: Wed Sep 10, 2008 11:23 pm Hasthanked: 0 time Beenthanked: 0 time Top Re: SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION Top Re: DATA CHECK by dick scherrer » Wed Nov 26, 2008 10:17 am Hello,I'm creating 6 tables on a DB, with a few indexes and constraints...Were the tables created successfully? Post the output that s
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 SQLCODE -904 during insert Carlton http://www.idug.org/p/fo/et/thread=3728 Enuda SQLCODE -904 during insert August 2, 2000 10:38 AM Hi list, Attempt to http://stackoverflow.com/questions/17297845/what-is-the-difference-between-db2-sql-codes-913-and-904-with-an-example insert a row into a table produces a -904 reason code 200. I checked the status of the tablespace and it is "A"ctive. I also checked the status for the table and it is blank (no parent index defined): (1) The catalog space column for the tablespace is zero '0' and I'll like to know db2 sql if perhaps that is the reason for the -904 error I get while trying to insert into this table? (2) During load process for the same table, I receive a DSNU012 with return code = 8. I examine utility output for other error messages but nothing there could point me to the probable cause. Anybody come across this problem? Your response will be greatly appreciated. Carlton ________________________________________________________________________ Get Your Private, db2 sql error Free E-mail from MSN Hotmail at http://www.hotmail.com craig patton Re: SQLCODE -904 during insert August 2, 2000 11:08 AM (in response to Carlton Enuda) Carlton, Can you print more of the message? The '0' in the catalog for space is NOT the cause of your problem. Check to see how many extents you have for your VSAM file, check the DASD volume it is allocated to and make sure there is space available for another extent. Is this STOGROUP or VSAM defined? (A 'Y' in the IMPLICIT column in SYSTABLESPACE indicates that it was created using a STOGROUP.) If using a STOGROUP, check that all the volumes have space. I have found that most problems with a -904 and all objects are in 'normal' mode, is caused by some sort of space problem for 1 of the VSAM files being used for either the TS or 1 of the indexes. HTH, Craig Patton >From: Carlton Enuda <[login to unmask email]> >Reply-To: DB2 Data Base Discussion List <[login to unmask email]> >To: [login to unmask email] >Subject: SQLCODE -904 during insert >Date: Wed, 2 Aug 2000 11:38:36 EDT > >Hi list, >Attempt to insert a row into a table produces a -904 reason code 200. I >checked the sta
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up What is the difference between DB2 sql codes -913 and -904 with an example? [closed] up vote -3 down vote favorite What is the difference between DB2 sql codes -913 and -904 with an example? db2 share|improve this question edited Jun 25 '13 at 14:09 Leons 1,186918 asked Jun 25 '13 at 12:50 Rahul khandelwal 112 closed as too broad by Andrew Barber Sep 4 '13 at 20:56 There are either too many possible answers, or good answers would be too long for this format. Please add details to narrow the answer set or to isolate an issue that can be answered in a few paragraphs.If this question can be reworded to fit the rules in the help center, please edit the question. add a comment| 2 Answers 2 active oldest votes up vote 2 down vote An SQL code of -913 is UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT. REASON CODE reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME resource-name An SQL code of -904 is UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME resource-name A -913 is a deadlock, or two programs trying to get the same resource. The classic example is program 1 updating table B, then A; and program 2 updating table A, then B. Neither program can get to the second resource, so you have a deadlock. To prevent this, all of your programs m