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.

IDS Forum is maintained by Administrator with WebBBS 5.12.