Renaming DSNTEP4 to DSNTEP2

Tino Manganaro

Renaming DSNTEP4 to DSNTEP2
I currently working out the roll-out of DB2 V810 to NFM Mode and I
trying to decide if it is good idea to rename DSNTEP4 to DSNTEP2 and
force the Multi-Row capabilities on my user community. I was hoping to
hear any negative or positive feedback on any issues that you may have
run across.



Thanks,

Tino Manganaro

System Engineer Development and Support

Mainframe Technologies TPS



IT Services Americas

DHL

8701 East Hartford Drive
Building A, Cube #206A
Scottsdale, AZ
85255



Phone : (480) 375-7130
Cell Phone: (480) 330-2418

Fax: (480) 375-6450

[login to unmask email]

www.dhl.com




IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

---------------------------------------------------------------------------------
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

David Seibert

Re: Renaming DSNTEP4 to DSNTEP2
(in response to Tino Manganaro)
Hi Tino,

Here's a consideration.
I believe it was Roger Miller at the DB2 Tech Conference as v8 was new
who said that IBM found customers who used TEP2 for regression testing
of the new release and that's one of the reasons TEP4 did not replace
TEP2.
You may look out for similar uses of TEP2 in your shop.

Dave
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.

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

---------------------------------------------------------------------------------
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

George Palko

Re: Renaming DSNTEP4 to DSNTEP2
(in response to David Seibert)
Hi Tino,

We've been at V8NFM for a couple of years now. We have held off rolling out the DSNTEP4 module as a replacement for DSNTEP2. We discovered that DSNTEP4, under certain circumstances, had performance issues compared to DSNTEP2. Please read APAR PK05360, it pertains to hybrid joins.
The APAR has fixed the problem; however, prior to replacing DSNTEP2 with DSNTEP4, our shop plans on performing a complete regression test of DSNTEP4.

Regards,
George


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of Tino Manganaro (DHL US)
Sent: Thursday, November 29, 2007 12:25 PM
To: [login to unmask email]
Subject: [DB2-L] Renaming DSNTEP4 to DSNTEP2



I currently working out the roll-out of DB2 V810 to NFM Mode and I trying to decide if it is good idea to rename DSNTEP4 to DSNTEP2 and force the Multi-Row capabilities on my user community. I was hoping to hear any negative or positive feedback on any issues that you may have run across.



Thanks,

Tino Manganaro

System Engineer Development and Support

Mainframe Technologies TPS



IT Services Americas

DHL

8701 East Hartford Drive
Building A, Cube #206A
Scottsdale, AZ
85255



Phone : (480) 375-7130
Cell Phone: (480) 330-2418

Fax: (480) 375-6450

[login to unmask email]

www.dhl.com



IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org


--------------------------------------------------------------------------------- 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





-----------------------------------------
CONFIDENTIALITY NOTICE: The Ohio Public Employees Retirement System
intends this e-mail message, and any attachments, to be used only
by the person(s) or entity to which it is addressed. This message
may contain confidential and/or legally privileged information. If
the reader is not the intended recipient of this message or an
employee or agent responsible for delivering the message to the
intended recipient, you are hereby notified that you are prohibited
from printing, copying, storing, disseminating or distributing this
communication. If you received this communication in error, please
delete it from your computer and notify the sender by reply e-mail.

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

---------------------------------------------------------------------------------
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

Barbara Koenen

Re: Renaming DSNTEP4 to DSNTEP2
(in response to George Palko)
We did replace DSNTEP2 with DSNTEP4, figuring everyone should probably
be running DSNTEP4.

We had to back off and put DSNTEP2 back out there. We ran into a
problem with one job that couldn't run with DSNTEP4.

I don't remember the details, but I can get them if you need them. (The
sysadm involved is ooo today.)

________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Tino Manganaro (DHL US)
Sent: Thursday, November 29, 2007 11:25 AM
To: [login to unmask email]
Subject: [DB2-L] Renaming DSNTEP4 to DSNTEP2



I currently working out the roll-out of DB2 V810 to NFM Mode and I
trying to decide if it is good idea to rename DSNTEP4 to DSNTEP2 and
force the Multi-Row capabilities on my user community. I was hoping to
hear any negative or positive feedback on any issues that you may have
run across.



Thanks,

Tino Manganaro

System Engineer Development and Support

Mainframe Technologies TPS



IT Services Americas

DHL

8701 East Hartford Drive
Building A, Cube #206A
Scottsdale, AZ
85255



Phone : (480) 375-7130
Cell Phone: (480) 330-2418

Fax: (480) 375-6450

[login to unmask email]

www.dhl.com



IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion
listserv that are being implemented to improve reliability and the
overall user experience of DB2-L. These changes are coming on November
30th. Details at http://www.idug.org

------------------------------------------------------------------------
--------- 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


IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

---------------------------------------------------------------------------------
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