Assert Failed: Archive detects that page 0x4704d5c

OS Level: SunOS 5.6 Informix Version: Informix Dynamic Server Version 7.30.UC3 We are in the process of upgrading this application to 11.50, but until then the application is currently at the OS level and IDS version above. How can I fix this issue: 21:39:32 Assert Failed: Archive detects that page 0x4704d5c is corrupt. 21:39:32 Informix Dynamic Server Version 7.30.UC3 21:39:32 Who: Session(37426, informix@srs0176, 25988, 0) Thread(53024, arcbackup1, 0, 5) File: rsarcbu.c Line: 2337 21:39:33 See Also: /tmp/af.cf20ae63 21:46:38 Checkpoint Completed: duration was 2 seconds. Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com <mailto:2244650553@messaging.sprintpcs.com> Page via Skytel: 2244650553@sprint.skytel.com <mailto:2244650553@sprint.skytel.com> Informix or MySQL Primary: 9110210@skytel.com <mailto:9110210@skytel.com> Informix or MySQL Secondary: 7276872@skytel.com <mailto:7276872@skytel.com> " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU *******************************************************************

Unload all data, initialize the instance cold, reload the data. Art Art S. Kagel Advanced DataTools (www.advancedatatools.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, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. 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 Wed, Jun 30, 2010 at 5:35 PM, Knox, Ernest <Ernest.Knox@searshc.com>wrote: > OS Level: SunOS 5.6 Informix Version: Informix Dynamic Server Version > 7.30.UC3 > > We are in the process of upgrading this application to 11.50, but until > then the application is currently at the OS level and IDS version above. > > How can I fix this issue: > > 21:39:32 Assert Failed: Archive detects that page 0x4704d5c is corrupt. > > 21:39:32 Informix Dynamic Server Version 7.30.UC3 > > 21:39:32 Who: Session(37426, informix@srs0176, 25988, 0) > > Thread(53024, arcbackup1, 0, 5) > > File: rsarcbu.c Line: 2337 > > 21:39:33 See Also: /tmp/af.cf20ae63 > > 21:46:38 Checkpoint Completed: duration was 2 seconds. > > Thanks, > > ******************************************************************* > > Ernie Knox > > IT Database Administrator Specialist > > Sears Holdings - BU: I & T Group > > 3333 Beverly Rd., B4-266A > > Hoffman Estates, IL. 60179 > > Office: (847) 286-5735 > > Email: Ernest.Knox@searshc.com > > Blackberry: 2244650553@messaging.sprintpcs.com > <mailto:2244650553@messaging.sprintpcs.com> > > Page via Skytel: 2244650553@sprint.skytel.com > <mailto:2244650553@sprint.skytel.com> > > Informix or MySQL Primary: 9110210@skytel.com > <mailto:9110210@skytel.com> > > Informix or MySQL Secondary: 7276872@skytel.com > <mailto:7276872@skytel.com> > > " Yes we can make a Change! " > > " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! > " > > " Lets not forget - GO Pistons and Red Wings! " > > GSU > > ******************************************************************* > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016362841e482f686048a4a45e1

Database too large. It's over 200 GB. Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com Informix or MySQL Primary: 9110210@skytel.com Informix or MySQL Secondary: 7276872@skytel.com " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU ******************************************************************* ----- Original Message ----- From: ids-bounces@iiug.org <ids-bounces@iiug.org> To: ids@iiug.org <ids@iiug.org> Sent: Wed Jun 30 22:31:47 2010 Subject: Re: Assert Failed: Archive detects that page 0.... [20495] Unload all data, initialize the instance cold, reload the data. Art Art S. Kagel Advanced DataTools (www.advancedatatools.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, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. 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 Wed, Jun 30, 2010 at 5:35 PM, Knox, Ernest <Ernest.Knox@searshc.com>wrote: > OS Level: SunOS 5.6 Informix Version: Informix Dynamic Server Version > 7.30.UC3 > > We are in the process of upgrading this application to 11.50, but until > then the application is currently at the OS level and IDS version above. > > How can I fix this issue: > > 21:39:32 Assert Failed: Archive detects that page 0x4704d5c is corrupt. > > 21:39:32 Informix Dynamic Server Version 7.30.UC3 > > 21:39:32 Who: Session(37426, informix@srs0176, 25988, 0) > > Thread(53024, arcbackup1, 0, 5) > > File: rsarcbu.c Line: 2337 > > 21:39:33 See Also: /tmp/af.cf20ae63 > > 21:46:38 Checkpoint Completed: duration was 2 seconds. > > Thanks, > > ******************************************************************* > > Ernie Knox > > IT Database Administrator Specialist > > Sears Holdings - BU: I & T Group > > 3333 Beverly Rd., B4-266A > > Hoffman Estates, IL. 60179 > > Office: (847) 286-5735 > > Email: Ernest.Knox@searshc.com > > Blackberry: 2244650553@messaging.sprintpcs.com > <mailto:2244650553@messaging.sprintpcs.com> > > Page via Skytel: 2244650553@sprint.skytel.com > <mailto:2244650553@sprint.skytel.com> > > Informix or MySQL Primary: 9110210@skytel.com > <mailto:9110210@skytel.com> > > Informix or MySQL Secondary: 7276872@skytel.com > <mailto:7276872@skytel.com> > > " Yes we can make a Change! " > > " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! > " > > " Lets not forget - GO Pistons and Red Wings! " > > GSU > > ******************************************************************* > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016362841e482f686048a4a45e1 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

There is no joy in Mudville! You can try onchecking the offending address/table and see what needs to be rebuilt or unloaded to accomplish this with minimal impact. I would be concerned, however, that the real problem is that the underlying disk is going south. If the drives are as old and the IDS version .... Art Art S. Kagel Advanced DataTools (www.advancedatatools.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, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. 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 Wed, Jun 30, 2010 at 10:34 PM, Knox, Ernest <Ernest.Knox@searshc.com>wrote: > Database too large. It's over 200 GB. > > Thanks, > ******************************************************************* > Ernie Knox > IT Database Administrator Specialist > Sears Holdings > 3333 Beverly Rd., B4-266A > Hoffman Estates, IL. 60179 > Office: (847) 286-5735 > Email: Ernest.Knox@searshc.com > Blackberry: 2244650553@messaging.sprintpcs.com > Page via Skytel: 2244650553@sprint.skytel.com > Informix or MySQL Primary: 9110210@skytel.com > Informix or MySQL Secondary: 7276872@skytel.com > > " Yes we can make a Change! " > " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " > " Lets not forget - GO Pistons and Red Wings! " > GSU > ******************************************************************* > > ----- Original Message ----- > From: ids-bounces@iiug.org <ids-bounces@iiug.org> > To: ids@iiug.org <ids@iiug.org> > Sent: Wed Jun 30 22:31:47 2010 > Subject: Re: Assert Failed: Archive detects that page 0.... [20495] > > Unload all data, initialize the instance cold, reload the data. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.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, Advanced DataTools, the IIUG, nor any other > organization with which I am associated either explicitly, implicitly, or > by > inference. 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 Wed, Jun 30, 2010 at 5:35 PM, Knox, Ernest <Ernest.Knox@searshc.com > >wrote: > > > OS Level: SunOS 5.6 Informix Version: Informix Dynamic Server Version > > 7.30.UC3 > > > > We are in the process of upgrading this application to 11.50, but until > > then the application is currently at the OS level and IDS version above. > > > > How can I fix this issue: > > > > 21:39:32 Assert Failed: Archive detects that page 0x4704d5c is corrupt. > > > > 21:39:32 Informix Dynamic Server Version 7.30.UC3 > > > > 21:39:32 Who: Session(37426, informix@srs0176, 25988, 0) > > > > Thread(53024, arcbackup1, 0, 5) > > > > File: rsarcbu.c Line: 2337 > > > > 21:39:33 See Also: /tmp/af.cf20ae63 > > > > 21:46:38 Checkpoint Completed: duration was 2 seconds. > > > > Thanks, > > > > ******************************************************************* > > > > Ernie Knox > > > > IT Database Administrator Specialist > > > > Sears Holdings - BU: I & T Group > > > > 3333 Beverly Rd., B4-266A > > > > Hoffman Estates, IL. 60179 > > > > Office: (847) 286-5735 > > > > Email: Ernest.Knox@searshc.com > > > > Blackberry: 2244650553@messaging.sprintpcs.com > > <mailto:2244650553@messaging.sprintpcs.com> > > > > Page via Skytel: 2244650553@sprint.skytel.com > > <mailto:2244650553@sprint.skytel.com> > > > > Informix or MySQL Primary: 9110210@skytel.com > > <mailto:9110210@skytel.com> > > > > Informix or MySQL Secondary: 7276872@skytel.com > > <mailto:7276872@skytel.com> > > > > " Yes we can make a Change! " > > > > " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! > > " > > > > " Lets not forget - GO Pistons and Red Wings! " > > > > GSU > > > > ******************************************************************* > > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --0016362841e482f686048a4a45e1 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001485f913d66b216b048a4a6bd3

With that thought, I will need to hasten their upgrade process. Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com Informix or MySQL Primary: 9110210@skytel.com Informix or MySQL Secondary: 7276872@skytel.com " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU ******************************************************************* ----- Original Message ----- From: ids-bounces@iiug.org <ids-bounces@iiug.org> To: ids@iiug.org <ids@iiug.org> Sent: Wed Jun 30 22:42:23 2010 Subject: Re: Assert Failed: Archive detects that page 0.... [20497] There is no joy in Mudville! You can try onchecking the offending address/table and see what needs to be rebuilt or unloaded to accomplish this with minimal impact. I would be concerned, however, that the real problem is that the underlying disk is going south. If the drives are as old and the IDS version .... Art Art S. Kagel Advanced DataTools (www.advancedatatools.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, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. 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 Wed, Jun 30, 2010 at 10:34 PM, Knox, Ernest <Ernest.Knox@searshc.com>wrote: > Database too large. It's over 200 GB. > > Thanks, > ******************************************************************* > Ernie Knox > IT Database Administrator Specialist > Sears Holdings > 3333 Beverly Rd., B4-266A > Hoffman Estates, IL. 60179 > Office: (847) 286-5735 > Email: Ernest.Knox@searshc.com > Blackberry: 2244650553@messaging.sprintpcs.com > Page via Skytel: 2244650553@sprint.skytel.com > Informix or MySQL Primary: 9110210@skytel.com > Informix or MySQL Secondary: 7276872@skytel.com > > " Yes we can make a Change! " > " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " > " Lets not forget - GO Pistons and Red Wings! " > GSU > ******************************************************************* > > ----- Original Message ----- > From: ids-bounces@iiug.org <ids-bounces@iiug.org> > To: ids@iiug.org <ids@iiug.org> > Sent: Wed Jun 30 22:31:47 2010 > Subject: Re: Assert Failed: Archive detects that page 0.... [20495] > > Unload all data, initialize the instance cold, reload the data. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.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, Advanced DataTools, the IIUG, nor any other > organization with which I am associated either explicitly, implicitly, or > by > inference. 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 Wed, Jun 30, 2010 at 5:35 PM, Knox, Ernest <Ernest.Knox@searshc.com > >wrote: > > > OS Level: SunOS 5.6 Informix Version: Informix Dynamic Server Version > > 7.30.UC3 > > > > We are in the process of upgrading this application to 11.50, but until > > then the application is currently at the OS level and IDS version above. > > > > How can I fix this issue: > > > > 21:39:32 Assert Failed: Archive detects that page 0x4704d5c is corrupt. > > > > 21:39:32 Informix Dynamic Server Version 7.30.UC3 > > > > 21:39:32 Who: Session(37426, informix@srs0176, 25988, 0) > > > > Thread(53024, arcbackup1, 0, 5) > > > > File: rsarcbu.c Line: 2337 > > > > 21:39:33 See Also: /tmp/af.cf20ae63 > > > > 21:46:38 Checkpoint Completed: duration was 2 seconds. > > > > Thanks, > > > > ******************************************************************* > > > > Ernie Knox > > > > IT Database Administrator Specialist > > > > Sears Holdings - BU: I & T Group > > > > 3333 Beverly Rd., B4-266A > > > > Hoffman Estates, IL. 60179 > > > > Office: (847) 286-5735 > > > > Email: Ernest.Knox@searshc.com > > > > Blackberry: 2244650553@messaging.sprintpcs.com > > <mailto:2244650553@messaging.sprintpcs.com> > > > > Page via Skytel: 2244650553@sprint.skytel.com > > <mailto:2244650553@sprint.skytel.com> > > > > Informix or MySQL Primary: 9110210@skytel.com > > <mailto:9110210@skytel.com> > > > > Informix or MySQL Secondary: 7276872@skytel.com > > <mailto:7276872@skytel.com> > > > > " Yes we can make a Change! " > > > > " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! > > " > > > > " Lets not forget - GO Pistons and Red Wings! " > > > > GSU > > > > ******************************************************************* > > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --0016362841e482f686048a4a45e1 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001485f913d66b216b048a4a6bd3 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.