DB2-L Digest - 10 Jan 2011 to 11 Jan 2011 (#2011-10)

Dave Edwards

DB2-L Digest - 10 Jan 2011 to 11 Jan 2011 (#2011-10)
----- Original Message -----
From: "DB2-L automatic digest system" <[login to unmask email]>
To: <[login to unmask email]>
Sent: Tuesday, January 11, 2011 1:00 AM
Subject: DB2-L Digest - 10 Jan 2011 to 11 Jan 2011 (#2011-10)


There are 12 messages totaling 1930 lines in this issue.

Topics of the day:

1. DB2 v8.1 CM - ENFM mode issues (5)
2. Delete view in V7 that is in Systables but not in Sysviews
3. AW: [DB2-L] Using Reopt(ONCE) or REOPT(ALWAYS) with DSNTIAUL
4. Multi-Dimensional Clustering (MDC) Tables in DB2 LUW - Friday January
14,
2011 10:00 AM - 11:00 AM CST
5. Data replication for DB2, Oracle, VSAM
6. HOTDUG meeting on Jan. 18
7. Another reminder about he HADUG meeting Jan 19
8. modify recovery

----------------------------------------------------------------------

Date: Mon, 10 Jan 2011 10:18:57 +0100
From: Max Scarpa <[login to unmask email]>
Subject: Re: DB2 v8.1 CM - ENFM mode issues

Hi all

Wow 1 year in CM, it's a real long time.

We moved to ENFM-->NFM very quickly as suggested by IBM and as suggested
by users experience. After a so long time I don't expect real big issues
moving to NFM in a very short period, your V8 'foundations' are stable and
solid and all DB2+z/OS related issues should have been resolved after a
year (and at least 1 IPL), there're few modifications (with respect
V7-->V8 CM migration) moving to ENFM/NFM.

We removed NFM=NO after a short interval of time, we left it upon
programmers' request, but I think it'd be better to remove it ASAP.

Just my experience.

Max Scarpa

Certiflu(ed) DB2 sysprog

“May the Force be with you. Or at least good DB2 sysprog"


IDUG DB2-L <[login to unmask email]> wrote on 06/01/2011 20.41.51:

> From: "Kaminski, Michael" <[login to unmask email]>
> To: [login to unmask email]
> Date: 06/01/2011 20.42
> Subject: [DB2-L] DB2 v8.1 CM - ENFM mode issues
> Sent by: IDUG DB2-L <[login to unmask email]>
>
>
>
> We finally have approval from the applications\business area to
> upgrade our production Db2 sub-system from CM to ENFM. We have been
> in CM mode for just over 1 yr. and our test\QA have been in ENFM for
> 3+ months with no reported issues. But senior management asked the
question:
>
> 'Has anyone else experienced any other foreseen issues with going to
> ENFM from CM?'
>
> Any feedback would be greatly appreciated.
>
> Thanks,
>
> Michael A. Kaminski
> [login to unmask email]
>
>
>
> NOTICE: This message and all attachments transmitted with it may
> contain confidential,
> sensitive, or protected information intended solely for the use of
> the addressee. If the reader
> of this message is not the intended recipient, you are hereby
> notified that any reading,
> dissemination, distribution, copying, or other use of this message
> or its attachments is strictly
> prohibited. If you have received this message in error, please
> notify the sender immediately
> by telephone or by electronic mail and delete this message and all
> copies and backups thereof.
> Thank you.
>
>
>
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 * http://
> IDUG.ORG/NA *
> * Your only source for independent, unbiased, and trusted DB2
> information. *
> ** The most DB2 technical sessions of any conference
> ** Access IBM experts and developers
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
> is the home of IDUG's Listserv


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-

------------------------------

Date: Mon, 10 Jan 2011 05:48:40 -0500
From: Avram Friedman <[login to unmask email]>
Subject: Re: Delete view in V7 that is in Systables but not in Sysviews

I would suggest the REPAIR DBD utility function with the guidence of IBM
support.

This might be a bit problemmatic for a DB2 version like V7 that is out of
support.
There are several options at this point
1. Pay for support for V7
2. Claim its a conversion issue so it is infact a V8 problem not a V7 one (I
assume you have support for V8)
3. Migrate to V8 and then request it assistance with repair.

I do not know what IBM's response will be in any of these cases.

My guess is this is garbage left behind from a previous failed upgrade.
Id bet a cup of coffee that it is to or from V5 ... a lot of this sort of
stuff dates from back then.

Best wishes
Avram Friedman

PS before you attempt a fix with or without the vendors help.
Warn the user commuity or at least management depending on shop standards.
Back up everything.
Be prepared for a total restore.

On Sun, 9 Jan 2011 13:49:57 +0200, Michal Peleg <[login to unmask email]>
wrote:

>Hello All,
>
>
>
>We're converting our DB2 to V8.
>
>
>
>One of the selects that we need to run, checks if there are miss-matched
>views definitions in the catalog.
>
>The select retrieved one problematic view from the catalog, it is
>defined in SYS.SYSTABLES as view, but is not defined
>
>In SYS.SYSVIEWS.
>
>
>
>I'd like to delete this VIEW.
>
>Any ideas??? DROP doesn't work, of course.
>
>
>
>Thank you in advance,
>
>Michal
>
>
>
>_____________________________________________________________________
>* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 *
>http://IDUG.ORG/EMEA *
>* If you are going to attend only one conference this year, this is it!
>*
>_____________________________________________________________________
>http://www.IDUG.org/mentor
>How can you expand your staff or do succession planning in this economy?
>Mentoring is a proven, economical, way to train the next generation of DB2
>Users!
>_____________________________________________________________________
>
>If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
>the home of IDUG's Listserv
>

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv

------------------------------

Date: Mon, 10 Jan 2011 06:05:57 -0500
From: Avram Friedman <[login to unmask email]>
Subject: Re: DB2 v8.1 CM - ENFM mode issues

I argee with Max, may the force be with you.

I experienced many problems migrating from V8 CM to ENFM

Some or all may not be meainingful to you.

Let me point out what is at work here, as has been done many times since the
introduction of V8

DB2 services that my shop uses may not be in use by your shop or vice versa.
Some problems experienced 3 years ago may now of been fixed, new ones may of
been created.
DB2 V8 today can not be compared to DB2 V8 3 years ago.
3 years ago migration was expected today it is not.
3 years ago there was no V9 and V9+ functionality retrofitted to V8 AT
ALL

There is a reason to stay current.

My suggestion is to go for it before V8 goes EOS in 15 months.
If you think its bad today you can rest assured that it will be worse, not
better tomorrow.

Regards
Avram Friedman

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv

------------------------------

Date: Mon, 10 Jan 2011 12:22:34 +0100
From: Walter Janißen <[login to unmask email]>
Subject: AW: [DB2-L] Using Reopt(ONCE) or REOPT(ALWAYS) with DSNTIAUL

Hi Larry

Very interesting. I didn't know that before. I will also consider binding
DSNTIAUL and DSNTEP2(4) with REOPT(ONCE).

Mit freundlichen Grüßen
Walter Janißen

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Systeme Laufzeitarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
[login to unmask email]

Vorsitzender des Aufsichtsrats: Jürgen Vetter
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Ina Kirchhof, Dr. Christian Nymphius, Dr. Michael Regauer, Wolfgang Schön
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf, HRB 37996



-----Ursprüngliche Nachricht-----
Von: IDUG DB2-L [mailto:[login to unmask email] Im Auftrag von Larry
Gesendet: Freitag, 7. Januar 2011 17:26
An: [login to unmask email]
Betreff: [DB2-L] Using Reopt(ONCE) or REOPT(ALWAYS) with DSNTIAUL

I just had a "ah ha" moment regarding query tuning (plug not intended).

I encountered a query with the following predicate:

WHERE MY_DATE_COL1 < CURRENT DATE

I did not know that DB2 treated the CURRENT DATE register like a host
variable. I did know that REOPT(ONCE) and/or REOPT(ALWAYS) caused host
variables to be evaluated at run time but, I did not know that this applied
to the date/time/timestamp registers.

The above predicate originally had a filter factor of .0333 (as I said, DB2
treated it like a host variable). When I coded the query with the literal
of todays date, the filter factor changed to .99 (which was very accurate).
Running the original query had an elapsed time of 4.75 minutes and a CPU
time of 49 seconds. Running it with a literal caused it to run in .19
minutes (of elapsed time) and 4.66 seconds of CPU time! Since I was running
with DSNTIAUL, I tried rebinding the package with REOPT(ONCE) - removed the
original query from the cache and reran. It then ran with the better
performance.

I am thinking that as a general rule, it probably would be better to bind
DSNTIAUL with REOPT(ONCE) and/or REOPT(ALWAYS). What are your thoughts
and/or experiences on this?

Larry

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it!
*
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv

------------------------------

Date: Mon, 10 Jan 2011 13:17:23 +0100
From: Max Scarpa <[login to unmask email]>
Subject: Re: DB2 v8.1 CM - ENFM mode issues

Hi Avram

I heard some collegues had many issues as well after migration to V8 (they
had to fallback), but it was in CM. They happily migrated to NFM after
they applied all needed fixes/updates. I heard other collegues having
troubles after they moved to NFM when they started to use new V8
features, and it was a long way to reach a stable DB2. But it was some
years ago. We migrated in year 2009
and, apart an increase in cpu usage in DIST space (as %), we had few
troubles and cpu consumption were similar to V7, at least for normal and
daily workloads.
We collected few PTFs left before migrating prod DB2s so I presume V8 was
enough stable. But, as I usually point out, we were 'current' with hipers
in z/OS as well (and more I think), after 'BLOBs rage' I decided to have a
look with z/OS sysprogs to the level of maintenance in z/OS system. I
think it's now a best practice as DB2 and z/OS interact more in every
version (and Db2 10 isn't an exception) .
We stayed in CM for 35-36 days in prod, if I remeber well, after a
significant period for our shop (which is different in almost every other
shop).

Just my later experience, along the same track.

Max Scarpa

Certiflu(ed) DB2 sysprog





From: Avram Friedman <[login to unmask email]>
To: [login to unmask email]
Date: 10/01/2011 12.06
Subject: Re: [DB2-L] DB2 v8.1 CM - ENFM mode issues
Sent by: IDUG DB2-L <[login to unmask email]>



I argee with Max, may the force be with you.

I experienced many problems migrating from V8 CM to ENFM

Some or all may not be meainingful to you.

Let me point out what is at work here, as has been done many times since
the introduction of V8

DB2 services that my shop uses may not be in use by your shop or vice
versa.
Some problems experienced 3 years ago may now of been fixed, new ones may
of been created.
DB2 V8 today can not be compared to DB2 V8 3 years ago.
3 years ago migration was expected today it is not.
3 years ago there was no V9 and V9+ functionality retrofitted to V8 AT
ALL

There is a reason to stay current.

My suggestion is to go for it before V8 goes EOS in 15 months.
If you think its bad today you can rest assured that it will be worse, not
better tomorrow.

Regards
Avram Friedman

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2
information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv

------------------------------

Date: Mon, 10 Jan 2011 08:21:45 -0500
From: Linda Adams <[login to unmask email]>
Subject: Multi-Dimensional Clustering (MDC) Tables in DB2 LUW - Friday
January 14, 2011 10:00 AM - 11:00 AM CST


Hi DB2 Listserv:
The International DB2 Users Group (IDUG) is pleased to partner with DBI to
deliver a free Webcast by renowned presenter Scott Hayes, President & CEO,
DBI.

Multi-Dimensional Clustering (MDC) Tables in DB2 LUWMulti-Dimensional
Clustering (MDC) Tables in DB2 LUW

In this episode of The DB2Night Show, we've tapped two top shelf guests from
the IBM Toronto Lab to talk about MDC tables. Special guest Paul Zikopoulos
aka "Paul Z" returns and his peer Pat Bates makes his debut. Together these
two will share with us the magic of MDC tables and offer tips and best
practices.

The DB2Night Show now has a LinkedIn Group - join us to stay up to date on
our show and discuss show episodes! The group registration link can be
found on www.DB2NightShow.com.

We hope you will join us and participate as a studio audience member. One
studio audience member will be randomly selected to win an electronic gift
certificate!

If you can't make the scheduled time, register anyways so that you get
information about recorded replays. Lastly, please forward this invitation
to at least 5 of your friends! Thank you!


About the Presenter:
Scott Hayes, President & CEO DBI, will be the keynote speaker for this
Webinar. Scott has published several articles in DB2 Magazine (now IBM
Database Magazine), and he is a frequent speaker at DB2, ISACA, and ISSA
conferences on topics of database performance, security, and auditing. He
is also providing free DB2 LUW education via the DB2 Magazine blogs at:
http://www.dbisoftware.com/blog/db2_performance.php

Webcast Schedule Times – Friday, 14 January 2011:
USA (CST) 1000 to 1100.
UK (GMT) 1600 to 1700.
Central Europe (CET) 1700 to 1800.
Universal Coordinated Time 1600 to 1700.

To register: http://www.DB2NightShow.com

For more information don’t forget to visit the IDUG website at www.idug.org

Linda Adams.
IDUG Web Team.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv

------------------------------

Date: Mon, 10 Jan 2011 08:25:35 -0500
From: Avram Friedman <[login to unmask email]>
Subject: Re: DB2 v8.1 CM - ENFM mode issues

In the move between V8 CM and V8 ENFM
We had lots of problems with old DBDs built many versions ago.
There is currently an active thread that deals with someone elses DBD
problems
(Hanging view)

In the move to CM our biggest problems were with DIST
Perhaps in second place CCID issues

Through out the conversion period sometimes in both CM and ENFM we had
Reserved word issues
New zparms and zparm meanings esp with DIST and Stored procedure control
Changes in the way utilities worked esp but not only those sites that were
not users of IBM sort
People who expected new features like XML to work auto-magicly.

I am still doing conversions to V8, Im in the out sourcing business and out
of date software is very common.
May be one of the reasons why some shops look for outsourcers.

The biggest problem I run into today is the assumption that experiences
recorded 3 or 8 years ago are vaild today.
Not wanting to beat a dead horse but often they are not vaild.
DB2 V8 has changed from ready to install product to ready to be upgraded
product.

Thanks and best wishes Max
Avram Friedman

PS in the last quarter the shop I work for upgraded our last DB2 V4 system.
It is now V9.
We do, however, still have a number of DB2 V3 systems.

On Mon, 10 Jan 2011 13:17:23 +0100, Max Scarpa <[login to unmask email]> wrote:

>Hi Avram
>
>I heard some collegues had many issues as well after migration to V8 (they
>had to fallback), but it was in CM. They happily migrated to NFM after
>they applied all needed fixes/updates. I heard other collegues having
>troubles after they moved to NFM when they started to use new V8
>features, and it was a long way to reach a stable DB2. But it was some
>years ago. We migrated in year 2009
>and, apart an increase in cpu usage in DIST space (as %), we had few
>troubles and cpu consumption were similar to V7, at least for normal and
>daily workloads.
>We collected few PTFs left before migrating prod DB2s so I presume V8 was
>enough stable. But, as I usually point out, we were 'current' with hipers
>in z/OS as well (and more I think), after 'BLOBs rage' I decided to have a
>look with z/OS sysprogs to the level of maintenance in z/OS system. I
>think it's now a best practice as DB2 and z/OS interact more in every
>version (and Db2 10 isn't an exception) .
>We stayed in CM for 35-36 days in prod, if I remeber well, after a
>significant period for our shop (which is different in almost every other
>shop).
>
>Just my later experience, along the same track.
>
>Max Scarpa
>
>Certiflu(ed) DB2 sysprog
>
>
>
>
>
>From: Avram Friedman <[login to unmask email]>
>To: [login to unmask email]
>Date: 10/01/2011 12.06
>Subject: Re: [DB2-L] DB2 v8.1 CM - ENFM mode issues
>Sent by: IDUG DB2-L <[login to unmask email]>
>
>
>
>I argee with Max, may the force be with you.
>
>I experienced many problems migrating from V8 CM to ENFM
>
>Some or all may not be meainingful to you.
>
>Let me point out what is at work here, as has been done many times since
>the introduction of V8
>
>DB2 services that my shop uses may not be in use by your shop or vice
>versa.
>Some problems experienced 3 years ago may now of been fixed, new ones may
>of been created.
>DB2 V8 today can not be compared to DB2 V8 3 years ago.
> 3 years ago migration was expected today it is not.
> 3 years ago there was no V9 and V9+ functionality retrofitted to V8 AT
>ALL
>
>There is a reason to stay current.
>
>My suggestion is to go for it before V8 goes EOS in 15 months.
>If you think its bad today you can rest assured that it will be worse, not
>better tomorrow.
>
>Regards
>Avram Friedman
>
>_____________________________________________________________________
>* IDUG North America * Anaheim, California * May 2-6 2011 *
>http://IDUG.ORG/NA *
>* Your only source for independent, unbiased, and trusted DB2
>information. *
>_____________________________________________________________________
>http://www.IDUG.org/mentor
>Mentoring should be a rewarding experience for everyone...
>IDUG is offering up to 80% off when you both come to the conference!
>_____________________________________________________________________
>
>If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
>the home of IDUG's Listserv
>
>
>_____________________________________________________________________
>* IDUG North America * Anaheim, California * May 2-6 2011 *
>http://IDUG.ORG/NA *
>* Your only source for independent, unbiased, and trusted DB2
>information. *
>_____________________________________________________________________
>http://www.IDUG.org/mentor
>Mentoring should be a rewarding experience for everyone...
>IDUG is offering up to 80% off when you both come to the conference!
>_____________________________________________________________________
>
>If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
>the home of IDUG's Listserv
>

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv

------------------------------

Date: Mon, 10 Jan 2011 05:30:09 -0800
From: "Kaminski, Michael" <[login to unmask email]>
Subject: Re: DB2 v8.1 CM - ENFM mode issues

Thanks to all for sharing your experiences and knowledge.

Mike Kaminski

________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Max Scarpa
Sent: Monday, January 10, 2011 6:17 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 v8.1 CM - ENFM mode issues

Hi Avram

I heard some collegues had many issues as well after migration to V8 (they
had to fallback), but it was in CM. They happily migrated to NFM after they
applied all needed fixes/updates. I heard other collegues having troubles
after they moved to NFM when they started to use new V8 features, and it
was a long way to reach a stable DB2. But it was some years ago. We migrated
in year 2009
and, apart an increase in cpu usage in DIST space (as %), we had few
troubles and cpu consumption were similar to V7, at least for normal and
daily workloads.
We collected few PTFs left before migrating prod DB2s so I presume V8 was
enough stable. But, as I usually point out, we were 'current' with hipers in
z/OS as well (and more I think), after 'BLOBs rage' I decided to have a look
with z/OS sysprogs to the level of maintenance in z/OS system. I think it's
now a best practice as DB2 and z/OS interact more in every version (and Db2
10 isn't an exception) .
We stayed in CM for 35-36 days in prod, if I remeber well, after a
significant period for our shop (which is different in almost every other
shop).

Just my later experience, along the same track.

Max Scarpa

Certiflu(ed) DB2 sysprog





From: Avram Friedman <[login to unmask email]>
To: [login to unmask email]
Date: 10/01/2011 12.06
Subject: Re: [DB2-L] DB2 v8.1 CM - ENFM mode issues
Sent by: IDUG DB2-L <[login to unmask email]>
________________________________



I argee with Max, may the force be with you.

I experienced many problems migrating from V8 CM to ENFM

Some or all may not be meainingful to you.

Let me point out what is at work here, as has been done many times since the
introduction of V8

DB2 services that my shop uses may not be in use by your shop or vice versa.
Some problems experienced 3 years ago may now of been fixed, new ones may of
been created.
DB2 V8 today can not be compared to DB2 V8 3 years ago.
3 years ago migration was expected today it is not.
3 years ago there was no V9 and V9+ functionality retrofitted to V8 AT
ALL

There is a reason to stay current.

My suggestion is to go for it before V8 goes EOS in 15 months.
If you think its bad today you can rest assured that it will be worse, not
better tomorrow.

Regards
Avram Friedman

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA < http://idug.org/NA > *
* Your only source for independent, unbiased, and trusted DB2 information.
*
_____________________________________________________________________
http://www.IDUG.org/mentor < http://www.idug.org/mentor >
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv


________________________________

[ http://www.idug.org/images/stories/db2/db2_10_savings.jpg ] < http://www-01.ibm.com/software/data/db2/zos/db2-10/ >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
not already an IDUG member, please register
here. < http://www.idug.org/register >

NOTICE: This message and all attachments transmitted with it may contain
confidential,
sensitive, or protected information intended solely for the use of the
addressee. If the reader
of this message is not the intended recipient, you are hereby notified that
any reading,
dissemination, distribution, copying, or other use of this message or its
attachments is strictly
prohibited. If you have received this message in error, please notify the
sender immediately
by telephone or by electronic mail and delete this message and all copies
and backups thereof.
Thank you.



_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

------------------------------

Date: Mon, 10 Jan 2011 14:52:36 -0600
From: Bob Brock <[login to unmask email]>
Subject: Re: Data replication for DB2, Oracle, VSAM

Hi Alison,

One of the biggest issues I know of with the IBM toolset for what you would
like to accomplish is you are looking at several components to get
everything done. Q Rep is an older version of one of the IBM infosphere
line of products. It was originally a newer version of Data Propagator that
was modified to use MQ. I believe you would need multiple capture
components and event publishers to process the variety of data that you
referenced in your message. I replied to a similar message last week asking
about overhead associated with infosphere and gave my recommendation of
SQData as an alternative to the IBM offerings. One tool from SQData could
accomplish everything you listed without going the ala carte route. I've
worked with SQData at a couple customers doing very similar high performance
active/active projects with great success.

Thanks,
Bob Brock
Krypton Consulting LLC
800-687-8884

----- Original Message -----
From: "Alison Pelletier" <[login to unmask email]>
Sent: Friday, January 07, 2011 2:12 PM
Subject: Data replication for DB2, Oracle, VSAM


Hello.

Does anyone (customers) have firsthand experience, they wouldn't mind
sharing, with IBM's Q Replication? Do you know of any other products that
are resilient enough to handle high volume DB2 for z/OS to DB2 for z/OS
bidirectional active/active replication? It would be of added interest, if
it also handles VSAM to VSAM unidirectional, and Oracle to DB2 and DB2 to
Oracle unidirectional. Feel free to contact me offline, if you prefer.

Thanks,

Alison Pelletier
Discover Financial Services
[login to unmask email]
(801) 902-4184

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it!
*
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv

------------------------------

Date: Mon, 10 Jan 2011 16:05:27 -0600
From: "Lo, Mary" <[login to unmask email]>
Subject: HOTDUG meeting on Jan. 18

Happy New Year! From HOTDUG, we wish you all the best with DB2 in 2011!

We will ring in the new year with our 1st quarterly meeting featuring Dave
Beulke, internationally recognized DB2 consultant, author and instructor.
Date: Tuesday Jan. 18, 2011 8:30 - 12
Location: Teachers Retirement System, 1000 Red River St., Room 110 West,
Austin, TX

Dave will speak on 2 DB2 performance topics. Bring your questions to Q&A
with Dave. Please RSVP to [login to unmask email]<mailto:[login to unmask email]>

------ Agenda ----

08:30 - 09:00 Registration and Breakfast

09:00 - 09:05 Business and Announcements
09:05 - 10:05 DB2 Database Performance Discoveries and
Recommendations

Dave Beulke, Dave Beulke & Associates

10:05 - 10:25 Break

10:25 - 11:25 Java DB2 Developer Performance Best
Practices
Dave Beulke, Dave Beulke & Associates

11:25 -11:40 Q & A with Dave

11:40 - 12:00 Closing - Raffle for Prizes

** Directions to Teachers Retirement System (TRS) **

Teachers Retirement System is located in downtown Austin at: 1000 Red River
St. TRS occupies the block between 10th & 11th Streets and Red River &
Trinity. Red River is 1 block west of I-35. If you are coming from I-35,
take 11th Street Exit, go west on 11th. There are two connected buildings.
Room 110 West is on the ground floor of the West building. There is a
visitor parking close to 11th and Trinity.



_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv

------------------------------

Date: Mon, 10 Jan 2011 16:25:46 -0600
From: Willie Favero <[login to unmask email]>
Subject: Another reminder about he HADUG meeting Jan 19

Hi all... again...

Just one more reminder that we will be having our first Houston Area DB2
User Group (HADUG) meeting on Jan 19 at the IBM facility at Two Riverway
near the Galleria. Details and directions can be found at our web
site.. http://db2now.com/hadug/

8:30 - 09:00 Registration and Breakfast

08:50 - 09:00 Business and Announcements

09:00 - 10:30 *DB2 Database Performance Discoveries and Recommendations**//
**Dave Beulke*, Dave Beulke & Associates

10:30 - 10:45 Break

10:45 - 12:15 *Java DB2 Developer Performance Best Practices
Dave Beulke*, Dave Beulke & Associates

12:15 Closing

Please drop me a note to let me know if you will be attending so we can
plan appropriately.

Also, please do not reply to the list if you attending.

Thanks

--
Willie
My DB2 blog --> http://it.toolbox.com/blogs/db2zos/
Houston, TX, USA


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv

------------------------------

Date: Tue, 11 Jan 2011 10:34:18 +0800
From: [login to unmask email]
Subject: Re: modify recovery

Koen,

I bet it must be DB2 9, for the RETAIN keyword.

It sounds strange for this simple MODIFY utility. I would like to
ask for your COPY and related MODIFY RECOVERY control statements.





"Rasmussen, Steen" <[login to unmask email]>
发件人: IDUG DB2-L <[login to unmask email]>
2011-01-07 22:09
请答复 给
IDUG DB2-L <[login to unmask email]>


收件人
[login to unmask email]
抄送

主题
Re: [DB2-L] modify recovery






Hello Koen,
I believe you must be at DB2 V8 ?
In that case you can use LISTDEF instead of coding every statement.
If memory serves me well, DB2 9 changed this behavior and the
recommendation is to use DSNUM ALL if you have image copies at both the
partition level and tablespace level.

Steen Rasmussen
CA Technologies
Sr Engineering Services Architect
IBM Certified Database Associate - DB2 9 Fundamentals
IBM Certified database Administrator - DB2 9 DBA for z/OS



-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Koen
Vannisselroy
Sent: Friday, January 07, 2011 12:37 AM
To: [login to unmask email]
Subject: [DB2-L] modify recovery

Hello,

At ourt system I introduced taking partlevel full image copies. For
cleaning up old imagecopies I use de retain parameter to save the last 21
copies. Even when I use the dsnum all parameter DB2 ignores die partlevel
imagecopies and is not cleaning up any partlevel copies. In the manual is
statet that you have to specify the dsnum specifically. My table has 480
partitions, this means I have to create 480 statements. Has anyone
experience with this en give me a solution for this problem?

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it!
*
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it!
*
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv



_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG

------------------------------

End of DB2-L Digest - 10 Jan 2011 to 11 Jan 2011 (#2011-10)
***********************************************************

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Philip Sevetson

Re: DB2-L Digest - 10 Jan 2011 to 11 Jan 2011 (#2011-10)
(in response to Dave Edwards)
Dave,
When replying to a message in the Digest, you need to clip away most of the digest (the part you're not replying to) and make it clear what part of the post is your reply -- I, at least, can't see what your part of the message is.

--Phil


-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Dave Edwards
Sent: Tuesday, January 11, 2011 9:26 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2-L Digest - 10 Jan 2011 to 11 Jan 2011 (#2011-10)

----- Original Message -----
From: "DB2-L automatic digest system" <[login to unmask email]>
To: <[login to unmask email]>
Sent: Tuesday, January 11, 2011 1:00 AM
Subject: DB2-L Digest - 10 Jan 2011 to 11 Jan 2011 (#2011-10)


There are 12 messages totaling 1930 lines in this issue.

Topics of the day:

1. DB2 v8.1 CM - ENFM mode issues (5)
2. Delete view in V7 that is in Systables but not in Sysviews
3. AW: [DB2-L] Using Reopt(ONCE) or REOPT(ALWAYS) with DSNTIAUL
4. Multi-Dimensional Clustering (MDC) Tables in DB2 LUW - Friday January
14,
2011 10:00 AM - 11:00 AM CST
5. Data replication for DB2, Oracle, VSAM
6. HOTDUG meeting on Jan. 18
7. Another reminder about he HADUG meeting Jan 19
8. modify recovery

[much text snipped]

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv