Timeout when SERVER is down

Horacio Villa

Timeout when SERVER is down
Hi list,

I'm looking for a workaround for this problem.
A COBOL/CICS/DB2 program running on OS/390 2.10, DB2 V5, is issuing a
CONNECT statement to a DB2 on AIX 4.3.3, DB2 V7.1
Whenever this server is down (not responding) it takes about 3 minutes to
get an error sqlcode.
This time is unacceptable for users.
Does anybody know what can I do to get a quicker response?

Thanks in advance,

Horacio Villa

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Horacio Villa

Timeout when SERVER is down
(in response to Horacio Villa)
Sorry if you get this for a second time, but I'm not sure if the list was
up when I first sent it (no answers yet).
Kind regards,
Horacio Villa

----- Forwarded by Horacio Villa/Argentina/Contr/IBM on 12/04/03 04:20 PM
-----

Horacio Villa
To:
12/01/03 08:28 PM cc:
From: Horacio [login to unmask email]
Subject: Timeout when SERVER is down





Hi list,

I'm looking for a workaround for this problem.
A COBOL/CICS/DB2 program running on OS/390 2.10, DB2 V5, is issuing a
CONNECT statement to a DB2 on AIX 4.3.3, DB2 V7.1
Whenever this server is down (not responding) it takes about 3 minutes to
get an error sqlcode.
This time is unacceptable for users.
Does anybody know what can I do to get a quicker response?

Thanks in advance,

Horacio Villa

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Mike Polley

Re: Timeout when SERVER is down
(in response to Horacio Villa)
Horacio, Can't actually tell you how to get a quicker response; however,
just to stir your mind: If the users are given a screen to enter data which
takes a few minutes and then depresses enter and waits another few minutes
only to find out the server is down, then I can understand the users not
being happy. If you try a Connect prior to displaying the initial screen,
then maybe the 3 mins wouldn't seem as long. HTH

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
Horacio Villa
Sent: Thursday, December 04, 2003 2:16 PM
To: [login to unmask email]
Subject: Timeout when SERVER is down

Sorry if you get this for a second time, but I'm not sure if the list was
up when I first sent it (no answers yet).
Kind regards,
Horacio Villa

----- Forwarded by Horacio Villa/Argentina/Contr/IBM on 12/04/03 04:20 PM
-----

Horacio Villa
To:
12/01/03 08:28 PM cc:
From: Horacio
[login to unmask email]
Subject: Timeout when SERVER
is down





Hi list,

I'm looking for a workaround for this problem.
A COBOL/CICS/DB2 program running on OS/390 2.10, DB2 V5, is issuing a
CONNECT statement to a DB2 on AIX 4.3.3, DB2 V7.1
Whenever this server is down (not responding) it takes about 3 minutes to
get an error sqlcode.
This time is unacceptable for users.
Does anybody know what can I do to get a quicker response?

Thanks in advance,

Horacio Villa

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Edward Long

Re: Timeout when SERVER is down
(in response to Mike Polley)
What are IDTHION(SP),the IRLM timeout, the other DB2
timeout values and the SMF timeout values set to on
the V5 system?

If you find the ones' set to 3 minutes (180 seconds)
then the simplest cure is to lower it. This also could
have other less attractive implications however.

Another consideration, and I don't say this flippantly
like the IBM'er who originally said it to me years
ago, make sure the first system doesn't go down very
often.

This whole thing is only an issue if the originating
system is perceived to be unreliable.
Prior to Parallel Sysplex and Datasharing this what
folks did to improve customer satisfaction, find the
weaknesses and cure them.

Let us know what you come up with; your not the first
or the last to deal with this problem.

--- Horacio Villa <[login to unmask email]> wrote:
> Sorry if you get this for a second time, but I'm not
> sure if the list was
> up when I first sent it (no answers yet).
> Kind regards,
> Horacio Villa
>
> ----- Forwarded by Horacio Villa/Argentina/Contr/IBM
> on 12/04/03 04:20 PM
> -----
>
> Horacio Villa
> To:
> 12/01/03 08:28 PM cc:
> From:
> Horacio [login to unmask email]
>
> Subject: Timeout when SERVER is down
>
>
>
>
>
> Hi list,
>
> I'm looking for a workaround for this problem.
> A COBOL/CICS/DB2 program running on OS/390 2.10, DB2
> V5, is issuing a
> CONNECT statement to a DB2 on AIX 4.3.3, DB2 V7.1
> Whenever this server is down (not responding) it
> takes about 3 minutes to
> get an error sqlcode.
> This time is unacceptable for users.
> Does anybody know what can I do to get a quicker
> response?
>
> Thanks in advance,
>
> Horacio Villa
>
>
---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go
> to the archives and home page at
> http://www.idugdb2-l.org/archives/db2-l.html. From
> that page select "Join or Leave the list". If you
> will be out of the office, send the SET DB2-L NO
> MAIL command to [login to unmask email] The IDUG
> List Admins can be reached at
> [login to unmask email] Find out the latest
> on IDUG conferences at
http://conferences.idug.org/index.cfm


=====
Edward Long

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Tina Hilton

Re: Timeout when SERVER is down
(in response to Edward Long)
You could have a program that checks the server at a regular interval and
updates a table when the status changes. Your regular transactions could
then check the table for the current status. It would be extra overhead,
obviously, but if it's important enough it may be worthwhile.

Tina

-----Original Message-----
From: Horacio Villa [mailto:[login to unmask email]
Sent: Thursday, December 04, 2003 2:16 PM
To: [login to unmask email]
Subject: Timeout when SERVER is down


Sorry if you get this for a second time, but I'm not sure if the list was up
when I first sent it (no answers yet). Kind regards, Horacio Villa

----- Forwarded by Horacio Villa/Argentina/Contr/IBM on 12/04/03 04:20 PM
-----

Horacio Villa
To:
12/01/03 08:28 PM cc:
From: Horacio
[login to unmask email]
Subject: Timeout when SERVER
is down





Hi list,

I'm looking for a workaround for this problem.
A COBOL/CICS/DB2 program running on OS/390 2.10, DB2 V5, is issuing a
CONNECT statement to a DB2 on AIX 4.3.3, DB2 V7.1 Whenever this server is
down (not responding) it takes about 3 minutes to get an error sqlcode. This
time is unacceptable for users. Does anybody know what can I do to get a
quicker response?

Thanks in advance,

Horacio Villa

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm