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: Session "Waiting on a transaction"

Posted By: Art Kagel
Date: Sunday, 23 August 2015, at 9:34 a.m.

In Response To: Re: Session "Waiting on a transaction" (Frank Langelage)

Then create local synonyms for each of the tables you need to modify in the
other database so you can use local SQL in a single database. There's more
than one way to skin a cat.

Art

Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com

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 Sun, Aug 23, 2015 at 7:36 AM, Frank Langelage <frank@lafr.de> wrote:

> Thanks Art.
> But as I am using an Java Enterprise Edition application server I do not
> have this level of control over the statements and the connections used.
> The aplication server handles the connections and transactions.
> Different database, different connection.
>
> Frank
>
> On 23.08.15 11:11, Art Kagel wrote:
> > Frank:
> >
> > If you just use the SQL "BEGIN WORK" and "COMMIT WORK" Informix can
> manage
> > the transaction across multiple databases and servers without having to
> > use XA transactions. Just process inserts, updates, and deletes to both
> > databases through a single connection as remote references. Example:
> >
> > connect to database1@servername;
> > begin work;
> > update local_table1 set col1 = value1 where key1 = 123456;
> > update database2@servername:remote_table1 set col3 = value3 where key =
> > 54326;
> > commit work;
> >
> > Since the second database resides in the same server as the connected
> > database the reference to "database2@servername" doesn't strictly
> require
> > the "@servername" reference, but I include it for completeness. Informix
> > will handle updating the tables in both database (whether in the same
> > server instance or different instances) including managing the
> possibility
> > that it will lose connectivity with the "remote" database's server using
> > two-phase commit protocols. This is stated in the Administrator's Guide
> on
> > page 1-8 and here is a Wiki reference describing the protocol:
> > https://en.wikipedia.org/wiki/Two-phase_commit_protocol
> >
> > I hope this helps.
> >
> > Art
> >
> > Art S. Kagel, President and Principal Consultant
> > ASK Database Management
> > www.askdbmgt.com
> >
> > 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 Sun, Aug 23, 2015 at 3:44 AM, Frank Langelage <frank@lafr.de> wrote:
> >
> >> Art,
> >>
> >> could you explain more about this or reference a documentation?
> >> I never heard of it.
> >> But I'm bound to what application server supports.
> >>
> >> Frank
> >>
> >> On 11.08.15 23:45, Art Kagel wrote:
> >>> Have you tried this with native Informix two phase commit transactions
> >> (ie
> >>> no XA)? XA transactions carry a lot of overhead.
> >>>
> >>> Art
> >>>
> >>> Art S. Kagel, President and Principal Consultant
> >>> ASK Database Management
> >>> www.askdbmgt.com
> >>>
> >>> 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, Aug 11, 2015 at 3:40 PM, Frank Langelage <frank@lafr.de>
> wrote:
> >>>
> >>>> Hello,
> >>>>
> >>>> I'm using Wildfly application server (JEE server) together with
> Informix
> >>>> 12.10.FC5 as the database on Oracle Solaris SPARC 10.
> >>>> It's using distributed (XA) transaction using 2 databases on the same
> >>>> instance in this case.
> >>>> On start up the server gets stuck at some point and then prints out a
> >>>> transaction timeout.
> >>>> On the database level I see the output shown below. Note the session
> >>>> 3018 with flags T--P---.
> >>>> According to http://www.oninit.com/onstat/index.php?id=u the first
> flag
> >>>> T means: Waiting on a transaction. Can anybody explain what this means
> >>>> exactly?
> >>>>
> >>>> If only the wildfly10 instance database is on this Informix instance
> and
> >>>> the application database on another Informix instance or on another
> DBMS
> >>>> like Oracle the problem does not appear.
> >>>> I already reduced isolation level to dirty read, but this did not
> help.
> >>>>
> >>>> Any hints?
> >>>>
> >>>> Regards, Frank
> >>>>
> >>>> ---------------------------------
> >>>>
> >>>> IBM Informix Dynamic Server Version 12.10.FC5IE -- On-Line -- Up 27
> days
> >>>> 23:35:43 -- 1540096 Kbytes
> >>>> Userthreads
> >>>> address flags sessid user tty wait tout
> >>>> locks nreads nwrites
> >>>> 1147e2028 ---P--D 1 informix - 0 0 0
> >>>> 46 500
> >>>> 1147e28e8 ---P--F 0 informix - 0 0 0
> >>>> 0 13078
> >>>> 1147e31a8 ---P--F 0 informix - 0 0 0
> >>>> 0 524
> >>>> 1147e3a68 ---P--F 0 informix - 0 0 0
> >>>> 0 4943
> >>>> 1147e4328 ---P--F 0 informix - 0 0 0
> >>>> 0 4
> >>>> 1147e4be8 ---P--F 0 informix - 0 0 0
> >>>> 0 10
> >>>> 1147e54a8 ---P--F 0 informix - 0 0 0
> >>>> 0 0
> >>>> 1147e5d68 ---P--F 0 informix - 0 0 0
> >>>> 0 0
> >>>> 1147e6628 ---P--F 0 informix - 0 0 0
> >>>> 0 0
> >>>> 1147e6ee8 ---P--- 9 informix - 0 0 0
> >>>> 0 0
> >>>> 1147e77a8 ---P--B 10 informix - 0 0 0
> >>>> 286591 576
> >>>> 1147e8068 Y--P--D 11 informix - 1159705d8 0 0
> >>>> 37637603 0
> >>>> 1147e8928 ---P--D 12 informix - 0 0 0
> >>>> 0 0
> >>>> 1147e91e8 Y--P--- 3012 mbi - 1181032f8 0 2
> >>>> 0 0
> >>>> 1147e9aa8 ---P--D 16 informix - 0 0 0
> >>>> 0 0
> >>>> 1147ea368 Y--P--- 3016 mbi - 1179ec6e8 0 2
> >>>> 0 0
> >>>> 1147eac28 ---P--D 17 informix - 0 0 0
> >>>> 2 0
> >>>> 1147eb4e8 ---P--D 18 informix - 0 0 0
> >>>> 0 0
> >>>> 1147ebda8 ---P--D 19 informix - 0 0 0
> >>>> 0 0
> >>>> 1147ec668 ---P--- 32 informix - 0 0 1
> >>>> 7037 39254
> >>>> 1147ecf28 Y--P--D 28 informix - 10a2ddc30 0 0
> >>>> 0 0
> >>>> 1147ed7e8 ---P--- 30 informix - 0 0 1
> >>>> 11 0
> >>>> 1147ee0a8 ---P--- 31 informix - 0 0 2
> >>>> 317 47207
> >>>> 1147ee968 ---P--- 33 informix - 0 0 1
> >>>> 2609 39140
> >>>> 1147ef228 Y--P--- 3017 mbi - 117ea8028 0 0
> >>>> 0 0
> >>>> 1147efae8 Y--P--- 2999 mbi - 1180f1348 0 1
> >>>> 0 0
> >>>> 1147f03a8 Y--P--- 3015 mbi - 11675e388 0 2
> >>>> 0 0
> >>>> 1147f0c68 Y--P--- 3014 mbi - 1162f96e8 0 2
> >>>> 0 0
> >>>> 1147f1528 Y--P--- 3019 mbi - 116fd06e8 0 2
> >>>> 0 0
> >>>> 1147f1de8 Y--P--- 2997 mbi - 116dc8778 0 1
> >>>> 0 0
> >>>> 1147f26a8 Y--P--- 2995 mbi - 1180f1978 0 1
> >>>> 0 0
> >>>> 1147f2f68 Y--P--- 3013 mbi - 1166cdd18 0 2
> >>>> 0 83
> >>>> 1147f3828 Y--P--- 3004 mbi - 117ea8e38 0 1
> >>>> 0 0
> >>>> 1147f40e8 T--P--- 3018 mbi - 114831500 0 0
> >>>> 0 0
> >>>> 34 active, 128 total, 36 maximum concurrent
> >>>>
> >>>> Sess SQL Current Iso Lock SQL ISAM F.E.
> >>>> Id Stmt type Database Lvl Mode ERR ERR Vers
> >>>> Explain
> >>>> 3019 - wildfly10 DRU Wait 10 0 0 9.28 Off
> >>>> 3018 - wildfly10 DRU Wait 10 0 0 9.28 Off
> >>>> 3017 SELECT neu2e_langfr DRU Wait 8 0 0 9.28 Off
> >>>> 3016 - neu2e_langfr DRU Wait 8 0 0 9.28 Off
> >>>> 3015 - wildfly10 DRU Wait 10 0 0 9.28 Off
> >>>> 3014 - neu2e_langfr DRU Wait 8 0 0 9.28 Off
> >>>> 3013 - wildfly10 DRU Wait 10 0 0 9.28 Off
> >>>> 3012 SELECT wildfly10 DRU Wait 10 0 0 9.28 Off
> >>>> 3004 - neu2e_langfr DR Wait 0 0 9.35 Off
> >>>> 2999 - neu2e_langfr DR Wait 0 0 9.35 Off
> >>>> 2997 SELECT neu2e_langfr DR Wait 0 0 9.35 Off
> >>>> 2995 - neu2e_langfr DR Wait 0 0 9.35 Off
> >>>> 33 sysadmin DR Wait 5 0 0 - Off
> >>>> 32 sysadmin DR Wait 5 0 0 - Off
> >>>> 31 sysadmin DR Wait 5 0 0 - Off
> >>>> 30 sysadmin CR Not Wait 0 0 - O
> >>>>
> >>>>
> >>>>
> >>>>
> >>
> >
>
> *******************************************************************************
> >>>> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>>>
> >>>>
> >>> --001a113ebc3c8c5e93051d1003e7
> >>>
> >>>
> >>>
> >>
> >
>
> *******************************************************************************
> >>> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>>
> >>>
> >>
> >>
> >>
> >
>
> *******************************************************************************
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>
> >>
> > --089e01184b9ad52973051df6e24e
> >
> >
> >
>
> *******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--089e01184b9a9eee4c051dfa907b

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.