Join IIUG
 for   
 

Informix News
18 Nov 13 - ZDNet - Top 20 mobile skills in demand... Read
09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read
06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read
01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read
14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read
3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read
28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read
10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read
3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read
2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read
28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read
23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read


End of Support Dates

IIUG on Facebook IIUG on Twitter

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum

Re: ARCHIVE ERROR: init_archive()/alloc_sb_pre....

Posted By: H.G
Date: Friday, 4 December 2009, at 11:09 a.m.

In Response To: Re: ARCHIVE ERROR: init_archive()/alloc_sb_pre.... (Martin Fuerderer)

Once again thanks Martin for an excellent information on this issue. This information not only helped me for my understanding but also helped to explain this to senior management.

________________________________
From: Martin Fuerderer <MARTINFU@de.ibm.com>
To: ids@iiug.org
Sent: Fri, 4 December, 2009 10:03:10 PM
Subject: Re: ARCHIVE ERROR: init_archive()/alloc_sb_pre.... [18273]

Hi,

you can try engine bounce, but my guess is,
that it will not improve the situation. But try.
Also, try drop and re-create of the dbspace.
As I don't know what exactly (e.g. which flag)
causes the problem, I don't know whether
drop and re-create will be possible.

Still, I think involvement of Technical Support
would also help to find out the root cause and
getting this fixed - to prevent future occurance
of the problem ...

Regards, Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management

IBM Deutschland Research & Development GmbH
Chairman of the Supervisory Board: Martin Jetter
Board of Management: Dirk Wittkopp
Corporate Seat: Boeblingen, Germany
Reg.-Gericht: Amtsgericht Stuttgart, HRB 243294

ids-bounces@iiug.org wrote on 12/04/2009 11:20:46 AM:
>
> Thanks Martin & Art for your prompt response. We have organised an
> outage this
> weekend to bounce the server BUT now I am almost certain recyclingof
engine
> will not resolve the issue as both of you have adviced to contact IBM
tech
> support.
>
> I am also assuming engine will not allow drop/recreate this Smart
Blobspace
> (33) which we don't use otherwise you would have suggested this earlier.
Is
> this correct?
>
> Once again, thank you very much for your help.
>
> HG
>
> ________________________________
> From: Martin Fuerderer <MARTINFU@de.ibm.com>
> To: ids@iiug.org
> Sent: Fri, 4 December, 2009 8:13:55 PM
> Subject: Re: ARCHIVE ERROR: init_archive()/alloc_sb_pre.... [18271]
>
> Hi,
>
> as already adviced by Art: Please contact IBM Informix
> Technical Support.
>
> My guess is, that for some dbspace a flag that gets
> set during the archive operation has not been
> reset due to the abort of the archive operation.
>
> Tech Support should be able to find out, whether my
> thought is correct. If it is, then
> a) this is a defect that should be fixed ... i.e. to reset
> the flag(s) properly in case of such an archive abort.
> b) Tech Support may well be able to logon to your
> machine and correct the flag setting by patching
> it on disk. This would then require only a rather
> short downtime of the system. Whether it would be
> possible to patch something like this while the system
> keeps running - I don't know. But they will tell you. :)
>
> For both items it is necessary that you contact
> Tech Support. So it really is the best advice that
> I can give.
>
> Regards, Martin
> --
> Martin Fuerderer
> IBM Informix Development Munich, Germany
> Information Management
>
> IBM Deutschland Research & Development GmbH
> Chairman of the Supervisory Board: Martin Jetter
> Board of Management: Dirk Wittkopp
> Corporate Seat: Boeblingen, Germany
> Reg.-Gericht: Amtsgericht Stuttgart, HRB 243294
>
> ids-bounces@iiug.org wrote on 12/04/2009 01:50:06 AM:
> >
> > Hi All,
> > IDS 11.50.FC4
> > Redhat Linux 2.6.9-42.ELsmp #1 SMP x86_64
> > NetBackup-RedHat2.6 6.5.4
> >
> > We use onbar with NetBackup (storage manager). Unfortunately,
> > media server ran
> > out of disk space and onbar Level 0 archive had been aborted with the
> > following error in OnLine message log. Since then every time cron
kicks
> off
> > Level 0 archive, we get the same error. We tried ontape with no
> > luck and got
> > the same error. Onbar is backing up logical logs nicely. From my past
> > experience, restarting the engine had resolved the issue but one
> > of our senior
> > guys told that restart wouldnt work and only way is to restore
> > last successful
> > Level 0 archive and roll forward the logs. Being a production server
> (24X7)
> > and having so many interface connected, its make life more difficult
for
> an
> > outage window. My objective to have only one outage to bounce the
> > engine and
> > if does not work then try whatever you all suggest before I go back to

> IBM
> > support. Restore would be the last choice. I think IDS 11.50.FC5
> > has got a fix
> > for similar issue but not 100% sure. Is there any
> > work around to avoid this situation in future as chances are there
> > that media
> > server may run out of disk space again?
> >
> > Prompt response would be HIGHLY appreciated.
> >
> > ARCHIVE ERROR: init_archive()/alloc_sb_preimage() sbsnum=33
> sberrno=12073
> >
> > TIA
> >
> > The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
> > http://in.yahoo.com/
> >
> >
> >
>
>
>

*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>

*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
> http://in.yahoo.com/
>
>
>

*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/

Messages In This Thread

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.