Informix Error Cannot Read System Catalog
/ -107 due to locks on systables Technote (troubleshooting) Problem(Abstract) You have client applications working on Updateable Secondary. From time to time the corresponding sessions are getting errors -211 / -107 (Cannot read system catalog systables / Record is locked). Symptom The output of 'onstat -k' implies that locks on systables were placed by UPDATE STATISTICS process: Locks address wtlist owner lklist type tblsnum rowid key#/bsiz 11ec889c0 0 7b76e1738 12a677040 HDR+X 4005ed c05 0 U 11ec999c0 0 7b76e1738 11fb89140 HDR+X 4005ed 30b 0 U 11ed43b40 0 7b76e1738 134787240 HDR+X 4005ed 1d06 0 U 11f039b40 0 7b76e1738 133e1f840 HDR+X 4005ed d307 0 U 11f304e40 0 7b76e1738 134a474c0 HDR+X 4005ed 2504 0 U 11f4340c0 0 7b76e1738 1239cf540 HDR+X 4005ed 1209 0 U <...> Cause During execution of UPDATE STATISTICS on the Primary systables is locked exclusively. These locks are then propagated to the Updateable Secondary which interferes with the applications processing. Diagnosing the problem 1) Identify partnum of systables table 2) On the secondary use 'onmode -I 211' to capture the assert failure file for error -211: Cannot read system catalog. 3) Open the assert failure file and search for systables partnum in the 'onstat -k' output saved in the file. 4) For identified locks check if U flag is set. Resolving the problem - Use LOCK MODE WAIT for the client applications. - Enable SQL_FEAT_CTRL 0x00000020 in the $ONCONFIG file of the Primary. Having it set should reduce the number of locking issue during processing of UPDATE STATISTICS LOW. Note that this feature was introduced in Informix v11.50.FC9W1 & in v11.70.FC4. - Reschedule UPDATE STATISTICS operations so they would not interfere with the running applications. Document information More support for: Informix Servers Software version: 11.5, 11.7, 11.70, 12.1 Operating system(s): AIX, HP-UX, Linux, OS X, Solaris, Windows Software edition: Enterprise, Growth, Ultimate, Workgroup Reference #: 1644785 Modified date: 2014-06-26 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
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. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 2 of 2 Thread: Cannot read system catalog(sysprocplan) 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 10-13-03,04:59 #1 dbforumstest View Profile View http://www.ibm.com/support/docview.wss?uid=swg21644785 Forum Posts Registered User Join Date Sep 2003 Posts 11 Unanswered: Cannot read system catalog(sysprocplan) Hi, Received the following message. 20211 - Cannot read system catalog(sysprocplan).ISAM error:key value locked. Any idea hot to resolve this please. Thanks Reply With Quote 10-16-03,07:26 #2 gurey View Profile View Forum Posts Registered User Join Date Aug 2003 Location Argentina Posts 780 Re: Cannot read system http://www.dbforums.com/showthread.php?927981-Cannot-read-system-catalog(sysprocplan) catalog(sysprocplan) Originally posted by dbforumstest Hi, Received the following message. 20211 - Cannot read system catalog(sysprocplan).ISAM error:key value locked. Any idea hot to resolve this please. Thanks Hi, This can be due to that the database engine this recompilando stored procedure that was invoked by a user and the optimizer volume the decision to do it. Usually it happens in some versions of 7.x of informix. Gustavo. Reply With Quote Quick Navigation Informix Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Non-SQL Forums MongoDB Database Server Software Adabas DB2 Informix Microsoft SQL Server MySQL Oracle Pervasive.SQL PostgreSQL Sybase Other Data Access, Manipulation & Batch Languages ASP Crystal Reports Delphi, C etc JAVA Perl and the DBI PHP ANSI SQL Unix Shell Scripts Visual Basic PC based Database Applications Brilliant Database Corel Paradox FileMaker Microsoft Access Microsoft Excel Other PC Databases General New Members & Introductions Applications & Tools Database Concepts & Design Chit Chat Marketplace Job Opportunities Suggestions & Feedback Links to other iNet owned sites web development forum Web Hosting Talk « Previous Thread |
managed to recover from the error above. If yes, what are the steps taken. Please advise. Give us a clue, at least which database http://www.verycomputer.com/161_cb8a7b6815b626c5_1.htm server you are using. The first pass is probably going to involve https://groups.google.com/d/topic/comp.databases.informix/cijomQx-Mg0 bcheck or oncheck. The second pass is probably going to involve Informix technical support. The third pass is probably going to involve a restore from backup. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | informix error +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for informix error cannot our records.|/ ////////| +----------------------+-----------------------------------+-----------+ Top 1. error 211 Cannot read system catalog (sysindexes). I have SQLs which have been working for months. It looks like the system catalog index file is corrupt. How can I fix it. What can I do. I am getting an the following error now when it runs. Cannot read system catalog (sysindexes). See error number -211. I have run a bcheck -s sys*.dat This command seems to reindex the files but did not fix the problem Please does anyone know what I can do to eliminate this problem 2. Check this new concept out 3. Error: 211 Cannot read system catalog (systrigbody) 4. IMS/DB Convert to DB2? 5. Error 211 Error Isam 111 6. Announce($): ChimneySweep... a "terribly useful" database utility 7. Unable to read system catalog (systables) 8. ROWNUM? 9. Update Statistics Error:-243 C-ISAM:-103 10. Error -245 ISAM -103 - Help 11. SQL error 245 ISAM 103 12. Error 211 ISAM 111 on sysindeces 13. URGENT: Sysprocplan lock error - sqlcode=-211, ISAM=-144 1 post • Page:1 of 1 All times are UTC Board index Spam Report