*Error description** * *DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED B*
*UNAVAILABLE RESOURCE. REASON 00E70081, TYPE OF RESOURC* * RESOURCE NAME HRTST7.PS_EMPL_NAME_SRCH* *DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE* *DSNT415I SQLERRP = DSNXIDMH SQL PROCEDURE DETECTING ERROR* *Cleanup not performed on registered use count entry when we are* *preparing a statement for insertion into the cache, when an* *abend occurs.* *Local fix** * *Problem summary** * ****************************************************************** ** USERS AFFECTED: All DB2 users with systems that have ** ** dynamic statement caching enabled. ** ****************************************************************** ** PROBLEM DESCRIPTION: SQLCODE904 RC00E70081 occurs when ** ** attempting a DROP or ALTER of a ** ** database object. ** ****************************************************************** ** RECOMMENDATION: ** ****************************************************************** *When dynamic statement caching is used, DB2 records, in memory,* *a record of all objects that a cached statement is dependent on.* *This information is collected during the initial PREPARE, before* *a statement is inserted in the cache. If an abend occurred* *during this PREPARE, DB2 left these dependency records showing* *that there was an active user of the SQL statement. When a DROP* *or ALTER was later issued for one of the objects, it failed* *with SQLCODE 904 and reason code RC00E70081, indicating that* *the object cannot be dropped or altered because a cached* *statement user is currently dependent on it. The dependency* *record would never be cleaned up because the abending agent was* *gone. So the object could not be dropped or altered until DB2* *was stopped and restarted.* *Problem conclusion** * *DB2 code has been corrected to clean up properly if an abend* *occurs during a statement cache prepare.* *Temporary fix** * *Comments** * *APAR information*** *APAR number* *PQ22726* *Reported component name* *5740 IBM DATABA* *Reported component ID* *5740XYR00* *Reported release* *510* *Status* *CLOSED PER* *PE* *NoPE* *HIPER* *NoHIPER* *Submitted date* *1999-01-07* *Closed date* *1999-03-16* *Last modified date* *1999-05-04* * APAR is sysrouted FROM one or more of the following: APAR is sysrouted TO one or more of the following: UQ27897 UQ27898 Modules/Macros* *DSNXEDSC* *DSNXEDS1* * * * * * * * * 2010/3/1 Galambos, Robert <robert.galam...@compuware.com> > Did you look up the reason code? > > > > > Robert Galambos CIPP/C CIPP/IT > > Compuware Senior Technical Specialist > IBM Certified Database Associate > IBM Certified DB2 9 for z/OS Database Administration > Certified Information Privacy Professional/Canada > Certified Information Privacy Professional/Information Technology > > robert.galam...@compuware.com > > Tel: +1 905 886 7000 > Toll Free: +1 800 263 7189 > Fax: +1 905 886 7023 > Quebec: +1 877-281-1888 > > > > Le contenu de ce courriel s'adresse au destinataire seulement. Il contient > de l'information pouvant être confidentielle. Vous ne devez ni le copier ni > l'utiliser ni le divulguer à qui que ce soit à moins que vous soyez le > destinataire ou une personne désignée autorisée. Si vous le receviez par > erreur, veuillez nous aviser immédiatement et le détruire. > > The contents of this e-mail are intended for the named addressee only. It > contains information that may be confidential. Unless you are the named > addressee or an authorized designee, you may not copy or use it, or disclose > it to anyone else. If you received it in error please notify us immediately > and then destroy it. > > > > > "Service in every product... > > Les renseignements contenus dans le présent message électronique sont > confidentiels et concernent exclusivement le(s) destinataire(s) désigné(s). > Il est strictement interdit de distribuer ou de copier ce message. Si vous > avez reçu ce message par erreur, veuillez répondre par courriel à > l'expéditeur et effacer ou détruire toutes les copies du présent message. > > > -----Original Message----- > > From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On > > Behalf Of Chokalingam Thangavelu > > Sent: March 1, 2010 11:13 AM > > To: IBM-MAIN@bama.ua.edu > > Subject: Unable drop or alter DB2 table > > > > Hi, > > > > We are using DB2 V7 on our system and getting following error message > > when we are trying to drop or alter a tablespace. > > > > Error description > > DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED B > > UNAVAILABLE RESOURCE. REASON 00E70081 > > > > Does this has any relation with dynamic cache enabling? If yes then is > > there any PTFs are available for DB2 V7. > > > > Regards, > > Chokalingam Thangavelu > > > > Wipro Limited (Company Regn No in UK FC 019088) > > Address: Level 2, West wing, 3 Sheldon Square, London W2 6PS, United > > Kingdom. Tel +44 20 7432 8500 Fax: +44 20 7286 5703 > > > > VAT Number: 563 1947 27 > > > > (Branch of Wipro Limited (Incorporated in India at Bangalore with > > limited liability vide Reg no L99999KA1945PLC02800 with Registrar of > > Companies at Bangalore, India. Authorized share capital Rs 3550 mn)) > > > > Please do not print this email unless it is absolutely necessary. > > > > The information contained in this electronic message and any > > attachments to this message are intended for the exclusive use of the > > addressee(s) and may contain proprietary, confidential or privileged > > information. If you are not the intended recipient, you should not > > disseminate, distribute or copy this e-mail. Please notify the sender > > immediately and destroy all copies of this message and any attachments. > > > > WARNING: Computer viruses can be transmitted via email. The recipient > > should check this email and any attachments for the presence of > > viruses. The company accepts no liability for any damage caused by any > > virus transmitted by this email. > > > > www.wipro.com > > > > ---------------------------------------------------------------------- > > For IBM-MAIN subscribe / signoff / archive access instructions, > > send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO > > Search the archives at http://bama.ua.edu/archives/ibm-main.html > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO > Search the archives at http://bama.ua.edu/archives/ibm-main.html > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
