IDS Forum

Re: oninit -r

Posted By: Art Kagel
Date: Monday, 14 September 2009, at 5:10 p.m.

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

Call tech support. Something is hinky.

Art

Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.

On Mon, Sep 14, 2009 at 4:10 PM, Jairo Gubler
<jairo.gubler@digitro.com.br>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
> >
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--00235453092844060c047390199c

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.