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: backup failed

Posted By: FRANK
Date: Tuesday, 17 June 2014, at 4:10 p.m.

In Response To: Re: backup failed (Art Kagel)

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

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.