Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. Read 09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Read 3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More... navigate here
I have SQLs which have been working for months. Read 1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Forum New Posts Today's Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders dBforums Database Server Software Informix Cannot read system catalog(sysprocplan) If this is your first Read 16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Read More Here
Update Statistics Error:-243 C-ISAM:-103 10. Read 9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read 14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... 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
Symptom The output of 'onstat -k' implies that locks on systables were placed by UPDATE STATISTICS process: Locks address wtlist owner 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) Read 9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free!
Read 11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... 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 catalog(sysprocplan) Originally posted by dbforumstest How can I fix it. Read 1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix...
Read 8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... http://www.oninit.com/errorcode/index.php?pageid=-211 By joining you are opting in to receive e-mail. Read 17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Posts [ 14 ] Pages 1 You must login or register to post a reply Programmer's Town »Databases »cannot read system catalog (sysprocedures) Jump to forum: .NET .NET GUI ASP.NET ATL/WTL
In them is not present a mention about pages. :-))) at least at filling create procedure...Pages here at anything. Usually it happens in some versions of 7.x of informix. ROWNUM? 9. his comment is here Generally that, it is not normal. 13 Reply by Petrov Andrey 2012-06-21 14:49:26 Petrov Andrey Member Offline Registered: 2012-04-21 Posts: 1,072 Re: cannot read system catalog (sysprocedures) Well the sense that
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. The error log contains the following error code. <-- SQL(-211,-107,0) [systables] Cannot read system catalog (systables). Log-based Change Data Capture...
Table - systables was not used in my select query. Read 8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... execute the following query select tabid from systables where tabname =