BMC utility retry count

Vidya Attuluri

BMC utility retry count
Hi,

Environment: DB2 V7.1 for z/OS 1.8

We use BMC utilities to load the data.
Is the retry count for the utility in case of a drain lock is
specifiable at the utility job level or only as part of installation.

Regards
Vidya

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Raymond Bell

Re: BMC utility retry count
(in response to Vidya Attuluri)
Hi Vidya,

Now, where's my pre-coded reminder about our excellent 24x7 support team? Dunno; lost it in the mess that is a Friday afternoon.

I guess you're talking about DRAIN_WAIT, right? Your timing is perfect as I've been researching this for a customer today. It's both an install option and overridable (is that a word?) in the Sysin for each execution. So you can decide how best to wait for your drain to be granted as you see fit. Hint: as a collegue of mine recommends, go for DRAIN_WAIT NONE and RETRY_LIMIT some_number_you_set, so you never hold up anyone else while you're waiting for your drain to be granted.

Have a fun what's-left-of-Friday.


Raymond


________________________________

From: DB2 Data Base Discussion List on behalf of Attuluri, Vidya
Sent: Fri 1/11/2008 6:13 PM
To: [login to unmask email]
Subject: [DB2-L] BMC utility retry count



Hi,

Environment: DB2 V7.1 for z/OS 1.8

We use BMC utilities to load the data.
Is the retry count for the utility in case of a drain lock is specifiable at the utility job level or only as part of installation.

Regards
Vidya


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at www.idug.org <http://www.idug.org/lsidug> under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information < http://www.idug.org/lsconf > , and much more.
If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services < http://www.idug.org/lsms >

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Randy Bright

Re: BMC utility retry count
(in response to Raymond Bell)
I think Raymond may have made an incorrect assumption that you were
talking about BMC Reorg Plus. We have not yet implemented the
DRAIN_WAIT syntax into LoadPlus for DB2. We do have it on our "to-do"
list, but just have not gotten to it yet.

To answer your question directly, the retry count can be specified in
the Installation Options module, but not in the LoadPlus command syntax.
The SQLRETRY parameter is used for specifying how many retries you want
when LoadPlus issues a DRAIN before stopping the object to be loaded as
well as the number of times to retry when an SQL statement receives a
timeout (SQLCODE-911).

If you have any other questions, or need further information, call our
support center or you can E-Mail me directly if you want.

Randy Bright
DB2 Utilities Architect
BMC Software, Inc.
[login to unmask email]



The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Raymond Bell

Re: BMC utility retry count
(in response to Randy Bright)
Ah. Oops. Good spot, Randy. Yes, I was thinking of Reorg Plus. Sorry Vidya, I put you wrong. I'll sod off now, crawl back under my rock and try to RTFM - that's Read The Friendly Mail message - properly before replying.

Cheers,


Raymond

________________________________

From: DB2 Data Base Discussion List on behalf of Bright, Randy
Sent: Sat 1/12/2008 2:26 AM
To: [login to unmask email]
Subject: Re: [DB2-L] BMC utility retry count



I think Raymond may have made an incorrect assumption that you were talking about BMC Reorg Plus. We have not yet implemented the DRAIN_WAIT syntax into LoadPlus for DB2. We do have it on our "to-do" list, but just have not gotten to it yet.

To answer your question directly, the retry count can be specified in the Installation Options module, but not in the LoadPlus command syntax. The SQLRETRY parameter is used for specifying how many retries you want when LoadPlus issues a DRAIN before stopping the object to be loaded as well as the number of times to retry when an SQL statement receives a timeout (SQLCODE-911).

If you have any other questions, or need further information, call our support center or you can E-Mail me directly if you want.

Randy Bright

DB2 Utilities Architect

BMC Software, Inc.

[login to unmask email] <mailto:[login to unmask email]>


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at www.idug.org <http://www.idug.org/lsidug> under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information < http://www.idug.org/lsconf > , and much more.
If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services < http://www.idug.org/lsms >

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms