Author Topic: MP odwek and Z base code- connection pooling  (Read 3964 times)

geoffwilde

  • Administrator
  • Sr. Member
  • *****
  • Posts: 253
  • z/os erm icn
    • View Profile
MP odwek and Z base code- connection pooling
« on: November 07, 2012, 02:31:18 PM »
Any insight into connection pooling with a Z library and object server, and ODWEK running on linux?  It seems the connection is established on a single lpar, rather than across the sysplex and if that lpar goes down, so does the connection pool. 

I'm not an odwek developer, so speak in English terms please.
President, OnDemand Users Group
Lead Technician for Content Manager OnDemand @
US Bank
#zSeries

hakan_carlberg

  • Jr. Member
  • **
  • Posts: 83
    • View Profile
Re: MP odwek and Z base code- connection pooling
« Reply #1 on: November 08, 2012, 09:05:07 AM »
Hi Geoff

English ?? Why not ... Swedish
Anyway.
Look at SG24-7511-00, search for 'Sysplex Distributor', Figure 4-4.
Since your ODWek-application is only a Client to ARSSOCKD, then I can't understand why you have that problem.

I tried this scenario today, where I have 2 Lpar running the same OD-instance.
1) Started an application(doing connection pooling) thru batch. This application creates a pool, retrieves 1 document and sleeps for 60 seconds. At this moment I had ARSSOCKD running on LPAR1.
2) during the sleep, which was 60 seconds, I stopped ARSSOCKD on LPAR1 and started on LPAR2.
3)  When the application woke up, it did a new retrieve of a document, and was successfull without doing a logon again.
Then it slept for 60 seconds.
4) I stopped the ARSSOCKD on LPAR2, started on LPAR1
5) Application woke up and did a new retrieve, successfull without doing a new logon.

What am I missing ?
Regards
/H Carlberg

geoffwilde

  • Administrator
  • Sr. Member
  • *****
  • Posts: 253
  • z/os erm icn
    • View Profile
Re: MP odwek and Z base code- connection pooling
« Reply #2 on: November 08, 2012, 11:35:30 AM »
I don't think we sleep at all, based on our volume. but we had an instance where the lpar went down, and all connections were lost. We had to restart the odwek servers. Our odwek are running off the mainframe on a unix box.
President, OnDemand Users Group
Lead Technician for Content Manager OnDemand @
US Bank
#zSeries

hakan_carlberg

  • Jr. Member
  • **
  • Posts: 83
    • View Profile
Re: MP odwek and Z base code- connection pooling
« Reply #3 on: November 08, 2012, 10:30:24 PM »
Hi
The reason for me doing 'sleep' was just because I didn't wanted a lot of messages at this run, so I wanted just to have 'time' to switch ARSSOCKD.
I' ll running the code from a Windows-machine later today and let you know the outcome.
But I doubt it will be any difference

Regards
/H Carlberg

hakan_carlberg

  • Jr. Member
  • **
  • Posts: 83
    • View Profile
Re: MP odwek and Z base code- connection pooling
« Reply #4 on: November 09, 2012, 11:35:35 AM »
Hi Geoff

Now I've tried with the ODWek-application running on Windows, and switching ARSSOCKD between two different LPAR's.
And the application do NOT!! need to do creation of the connection-pool if I stop/start the ARSSOCKD between two different LPAR's.

Regards
/H Carlberg
 

geoffwilde

  • Administrator
  • Sr. Member
  • *****
  • Posts: 253
  • z/os erm icn
    • View Profile
Re: MP odwek and Z base code- connection pooling
« Reply #5 on: November 13, 2012, 11:01:44 AM »
hmmm- I'm befuddled then as to why we lost all the connectivity on this day.
President, OnDemand Users Group
Lead Technician for Content Manager OnDemand @
US Bank
#zSeries