JES3 users of DB2

Rowland Charge

JES3 users of DB2
Environment: DB2 V6, z/OS 1.4

Would any JES3 users of DB2 like to tell me how they cope with the JES3
restrictions placed upon DB2 in terms of its ability to dynamically mount
cartridges for DB2 image copy, merge copy, and recovery purposes?

Detail:

Under JES3, dynamic cartridge allocation has a low dispatching priority, and
the process times out after 30 minutes. This unfriendly attitude on the part
of JES3 towards dynamic allocation has resulted in its avoidance at all
costs.

The problem with DB2 is that it maked up its own mind as to which cartridges
it will need for a given mergecopy/restore job. Consequently, an urgent
restore job (with business users pressing for return of service) can be
sitting around waiting for a low priority device allocation.

The obvious solution seems to be to image copy to DASD and archive to
cartridge asynchronously. This will separate the cartridge allocation from
the DB2 process.

Do any DB2 users have experience of using this DASD archive method?

Do any JES3 users have experience of this, or any other solutions to this
problem?

Do any JES3 users not find it a problem?

Regards,
Rowland Charge
TS Host Development
Technology Services
Experian International Limited
Telephone: +44 (0)115 93 44776
Mobile: 07967 342969
Email: [login to unmask email]




This e-mail has come from Experian International: winner of the UK's National Business of the Year Award 2003.

=
Information in this e-mail and any attachments are confidential, and may
not be copied or used by anyone other than the addressee, nor disclosed
to any third party without our permission. There is no intention to
create any legally binding contract or other binding commitment through
the use of this electronic communication unless it is issued in accordance
with the Experian Limited standard terms and conditions of purchase or
other express written agreement between Experian Limited and the recipient
Experian Limited (registration number 653331) Registered office:
Talbot House, Talbot Street, Nottingham NG80 1TH

Although Experian has taken reasonable steps to ensure that this communication
and any attachments are free from computer virus, you are advised to take
your own steps to ensure that they are actually virus free.

---------------------------------------------------------------------------------
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". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. 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

Jim Tonchick

Re: JES3 users of DB2
(in response to Rowland Charge)
Rowland,

I supported DB2 under JES3 in a previous lifetime (DB2 was V3, 4 & 5 with
JES3 under MVS/ESA 5.2 and OS/390 1.2). I did not experience the problem you
described with dynamic allocation of tape cartridges. I had both image copies
and archive logs on tape, and none of the recovery jobs experienced device
allocation delays like you describe.

I'd have to suggest that you press the operating system/JES system
programmers to check into your allocation problem. Even to the point of opening an ETR
with IBM.

Jim Tonchick

---------------------------------------------------------------------------------
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". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. 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