Join IIUG
 for   
 

Informix News
18 Nov 13 - ZDNet - Top 20 mobile skills in demand... Read
09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read
06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read
01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read
14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read
3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read
28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read
10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read
3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read
2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read
28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read
23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... 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 Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read


End of Support Dates

IIUG on Facebook IIUG on Twitter

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum

Re: oninit -r

Posted By: Marco Greco
Date: Monday, 14 September 2009, at 5:01 p.m.

In Response To: Re: oninit -r (Jairo Gubler)

Jairo Gubler wrote:
> I changed LTAPEDEV and restarted, but the database is in the same state,
> with another message (Waiting for Next Logical Log Fila to be Freed).
>
> 13:49:16 Physical Recovery Started at Page (1:329).
> 13:49:17 Physical Recovery Complete: 880 Pages Examined, 880 Pages
> Restored.
> 13:49:17 Logical Recovery Started.
> 13:49:17 10 recovery worker threads will be started.
> 13:49:18 Fast Recovery Switching to Log 1070745
> ....
> 13:49:40 Fast Recovery Switching to Log 1070939
> 13:49:40 Fast Recovery Switching to Log 1070940
> 13:49:40 Fast Recovery Switching to Log 1070941
> 13:49:40 Fast Recovery Switching to Log 1070942
> 13:49:40 Fast Recovery Switching to Log 1070943
> 13:49:43 Logical Recovery has reached the transaction cleanup phase.
> 13:49:43 Logical Recovery Complete.
>
> 200170 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
>
> 13:49:44 Dataskip is now OFF for all dbspaces
> 13:49:45 Waiting for Next Logical Log File to be Freed
>
> IBM Informix Dynamic Server Version 10.00.UC5 -- Quiescent (CKPT
> REQ) -- Up 00:12:54 -- 488472 Kbytes
> Blocked:CKPT
>
> Physical Logging
> Buffer bufused bufsize numpages numwrits pages/io
> P-1 0 128 0 0 0.00
>
> phybegin physize phypos phyused %used
>
> 1:263 2000 953 887 44.35
>
> Logical Logging
> Buffer bufused bufsize numrecs numpages numwrits recs/pages
> pages/io
> L-1 1 128 1 1 1 1.0
> 1.0
>
> Subsystem numrecs Log Space used
>
> OLDRSAM 1 36
>
> Buffer Waiting
> Buffer ioproc flags
> L-1 1e570018 0x1 0
>
> address number flags uniqid begin size
> used %used
> 1e5aa630 1 U-B---- 1070801 1:2263 1000 1000
> 100.00
> 1e5aa678 2 U-B---- 1070802 1:3263 1000 1000
> 100.00
> 1e5aa6c0 3 U-B---- 1070803 1:4263 1000 1000
> 100.00
> 1e5aa708 4 U-B---- 1070804 1:5263 1000 1000
> 100.00
> 1e5aa750 5 U-B---- 1070805 1:6263 1000 1000
> 100.00
> 1e5aa798 6 U-B---- 1070806 1:7263 1000 1000
> 100.00
> 1e5aa7e0 7 U-B---- 1070807 1:8263 1000 1000
> 100.00
> 1e5aa828 8 U-B---- 1070808 1:9263 1000 1000
> 100.00
> 1e5aa870 9 U-B---- 1070809 1:10263 1000 1000
> 100.00
> 1e5aa8b8 10 U-B---- 1070810 1:11263 1000 1000
> 100.00
> 1e5aa900 11 U-B---- 1070811 1:12263 1000 1000
> 100.00
> 1e5aa948 12 U-B---- 1070812 1:13263 1000 1000
> 100.00
> 1e5aa990 13 U-B---- 1070813 1:14263 1000 1000
> 100.00
> 1e5aa9d8 14 U-B---- 1070814 1:15263 1000 1000
> 100.00
> 1e5aaa20 15 U-B---- 1070815 1:16263 1000 1000
> 100.00
> 1e5aaa68 16 U-B---- 1070816 1:17263 1000 1000
> 100.00
> 1e5aaab0 17 U-B---- 1070817 1:18263 1000 1000
> 100.00
> 1e5aaaf8 18 U-B---- 1070818 1:19263 1000 1000
> 100.00
> 1e5aab40 19 U-B---- 1070819 1:20263 1000 1000
> 100.00
> 1e5aab88 20 U-B---- 1070820 1:21263 1000 1000
> 100.00
> 1e5aabd0 21 U-B---- 1070821 1:22263 1000 1000
> 100.00
> 1e5aac18 22 U-B---- 1070822 1:23263 1000 1000
> 100.00
> 1e5aac60 23 U-B---- 1070823 1:24263 1000 1000
> 100.00
> 1e5aaca8 24 U-B---- 1070824 1:25263 1000 1000
> 100.00
> 1e5aacf0 25 U-B---- 1070825 1:26263 1000 1000
> 100.00
> 1e5aad38 26 U-B---- 1070826 1:27263 1000 1000
> 100.00
> 1e5aad80 27 U-B---- 1070827 1:28263 1000 1000
> 100.00
> 1e5aadc8 28 U-B---- 1070828 1:29263 1000 1000
> 100.00
> 1e5aae10 29 U-B---- 1070829 1:30263 1000 1000
> 100.00
> 1e5aae58 30 U-B---- 1070830 1:31263 1000 1000
> 100.00
> 1e5aaea0 31 U-B---- 1070831 1:32263 1000 1000
> 100.00
> 1e5aaee8 32 U-B---- 1070832 1:33263 1000 1000
> 100.00
> 1e5aaf30 33 U-B---- 1070833 1:34263 1000 1000
> 100.00
> 1e5aaf78 34 U-B---- 1070834 1:35263 1000 1000
> 100.00
> 1e5aafc0 35 U-B---- 1070835 1:36263 1000 1000
> 100.00
> 1e432b18 36 U-B---- 1070836 1:37263 1000 1000
> 100.00
> 1e432b60 37 U-B---- 1070837 1:38263 1000 1000
> 100.00
> 1e432ba8 38 U-B---- 1070838 1:39263 1000 1000
> 100.00
> 1e432bf0 39 U-B---- 1070839 1:40263 1000 1000
> 100.00
> 1e432c38 40 U-B---- 1070840 1:41263 1000 1000
> 100.00
> 1e432c80 41 U-B---- 1070841 1:42263 1000 1000
> 100.00
> 1e432cc8 42 U-B---- 1070842 1:43263 1000 1000
> 100.00
> 1e432d10 43 U-B---- 1070843 1:44263 1000 1000
> 100.00
> 1e432d58 44 U-B---- 1070844 1:45263 1000 1000
> 100.00
> 1e432da0 45 U-B---- 1070845 1:46263 1000 1000
> 100.00
> 1e432de8 46 U-B---- 1070846 1:47263 1000 1000
> 100.00
> 1e432e30 47 U-B---- 1070847 1:48263 1000 1000
> 100.00
> 1e432e78 48 U-B---- 1070848 1:49263 1000 1000
> 100.00
> 1e432ec0 49 U-B---- 1070849 1:50263 1000 1000
> 100.00
> 1e432f08 50 U-B---- 1070850 1:51263 1000 1000
> 100.00
> 1e432f50 51 U-B---- 1070851 1:52263 1000 1000
> 100.00
> 1e432f98 52 U-B---- 1070852 1:53263 1000 1000
> 100.00
> 1e599630 53 U-B---- 1070853 1:54263 1000 1000
> 100.00
> 1e599678 54 U-B---- 1070854 1:55263 1000 1000
> 100.00
> 1e5996c0 55 U-B---- 1070855 1:56263 1000 1000
> 100.00
> 1e599708 56 U-B---- 1070856 1:57263 1000 1000
> 100.00
> 1e599750 57 U-B---- 1070857 1:58263 1000 1000
> 100.00
> 1e599798 58 U-B---- 1070858 1:59263 1000 1000
> 100.00
> 1e5997e0 59 U-B---- 1070859 1:60263 1000 1000
> 100.00
> 1e599828 60 U-B---- 1070860 1:61263 1000 1000
> 100.00
> 1e599870 61 U-B---- 1070861 1:62263 1000 1000
> 100.00
> 1e5998b8 62 U-B---- 1070862 1:63263 1000 1000
> 100.00
> 1e599900 63 U-B---- 1070863 1:64263 1000 1000
> 100.00
> 1e599948 64 U-B---- 1070864 1:65263 1000 1000
> 100.00
> 1e599990 65 U-B---- 1070865 1:66263 1000 1000
> 100.00
> 1e5999d8 66 U-B---- 1070866 1:67263 1000 1000
> 100.00
> 1e599a20 67 U-B---- 1070867 1:68263 1000 1000
> 100.00
> 1e599a68 68 U-B---- 1070868 1:69263 1000 1000
> 100.00
> 1e599ab0 69 U-B---- 1070869 1:70263 1000 1000
> 100.00
> 1e599af8 70 U-B---- 1070870 1:71263 1000 1000
> 100.00
> 1e599b40 71 U-B---- 1070871 1:72263 1000 1000
> 100.00
> 1e599b88 72 U-B---- 1070872 1:73263 1000 1000
> 100.00
> 1e599bd0 73 U-B---- 1070873 1:74263 1000 1000
> 100.00
> 1e599c18 74 U-B---- 1070874 1:75263 1000 1000
> 100.00
> 1e599c60 75 U-B---- 1070875 1:76263 1000 1000
> 100.00
> 1e599ca8 76 U-B---- 1070876 1:77263 1000 1000
> 100.00
> 1e599cf0 77 U-B---- 1070877 1:78263 1000 1000
> 100.00
> 1e599d38 78 U-B---- 1070878 1:79263 1000 1000
> 100.00
> 1e599d80 79 U-B---- 1070879 1:80263 1000 1000
> 100.00
> 1e599dc8 80 U-B---- 1070880 1:81263 1000 1000
> 100.00
> 1e599e10 81 U-B---- 1070881 1:82263 1000 1000
> 100.00
> 1e599e58 82 U-B---- 1070882 1:83263 1000 1000
> 100.00
> 1e599ea0 83 U-B---- 1070883 1:84263 1000 1000
> 100.00
> 1e599ee8 84 U-B---- 1070884 1:85263 1000 1000
> 100.00
> 1e599f30 85 U-B---- 1070885 1:86263 1000 1000
> 100.00
> 1e599f78 86 U-B---- 1070886 1:87263 1000 1000
> 100.00
> 1e599fc0 87 U-B---- 1070887 1:88263 1000 1000
> 100.00
> 1ecdc018 88 U-B---- 1070888 1:89263 1000 1000
> 100.00
> 1ecdc060 89 U-B---- 1070889 1:90263 1000 1000
> 100.00
> 1ecdc0a8 90 U-B---- 1070890 1:91263 1000 1000
> 100.00
> 1ecdc0f0 91 U-B---- 1070891 1:92263 1000 1000
> 100.00
> 1ecdc138 92 U-B---- 1070892 1:93263 1000 1000
> 100.00
> 1ecdc180 93 U-B---- 1070893 1:94263 1000 1000
> 100.00
> 1ecdc1c8 94 U-B---- 1070894 1:95263 1000 1000
> 100.00
> 1ecdc210 95 U-B---- 1070895 1:96263 1000 1000
> 100.00
> 1ecdc258 96 U-B---- 1070896 1:97263 1000 1000
> 100.00
> 1ecdc2a0 97 U-B---- 1070897 1:98263 1000 1000
> 100.00
> 1ecdc2e8 98 U-B---- 1070898 1:99263 1000 1000
> 100.00
> 1ecdc330 99 U-B---- 1070899 1:100263 1000 1000
> 100.00
> 1ecdc378 100 U-B---- 1070900 1:101263 1000 1000
> 100.00
> 1ecdc3c0 101 U-B---- 1070901 1:102263 1000 1000
> 100.00
> 1ecdc408 102 U-B---- 1070902 1:103263 1000 1000
> 100.00
> 1ecdc450 103 U-B---- 1070903 1:104263 1000 1000
> 100.00
> 1ecdc498 104 U-B---- 1070904 1:105263 1000 1000
> 100.00
> 1ecdc4e0 105 U-B---- 1070905 1:106263 1000 1000
> 100.00
> 1ecdc528 106 U-B---- 1070906 1:107263 1000 1000
> 100.00
> 1ecdc570 107 U-B---- 1070907 1:108263 1000 1000
> 100.00
> 1ecdc5b8 108 U-B---- 1070908 1:109263 1000 1000
> 100.00
> 1ecdc600 109 U-B---- 1070909 1:110263 1000 1000
> 100.00
> 1ecdc648 110 U-B---- 1070910 1:111263 1000 1000
> 100.00
> 1ecdc690 111 U-B---- 1070911 1:112263 1000 1000
> 100.00
> 1ecdc6d8 112 U-B---- 1070912 1:113263 1000 1000
> 100.00
> 1ecdc720 113 U-B---- 1070913 1:114263 1000 1000
> 100.00
> 1ecdc768 114 U-B---- 1070914 1:115263 1000 1000
> 100.00
> 1ecdc7b0 115 U-B---- 1070915 1:116263 1000 1000
> 100.00
> 1ecdc7f8 116 U-B---- 1070916 1:117263 1000 1000
> 100.00
> 1ecdc840 117 U-B---- 1070917 1:118263 1000 1000
> 100.00
> 1ecdc888 118 U-B---- 1070918 1:119263 1000 1000
> 100.00
> 1ecdc8d0 119 U-B---- 1070919 1:120263 1000 1000
> 100.00
> 1ecdc918 120 U-B---- 1070920 1:121263 1000 1000
> 100.00
> 1ecdc960 121 U-B---- 1070921 1:122263 1000 1000
> 100.00
> 1ecdc9a8 122 U-B---- 1070922 1:123263 1000 1000
> 100.00
> 1ecdc9f0 123 U-B---- 1070923 1:124263 1000 1000
> 100.00
> 1ecdca38 124 U-B---- 1070924 1:125263 1000 1000
> 100.00
> 1ecdca80 125 U-B---- 1070925 1:126263 1000 1000
> 100.00
> 1ecdcac8 126 U-B---- 1070926 1:127263 1000 1000
> 100.00
> 1ecdcb10 127 U-B---- 1070927 1:128263 1000 1000
> 100.00
> 1ecdcb58 128 U-B---- 1070928 1:129263 1000 1000
> 100.00
> 1ecdcba0 129 U-B---- 1070929 1:130263 1000 1000
> 100.00
> 1ecdcbe8 130 U-B---- 1070930 1:131263 1000 1000
> 100.00
> 1ecdcc30 131 U-B---- 1070931 1:132263 1000 1000
> 100.00
> 1ecdcc78 132 U-B---- 1070932 1:133263 1000 1000
> 100.00
> 1ecdccc0 133 U-B---- 1070933 1:134263 1000 1000
> 100.00
> 1ecdcd08 134 U-B---- 1070934 1:135263 1000 1000
> 100.00
> 1ecdcd50 135 U-B---- 1070935 1:136263 1000 1000
> 100.00
> 1ecdcd98 136 U-B---- 1070936 1:137263 1000 1000
> 100.00
> 1ecdcde0 137 U-B---- 1070937 1:138263 1000 1000
> 100.00
> 1ecdce28 138 U-B---- 1070938 1:139263 1000 1000
> 100.00
> 1ecdce70 139 U-B---- 1070939 1:140263 1000 1000
> 100.00
> 1ecdceb8 140 U-B---- 1070940 1:141263 1000 1000
> 100.00
> 1ecdcf00 141 U-B---- 1070941 1:142263 1000 1000
> 100.00
> 1ecdcf48 142 U-B---- 1070942 1:143263 1000 1000
> 100.00
> 1ecdcf90 143 U---C-L 1070943 1:144263 1000 1000
> 100.00
> 1ecdd018 144 U-B---- 1070744 1:145263 1000 1000
> 100.00
> 1ecdd060 145 U-B---- 1070745 1:146263 1000 1000
> 100.00
> 1ecdd0a8 146 U-B---- 1070746 1:147263 1000 1000
> 100.00
> 1ecdd0f0 147 U-B---- 1070747 1:148263 1000 1000
> 100.00
> 1ecdd138 148 U-B---- 1070748 1:149263 1000 1000
> 100.00
> 1ecdd180 149 U-B---- 1070749 1:150263 1000 1000
> 100.00
> 1ecdd1c8 150 U-B---- 1070750 1:151263 1000 1000
> 100.00
> 1ecdd210 151 U-B---- 1070751 1:152263 1000 1000
> 100.00
> 1ecdd258 152 U-B---- 1070752 1:153263 1000 1000
> 100.00
> 1ecdd2a0 153 U-B---- 1070753 1:154263 1000 1000
> 100.00
> 1ecdd2e8 154 U-B---- 1070754 1:155263 1000 1000
> 100.00
> 1ecdd330 155 U-B---- 1070755 1:156263 1000 1000
> 100.00
> 1ecdd378 156 U-B---- 1070756 1:157263 1000 1000
> 100.00
> 1ecdd3c0 157 U-B---- 1070757 1:158263 1000 1000
> 100.00
> 1ecdd408 158 U-B---- 1070758 1:159263 1000 1000
> 100.00
> 1ecdd450 159 U-B---- 1070759 1:160263 1000 1000
> 100.00
> 1ecdd498 160 U-B---- 1070760 1:161263 1000 1000
> 100.00
> 1ecdd4e0 161 U-B---- 1070761 1:162263 1000 1000
> 100.00
> 1ecdd528 162 U-B---- 1070762 1:163263 1000 1000
> 100.00
> 1ecdd570 163 U-B---- 1070763 1:164263 1000 1000
> 100.00
> 1ecdd5b8 164 U-B---- 1070764 1:165263 1000 1000
> 100.00
> 1ecdd600 165 U-B---- 1070765 1:166263 1000 1000
> 100.00
> 1ecdd648 166 U-B---- 1070766 1:167263 1000 1000
> 100.00
> 1ecdd690 167 U-B---- 1070767 1:168263 1000 1000
> 100.00
> 1ecdd6d8 168 U-B---- 1070768 1:169263 1000 1000
> 100.00
> 1ecdd720 169 U-B---- 1070769 1:170263 1000 1000
> 100.00
> 1ecdd768 170 U-B---- 1070770 1:171263 1000 1000
> 100.00
> 1ecdd7b0 171 U-B---- 1070771 1:172263 1000 1000
> 100.00
> 1ecdd7f8 172 U-B---- 1070772 1:173263 1000 1000
> 100.00
> 1ecdd840 173 U-B---- 1070773 1:174263 1000 1000
> 100.00
> 1ecdd888 174 U-B---- 1070774 1:175263 1000 1000
> 100.00
> 1ecdd8d0 175 U-B---- 1070775 1:176263 1000 1000
> 100.00
> 1ecdd918 176 U-B---- 1070776 1:177263 1000 1000
> 100.00
> 1ecdd960 177 U-B---- 1070777 1:178263 1000 1000
> 100.00
> 1ecdd9a8 178 U-B---- 1070778 1:179263 1000 1000
> 100.00
> 1ecdd9f0 179 U-B---- 1070779 1:180263 1000 1000
> 100.00
> 1ecdda38 180 U-B---- 1070780 1:181263 1000 1000
> 100.00
> 1ecdda80 181 U-B---- 1070781 1:182263 1000 1000
> 100.00
> 1ecddac8 182 U-B---- 1070782 1:183263 1000 1000
> 100.00
> 1ecddb10 183 U-B---- 1070783 1:184263 1000 1000
> 100.00
> 1ecddb58 184 U-B---- 1070784 1:185263 1000 1000
> 100.00
> 1ecddba0 185 U-B---- 1070785 1:186263 1000 1000
> 100.00
> 1ecddbe8 186 U-B---- 1070786 1:187263 1000 1000
> 100.00
> 1ecddc30 187 U-B---- 1070787 1:188263 1000 1000
> 100.00
> 1ecddc78 188 U-B---- 1070788 1:189263 1000 1000
> 100.00
> 1ecddcc0 189 U-B---- 1070789 1:190263 1000 1000
> 100.00
> 1ecddd08 190 U-B---- 1070790 1:191263 1000 1000
> 100.00
> 1ecddd50 191 U-B---- 1070791 1:192263 1000 1000
> 100.00
> 1ecddd98 192 U-B---- 1070792 1:193263 1000 1000
> 100.00
> 1ecddde0 193 U-B---- 1070793 1:194263 1000 1000
> 100.00
> 1ecdde28 194 U-B---- 1070794 1:195263 1000 1000
> 100.00
> 1ecdde70 195 U-B---- 1070795 1:196263 1000 1000
> 100.00
> 1ecddeb8 196 U-B---- 1070796 1:197263 1000 1000
> 100.00
> 1ecddf00 197 U-B---- 1070797 1:198263 1000 1000
> 100.00
> 1ecddf48 198 U-B---- 1070798 1:199263 1000 1000
> 100.00
> 1ecddf90 199 U-B---- 1070799 1:200263 1000 1000
> 100.00
> 1ecde018 200 U-B---- 1070800 1:201263 1000 1000
> 100.00
> 200 active, 200 total
>
> **
>
> Vivian Jones escreveu:
>> You can put your LTAPEDEV variable in "/dev/null" on the onconfig file and
>> try again the oninit.
>>
>> Regards,
>>
>> Vivian Jones
>> President
>>
>> IBM Information Management Awards 2006 - Most Distinguished Achievement
>> Winner - Latin America
>> Accredited for IBM Information On Demand Specialty
>> Movil: (57-310) 4883890
>> Headquarter Phone: (57-1) 3215753
>> Offices: Colombia, Venezuela, Ecuador, Perú, Chile, Mexico.
>> Email: jones@itconsultings.net
>> Web Site: www.itconsultings.net
>>
>> -----Mensaje original-----
>> De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] En nombre de Marco
>> Greco
>> Enviado el: Lunes, 14 de Septiembre de 2009 01:28 p.m.
>> Para: ids@iiug.org
>> Asunto: Re: oninit -r [16981]
>>
>> Jairo Gubler wrote:
>>
>>> We wrongly issued an undocumented command "oninit -r" in a production
>>>
>>> instance.
>>>
>>> Now the system is in Checkpoint state..
>>>
>>> IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT
>>>
>>> REQ) -- Up 00:01:50 -- 488472 Kbytes
>>>
>>> Blocked:CKPT
>>>
>>> I have tryed to bring system down and up for many times but nothing
>>>
>>> does the system online.
>>>
>>> 13:15:16 WARNING: Checkpoint appears stalled and may not complete
>>>
>>> before the database server shuts down.
>>>
>>> Is there some way to undo this command an bring the system online
>>>
>>> again.
>>>
>>>
>> onmode -m should do the trick. If it doesn't, killing it (ie kill -11 on vp
>> 1)
>> will do no harm
>>
>

that's a slightly different problem from what you have originally described:
most likely you are using fuzzy checkpoints and the LSN is still pointing to
the same log the engine would like to switch to. Your only way out is to have
advanced support dialin and forcibly add a log. Open a PMR.
--
Ciao,
Marco
______________________________________________________________________________
Marco Greco /UK /IBM Standard disclaimers apply!

Structured Query Scripting Language http://www.4glworks.com/sqsl.htm
4glworks http://www.4glworks.com
Informix on Linux http://www.4glworks.com/ifmxlinux.htm

Messages In This Thread

  • oninit -r
    Jairo Gubler -- Monday, 14 September 2009, at 2:22 p.m.
    • Re: oninit -r
      Marco Greco -- Monday, 14 September 2009, at 2:28 p.m.
      • Re: oninit -r
        Jairo Gubler -- Monday, 14 September 2009, at 2:36 p.m.
        • Re: oninit -r
          tilleul17@web.de -- Monday, 14 September 2009, at 3:10 p.m.
      • RE: oninit -r
        Vivian Jones -- Monday, 14 September 2009, at 3:30 p.m.
        • Re: oninit -r
          Jairo Gubler -- Monday, 14 September 2009, at 4:10 p.m.
          • Re: oninit -r
            Marco Greco -- Monday, 14 September 2009, at 5:01 p.m.
          • Re: oninit -r
            Art Kagel -- Monday, 14 September 2009, at 5:10 p.m.
    • Re: oninit -r
      Art Kagel -- Monday, 14 September 2009, at 4:53 p.m.

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.