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
>