INSERT Statements Per Hour

SUBSCRIBE DB2-L Anil Kale

INSERT Statements Per Hour
Hi All !

I have been reviewing the performance of the inserts volume at our shop. We
are using DB2 V9 CM on z/os (non-sysplex, non-data sharing env).
We use a product called Optim (formerly princeton softech) and it performs a
few millions of inserts in an hour. In contrast, the COBOL programs performs
a max of 100K inserts per hour.
I was wondering if any of you have done some analysis with regards to a
performance test for massive inserts using COBOL program. And what were
your findings/lessons learned.
For those who are familiar with optim/softech tool,
why would there be such a huge difference in the number of inserts using
optim versus inserts using a cobol program.

Thanks

Anil

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

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

Roy Boxwell

Re: INSERT Statements Per Hour
(in response to SUBSCRIBE DB2-L Anil Kale)
we would need to see

1) The DDL of the tables, indices and tablespaces
2) The code used to insert

to actually begin to get a grip on the possibility of the answer (Which of
course is "It depends") however my gut feeling (and ask anyone who knows
me - it is a big feeling ;) ) is simply good DDL and good code running
against "bad" DDL and "bad" code. There are so many possibilites - better
IO from faster disks, better preformat, better extent managment, better
DDL (MEMBER CLUSTER being one thing) better usage of tablespaces FREEPAGE
etc etc...better/lower index count or cols etc etc and then there is the
code. Are you using multi-row insert? Is the code written to be fast or
slow?

Post all the DDL and we can begin the autopsy....



Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Siegfried Fürst, Gerhard Schubert




Anil <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>
18.01.2010 04:49
Bitte antworten an
IDUG DB2-L <[login to unmask email]>


An
[login to unmask email]
Kopie

Thema
[DB2-L] INSERT Statements Per Hour






Hi All !

I have been reviewing the performance of the inserts volume at our shop.
We
are using DB2 V9 CM on z/os (non-sysplex, non-data sharing env).
We use a product called Optim (formerly princeton softech) and it performs
a
few millions of inserts in an hour. In contrast, the COBOL programs
performs
a max of 100K inserts per hour.
I was wondering if any of you have done some analysis with regards to a
performance test for massive inserts using COBOL program. And what were
your findings/lessons learned.
For those who are familiar with optim/softech tool,
why would there be such a huge difference in the number of inserts using
optim versus inserts using a cobol program.

Thanks

Anil

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 *
http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

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


_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

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

Sudhir Raj

Re: INSERT Statements Per Hour
(in response to Roy Boxwell)
If the underlying tables that the rows are inserted into are the same for both workloads (optim & cobol program). The huge difference could be due to many factors.. I would start looking at..

A) Insert key sequence  (sequential ascending/descending by clustering index vs. random insert that will drag performance down)
B) Commit Frequency 
C) Is Optim utilizing MRI ?
D) State of tablespace/indexspaces when insert workload runs. (free space, was Reorg run? , contention etc..)
E) Compare class1/class2 elapsed and cpu time between optim and DB2 workload, maybe the cobol program is spending most of the time in application outside DB2!

If the underlying tables are not exactly the same, and/or the characteristics/sequence of data inserted  is not the same, we will be comparing apples and oranges
And as Roy said, more info will help.
 
(MEMBER CLUSTER will only help in datasharing with parallel inserts from multiple members)
 Sudhir Muthuraj
RealTime-DBA




________________________________
From: Roy Boxwell <[login to unmask email]>
To: [login to unmask email]
Sent: Mon, January 18, 2010 3:16:34 AM
Subject: Re: INSERT Statements Per Hour


we would need to see

1) The DDL of the tables, indices and tablespaces
2) The code used to insert

to actually begin to get a grip on the possibility of the answer (Which of course is "It depends") however my gut feeling (and ask anyone who knows me - it is a big feeling ;)  ) is simply good DDL and good code running against "bad" DDL and "bad" code. There are so many possibilites - better IO from faster disks, better preformat, better extent managment, better DDL (MEMBER CLUSTER being one thing) better usage of tablespaces FREEPAGE etc etc...better/lower index count or cols etc etc and then there is the code. Are you using multi-row insert? Is the code written to be fast or slow?

Post all the DDL and we can begin the autopsy....



Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Siegfried Fürst, Gerhard Schubert




Anil <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>
18.01.2010 04:49
Bitte antworten an
IDUG DB2-L <[login to unmask email]>
An [login to unmask email]
Kopie
Thema [DB2-L] INSERT Statements Per Hour




Hi All !

I have been reviewing the performance of the inserts volume at our shop. We
are using DB2 V9 CM on z/os (non-sysplex, non-data sharing env).
We use a product called Optim (formerly princeton softech) and it performs a
few millions of inserts in an hour. In contrast, the COBOL programs performs
a max of 100K inserts per hour.
I was wondering if any of you have done some analysis with regards to a
performance test for massive inserts using COBOL program. And what were
your findings/lessons learned.
For those who are familiar with optim/softech tool,
why would there be such a huge difference in the number of inserts using
optim versus inserts using a cobol program.

Thanks

Anil

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 *  http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

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


________________________________

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here.




_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

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

Roy Boxwell

Re: INSERT Statements Per Hour
(in response to Sudhir Raj)
Careful! I use MEMBER CLUSTER to improve insert in non-datasharing....


MEMBER CLUSTER
Specifies that data inserted by an insert operation is not clustered by
the
implicit clustering index (the first index) or the explicit clustering
index.
Instead, DB2 chooses where to locate the data in the table space based on
available space.


many many moons ago it was only for data-sharing but that changed...of
course you have to reorg more often but hey this is DB2!

Performance boost with the right hand....TS Reorg with the left...


Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Siegfried Fürst, Gerhard Schubert




Sudhir Raj <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>
20.01.2010 02:39
Bitte antworten an
IDUG DB2-L <[login to unmask email]>


An
[login to unmask email]
Kopie

Thema
Re: [DB2-L] INSERT Statements Per Hour






If the underlying tables that the rows are inserted into are the same for
both workloads (optim & cobol program). The huge difference could be due
to many factors.. I would start looking at..

A) Insert key sequence (sequential ascending/descending by clustering
index vs. random insert that will drag performance down)
B) Commit Frequency
C) Is Optim utilizing MRI ?
D) State of tablespace/indexspaces when insert workload runs. (free space,
was Reorg run? , contention etc..)
E) Compare class1/class2 elapsed and cpu time between optim and DB2
workload, maybe the cobol program is spending most of the time in
application outside DB2!

If the underlying tables are not exactly the same, and/or the
characteristics/sequence of data inserted is not the same, we will be
comparing apples and oranges
And as Roy said, more info will help.

(MEMBER CLUSTER will only help in datasharing with parallel inserts from
multiple members)

Sudhir Muthuraj
RealTime-DBA


From: Roy Boxwell <[login to unmask email]>
To: [login to unmask email]
Sent: Mon, January 18, 2010 3:16:34 AM
Subject: Re: INSERT Statements Per Hour


we would need to see

1) The DDL of the tables, indices and tablespaces
2) The code used to insert

to actually begin to get a grip on the possibility of the answer (Which of
course is "It depends") however my gut feeling (and ask anyone who knows
me - it is a big feeling ;) ) is simply good DDL and good code running
against "bad" DDL and "bad" code. There are so many possibilites - better
IO from faster disks, better preformat, better extent managment, better
DDL (MEMBER CLUSTER being one thing) better usage of tablespaces FREEPAGE
etc etc...better/lower index count or cols etc etc and then there is the
code. Are you using multi-row insert? Is the code written to be fast or
slow?

Post all the DDL and we can begin the autopsy....



Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Siegfried Fürst, Gerhard Schubert



Anil <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>
18.01.2010 04:49

Bitte antworten an
IDUG DB2-L <[login to unmask email]>



An
[login to unmask email]
Kopie

Thema
[DB2-L] INSERT Statements Per Hour








Hi All !

I have been reviewing the performance of the inserts volume at our shop.
We
are using DB2 V9 CM on z/os (non-sysplex, non-data sharing env).
We use a product called Optim (formerly princeton softech) and it performs
a
few millions of inserts in an hour. In contrast, the COBOL programs
performs
a max of 100K inserts per hour.
I was wondering if any of you have done some analysis with regards to a
performance test for massive inserts using COBOL program. And what were
your findings/lessons learned.
For those who are familiar with optim/softech tool,
why would there be such a huge difference in the number of inserts using
optim versus inserts using a cobol program.

Thanks

Anil

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 *
http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

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




The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.




The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

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

Roy Boxwell

Re: INSERT Statements Per Hour
(in response to Roy Boxwell)
just did some research... MEMBER CLUSTER seems to have appeared half-way
through DB2 V6. Text is the same as now except the limitations were simply
No LOB, Work or temp. That hasnt changed upto V8. New in V9 is no Segsize
or UTS. I only use MEMBER CLUSTER for partitioned spaces of course so have
no worries there!



Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Siegfried Fürst, Gerhard Schubert

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

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

Shery hepp

Re: INSERT Statements Per Hour
(in response to Roy Boxwell)
Sudhir- IBM had a free webinar on December 1,2009 called



DB2 for z/OS Optimising Insert Performance presented by bell

Distinguished Engineer

John Campbell

Distinguished Engineer



It had a lot of VERY GOOD information. Maybe you can find the
presentation out on IBMs website to listen too. Otherwise I'm including
the presenters contact information from the presentation- maybe he can
send you the presentation if you're unable to find it on IBMs website.



Email: [login to unmask email]



Hope this helps- regards, Shery





From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sudhir Raj
Sent: Tuesday, January 19, 2010 6:39 PM
To: [login to unmask email]
Subject: Re: [DB2-L] INSERT Statements Per Hour



If the underlying tables that the rows are inserted into are the same
for both workloads (optim & cobol program). The huge difference could be
due to many factors.. I would start looking at..

A) Insert key sequence (sequential ascending/descending by clustering
index vs. random insert that will drag performance down)
B) Commit Frequency
C) Is Optim utilizing MRI ?
D) State of tablespace/indexspaces when insert workload runs. (free
space, was Reorg run? , contention etc..)
E) Compare class1/class2 elapsed and cpu time between optim and DB2
workload, maybe the cobol program is spending most of the time in
application outside DB2!

If the underlying tables are not exactly the same, and/or the
characteristics/sequence of data inserted is not the same, we will be
comparing apples and oranges

And as Roy said, more info will help.



(MEMBER CLUSTER will only help in datasharing with parallel inserts from
multiple members)


Sudhir Muthuraj
RealTime-DBA





________________________________


_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

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

Sudhir Raj

Re: INSERT Statements Per Hour
(in response to Shery hepp)
Thanks Roy, I always assumed (wrongly! ) that MEMBER CLUSTER only works in datasharing, i now will add this to my tool box!

Sudhir
RealTime-DBA




________________________________
From: Roy Boxwell <[login to unmask email]>
To: [login to unmask email]
Sent: Wed, January 20, 2010 1:23:16 AM
Subject: Re: INSERT Statements Per Hour


Careful! I use MEMBER CLUSTER to improve insert in non-datasharing....


MEMBER CLUSTER
Specifies that data inserted by an insert operation is not clustered by the
implicit clustering index (the first index) or the explicit clustering index.
Instead, DB2 chooses where to locate the data in the table space based on
available space.


many many moons ago it was only for data-sharing but that changed...of course you have to reorg more often but hey this is DB2!

Performance boost with the right hand....TS Reorg with the left...


Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Siegfried Fürst, Gerhard Schubert




Sudhir Raj <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>
20.01.2010 02:39
Bitte antworten an
IDUG DB2-L <[login to unmask email]>
An [login to unmask email]
Kopie
Thema Re: [DB2-L] INSERT Statements Per Hour




If the underlying tables that the rows are inserted into are the same for both workloads (optim & cobol program). The huge difference could be due to many factors.. I would start looking at..

A) Insert key sequence  (sequential ascending/descending by clustering index vs. random insert that will drag performance down)
B) Commit Frequency
C) Is Optim utilizing MRI ?
D) State of tablespace/indexspaces when insert workload runs. (free space, was Reorg run? , contention etc..)
E) Compare class1/class2 elapsed and cpu time between optim and DB2 workload, maybe the cobol program is spending most of the time in application outside DB2!

If the underlying tables are not exactly the same, and/or the characteristics/sequence of data inserted  is not the same, we will be comparing apples and oranges
And as Roy said, more info will help.
 
(MEMBER CLUSTER will only help in datasharing with parallel inserts from multiple members)

Sudhir Muthuraj
RealTime-DBA


________________________________
From: Roy Boxwell <[login to unmask email]>
To: [login to unmask email]
Sent: Mon, January 18, 2010 3:16:34 AM
Subject: Re: INSERT Statements Per Hour


we would need to see

1) The DDL of the tables, indices and tablespaces
2) The code used to insert

to actually begin to get a grip on the possibility of the answer (Which of course is "It depends") however my gut feeling (and ask anyone who knows me - it is a big feeling ;)  ) is simply good DDL and good code running against "bad" DDL and "bad" code.. There are so many possibilites - better IO from faster disks, better preformat, better extent managment, better DDL (MEMBER CLUSTER being one thing) better usage of tablespaces FREEPAGE etc etc...better/lower index count or cols etc etc and then there is the code. Are you using multi-row insert? Is the code written to be fast or slow?

Post all the DDL and we can begin the autopsy....



Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Siegfried Fürst, Gerhard Schubert



Anil <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>
18.01.2010 04:49

Bitte antworten an
IDUG DB2-L <[login to unmask email]>

An [login to unmask email]
Kopie
Thema [DB2-L] INSERT Statements Per Hour






Hi All !

I have been reviewing the performance of the inserts volume at our shop. We
are using DB2 V9 CM on z/os (non-sysplex, non-data sharing env).
We use a product called Optim (formerly princeton softech) and it performs a
few millions of inserts in an hour. In contrast, the COBOL programs performs
a max of 100K inserts per hour.
I was wondering if any of you have done some analysis with regards to a
performance test for massive inserts using COBOL program. And what were
your findings/lessons learned.
For those who are familiar with optim/softech tool,
why would there be such a huge difference in the number of inserts using
optim versus inserts using a cobol program.

Thanks

Anil

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 *  http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

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



________________________________

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here.


________________________________

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here.

________________________________

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here.



_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

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

Sudhir Raj

Re: INSERT Statements Per Hour
(in response to Sudhir Raj)
When I want the performance benifit of MEMBER CLUSTER on a non-partitioned table space, I create a one partition partitioned tablespace.
 Sudhir
RealTime-DBA




________________________________
From: Roy Boxwell <[login to unmask email]>
To: [login to unmask email]
Sent: Wed, January 20, 2010 1:40:53 AM
Subject: Re: INSERT Statements Per Hour


just did some research... MEMBER CLUSTER seems to have appeared half-way through DB2 V6. Text is the same as now except the limitations were simply No LOB, Work or temp. That hasnt changed upto V8. New in V9 is no Segsize or UTS. I only use MEMBER CLUSTER for partitioned spaces of course so have no worries there!



Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Siegfried Fürst, Gerhard Schubert

________________________________

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here.




_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

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