CRITICAL PHYSLOG CHUNK DOWN

Hi, I was working on a new database informix 12 on Windows 2008 r2, I was working in gathering archive datas in this new informix 12 databse, I have not yet take any backup, and I have resize the Physlog to a chunk of 40 Gb, the informix has went down because maybe of the size and wont to start, in the log I get "bad primary chunk PHYSLOG" wich is the chunk of physicla log, I verify with oncheck and I found that this chunk is marcked down, so Is there any way to bypass this chunk, we have no backups of this database and its a very important database for us, did IBM support got some tips or tools to bring this database up again. I need advice plz. thanks a lot for answering.

Hello. Your physical log is a critical dbspace. Did online.log shows any af file generation? I suggest you to open a support call with IBM, even if I really can't imagine why you should need such a huge physdbs. I have seen some VLDBs with a little lower, so I figure you might be running an Enteprise Version. The only trivial way would be a dbspace restore, indeed. In my humble opinion, you should not run more than a medium Informix instance, in windows OS. We have several better OSes, much more performatic with Informix databases, including open-source ones (and supported by IBM). I would even suggest an oninit -PHY, but.... I won't recommend you, since there seems to be something anormal with your physlog. Good luck, hope it helps. Best regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Information Management Informix Technical Professional IBM Certified Developer - Informix Genero BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: abderrafi212@gmail.com > Subject: CRITICAL PHYSLOG CHUNK DOWN [35799] > Date: Wed, 23 Sep 2015 19:44:20 -0400 > > Hi, I was working on a new database informix 12 on Windows 2008 r2, I was > working in gathering archive datas in this new informix 12 databse, I have not > yet take any backup, and I have resize the Physlog to a chunk of 40 Gb, the > informix has went down because maybe of the size and wont to start, in the log > I get "bad primary chunk PHYSLOG" wich is the chunk of physicla log, I verify > with oncheck and I found that this chunk is marcked down, so Is there any way > to bypass this chunk, we have no backups of this database and its a very > important database for us, did IBM support got some tips or tools to bring > this database up again. > > I need advice plz. > > thanks a lot for answering. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

How did you "resize phslog". Art On Sep 23, 2015 7:44 PM, "CHALLENGER212 ABDERRAFI" <abderrafi212@gmail.com> wrote: > Hi, I was working on a new database informix 12 on Windows 2008 r2, I was > working in gathering archive datas in this new informix 12 databse, I have > not > yet take any backup, and I have resize the Physlog to a chunk of 40 Gb, the > informix has went down because maybe of the size and wont to start, in the > log > I get "bad primary chunk PHYSLOG" wich is the chunk of physicla log, I > verify > with oncheck and I found that this chunk is marcked down, so Is there any > way > to bypass this chunk, we have no backups of this database and its a very > important database for us, did IBM support got some tips or tools to bring > this database up again. > > I need advice plz. > > thanks a lot for answering. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e01184e1a3bcbfc052073bed8