Antwort: [DB2-L] Cardinality and distribution statistics DB2 v8.1 z/OS

Roy Boxwell

Antwort: [DB2-L] Cardinality and distribution statistics DB2 v8.1 z/OS
This is a major "challenge" that we all face! We started doing research
about three years ago into a tool that would read all static and dynamic
SQL, parse the statements for "usable" COLGROUP defs and generate a list of
colgroup defs for Runstats utils. It very quickly became clear that most if
not all DBA "know" the SQL that needs all this info and so a tool would
never make it to market. This is obviously apparent as to my knowledge no
other vendor has tried my "Runstats Optimizer Logic" - My firm does do this
but purely as a consulting solution (Once the colgroups have been found you
do not need to look again unless your SQL changes a lot) as selling a tool
is not just not worth it. Bottom line of this pre-xmas book is to tell your
bosses "It isn't worth it" and either do some in house self-written methods
or pay me zillions to come over and do it for you :)

Roy "On holiday and certified German Beer drinker" Boxwell

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Phil Grainger

Re: Antwort: [DB2-L] Cardinality and distribution statistics DB2 v8.1 z/OS
(in response to Roy Boxwell)
Doesn't Statistics Advisor (in the OSC) do this? It may be one of the chargeable components though, I still haven't really figured out IBMs packaging

Of course, there is the added challenge of whether OSC will work with Db2 V8

Phil Grainger
CA

PS Happy Christmas to all

________________________________

From: DB2 Data Base Discussion List on behalf of Roy Boxwell
Sent: Wed 24/12/2008 09:38
To: [login to unmask email]
Subject: [DB2-L] Antwort: [DB2-L] Cardinality and distribution statistics DB2 v8.1 z/OS



This is a major "challenge" that we all face! We started doing research
about three years ago into a tool that would read all static and dynamic
SQL, parse the statements for "usable" COLGROUP defs and generate a list of
colgroup defs for Runstats utils. It very quickly became clear that most if
not all DBA "know" the SQL that needs all this info and so a tool would
never make it to market. This is obviously apparent as to my knowledge no
other vendor has tried my "Runstats Optimizer Logic" - My firm does do this
but purely as a consulting solution (Once the colgroups have been found you
do not need to look again unless your SQL changes a lot) as selling a tool
is not just not worth it. Bottom line of this pre-xmas book is to tell your
bosses "It isn't worth it" and either do some in house self-written methods
or pay me zillions to come over and do it for you :)

Roy "On holiday and certified German Beer drinker" Boxwell

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html




______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Adam Baldwin

Re: Antwort: [DB2-L] Cardinality and distribution statistics DB2 v8.1 z/OS
(in response to Phil Grainger)
I don't know if it'll do what you want but in DB2 for z/OS, Version 8, Statistics
Advisor was added to Visual Explain.

Cheers, Adam

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Tom Moulder

Re: Antwort: [DB2-L] Cardinality and distribution statistics DB2 v8.1 z/OS
(in response to Adam Baldwin)
Phil

I haven't checked recently, but last time I looked this facility was
provided on a statement by statement basis as opposed to looking at
all statements executed in -- say the last month...

What I have found is that what is good for one statement is not
necessarily good for another and may actually make it worse. What I
have experienced is that the best thing to do is get all your
statistics set and then trust the optimizer. At least make sure that
the objects referenced in statements that cause the greatest problems
have correct statistics. Failing all else, DBAs should trust their
instincts as I have found that they typically know the objects that
need help better than anyone else.

Tom Moulder


Quoting "Grainger, Phil" <[login to unmask email]>:

> Doesn't Statistics Advisor (in the OSC) do this? It may be one of
> the chargeable components though, I still haven't really figured out
> IBMs packaging
>
> Of course, there is the added challenge of whether OSC will work with Db2 V8
>
> Phil Grainger
> CA
>
> PS Happy Christmas to all
>
> ________________________________
>
> From: DB2 Data Base Discussion List on behalf of Roy Boxwell
> Sent: Wed 24/12/2008 09:38
> To: [login to unmask email]
> Subject: [DB2-L] Antwort: [DB2-L] Cardinality and distribution
> statistics DB2 v8.1 z/OS
>
>
>
> This is a major "challenge" that we all face! We started doing research
> about three years ago into a tool that would read all static and dynamic
> SQL, parse the statements for "usable" COLGROUP defs and generate a list of
> colgroup defs for Runstats utils. It very quickly became clear that most if
> not all DBA "know" the SQL that needs all this info and so a tool would
> never make it to market. This is obviously apparent as to my knowledge no
> other vendor has tried my "Runstats Optimizer Logic" - My firm does do this
> but purely as a consulting solution (Once the colgroups have been found you
> do not need to look again unless your SQL changes a lot) as selling a tool
> is not just not worth it. Bottom line of this pre-xmas book is to tell your
> bosses "It isn't worth it" and either do some in house self-written methods
> or pay me zillions to come over and do it for you :)
>
> Roy "On holiday and certified German Beer drinker" Boxwell
>
> ______________________________________________________________________
>
> * IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
> ______________________________________________________________________
>
>
>
>
> IDUG.org was recently updated requiring members to use a new
> password. You should have gotten an e-mail with the temporary
> password assigned to your account. Please log in and update your
> member profile. If you are not already an IDUG.org member, please
> register at http://www.idug.org/component/juser/register.html
>
>
>
>
> ______________________________________________________________________
>
> * IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
> ______________________________________________________________________
>
>
>
>
> IDUG.org was recently updated requiring members to use a new
> password. You should have gotten an e-mail with the temporary
> password assigned to your account. Please log in and update your
> member profile. If you are not already an IDUG.org member, please
> register at http://www.idug.org/component/juser/register.html
>

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

David Simpson

Re: Antwort: [DB2-L] Cardinality and distribution statistics DB2 v8.1 z/OS
(in response to Tom Moulder)
OSC will allow you to run the statistics advisor against an entire
workload. I think this is one of the great DBA challenges of the V8/9
era. The new stats can help solve a myriad of problems, but figuring
out how often to gather them (since they are often very expensive to
collect) and remembering what "extra" stats to put back after a
drop/recreate is a significant challenge.

David Simpson
Senior Technical Advisor
Themis Training
[login to unmask email]
http://www.themisinc.com

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of [login to unmask email]
Sent: Wednesday, December 24, 2008 10:17 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Antwort: [DB2-L] Cardinality and distribution
statistics DB2 v8.1 z/OS

Phil

I haven't checked recently, but last time I looked this facility was
provided on a statement by statement basis as opposed to looking at
all statements executed in -- say the last month...

What I have found is that what is good for one statement is not
necessarily good for another and may actually make it worse. What I
have experienced is that the best thing to do is get all your
statistics set and then trust the optimizer. At least make sure that
the objects referenced in statements that cause the greatest problems
have correct statistics. Failing all else, DBAs should trust their
instincts as I have found that they typically know the objects that
need help better than anyone else.

Tom Moulder


Quoting "Grainger, Phil" <[login to unmask email]>:

> Doesn't Statistics Advisor (in the OSC) do this? It may be one of
> the chargeable components though, I still haven't really figured out
> IBMs packaging
>
> Of course, there is the added challenge of whether OSC will work with
Db2 V8
>
> Phil Grainger
> CA
>
> PS Happy Christmas to all
>
> ________________________________
>
> From: DB2 Data Base Discussion List on behalf of Roy Boxwell
> Sent: Wed 24/12/2008 09:38
> To: [login to unmask email]
> Subject: [DB2-L] Antwort: [DB2-L] Cardinality and distribution
> statistics DB2 v8.1 z/OS
>
>
>
> This is a major "challenge" that we all face! We started doing
research
> about three years ago into a tool that would read all static and
dynamic
> SQL, parse the statements for "usable" COLGROUP defs and generate a
list of
> colgroup defs for Runstats utils. It very quickly became clear that
most if
> not all DBA "know" the SQL that needs all this info and so a tool
would
> never make it to market. This is obviously apparent as to my knowledge
no
> other vendor has tried my "Runstats Optimizer Logic" - My firm does do
this
> but purely as a consulting solution (Once the colgroups have been
found you
> do not need to look again unless your SQL changes a lot) as selling a
tool
> is not just not worth it. Bottom line of this pre-xmas book is to tell
your
> bosses "It isn't worth it" and either do some in house self-written
methods
> or pay me zillions to come over and do it for you :)
>
> Roy "On holiday and certified German Beer drinker" Boxwell
>
> ______________________________________________________________________
>
> * IDUG 2009 Melbourne, Australia * 18-20 March *
http://IDUG.ORG/Events *
> ______________________________________________________________________
>
>
>
>
> IDUG.org was recently updated requiring members to use a new
> password. You should have gotten an e-mail with the temporary
> password assigned to your account. Please log in and update your
> member profile. If you are not already an IDUG.org member, please
> register at http://www.idug.org/component/juser/register.html
>
>
>
>
> ______________________________________________________________________
>
> * IDUG 2009 Melbourne, Australia * 18-20 March *
http://IDUG.ORG/Events *
> ______________________________________________________________________
>
>
>
>
> IDUG.org was recently updated requiring members to use a new
> password. You should have gotten an e-mail with the temporary
> password assigned to your account. Please log in and update your
> member profile. If you are not already an IDUG.org member, please
> register at http://www.idug.org/component/juser/register.html
>

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events
*
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password.
You should have gotten an e-mail with the temporary password assigned to
your account. Please log in and update your member profile. If you are
not already an IDUG.org member, please register at
http://www.idug.org/component/juser/register.html

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Myron Miller

Re: Antwort: [DB2-L] Cardinality and distribution statistics DB2 v8.1 z/OS
(in response to David Simpson)
OSC works fine with DB2 V8.  Not 100% of all features work, but most, including all the equivalent of VE.




________________________________
From: "Grainger, Phil" <[login to unmask email]>
To: [login to unmask email]
Sent: Wednesday, December 24, 2008 6:17:54 AM
Subject: Re: [DB2-L] Antwort: [DB2-L] Cardinality and distribution statistics DB2 v8.1 z/OS

Doesn't Statistics Advisor (in the OSC) do this? It may be one of the chargeable components though, I still haven't really figured out IBMs packaging

Of course, there is the added challenge of whether OSC will work with Db2 V8

Phil Grainger
CA

PS Happy Christmas to all

________________________________

From: DB2 Data Base Discussion List on behalf of Roy Boxwell
Sent: Wed 24/12/2008 09:38
To: [login to unmask email]
Subject: [DB2-L] Antwort: [DB2-L] Cardinality and distribution statistics DB2 v8.1 z/OS



This is a major "challenge" that we all face! We started doing research
about three years ago into a tool that would read all static and dynamic
SQL, parse the statements for "usable" COLGROUP defs and generate a list of
colgroup defs for Runstats utils. It very quickly became clear that most if
not all DBA "know" the SQL that needs all this info and so a tool would
never make it to market. This is obviously apparent as to my knowledge no
other vendor has tried my "Runstats Optimizer Logic" - My firm does do this
but purely as a consulting solution (Once the colgroups have been found you
do not need to look again unless your SQL changes a lot) as selling a tool
is not just not worth it. Bottom line of this pre-xmas book is to tell your
bosses "It isn't worth it" and either do some in house self-written methods
or pay me zillions to come over and do it for you :)

Roy "On holiday and certified German Beer drinker" Boxwell

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html




______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html


______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Roger Hecq

Re: Cardinality and distribution statistics DB2 v8.1 z/OS
(in response to Myron Miller)
Nicola,
I do not know how frequently you run Runstats, but you should be
generating cardinality and distribution stats for all index columns.
This is done by specifying the Table (owner.tb_name) Column (coln1,
coln2...) clause in your Runstats.

I have a REXX that will generate the Runstats statement for a specific
tablespace. If you are interested, contact me off-list.


Roger Hecq
MF IB USA DB Support
203-719-0492 / 19-337-0492

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Nicola Nur
Sent: Tuesday, December 23, 2008 5:01 PM
To: [login to unmask email]
Subject: [DB2-L] Cardinality and distribution statistics DB2 v8.1 z/OS

Hi colleagues

I have a problem and hope to get some advice and insight from you.
To improve the access path of SQL statements in DB2 v8.1 I have been
using Visual Explain Analyze button to generate the cardinality and
distribution stats. That is a very time consuming process. My boss asked
why can't we productionize collecting these statistics?

The following quote from the Red Book 'Every thing you want to know
about v8' states: 'Cardinality and distribution statistics are collected
only on the columns explicitly specified. Cardinality and distribution
statistics are not collected if you specify COLUMN ALL'.

Our RUNSTAT jobs specify COLUMN ALL.

That poses a problem for me (constraints of time and lots of SQL stmnts)
because I have to take every SQL statement and generate the cardinality
and distribution stats and then productionize it.

Can any body help me with an idea or a solution? I do not know even if I
made myself clear for you. Thanks and grateful as always.

post script: I wish all of you a Merry Christmas and a Happy New Year.


Nick Nur






__________________________________________________________________
Get the name you've always wanted @ymail.com or @rocketmail.com! Go to
http://ca.promos.yahoo.com/jacko/

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password.
You should have gotten an e-mail with the temporary password assigned to
your account. Please log in and update your member profile. If you are
not already an IDUG.org member, please register at
http://www.idug.org/component/juser/register.html
Visit our website at http://www.ubs.com

This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.

E-mails are not encrypted and cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender
therefore does not accept liability for any errors or omissions in the
contents of this message which arise as a result of e-mail transmission.
If verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities
or related financial instruments.

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Philip Sevetson

Re: Cardinality and distribution statistics DB2 v8.1 z/OS
(in response to Roger Hecq)
Roger, I'd like a copy of that -- would you be willing to post it in the
Code Place? Or just email it to me here?

--Phil Sevetson
[login to unmask email]

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Roger Hecq
Sent: Friday, December 26, 2008 1:21 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Cardinality and distribution statistics DB2 v8.1
z/OS

Nicola,
I do not know how frequently you run Runstats, but you should be
generating cardinality and distribution stats for all index columns.
This is done by specifying the Table (owner.tb_name) Column (coln1,
coln2...) clause in your Runstats.

I have a REXX that will generate the Runstats statement for a specific
tablespace. If you are interested, contact me off-list.


Roger Hecq
MF IB USA DB Support
203-719-0492 / 19-337-0492

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Nicola Nur
Sent: Tuesday, December 23, 2008 5:01 PM
To: [login to unmask email]
Subject: [DB2-L] Cardinality and distribution statistics DB2 v8.1 z/OS

Hi colleagues

I have a problem and hope to get some advice and insight from you.
To improve the access path of SQL statements in DB2 v8.1 I have been
using Visual Explain Analyze button to generate the cardinality and
distribution stats. That is a very time consuming process. My boss asked
why can't we productionize collecting these statistics?

The following quote from the Red Book 'Every thing you want to know
about v8' states: 'Cardinality and distribution statistics are collected
only on the columns explicitly specified. Cardinality and distribution
statistics are not collected if you specify COLUMN ALL'.

Our RUNSTAT jobs specify COLUMN ALL.

That poses a problem for me (constraints of time and lots of SQL stmnts)
because I have to take every SQL statement and generate the cardinality
and distribution stats and then productionize it.

Can any body help me with an idea or a solution? I do not know even if I
made myself clear for you. Thanks and grateful as always.

post script: I wish all of you a Merry Christmas and a Happy New Year.


Nick Nur




=========
Confidentiality Notice: This e-mail communication, and any attachments, contains confidential and privileged information for the exclusive use of the recipient(s) named above. If you are not an intended recipient, or the employee or agent responsible to deliver it to an intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify me immediately by replying to this message and delete this communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the author and do not necessarily represent the opinions of the agency or the City.
=========

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Diana Nagel

Re: Cardinality and distribution statistics DB2 v8.1 z/OS
(in response to Philip Sevetson)
Me too.
Diana
[login to unmask email]

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Sevetson, Phil
Sent: Friday, December 26, 2008 1:57 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Cardinality and distribution statistics DB2 v8.1 z/OS

Roger, I'd like a copy of that -- would you be willing to post it in the Code Place? Or just email it to me here?

--Phil Sevetson
[login to unmask email]

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Roger Hecq
Sent: Friday, December 26, 2008 1:21 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Cardinality and distribution statistics DB2 v8.1 z/OS

Nicola,
I do not know how frequently you run Runstats, but you should be generating cardinality and distribution stats for all index columns.
This is done by specifying the Table (owner.tb_name) Column (coln1,
coln2...) clause in your Runstats.

I have a REXX that will generate the Runstats statement for a specific tablespace. If you are interested, contact me off-list.


Roger Hecq
MF IB USA DB Support
203-719-0492 / 19-337-0492

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Nicola Nur
Sent: Tuesday, December 23, 2008 5:01 PM
To: [login to unmask email]
Subject: [DB2-L] Cardinality and distribution statistics DB2 v8.1 z/OS

Hi colleagues

I have a problem and hope to get some advice and insight from you.
To improve the access path of SQL statements in DB2 v8.1 I have been using Visual Explain Analyze button to generate the cardinality and distribution stats. That is a very time consuming process. My boss asked why can't we productionize collecting these statistics?

The following quote from the Red Book 'Every thing you want to know about v8' states: 'Cardinality and distribution statistics are collected only on the columns explicitly specified. Cardinality and distribution statistics are not collected if you specify COLUMN ALL'.

Our RUNSTAT jobs specify COLUMN ALL.

That poses a problem for me (constraints of time and lots of SQL stmnts) because I have to take every SQL statement and generate the cardinality and distribution stats and then productionize it.

Can any body help me with an idea or a solution? I do not know even if I made myself clear for you. Thanks and grateful as always.

post script: I wish all of you a Merry Christmas and a Happy New Year.


Nick Nur




=========
Confidentiality Notice: This e-mail communication, and any attachments, contains confidential and privileged information for the exclusive use of the recipient(s) named above. If you are not an intended recipient, or the employee or agent responsible to deliver it to an intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify me immediately by replying to this message and delete this communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the author and do not necessarily represent the opinions of the agency or the City.
=========

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events * ______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html