The Best DB2 Articles

[lopezadmin]

Announcement!

Best DB2 Articles was started as a means to collect and share
information between IT Professionals who work with DB2 on any platform
and in any capacity. I have been working with DB2 for over 30 years
now and have not been able to find any source that was one stop
shopping.

My hope is that all of you will take a few minutes out of your day to
submit articles, scripts, sql, tips and techniques, so that others
can also learn and not have to rewrite code when its available from
most of us.

Note: There is no content on the site right now, I will be posting
out some AIX and Solaris scripts soon, but looking for suggestions and
content from the community. Remember there always someone looking for
a better way to do some task.

If you have a question or suggestion for the website, please drop me
an email...

Ray Lopez

lo********@gmail.com

http://bestdb2articles.com

[Serge Rielau]

lo********@gmail.com wrote:

Announcement!

Best DB2 Articles was started as a means to collect and share
information between IT Professionals who work with DB2 on any platform
and in any capacity. I have been working with DB2 for over 30 years
now and have not been able to find any source that was one stop
shopping.

My hope is that all of you will take a few minutes out of your day to
submit articles, scripts, sql, tips and techniques, so that others
can also learn and not have to rewrite code when its available from
most of us.

Note: There is no content on the site right now, I will be posting
out some AIX and Solaris scripts soon, but looking for suggestions and
content from the community. Remember there always someone looking for
a better way to do some task.

If you have a question or suggestion for the website, please drop me
an email...

Ray Lopez

lo********@gmail.com

http://bestdb2articles.com

Ray, please remove the "UDB" and replace with "DB2 for LUW" or "DB2
distributed" or just DB2 for HP/LINUX/whatever.
UDB never was a product and the property which includes DB2 UDB for zOS
has been stricken entirely with DB2 9 on all platforms.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[The Boss]

lo********@gmail.com wrote:

Announcement!

Best DB2 Articles was started as a means to collect and share
information between IT Professionals who work with DB2 on any platform
and in any capacity. I have been working with DB2 for over 30 years

That's pretty impressive, given the fact that the first product with that
name was DB2 for MVS v1, which was introduced in 1983.
And even its predecessors SQL/DS on VM/VSE (1982) and the integrated DBMS in
the System/38 servers (1980) aren't around 30 years. You must have been a
member of the System-R research-team, I guess? ;-)

now and have not been able to find any source that was one stop
shopping.

And why is this a problem?
And if so, how are you going to solve it? Adding another shop?

>
My hope is that all of you will take a few minutes out of your day to
submit articles, scripts, sql, tips and techniques, so that others
can also learn and not have to rewrite code when its available from
most of us.

Articles? OK
Tips, techniques and samples, etc? Yes
Ready-to-run scripts (for production use)? Ehm, no.

>
Note: There is no content on the site right now, I will be posting
out some AIX and Solaris scripts soon, but looking for suggestions and
content from the community. Remember there always someone looking for
a better way to do some task.

How about discussing them in this newsgroup?
Or other resources like the DeveloperWorks site or the one from IDUG or
blogs devoted to DB2 like the ones by Chris Eaton (LUW) or Willie Favero
(zOS)?
Or numerous other ways.

--
Jeroen

[Knut Stolze]

lo********@gmail.com wrote:

Best DB2 Articles was started as a means to collect and share
information between IT Professionals who work with DB2 on any platform
and in any capacity. I have been working with DB2 for over 30 years
now and have not been able to find any source that was one stop
shopping.

Have you seen DB2 developerWorks already? It is surely not complete, but it
contains a wealth of information.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

[lopezadmin]

On Aug 5, 11:48 am, Knut Stolze <[e-mail]:

[e-mail] wrote:

BestDB2Articleswas started as a means to collect and share
information between IT Professionals who work withDB2on any platform
and in any capacity. I have been working withDB2for over 30 years
now and have not been able to find any source that was one stop
shopping.

Have you seenDB2developerWorks already? It is surely not complete, but it
contains a wealth of information.

--
Knut StolzeDB2z/OS Utilities Development
IBM Germany

Knut,

Thank you for your response, and yes I have checked it out and use it
from time to time.

Ray

[lopezadmin]

On Aug 3, 3:54 pm, "The Boss" <[e-mail]:

[e-mail] wrote:

Announcement!

BestDB2Articleswas started as a means to collect and share
information between IT Professionals who work withDB2on any platform
and in any capacity. I have been working withDB2for over 30 years

That's pretty impressive, given the fact that the first product with that
name wasDB2for MVS v1, which was introduced in 1983.
And even its predecessors SQL/DS on VM/VSE (1982) and the integrated DBMS in
the System/38 servers (1980) aren't around 30 years. You must have been a
member of the System-R research-team, I guess? ;-)

now and have not been able to find any source that was one stop
shopping.

And why is this a problem?
And if so, how are you going to solve it? Adding another shop?

My hope is that all of you will take a few minutes out of your day to
submitarticles, scripts, sql, tips and techniques, so that others
can also learn and not have to rewrite code when its available from
most of us.

Articles? OK
Tips, techniques and samples, etc? Yes
Ready-to-run scripts (for production use)? Ehm, no.

Note: There is no content on the site right now, I will be posting
out some AIX and Solaris scripts soon, but looking for suggestions and
content from the community. Remember there always someone looking for
a better way to do some task.

How about discussing them in this newsgroup?
Or other resources like the DeveloperWorks site or the one from IDUG or
blogs devoted toDB2like the ones by Chris Eaton (LUW) or Willie Favero
(zOS)?
Or numerous other ways.

--
Jeroen

[lopezadmin]

On Aug 3, 3:54 pm, "The Boss" <[e-mail]:

[e-mail] wrote:

Announcement!

BestDB2Articleswas started as a means to collect and share
information between IT Professionals who work withDB2on any platform
and in any capacity. I have been working withDB2for over 30 years

That's pretty impressive, given the fact that the first product with that
name wasDB2for MVS v1, which was introduced in 1983.
And even its predecessors SQL/DS on VM/VSE (1982) and the integrated DBMS in
the System/38 servers (1980) aren't around 30 years. You must have been a
member of the System-R research-team, I guess? ;-)

now and have not been able to find any source that was one stop
shopping.

And why is this a problem?
And if so, how are you going to solve it? Adding another shop?

My hope is that all of you will take a few minutes out of your day to
submitarticles, scripts, sql, tips and techniques, so that others
can also learn and not have to rewrite code when its available from
most of us.

Articles? OK
Tips, techniques and samples, etc? Yes
Ready-to-run scripts (for production use)? Ehm, no.

Note: There is no content on the site right now, I will be posting
out some AIX and Solaris scripts soon, but looking for suggestions and
content from the community. Remember there always someone looking for
a better way to do some task.

How about discussing them in this newsgroup?
Or other resources like the DeveloperWorks site or the one from IDUG or
blogs devoted toDB2like the ones by Chris Eaton (LUW) or Willie Favero
(zOS)?
Or numerous other ways.

--
Jeroen

Jeroen,

Thank you for responding to the post, in fact I joined IBM in 1974 and
worked with System-R for a project that we had internally within one
of the groups at Santa Teresa Labs. When I said I had 30 years, maybe
I should have said that I have been working in IT for 30 years.

I agree with you on the production scripts, not looking for that.
Looking for DB2 scripts to be posted, it would be on the person that
downloads the scripts to test, modify, and test again before making
anything production status? The whole point being is to help out new
dba's with tips and techniques and scripts to help them get up to
speed faster on the product without having to go and write new sql or
code that someone else has already done.

Ray

[lopezadmin]

On Aug 3, 3:32 pm, Serge Rielau <[e-mail]:

[e-mail] wrote:

Announcement!

BestDB2Articleswas started as a means to collect and share
information between IT Professionals who work withDB2on any platform
and in any capacity. I have been working withDB2for over 30 years
now and have not been able to find any source that was one stop
shopping.

My hope is that all of you will take a few minutes out of your day to
submitarticles, scripts, sql, tips and techniques, so that others
can also learn and not have to rewrite code when its available from
most of us.

Note: There is no content on the site right now, I will be posting
out some AIX and Solaris scripts soon, but looking for suggestions and
content from the community. Remember there always someone looking for
a better way to do some task.

If you have a question or suggestion for the website, please drop me
an email...

Ray Lopez

[e-mail]

http://bestdb2articles.com

Ray, please remove the "UDB" and replace with "DB2for LUW" or "DB2
distributed" or justDB2for HP/LINUX/whatever.
UDB never was a product and the property which includesDB2UDB for zOS
has been stricken entirely withDB29 on all platforms.

Cheers
Serge
--
Serge RielauDB2Solutions Development
IBM Toronto Lab

Serge,
Thanks, will make the changes on the site.
Ray