Antwort: Re: [DB2-L] DB2/ZOS V7 - Refresh dynamic cache

Roy Boxwell

Antwort: Re: [DB2-L] DB2/ZOS V7 - Refresh dynamic cache
True the RUNSTATS REPORT NO UPDATE NONE invalidates the DSC but only in
V8....you can always use the "dirty trick" of doing an ALTER AUDIT YES /
NO which works for us!
Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Strasse 5
40470 Duesseldorf/Germany
Tel. +49 (0)211 96149-0
Fax +49 (0)211 96149-35
E-mail [login to unmask email]
Homepage www.seg.de





Suresh Sane <[login to unmask email]>
Gesendet von: DB2 Data Base Discussion List <[login to unmask email]>
16.12.2005 17:19
Bitte antworten an DB2 Database Discussion list at IDUG


An: [login to unmask email]
Kopie:
Thema: Re: [DB2-L] DB2/ZOS V7 - Refresh dynamic cache


Basivi,

Assuning you have IBM RUNSTATS, the no-udpate no-report option is the
quickes and painless way.

Cool as your suggestion sounds, I would strongly discourage using RENAME
for
this purpose. Here are some reasons why:

- Tables wth views, triggers or synonyms on them create problems (not
allowed)
- The act of invalidating, simple as it sounds, means that all users of
that
package must be drained - a batch applicatiopn may delay this for several
minutes
- The act of binding can cause similar issues
- Access path switches for static SQL in the middle of the day could
create
other headaches

Just keep it simple, please!

Thanks,
Suresh


>From: Basivi Inaganti <[login to unmask email]>
>Reply-To: DB2 Database Discussion list at IDUG <[login to unmask email]>
>To: [login to unmask email]
>Subject: Re: [DB2-L] DB2/ZOS V7 - Refresh dynamic cache
>Date: Thu, 15 Dec 2005 15:05:11 -0500
>
>Here i can think off the quick way.
>
>If you want to refresh the dynamic cached statements for TABLE A, then
>rename it to TABLE B. After the rename the cached statements become
>invalid. Later rename TABLE B back to TABLE A. Note you first renamed
>TABLE A, all the packages/plans get invalidated. In case AUTO BIND is not
>set to 'YES', you need to rebind them.
>
>Thanks,
>Basivi.
>
>
>
>
>
>Luiz Roberto Foroni <[login to unmask email]>
>Sent by: DB2 Data Base Discussion List <[login to unmask email]>
>12/15/2005 05:24 PM
>Please respond to DB2 Database Discussion list at IDUG
>
> To: [login to unmask email]
> cc:
> Subject: [DB2-L] DB2/ZOS V7 - Refresh dynamic cache
>
>
>Hi listers,
>
>I would like to know the easiest way to refresh dynamic statements
>cached in edm pool.
>
>thanks in advance.
>
>Luiz Roberto Foroni
>DBA - DB2 - ZOS
>Caixa Seguros - Brazil
>
>
>---------------------------------------------------------------------------------
>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
>
>
>---------------------------------------------------------------------------------
>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

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



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

Phil Grainger

Re: Antwort: Re: [DB2-L] DB2/ZOS V7 - Refresh dynamic cache
(in response to Roy Boxwell)
It seems like the RUNSTATS option is the preferred way to go, but you do
find yourself asking (well, I do anyway) why this useful piece of code
is in a utility that you have to BUY rather than being part of DB2
itself.....

Phil Grainger
CA
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]




________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Roy Boxwell
Sent: 16 December 2005 16:27
To: [login to unmask email]
Subject: [DB2-L] Antwort: Re: [DB2-L] DB2/ZOS V7 - Refresh dynamic cache



True the RUNSTATS REPORT NO UPDATE NONE invalidates the DSC but only in
V8....you can always use the "dirty trick" of doing an ALTER AUDIT YES /
NO which works for us!
Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Strasse 5
40470 Duesseldorf/Germany
Tel. +49 (0)211 96149-0
Fax +49 (0)211 96149-35
E-mail [login to unmask email]
Homepage www.seg.de




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

Raymond Bell

Re: DB2/ZOS V7 - Refresh dynamic cache
(in response to Phil Grainger)
Hmmm. Take 2. First attempt got blocked, apparently.


Raymond

-----Original Message-----
From: Bell, Raymond
To: 'Grainger, Phil '; 'DB2 Data Base Discussion List '
Sent: 16/12/2005 17:29
Subject: RE: [DB2-L] Antwort: Re: [DB2-L] DB2/ZOS V7 - Refresh dynamic cache

Phil Grainger, is that a dig at IBM? Shaaaaame (he says in a deep
voice, waiving a piece of paper from the back benches) ;o) But I do
agree the functionality is in an odd place. How about an SQL statement:
ALTER DTC REFRESH IMMEDIATE, or maybe a DSN command would be
easier/better. As long as they don't charge for it, right?

Rock on DB2 Vnext.


Raymond Bell
Database Administrator and Paternity Leave Taker (Ryan Alexander, as you
asked)

-----Original Message-----
From: DB2 Data Base Discussion List
To: [login to unmask email]
Sent: 16/12/2005 17:14
Subject: Re: [DB2-L] Antwort: Re: [DB2-L] DB2/ZOS V7 - Refresh dynamic
cache

It seems like the RUNSTATS option is the preferred way to go, but you do
find yourself asking (well, I do anyway) why this useful piece of code
is in a utility that you have to BUY rather than being part of DB2
itself.....

Phil Grainger
CA
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]




_____

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Roy Boxwell
Sent: 16 December 2005 16:27
To: [login to unmask email]
Subject: [DB2-L] Antwort: Re: [DB2-L] DB2/ZOS V7 - Refresh dynamic cache



True the RUNSTATS REPORT NO UPDATE NONE invalidates the DSC but only in
V8....you can always use the "dirty trick" of doing an ALTER AUDIT YES /
NO which works for us!
Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Strasse 5
40470 Duesseldorf/Germany
Tel. +49 (0)211 96149-0
Fax +49 (0)211 96149-35
E-mail [login to unmask email]
Homepage www.seg.de



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


This e-mail (and any attachments) may contain privileged and/or confidential information. If you are not the intended recipient please do not disclose, copy, distribute, disseminate or take any action in reliance on it. If you have received this message in error please reply and tell us and then delete it. Should you wish to communicate with us by e-mail we cannot guarantee the security of any data outside our own computer systems. For the protection of Legal & General's systems and staff, incoming emails will be automatically scanned.

Any information contained in this message may be subject to applicable terms and conditions and must not be construed as giving investment advice within or outside the United Kingdom.

The following companies are subsidiary companies of the Legal & General Group Plc which are authorised and regulated by the Financial Services Authority for advising and arranging the products shown: Legal & General Partnership Services Limited (insurance and mortgages), Legal & General Insurance Limited (insurance), Legal & General Assurance Society Limited
(life assurance, pensions and investments), Legal & General Unit Trust Managers Limited and Legal & General Portfolio Management Services Limited (investments).

They are registered in England under numbers shown.
The registered office is Temple Court, 11 Queen Victoria Street, London EC4N 4TP.

Legal & General Partnership Services Limited: 5045000 Legal & General Assurance Society Limited: 166055 Legal & General (Unit Trust Managers) Limited: 1009418 Legal & General (Portfolio Management Services) Limited: 2457525 Legal & General Insurance Limited: 423930

They are registered with the Financial Services Authority under numbers shown. You can check this at www.fsa.gov.uk/register

Legal & General Partnership Services Limited: 300792 Legal & General Assurance Society Limited: 117659 Legal & General (Unit Trust Managers) Limited: 119273 Legal & General (Portfolio Management Services) Limited: 146786 Legal & General Insurance Limited: 202050

---------------------------------------------------------------------------------
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: DB2/ZOS V7 - Refresh dynamic cache
(in response to Raymond Bell)
Hmmmm also.

A couple years ago Jim Ruddy explained at the US Tech conference that adding
a clause to the syntax of the RUNSTATS util was light-years less expensive
than adding a new command.

Raymond,
Did you consider Ryan Alexander Graham ...?

If I understand you correctly, Congratulations and good luck. You have a
tremendous adventure ahead of you.
My babies turn 20 next Thursday. It goes all too quickly.

There oughtta be a law against consecutive off-topic posts from an
individual, oughtn't there?
It'll never happen again.

Dave




-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Bell, Raymond
Sent: Friday, December 16, 2005 12:32 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2/ZOS V7 - Refresh dynamic cache


Hmmm. Take 2. First attempt got blocked, apparently.


Raymond

-----Original Message-----
From: Bell, Raymond
To: 'Grainger, Phil '; 'DB2 Data Base Discussion List '
Sent: 16/12/2005 17:29
Subject: RE: [DB2-L] Antwort: Re: [DB2-L] DB2/ZOS V7 - Refresh dynamic cache

Phil Grainger, is that a dig at IBM? Shaaaaame (he says in a deep voice,
waiving a piece of paper from the back benches) ;o) But I do agree the
functionality is in an odd place. How about an SQL statement: ALTER DTC
REFRESH IMMEDIATE, or maybe a DSN command would be easier/better. As long
as they don't charge for it, right?

Rock on DB2 Vnext.


Raymond Bell
Database Administrator and Paternity Leave Taker (Ryan Alexander, as you
asked)

-----Original Message-----
From: DB2 Data Base Discussion List
To: [login to unmask email]
Sent: 16/12/2005 17:14
Subject: Re: [DB2-L] Antwort: Re: [DB2-L] DB2/ZOS V7 - Refresh dynamic cache

It seems like the RUNSTATS option is the preferred way to go, but you do
find yourself asking (well, I do anyway) why this useful piece of code is in
a utility that you have to BUY rather than being part of DB2 itself.....

Phil Grainger
CA
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]




_____

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Roy Boxwell
Sent: 16 December 2005 16:27
To: [login to unmask email]
Subject: [DB2-L] Antwort: Re: [DB2-L] DB2/ZOS V7 - Refresh dynamic cache



True the RUNSTATS REPORT NO UPDATE NONE invalidates the DSC but only in
V8....you can always use the "dirty trick" of doing an ALTER AUDIT YES / NO
which works for us! Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Strasse 5
40470 Duesseldorf/Germany
Tel. +49 (0)211 96149-0
Fax +49 (0)211 96149-35
E-mail [login to unmask email]
Homepage www.seg.de



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


This e-mail (and any attachments) may contain privileged and/or confidential
information. If you are not the intended recipient please do not disclose,
copy, distribute, disseminate or take any action in reliance on it. If you
have received this message in error please reply and tell us and then delete
it. Should you wish to communicate with us by e-mail we cannot guarantee the
security of any data outside our own computer systems. For the protection of
Legal & General's systems and staff, incoming emails will be automatically
scanned.

Any information contained in this message may be subject to applicable terms
and conditions and must not be construed as giving investment advice within
or outside the United Kingdom.

The following companies are subsidiary companies of the Legal & General
Group Plc which are authorised and regulated by the Financial Services
Authority for advising and arranging the products shown: Legal & General
Partnership Services Limited (insurance and mortgages), Legal & General
Insurance Limited (insurance), Legal & General Assurance Society Limited
(life assurance, pensions and investments), Legal & General Unit Trust
Managers Limited and Legal & General Portfolio Management Services Limited
(investments).

They are registered in England under numbers shown.
The registered office is Temple Court, 11 Queen Victoria Street, London EC4N
4TP.

Legal & General Partnership Services Limited: 5045000 Legal & General
Assurance Society Limited: 166055 Legal & General (Unit Trust Managers)
Limited: 1009418 Legal & General (Portfolio Management Services) Limited:
2457525 Legal & General Insurance Limited: 423930

They are registered with the Financial Services Authority under numbers
shown. You can check this at www.fsa.gov.uk/register

Legal & General Partnership Services Limited: 300792 Legal & General
Assurance Society Limited: 117659 Legal & General (Unit Trust Managers)
Limited: 119273 Legal & General (Portfolio Management Services) Limited:
146786 Legal & General Insurance Limited: 202050

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



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

Michael Ebert

Re: DB2/ZOS V7 - Refresh dynamic cache
(in response to David Seibert)
Mr. B!

Congrats!!! Beware of interesting times ahead :-)

Mr. E.








"Bell, Raymond" <[login to unmask email]>
Please respond to DB2 Database Discussion list at IDUG
<[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
16-12-05 18:32

To
[login to unmask email]
cc



Subject
Re: [DB2-L] DB2/ZOS V7 - Refresh dynamic cache




Phil Grainger, is that a dig at IBM? Shaaaaame (he says in a deep
voice, waiving a piece of paper from the back benches) ;o) But I do
agree the functionality is in an odd place. How about an SQL statement:
ALTER DTC REFRESH IMMEDIATE, or maybe a DSN command would be
easier/better. As long as they don't charge for it, right?

Rock on DB2 Vnext.


Raymond Bell
Database Administrator and Paternity Leave Taker (Ryan Alexander, as you
asked)


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

Raymond Bell

FW: [DB2-L] DB2/ZOS V7 - Refresh dynamic cache
(in response to Michael Ebert)
Oh good grief. Another 'failed to send' message. Another take 2...


Raymond

-----Original Message-----
From: Bell, Raymond
To: 'DB2 Data Base Discussion List '
Sent: 16/12/2005 20:28
Subject: RE: [DB2-L] DB2/ZOS V7 - Refresh dynamic cache

Cheers, Doc. The interesting times have already begun - first night at
home tonight with 3 in the clan. But as Dave said, off-topic posts will
get you shot, so this'll be it. And no, Dave, I didn't consider RAGB.
I'm quite sure I don't know WHAT you mean... ;o)

Later, all.


Raymond Bell
Database Administrator
PS. Oh no, turned on my out-of-office assistant without unsubscribing.
Please don't take my first born.

-----Original Message-----
From: DB2 Data Base Discussion List
To: [login to unmask email]
Sent: 16/12/2005 18:22
Subject: Re: [DB2-L] DB2/ZOS V7 - Refresh dynamic cache


Mr. B!

Congrats!!! Beware of interesting times ahead :-)

Mr. E.










"Bell, Raymond" <[login to unmask email]>


Please respond to DB2 Database Discussion list at IDUG
<[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>
16-12-05 18:32

To
[login to unmask email]

cc


Subject
Re: [DB2-L] DB2/ZOS V7 - Refresh dynamic cache





Phil Grainger, is that a dig at IBM? Shaaaaame (he says in a deep
voice, waiving a piece of paper from the back benches) ;o) But I do
agree the functionality is in an odd place. How about an SQL statement:
ALTER DTC REFRESH IMMEDIATE, or maybe a DSN command would be
easier/better. As long as they don't charge for it, right?

Rock on DB2 Vnext.


Raymond Bell
Database Administrator and Paternity Leave Taker (Ryan Alexander, as you
asked)

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


This e-mail (and any attachments) may contain privileged and/or confidential information. If you are not the intended recipient please do not disclose, copy, distribute, disseminate or take any action in reliance on it. If you have received this message in error please reply and tell us and then delete it. Should you wish to communicate with us by e-mail we cannot guarantee the security of any data outside our own computer systems. For the protection of Legal & General's systems and staff, incoming emails will be automatically scanned.

Any information contained in this message may be subject to applicable terms and conditions and must not be construed as giving investment advice within or outside the United Kingdom.

The following companies are subsidiary companies of the Legal & General Group Plc which are authorised and regulated by the Financial Services Authority for advising and arranging the products shown: Legal & General Partnership Services Limited (insurance and mortgages), Legal & General Insurance Limited (insurance), Legal & General Assurance Society Limited
(life assurance, pensions and investments), Legal & General Unit Trust Managers Limited and Legal & General Portfolio Management Services Limited (investments).

They are registered in England under numbers shown.
The registered office is Temple Court, 11 Queen Victoria Street, London EC4N 4TP.

Legal & General Partnership Services Limited: 5045000 Legal & General Assurance Society Limited: 166055 Legal & General (Unit Trust Managers) Limited: 1009418 Legal & General (Portfolio Management Services) Limited: 2457525 Legal & General Insurance Limited: 423930

They are registered with the Financial Services Authority under numbers shown. You can check this at www.fsa.gov.uk/register

Legal & General Partnership Services Limited: 300792 Legal & General Assurance Society Limited: 117659 Legal & General (Unit Trust Managers) Limited: 119273 Legal & General (Portfolio Management Services) Limited: 146786 Legal & General Insurance Limited: 202050

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

Roger Miller

Re: DB2/ZOS V7 - Refresh dynamic cache
(in response to Raymond Bell)
I'd say that we charge for DB2, for utilities and for many other
products. I think most other companies do too. It's not cheaper to
provide a function in two ways than in one, and I don't find many
customers who don't have the utilities. Generally I think there are
enough functions that need to be provided that requests to do the same
thing again are not as important.

Roger Miller

On Fri, 16 Dec 2005 19:22:33 +0100, Michael Ebert <[login to unmask email]>
wrote:

>Mr. B!
>
>Congrats!!! Beware of interesting times ahead :-)
>
>Mr. E.
>
>
>"Bell, Raymond" <[login to unmask email]>
>Please respond to DB2 Database Discussion list at IDUG
><[login to unmask email]>
>Sent by: DB2 Data Base Discussion List <[login to unmask email]>
>16-12-05 18:32
>
>To
>[login to unmask email]
>cc
>
>
>Subject
>Re: [DB2-L] DB2/ZOS V7 - Refresh dynamic cache
>
>
>Phil Grainger, is that a dig at IBM? Shaaaaame (he says in a deep
>voice, waiving a piece of paper from the back benches) ;o) But I do
>agree the functionality is in an odd place. How about an SQL statement:
>ALTER DTC REFRESH IMMEDIATE, or maybe a DSN command would be
>easier/better. As long as they don't charge for it, right?
>
>Rock on DB2 Vnext.
>
>
>Raymond Bell
>Database Administrator and Paternity Leave Taker (Ryan Alexander, as you
>asked)
>
>

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