Db2 Error Code=-904 Sqlstate=57011
Contents |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
Db2 Sql Error Sqlcode=-911
To start viewing messages, select the forum that you want to visit from db2 sql error sqlcode=-905 the selection below. Results 1 to 5 of 5 Thread: Sqlcode = -904, Error: Unsuccessful Execution Caused By An Unavailable Resour
Sqlcode 90m Db2
Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 08-18-03,17:50 #1 tvuma12 View Profile View Forum Posts Registered http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n904.html User Join Date Aug 2003 Posts 1 Unanswered: Sqlcode = -904, Error: Unsuccessful Execution Caused By An Unavailable Resour Hi, I tried to insert one rows in the DB2 Table and got the following error. INSERT INTO SMPAPA2.PPMMSS_FACLTY 0022009 (FACLTY_IDENT_NBR, LAST_UPDATE, LAST_TRANSMISSION, 0023009 RECORDS_RECEIVED, FILE_STATUS, SEQUENCE_NBR, INT_TYPE) 0024009 VALUES 0025009 (17787, CURRENT TIMESTAMP, CURRENT TIMESTAMP, 0, ' ', 0, 'P'); 0026009 ---------+---------+---------+---------+---------+---------+---------+--------- DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED http://www.dbforums.com/showthread.php?887937-Sqlcode-904-Error-Unsuccessful-Execution-Caused-By-An-Unavailable-Resour BY AN UNAVAILABLE RESOURCE. REASON 00C90097, TYPE OF RESOURCE 00000200, AND RESOURCE NAME SMPAPA12.S020 DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXRUID SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -110 13172746 0 13223106 -974970879 12714050 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFFF92' X'00C9000A' X'00000000' X'00C9C4C2' X'C5E32001' X'00C20042' SQL DIAGNOSTIC INFORMATION ---------+---------+---------+---------+---------+---------+---------+--------- DSNE618I ROLLBACK PERFORMED, SQLCODE IS 0 Thanks Uma Reply With Quote 08-19-03,03:30 #2 sathyaram_s View Profile View Forum Posts Visit Homepage Super Moderator Join Date Aug 2001 Location UK Posts 4,650 Re: Sqlcode = -904, Error: Unsuccessful Execution Caused By An Unavailable Resour Uma Please look at the message reference for your platform .. The resource type 200 refers to TableSpace The reason code 00C90097 Explanation: An attempt was made to allocate to a table space for update operations. However, the table space was marked as 'image copy' required, and updates are not allowed. This condition occurs as a result of any of the following: Running a REORG LOG NO or LOAD LOG NO utility on the table space without running a copy that specifies FULL YES. Execution of a RECOVER utility which specifies the TORBA or TOCOPY options, without following it with the required COPY utility. Execution of a -TERM UTILITY comman
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 Enuda SQLCODE -904 during insert August http://www.idug.org/p/fo/et/thread=3728 2, 2000 10:38 AM Hi list, Attempt to 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 https://www.scribd.com/doc/2191596/List-of-SQLCODES-for-DB2 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 if perhaps that is the reason for the -904 error I get db2 sql 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, Free E-mail from MSN Hotmail at http://www.hotmail.com craig patton Re: SQLCODE -904 during insert August 2, 2000 11:08 db2 sql error 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 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'
allUploadSign inJoinBooksAudiobooksComicsSheet Music SQLCODES for DB2 Version 7 Scroll down to see ALL the SQLCODES there are in Version 7.The most common onesare at the top.SQLCODE +100SQLSTATE 02000Row not found or end of cursorSQLCODE -102String constant is too longSQLCODE -117 The number of values you are trying to INSERT does not match thenumber of columnsSQLCODE -180SQLSTATE 22007Bad data in Date/Time/TimestampString representation of DATE, TIME, TIMESTAMP is invalidSQLCODE -181SQLSTATE 22007Bad data in Date/Time/TimestampValue for DATE, TIME, TIMESTAMP is invalidSQLCODE -199Illegal use of the specified keyword.SQLCODE -204Object not defined to DB2SQLCODE -205Column name not in specified tableSQLCODE-206Column does not exist in any table in the SELECTSQLCODE -216 You need to use the same number of expressions on both sides of thecomparison.when using multiple operands in a comparison,Correct example:WHERE (E.SALARY, E.COMM) IN(SELECT S.PAY, S.COMMISSIONIncorrect example:WHERE (E.SALARY, E.COMM, E.BONUS )IN(SELECT S.PAY, S.COMMISSION SQLCODE +222 Trying to fetch a row that fell through a DELETE holeSQLCODE +223 Trying to fetch a row that fell through an UPDATE holeSQLCODE -224FETCH cannot make an INSENSITIVE cursor SENSITIVESQLCODE -229 The locale specified in a SET LOCALE statement was not found.SQLCODE +231FETCHbut you did a BEFORE or AFTER and you are not on a valid rowSQLCODE +304Value cannot be assigned to this host variable because it is out of rangeSQLCODE -305Null indicator neededSQLCODE -311Varchar, insert or update. You didn’t set the -LEN field with the right datalengthSQLCODE -482 The procedure returned no locatorsSQLCODE -501Cursor not open on FETCHSQLCODE -502Opening cursor that is already openSQLCODE -503Updating column which needs to be specified in FOR UPDATE OFSQLCODE -530SQLSTATE 23503Referential integrity prevents the INSERT/UPDATESQLCODE -532SQLSTATE 23504Referential integrity (DELETE RESTRICT rule) prevents the DELETE SQLCODE -536SQLSTATE 42914Referential integrity (DELETE RESTRICT rule) prevents the DELETESQLCODE -545SQLSTATE 23513Check constraint prevents the INSERT/UPDATESQLCODE -747 The table specified is not available because tables and/or indexes need to becreated.SQLCODE +802 The null indicator was set to -2 because an arithmetic statement didn't work.SQLCODE -803SQLSTATE 23505Duplicate key on insert or updateSQLCODE -805DBRM or package not found in planIs plan name correct?SQLCODE