International Informix Users Group

	Informix News

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 Previous news items

End of Support Dates

IDS 11.10 - 30 Sep 2012 Subscribe to notifications

Home Member Area About IIUG Help

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

IDS Forum

RE: HDR Issue / ER Differences

Posted By: Phil Torkington
Date: Saturday, 17 December 2005, at 1:18 p.m.

In Response To: HDR Issue / ER Differences (Phil Torkington)

Thanks for all the advice

The fact that the two servers are totally independent is very appealing
but also take note of the extra set-up / maintenance over HDR.

We will test ER in the new year and get a feel for how much more setting
up/maintenance is needed.

________________________________

From: Madison Pruet [mailto:mpruet@us.ibm.com]
Sent: 15 December 2005 20:24
To: Phil Torkington
Cc: forum.subscriber@iiug.org; ids@iiug.org
Subject: Re: HDR Issue / ER Differences [6113]

With ER the servers are totally independent. However ER is a bit more
tricky to set up.
I think that we've improved the setup issues significantly with v10,
especially with the additional functionality which was activated in
v10UC4. This would allow you, for instance, to set up replication via
templates with basically only two commands.

However some things to think about. ER does not currently automatically
create replication on objects which do not yet exist. Also, ER does not
currently support the automatic creation of secondary objects such as
triggers or stored procedures.

M.P.
"Phil Torkington" <PTorkington@lastminute.com>

"Phil Torkington" <PTorkington@lastminute.com>
Sent by: forum.subscriber@iiug.org

12/15/2005 11:23 AM

To

ids@iiug.org

cc

Subject

HDR Issue / ER Differences [6113]

Hi All,

We are running HDR between two informix 9.4FC6 instances on solaris
9....we have just experienced a chronic hardware failure on our
secondary (Sun still trying to find out why - no syslog errors or
diagnostics yet) which caused a long checkpoint followed by a rollback
error (see below) which managed to corrupt two data chunks on our
primary server. IBM tech support dialed in and managed to bring the
chunks online which enabled us to recover the data affected. Tech
Support believe this to be a bug but are still looking into the
diagnostic information.

The real reason for bringing this to the group's attention is to try to
understand if we had been running ER rather than HDR would there be less
chance of suffering a failure on our primary server ? Are there
architectural differences between the two replication methods which
would make the primary server less reliant on whats happening on the
secondary server ?

Thanks in advance

Phil Torkington

Primary Online Log.... (can't get to the secondary one yet ;-) )

09:27:15 Checkpoint Completed: duration was 4 seconds.
09:27:15 Checkpoint loguniq 36786, logpos 0xec558c, timestamp:
0xc18b696e

09:27:15 Maximum server connections 921
09:43:05 DR: ping timeout
09:43:05 DR: Receive error
09:43:05 ASF Echo-Thread Server: asfcode = -25582: oserr = 0: errstr =
: Network connection is broken.

09:43:05 Checkpoint Completed: duration was 650 seconds.
09:43:05 Checkpoint loguniq 36786, logpos 0x1303018, timestamp:
0xc18f9e3d

09:43:05 Maximum server connections 921
09:43:06 Assert Failed: Rollback error 126
09:43:06 IBM Informix Dynamic Server Version 9.40.FC6
09:43:06 Who: Session(721514, ebask13@prdpctb1701.lastminute.com, -1,
1a0e76178)
Thread(766809, sqlexec, 1a1b11388, 4)
File: rstrans.c Line: 2427
09:43:06 Results: Log record (OLDRSAM:HUPDATE) in log 36786, offset
0x1309570 was not rolled back
09:43:06 Action: Use 'onlog' to view the transaction and repair
manually.
09:43:06 stack trace for pid 4211 written to
/temp/informix_dump/af.b7413aa9
09:43:06 See Also: /temp/informix_dump/af.b7413aa9, shmem.b7413aa9.0
09:43:07 DR: Turned off on primary server
09:43:07 DR: Cannot connect to secondary server
09:43:07 Assert Failed: Rollback error 126
09:43:07 IBM Informix Dynamic Server Version 9.40.FC6
09:43:07 Who: Session(721935, ebask13@prdpctb1711.lastminute.com, -1,
19fdac1a8)
Thread(767232, sqlexec, 199ec30c0, 3)
File: rstrans.c Line: 2427
09:43:07 Results: Log record (OLDRSAM:HUPDATE) in log 36786, offset
0x130a030 was not rolled back
09:43:07 Action: Use 'onlog' to view the transaction and repair
manually.
09:43:07 stack trace for pid 4210 written to
/temp/informix_dump/af.b8e83aab
09:43:07 See Also: /temp/informix_dump/af.b8e83aab, shmem.b8e83aab.0
09:43:09 Assert Failed: Rollback error 126
09:43:09 IBM Informix Dynamic Server Version 9.40.FC6
09:43:09 Who: Session(720848, ebask13@prdpctb1801.lastminute.com, -1,
19d749aa8)
Thread(766143, sqlexec, 199ed2570, 1)
File: rstrans.c Line: 2427
09:43:09 Results: Log record (OLDRSAM:HUPDATE) in log 36786, offset
0x13093d0 was not rolled back
09:43:09 Action: Use 'onlog' to view the transaction and repair
manually.
09:43:09 stack trace for pid 4208 written to
/temp/informix_dump/af.b4a73aac
09:43:09 See Also: /temp/informix_dump/af.b4a73aac, shmem.b4a73aac.0
09:47:09 Rollback error 126
09:47:09 Rollback error 126
09:47:09 Rollback error 126
09:47:10 Assert Failed: Rollback error 126
09:47:10 IBM Informix Dynamic Server Version 9.40.FC6
09:47:10 Assert Failed: Rollback error 126
09:47:10 Who: Session(720848, ebask13@prdpctb1801.lastminute.com, -1,
19d749aa8)
Thread(766143, sqlexec, 199ed2570, 1)
File: rsextlog.c Line: 1643
09:47:10 IBM Informix Dynamic Server Version 9.40.FC6
09:47:10 Who: Session(721935, ebask13@prdpctb1711.lastminute.com, -1,
19fdac1a8)
Thread(767232, sqlexec, 199ec30c0, 3)
File: rsextlog.c Line: 1643
09:47:10 Results: Log record (OLDRSAM:HUPDATE) in log 36786, offset
0x130a030 was not rolled back
09:47:10 Action: Use 'onlog' to view the transaction and repair
manually.
09:47:10 stack trace for pid 4210 written to
/temp/informix_dump/af.b8e83aab
09:47:10 See Also: /temp/informix_dump/af.b8e83aab
09:47:10 Assert Failed: Rollback error 126
09:47:10 IBM Informix Dynamic Server Version 9.40.FC6
09:47:10 Who: Session(721514, ebask13@prdpctb1701.lastminute.com, -1,
1a0e76178)
Thread(766809, sqlexec, 1a1b11388, 4)
File: rsextlog.c Line: 1643
09:47:10 Results: Log record (OLDRSAM:HUPDATE) in log 36786, offset
0x1309570 was not rolled back
09:47:10 Action: Use 'onlog' to view the transaction and repair
manually.
09:47:10 stack trace for pid 4211 written to
/temp/informix_dump/af.b7413aa9
09:47:10 See Also: /temp/informix_dump/af.b7413aa9
09:47:10 Results: Log record (OLDRSAM:HUPDATE) in log 36786, offset
0x13093d0 was not rolled back
09:47:10 Action: Use 'onlog' to view the transaction and repair
manually.
09:47:10 stack trace for pid 4208 written to
/temp/informix_dump/af.b4a73aac
09:47:10 See Also: /temp/informix_dump/af.b4a73aac
09:47:30 Rollback error 126
09:47:30 Rollback error 126
09:47:30 Rollback error 126
09:47:31 Assert Failed: Dynamic Server must abort
09:47:31 IBM Informix Dynamic Server Version 9.40.FC6
09:47:31 Who: Session(721514, ebask13@prdpctb1701.lastminute.com, -1,
1a0e76178)
Thread(766809, sqlexec, 1a1b11388, 4)
File: rslog.c Line: 3511
09:47:31 Results: Dynamic Server must abort
09:47:31 Action: Reinitialize shared memory
09:47:31 stack trace for pid 4211 written to
/temp/informix_dump/af.b7413aa9
09:47:31 See Also: /temp/informix_dump/af.b7413aa9
09:47:32 Assert Failed: Dynamic Server must abort
09:47:32 IBM Informix Dynamic Server Version 9.40.FC6
09:47:32 Who: Session(720848, ebask13@prdpctb1801.lastminute.com, -1,
19d749aa8)
Thread(766143, sqlexec, 199ed2570, 1)
File: rslog.c Line: 3511
09:47:32 Results: Dynamic Server must abort
09:47:32 Action: Reinitialize shared memory
09:47:32 stack trace for pid 4208 written to
/temp/informix_dump/af.b4a73aac
09:47:32 See Also: /temp/informix_dump/af.b4a73aac
09:47:32 Assert Failed: Dynamic Server must abort
09:47:32 IBM Informix Dynamic Server Version 9.40.FC6
09:47:32 Who: Session(721935, ebask13@prdpctb1711.lastminute.com, -1,
19fdac1a8)
Thread(767232, sqlexec, 199ec30c0, 3)
File: rslog.c Line: 3511
09:47:32 Results: Dynamic Server must abort
09:47:32 Action: Reinitialize shared memory
09:47:32 stack trace for pid 4210 written to
/temp/informix_dump/af.b8e83aab
09:47:32 See Also: /temp/informix_dump/af.b8e83aab
09:47:51 rslog.c, line 3511, thread 766809, proc id 4211, Dynamic
Server must abort.
09:47:51 rslog.c, line 3511, thread 767232, proc id 4210, Dynamic
Server must abort.
09:47:51 rslog.c, line 3511, thread 766143, proc id 4208, Dynamic
Server must abort.
09:47:52 Fatal error in ADM VP at mt.c:12358
09:47:52 Unexpected virtual processor termination, pid = 4210, exit =
0x100

09:47:53 PANIC: Attempting to bring system down

**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************

[demime 1.01d removed an attachment of type image/gif which had a name of image001.gif]

[demime 1.01d removed an attachment of type image/gif which had a name of image002.gif]

[demime 1.01d removed an attachment of type image/gif which had a name of image003.gif]

Messages In This Thread

HDR Issue / ER Differences
Phil Torkington -- Thursday, 15 December 2005, at 12:23 p.m.
- RE: HDR Issue / ER Differences
  Thirugnanam, Kannan -- Thursday, 15 December 2005, at 2:13 p.m.
- RE: HDR Issue / ER Differences
  Lello, Nick -- Thursday, 15 December 2005, at 2:54 p.m.
  - RE: HDR Issue / ER Differences
    Ravi T -- Thursday, 15 December 2005, at 4:18 p.m.
- Re: HDR Issue / ER Differences
  AJAY GUPTA -- Friday, 16 December 2005, at 2:05 p.m.
- RE: HDR Issue / ER Differences
  Phil Torkington -- Saturday, 17 December 2005, at 1:18 p.m.

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

IDS Forum is maintained by Administrator with WebBBS 5.12.