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
IDS 11.10 - 30 Sep 2012
Subscribe to notifications

IIUG on Facebook IIUG on Twitter

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

IDS Forum

Re: backup failed

Posted By: Art Kagel
Date: Tuesday, 17 June 2014, at 4:16 p.m.

In Response To: Re: backup failed (FRANK)

Great! So, what was the final verdict on the cause? The solution? Share!

Art

Art S. Kagel, Principal Consultant
ASK Database Management

Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on 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 Tue, Jun 17, 2014 at 4:10 PM, FRANK <yunyaoqu@gmail.com> wrote:

> Thank Art!
>
> Finally I could managed to get rid of (drop) the corrupted indexes from
> that spot and completed an new backup successfully !
>
> Thank you all!
> Frank
>
> On Tue, Jun 17, 2014 at 10:05 AM, Art Kagel <art.kagel@gmail.com> wrote:
>
> > Chunk #99 isn't part of either of dbdata05 or dbdw06. Looks like an
> entire
> > SAN array has gone south!
> >
> > Not RAID5 I hope! B^(
> >
> > Check the SAN logs for errors and hope it's a soft problem. Meanwhile,
> get
> > out the last good backup and try to unload whatever tables you can for
> > ultimate backup in case the archives or log backups are not usable.
> > Remember "good DBAs are paranoid DBAs!"
> >
> > Art
> >
> > Art S. Kagel, Principal Consultant
> > ASK Database Management
> >
> > Blog: http://informix-myview.blogspot.com/
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and do not reflect on 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 Tue, Jun 17, 2014 at 9:56 AM, FRANK <yunyaoqu@gmail.com> wrote:
> >
> > > HI, Keith,
> > > I agree.
> > > The instance is up and online doing fine. But....
> > >
> > > The following is the result of oncehck and onstat -d
> > >
> > > Thanks
> > > Frank
> > >
> > > Validating indexes for noaa:informix.ds_head...
> > >
> > > Index ds_head_ipk
> > >
> > > Index fragment partition dbdata05 in DBspace dbdata05
> > > Could not check rowids and perform data<->index check
> > > ISAM error: Primary and Mirror chunks are bad
> > >
> > > Index ds_head_idx0
> > >
> > > Index fragment partition dbdw06 in DBspace dbdw06
> > > Could not check rowids and perform data<->index check
> > > ISAM error: Primary and Mirror chunks are bad
> > >
> > > Index w_ds_head_idx2
> > >
> > > Index fragment partition dbdata06 in DBspace dbdata06
> > > Could not bfget pagenum 0xec40, iserrno 0
> > > Not owner
> > >
> > > [informix@stephanie ontape]$ onstat -d
> > > IBM Informix Dynamic Server Version 11.50.FC8 -- On-Line -- Up 22:54:56
> > > -- 2870104 Kbytes
> > > Dbspaces
> > > address number flags fchunk nchunks pgsize flags
> > > owner name
> > > c20ae028 1 0x40001 1 1 2048 N B
> > > informix rootdbs
> > > c35dcb18 2 0x40001 2 3 2048 N B
> > > informix dblog1
> > > c35dccb0 3 0x40001 3 3 2048 N B
> > > informix dblog2
> > > c35dce48 4 0x42001 8 1 2048 N TB
> > > informix dbtemp1
> > > c35de028 5 0x42001 9 1 2048 N TB
> > > informix dbtemp2
> > > c35de1c0 6 0x42001 10 1 2048 N TB
> > > informix dbtemp3
> > > c35de358 7 0x40001 11 2 2048 N B
> > > informix dberdata00
> > > c35de4f0 8 0x48001 13 2 2048 N SB
> > > informix dbersbdata00
> > > c35de688 9 0x48001 15 2 2048 N SB
> > > informix dbersbdata01
> > > c35de820 10 0x40001 18 3 8192 N B
> > > informix dbdata09_1
> > > c35de9b8 11 0x40001 72 6 2048 N B
> > > informix dbdata09_2
> > > c35deb50 12 0x40001 19 2 2048 N B
> > > informix dbdata00
> > > c35dece8 13 0x40001 21 3 2048 N B
> > > informix dbdata01
> > > c35dee80 14 0x40001 23 2 2048 N B
> > > informix dbdata02
> > > c35e0028 15 0x40001 25 2 2048 N B
> > > informix dbdata03
> > > c35e01c0 16 0x40001 27 2 2048 N B
> > > informix dbdata04
> > > c35e0358 17 0x40001 29 2 2048 N B
> > > informix dbdata05
> > > c35e04f0 18 0x40001 31 4 2048 N B
> > > informix dbdata06
> > > c35e0688 19 0x40001 33 2 2048 N B
> > > informix dbdata07
> > > c35e0820 20 0x40001 35 3 2048 N B
> > > informix dbdata08
> > > c35e09b8 21 0x40001 37 5 2048 N B
> > > informix dbdata09
> > > c35e0b50 22 0x40001 39 3 2048 N B
> > > informix dbdata10
> > > c35e0ce8 23 0x40001 41 2 2048 N B
> > > informix dbdata11
> > > c35e0e80 24 0x40001 43 2 2048 N B
> > > informix dbdw00
> > > c35e1028 25 0x40001 45 7 2048 N B
> > > informix dbdw01
> > > c35e11c0 26 0x40001 47 3 2048 N B
> > > informix dbdw02
> > > c35e1358 27 0x40001 49 2 2048 N B
> > > informix dbdw03
> > > c35e14f0 28 0x40001 51 3 2048 N B
> > > informix dbdw04
> > > c35e1688 29 0x40001 53 2 8192 N B
> > > informix dbdw05
> > > c35e1820 30 0x40001 55 2 8192 N B
> > > informix dbdw06
> > > c35e19b8 31 0x40001 57 2 8192 N B
> > > informix dbdw07
> > > c35e1b50 32 0x40001 59 2 8192 N B
> > > informix dbdw08
> > > c35e1ce8 33 0x40001 90 5 8192 N B
> > > informix dbdata20
> > > c35e1e80 34 0x40001 63 1 2048 N B
> > > informix dbphylog
> > > c35e3028 35 0x40001 64 2 2048 N B
> > > informix dbdata12
> > > c35e31c0 36 0x40001 66 6 2048 N B
> > > informix dbdata13
> > > c35e3358 37 0x40001 93 4 8192 N B
> > > informix dbdata21
> > > c35e34f0 38 0x48001 97 2 2048 N SB
> > > informix dbsbdata00
> > > 38 active, 2047 maximum
> > > Chunks
> > > address chunk/dbs offset size free bpages
> > > flags pathname
> > > c20ae1c0 1 1 0 600000 585195
> > > PO-B- /usr/informix/dev-links/nsofops/rootdbs_ops
> > > c35e3688 2 2 0 5000000 199947
> > > PO-B- /usr/informix/dev-links/nsofops/dblog1_ops
> > > c35e3878 3 3 0 5000000 199947
> > > PO-B- /usr/informix/dev-links/nsofops/dblog2_ops
> > > c35e3a68 4 2 0 5000000 199997
> > > PO-B- /usr/informix/dev-links/nsofops/dblog1a_ops
> > > c35e3c58 5 3 0 5000000 199997
> > > PO-B- /usr/informix/dev-links/nsofops/dblog2a_ops
> > > c35e5028 6 2 0 5000000 199997
> > > PO-B- /usr/informix/dev-links/nsofops/dblog1b_ops
> > > c35e5218 7 3 0 5000000 199997
> > > PO-B- /usr/informix/dev-links/nsofops/dblog2b_ops
> > > c35e5408 8 4 0 3000000 2998596
> > > PO-B- /usr/informix/dev-links/nsofops/dbtemp1a_ops
> > > c35e55f8 9 5 0 3000000 2998596
> > > PO-B- /usr/informix/dev-links/nsofops/dbtemp2a_ops
> > > c35e57e8 10 6 0 3000000 2998596
> > > PO-B- /usr/informix/dev-links/nsofops/dbtemp3a_ops
> > > c35e59d8 11 7 0 5000000 4999947
> > > PO-B- /usr/informix/dev-links/nsofops/dberdata00_ops
> > > c35e5bc8 12 7 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dberdata00a_ops
> > > c35e5db8 13 8 0 5000000 4663405 4663405
> > > POSB- /usr/informix/dev-links/nsofops/dbersbdata00_ops
> > >
> > > Metadata 336542 27162 336542
> > > c35e6028 14 8 0 5000000 4663451 4663451
> > > POSB- /usr/informix/dev-links/nsofops/dbersbdata00a_ops
> > >
> > > Metadata 336546 199385 336546
> > > c35e6218 15 9 0 5000000 4663405 4663405
> > > POSB- /usr/informix/dev-links/nsofops/dbersbdata01_ops
> > >
> > > Metadata 336542 27162 336542
> > > c35e6408 16 9 0 5000000 4663451 4663451
> > > POSB- /usr/informix/dev-links/nsofops/dbersbdata01a_ops
> > >
> > > Metadata 336546 199385 336546
> > > c35e65f8 17 21 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata09c_ops
> > > c35e67e8 18 10 0 1250000 1227411
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata09d_ops
> > > c35e69d8 19 12 0 5000000 2001191
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata00_ops
> > > c35e6bc8 20 12 0 5000000 4920245
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata00a_ops
> > > c35e6db8 21 13 0 5000000 1116246
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata01_ops
> > > c35e7028 22 13 0 5000000 4315797
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata01a_ops
> > > c35e7218 23 14 0 5000000 1062985
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata02_ops
> > > c35e7408 24 14 0 5000000 4279997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata02a_ops
> > > c35e75f8 25 15 0 5000000 4154244
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata03_ops
> > > c35e77e8 26 15 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata03a_ops
> > > c35e79d8 27 16 0 5000000 4263203
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata04_ops
> > > c35e7bc8 28 16 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata04a_ops
> > > c35e7db8 29 17 0 5000000 4364412
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata05_ops
> > > c35e8028 30 17 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata05a_ops
> > > c35e8218 31 18 0 5000000 4982177
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata06_ops
> > > c35e8408 32 18 0 5000000 2076367
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata06a_ops
> > > c35e85f8 33 19 0 5000000 4999667
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata07_ops
> > > c35e87e8 34 19 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata07a_ops
> > > c35e89d8 35 20 0 5000000 762167
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata08_ops
> > > c35e8bc8 36 20 0 5000000 599509
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata08a_ops
> > > c35e8db8 37 21 0 5000000 4873082
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata09_ops
> > > c35e9028 38 21 0 5000000 4977261
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata09a_ops
> > > c35e9218 39 22 0 5000000 1258805
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata10_ops
> > > c35e9408 40 22 0 5000000 2706493
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata10a_ops
> > > c35e95f8 41 23 0 5000000 4262655
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata11_ops
> > > c35e97e8 42 23 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata11a_ops
> > > c35e99d8 43 24 0 5000000 1719340
> > > PO-B- /usr/informix/dev-links/nsofops/dbdw00_ops
> > > c35e9bc8 44 24 0 5000000 1795645
> > > PO-B- /usr/informix/dev-links/nsofops/dbdw00a_ops
> > > c35e9db8 45 25 0 5000000 513773
> > > PO-B- /usr/informix/dev-links/nsofops/dbdw01_ops
> > > c35ea028 46 25 0 5000000 4999575
> > > PO-B- /usr/informix/dev-links/nsofops/dbdw01a_ops
> > > c35ea218 47 26 0 5000000 3535925
> > > PO-B- /usr/informix/dev-links/nsofops/dbdw02_ops
> > > c35ea408 48 26 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdw02a_ops
> > > c35ea5f8 49 27 0 5000000 4152767
> > > PO-B- /usr/informix/dev-links/nsofops/dbdw03_ops
> > > c35ea7e8 50 27 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdw03a_ops
> > > c35ea9d8 51 28 0 5000000 4827332
> > > PO-B- /usr/informix/dev-links/nsofops/dbdw04_ops
> > > c35eabc8 52 28 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdw04a_ops
> > > c35eadb8 53 29 0 1250000 1185442
> > > PO-B- /usr/informix/dev-links/nsofops/dbdw05_ops
> > > c35ec028 54 29 0 1250000 1249997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdw05a_ops
> > > c35ec218 55 30 0 1250000 807172
> > > PO-B- /usr/informix/dev-links/nsofops/dbdw06_ops
> > > c35ec408 56 30 0 1250000 1249997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdw06a_ops
> > > c35ec5f8 57 31 0 1250000 1177488
> > > PO-B- /usr/informix/dev-links/nsofops/dbdw07_ops
> > > c35ec7e8 58 31 0 1250000 1249997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdw07a_ops
> > > c35ec9d8 59 32 0 1250000 273307
> > > PO-B- /usr/informix/dev-links/nsofops/dbdw08_ops
> > > c35ecbc8 60 32 0 1250000 1249997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdw08a_ops
> > > c35ecdb8 61 10 0 1250000 1249997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata09e_ops
> > > c35ee028 62 10 0 1250000 1249997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata09f_ops
> > > c35ee218 63 34 0 2000000 49947
> > > PO-B- /usr/informix/dev-links/nsofops/dbphylog_ops
> > > c35ee408 64 35 0 5000000 4522456
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata12_ops
> > > c35ee5f8 65 35 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata12a_ops
> > > c35ee7e8 66 36 0 5000000 4443266
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata13_ops
> > > c35ee9d8 67 36 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata13a_ops
> > > c35eebc8 68 21 0 5000000 4993773
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata09b_ops
> > > c35eedb8 69 25 0 5000000 4998743
> > > PO-B- /usr/informix/dev-links/nsofops/dbdw01b_ops
> > > c35f7028 70 26 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdw02b_ops
> > > c35f7218 71 36 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata13b_ops
> > > c35f7408 72 11 0 5000000 3931986
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata09a01_ops
> > > c35f75f8 73 11 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata09b01_ops
> > > c35f77e8 74 11 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata09c01_ops
> > > c35f79d8 75 11 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata09d01_ops
> > > c35f7bc8 76 11 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata09e01_ops
> > > c35f7db8 77 11 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata09f01_ops
> > > c35f9028 78 25 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdw01c_ops
> > > c35f9218 79 25 0 5000000 4973028
> > > PO-B- /usr/informix/dev-links/nsofops/dbdw01a01_ops
> > > c35f9408 80 36 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata13c_ops
> > > c35f95f8 81 25 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdw01b01_ops
> > > c35f97e8 82 25 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdw01c01_ops
> > > c35f99d8 83 36 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata13b01_ops
> > > c35f9bc8 84 21 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata09a02_ops
> > > c35f9db8 85 36 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata13a01_ops
> > > c35fc028 86 22 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata10b_ops
> > > c35fc218 87 28 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdw04b_ops
> > > c35fc408 88 20 0 5000000 2149633
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata08b_ops
> > > c35fc5f8 89 13 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata01a01_ops
> > > c35fc7e8 90 33 0 1250000 2139
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata20a_ops
> > > c35fc9d8 91 33 0 1250000 1207437
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata20b_ops
> > > c35fcbc8 92 33 0 1250000 1249997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata20c_ops
> > > c35fcdb8 93 37 0 1250000 7
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata21a_ops
> > > c35fe028 94 37 0 1250000 3891
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata21b_ops
> > > c35fe218 95 37 0 1250000 598477
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata21c_ops
> > > c35fe408 96 37 0 1250000 1249997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata21a01_ops
> > > c35fe5f8 97 38 0 5000000 4644862 4663405
> > > POSB- /usr/informix/dev-links/nsofops/dbsbdata00_ops
> > >
> > > Metadata 336542 164323 336542
> > > c35fe7e8 98 38 0 5000000 4650890 4663451
> > > POSB- /usr/informix/dev-links/nsofops/dbsbdata00a_ops
> > >
> > > Metadata 336546 336546 336546
> > > c35fe9d8 99 18 0 5000000 731413
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata06a01_ops
> > > c35febc8 100 18 0 5000000 4999997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata06a02_ops
> > > c35fedb8 101 33 0 1250000 1249997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata20c01_ops
> > > c3600028 102 33 0 1250000 1249997
> > > PO-B- /usr/informix/dev-links/nsofops/dbdata20c02_ops
> > > 102 active, 32766 maximum
> > > NOTE: The values in the "size" and "free" columns for DBspace chunks
> are
> > >
> > > displayed in terms of "pgsize" of the DBspace to which they belong.
> > > Expanded chunk capacity mode: always
> > >
> > > On Tue, Jun 17, 2014 at 9:40 AM, Keith Simmons <smiley73@gmail.com>
> > wrote:
> > >
> > > > Frank
> > > > This looks like a disk corruption, is the database behaving currently
> > ??
> > > > >From onstat -d do you know what is on chunk 99 ? What do onchecks
> > > against
> > > > the table show ?
> > > > Have you tried as second archive to see if it is a transient
> condition
> > ?
> > > > Make sure your latest complete archive and logs are secure and
> > available,
> > > > you may need to restore.
> > > > Keith
> > > >
> > > > On 17 June 2014 14:31, FRANK <yunyaoqu@gmail.com> wrote:
> > > >
> > > > > HI, Folks,
> > > > >
> > > > > IDs11.50 FC8, RHEL 6
> > > > >
> > > > > ontape is failed, the following is the info.
> > > > >
> > > > > Any suggestions?
> > > > >
> > > > > Thanks
> > > > > Frank
> > > > >
> > > > > 1)command:
> > > > >
> > > > > [informix@stephanie ontape]$ ontape -s -L 0
> > > > > Please mount tape 1 on /dbbackup/ontape/ontape_nsofpal and press
> > Return
> > > > to
> > > > > continue ...
> > > > > 10 percent done.
> > > > > Archive failed - function read archive backup failed code -1 errno
> 0
> > > > > Program over.
> > > > >
> > > > > 2) online log:
> > > > >
> > > > > 3:17:12 Maximum server connections 65
> > > > > 13:17:12 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
> > > > blocked
> > > > > 0, Plog used 16, Llog used 185
> > > > > 13:17:13 Level 0 Archive started on rootdbs, dblog1, dblog2,
> > > dberdata00,
> > > > > dbdata09_1, dbdata09_2, dbdata00, dbdata01, dbdata02, dbdata03,
> > > dbdata04,
> > > > > dbdata05, dbdata06, dbdata07, dbdata08, dbdata09, dbdata10,
> dbdata11,
> > > > > dbdw00, dbdw01, dbdw02, dbdw03, dbdw04, dbdw05, dbdw06, dbdw07,
> > dbdw08,
> > > > > dbdata20, dbphylog, dbdata12, dbdata13, dbdata21, dbersbdata00,
> > > > > dbersbdata01, dbsbdata00
> > > > > 13:21:50 I/O read chunk 99, pagenum 2, pagecnt 7 --> errno = 2
> > > > > 13:21:50 Assert Warning: ISAM error: An error has occurred during
> > > archive
> > > > > back up.
> > > > >
> > > > > 13:21:50 IBM Informix Dynamic Server Version 11.50.FC8
> > > > > 13:21:50 Who: Session(49353, informix@stephanie, 31263,
> 0xc23980f0)
> > > > >
> > > > > Thread(55326, arcbackup1, c2367f30, 7)
> > > > >
> > > > > File: rsarcutl.c Line: 124
> > > > > 13:21:50 Action: arc_pages()/bfphysio()
> > > > > 13:21:50 stack trace for pid 842 written to /tmp/af.dc0640ee
> > > > > 13:21:52 See Also: /tmp/af.dc0640ee
> > > > > 13:21:52 ISAM error: An error has occurred during archive back up.
> > > > >
> > > > > 13:21:53 Archive on rootdbs, dblog1, dblog2, dberdata00,
> dbdata09_1,
> > > > > dbdata09_2, dbdata00, dbdata01, dbdata02, dbdata03, dbdata04,
> > dbdata05,
> > > > > dbdata06, dbdata07, dbdata08, dbdata09, dbdata10, dbdata11, dbdw00,
> > > > dbdw01,
> > > > > dbdw02, dbdw03, dbdw04, dbdw05, dbdw06, dbdw07, dbdw08, dbdata20,
> > > > dbphylog,
> > > > > dbdata12, dbdata13, dbdata21, dbersbdata00, dbersbdata01,
> dbsbdata00
> > > > > ABORTED.
> > > > > 13:21:53 Aborted by client.
> > > > > 13:22:19 Checkpoint Completed: duration was 0 seconds.
> > > > > 13:22:19 Tue Jun 17 - loguniq 91344, logpos 0xa46e018, timestamp:
> > > > > 0x3e945f51 Interval: 334495
> > > > > 13:22:19 Maximum server connections 65
> > > > > 13:22:20 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
> > > > blocked
> > > > > 0, Plog used 28, Llog used 410
> > > > >
> > > > > 3) af file
> > > > >
> > > > > [informix@stephanie tmp]$ more af.dc0640ee
> > > > > 13:21:50 mt_aio_wait(0xc63b3608)
> > > > > 13:21:50 chunkio(101, 0x0xc6356c00, 0x2, 7, 0x0xc35fe9d8, 33, 1)
> > errno
> > > 2
> > > > > AIOREQ *a
> > > > > 00000000c70c68c0: 00000000 00000000 0a000000 00000000 ........
> > ........
> > > > > 00000000c70c68d0: 8adc0000 00000000 00000000 00000000 ........
> > ........
> > > > > 00000000c70c68e0: 00000000 00000000 00000000 00000000 ........
> > ........
> > > > > 00000000c70c68f0: f8383bc6 00000000 18333bc6 00000000 .8;.....
> > .3;.....
> > > > > 00000000c70c6900: 00000000 00000000 00000000 00000000 ........
> > ........
> > > > > 00000000c70c6910: c03b0000 41494f72 65710000 00000000 .;..AIOr
> > eq......
> > > > > 00000000c70c6920: 00000000 00000000 d1070000 00000000 ........
> > ........
> > > > > 00000000c70c6930: 00000000 00000000 04000000 01040000 ........
> > ........
> > > > > 00000000c70c6940: 0b000000 02000000 01000000 00000000 ........
> > ........
> > > > > 00000000c70c6950: 01000000 00000000 e0363bc6 00000000 ........
> > .6;.....
> > > > > 00000000c70c6960: 00000000 00000000 01000000 09000000 ........
> > ........
> > > > > 00000000c70c6970: 01000000 00000000 00000000 00000000 ........
> > ........
> > > > > 00000000c70c6980: 00000000 00000000 00000000 00000000 ........
> > ........
> > > > > 00000000c70c6990: 00000000 00000000 ........
> > > > > 13:21:50
> > > > > 13:21:50 IBM Informix Dynamic Server Version 11.50.FC8 Software
> > Serial
> > > > > Number AAA#B000000
> > > > > 13:21:50 Assert Warning: ISAM error: An error has occurred during
> > > archive
> > > > > back up.
> > > > >
> > > > > 13:21:50 Who: Session(49353, informix@stephanie, 31263,
> 0xc23980f0)
> > > > >
> > > > > Thread(55326, arcbackup1, c2367f30, 7)
> > > > >
> > > > > File: rsarcutl.c Line: 124
> > > > > 13:21:50 Action: arc_pages()/bfphysio()
> > > > > 13:21:50 Raw hex dump of stack located in /tmp/af.dc0640ee.rawstk
> > > > > 13:21:50 Stack for thread: 55326 arcbackup1
> > > > > base: 0x00000000c70b6000
> > > > > len: 69632
> > > > >
> > > > > pc: 0x00000000010c91d7
> > > > > tos: 0x00000000c70c5ef0
> > > > > state: running
> > > > >
> > > > > vp: 7
> > > > > 0x00000000010c91d7 (oninit) afstack
> > > > > 0x00000000010cb12c (oninit) afhandler
> > > > > 0x00000000010cb9a7 (oninit) afwarn_interface
> > > > > 0x0000000000c7d7a6 (oninit) oops_error
> > > > > 0x0000000000c8943a (oninit) arc_pages
> > > > > 0x0000000000c8959f (oninit) arc_dbspace
> > > > > 0x0000000000c8a890 (oninit) arc_scanner
> > > > > 0x000000000109a9bb (oninit) startup
> > > > >
> > > > > 13:21:52 See Also: /tmp/af.dc0640ee
> > > > > ---------------------------------
> > > > > Begin System Alarm Program Output
> > > > > ---------------------------------
> > > > > Assertion Failure Type: Warning
> > > > > Host Name: stephanie
> > > > > Database Server Name: nsofpal_tcp
> > > > > Time of failure: Tue Jun 17 13:21:52 UTC 2014
> > > > > AF file: /tmp/af.dc0640ee
> > > > > Shared memory file: None
> > > > > System Blocking: OFF
> > > > >
> > > > > -------------------------------
> > > > > End System Alarm Program Output
> > > > > -------------------------------
> > > > > 13:21:52 sh /usr/informix/etc/evidence.sh 1 0 /tmp/af.dc0640ee
> 49353
> > > > > 0xc2367f30 55326 0xc54c53a8 1025 0 0 0 0
> > > > > 13:21:52
> > > > > ------------------ End of assertion failure 0 -----------------
> > > > >
> > > > > --001a113a5fd0fbac6504fc08273b
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
> *******************************************************************************
> > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > > >
> > > > >
> > > >
> > > > --047d7b41c3daa6203f04fc084810
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
> *******************************************************************************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > >
> > > --001a1134aeb4eb2e7a04fc088340
> > >
> > >
> > >
> > >
> >
> >
>
> *******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --001a11c3b5dc411a1904fc08a378
> >
> >
> >
> >
>
> *******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001a113550d6b60e7d04fc0dbc80
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--089e0160bac067a3a204fc0dcfec

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.