Yevich, Lawson, and Associates

6/15/2010

Sign up for the free BMC webinar on utilizing indexes featuring Dan and Susan this June 23rd. Simply follow the link on the events page

5/5/2010

Long overdue updates to the site have begun. Susan has a new profile, new events have been added to the events page, and two new articles are available on the links page.

12/08/2009

A new podcast on caching is available on the podcasts page.

11/16/2009

The IOD podcasts on certification and Optim are now available on the podcast page and via RSS. Our recent BMC webcast on SQL can be replayed via a link on the links page. The companion whitepaper to that webcast on SMART SQL usage is available from the links or the download page.

10/16/2009

We have a new podcast on enterprise architecture on the podcasts page. The event schedule has been updated with details for our live IOD podcast party, and don't forget We're also doing a webinar for BMC in November. Check out the events page for details.

09/28/2009

The event schedule has been updated for the remainder of the year. Look for our strong presence at IDUG Europe and IBM IOD. We're also doing a webinar for BMC in November. Check out the events page for details.

06/15/2009

The BMC DB2 for z/OS Performance Guide is now available on the downloads page. Feel free to contact BMC for a hard copy also!

06/05/2009

The BMC DB2 for z/OS Backup and Recovery Guide is now available on the downloads page. Feel free to contact BMC for a hard copy also!

05/30/2009

Several new events and abstracts have been posted for new topics we are starting to talk about as we blaze yet more new trails.

05/22/2009

A new podcast featuring several senior IBM developers talking about the next version of DB2 for z/OS is now available on the podcasts page. There's a new article on the links page concerning enterprise architecture. Also, Dan and Susan are 2009 IBM Data Champions! Take a look at our credentials on the consultants page.

04/11/2009

The first podcast of our new series, On the Bar Stool with the DB2 Coctail Hour, is available on the podcasts page. We have a new zJournal article on name searching on the links page. I finally uploaded the extra three shots od DB2 performance from our January podcast.

02/05/2009

We've started updating the events page for 2009. Check back often for more updates. A new podcasts, the last of series 2, has been added to the podcast page. We are now offering 10% off all of our services for 2009 in celebration of our 10th anniversary!

11/19/2008

Some updates have been made to the events page with the addition of several public certification classes.

11/03/2008

A live podcast event from IOD North America 2008 has been added to the podcasts page. A Data Studio link has been added to the links page.

10/26/2008

A live podcast event from IDUG Europe 2008 has been added to the podcasts page, and a link to our latest zJournal article on as of imaging is on the links page.

09/17/2008

We updated our podcast page with a new podcast about when to do REORG, RUNSTAT, and REBIND. We also updated the documentation for the previous podcast on optimistic locking. There's a link to a new zJournal article about minimizing the SQL statements you issue on the links page. We've also seriously updated the events page with appearances at IDUG Europe, IOD, and a BMC webinar. Also, there's a new UDF on the downloads page that does hex to small integer conversions.

05/16/2008

Come see us at IDUG. We have a huge presence there with educational seminars, a presentation, a VSP, and two SIGs! Check out the Events Page for the details. There's a new podcast about optimistic locking on the Podcasts Page, and we've updated some of our offerings with the expansion of DB2 9 services.

04/12/2008

The DB2 Estimator page is now gone. We found the download and updated our link on the links page. Get it before it goes away!

02/18/2008

We put a new podcast up on the series 2 podcast page about EXPLAIN. We also have the new BMC DB2 9 for z/OS EXPLAIN poster on the downloads page, along with DB2 9 for z/OS EXPLAIN table DDL. We also fixed some broken links on the RUGS page.

01/04/2008

There has been a huge update to celebrate the new year (OK, actually because we were really busy, and the holiday break gave us a change to update)! Here's a short list:

Two new podcasts on the series 2 podcast page about data sharing and stored procedures
The DB2 for z/OS 9 Certification Guide is out, and we have a link to it on the links page
Several article links on the links page have been repaired
The DB2 9 for z/OS catalog poster is available for download on the downloads page
The CA Performance Guide is available on the downloads page
New EXPLAIN queries are on the download page
We located the old BMC Performance Primer, and that's now on the downloads page
The DB2 9 for z/OS Reference Guide is on the downloads page
A query to list statments (Unicode or EBCDIC) is now on the downloads page
A link to a nice Julian date conversion chart is on the links page
Two REXX routines to scrape performance reports to make package performance listings are now on the downloads page
The events page has been updated with a huge list of inexpensive public classes

Happy new year everyone! We're looking forward to all the new challenges and rewards ahead!

08/07/2007

The latest podcast on sorts and DB2 is now available.

07/03/2007

The events and services pages have been brought up to date.

07/02/2007

DB2 9 for z/OS transition class information has been added. Our lastest zJournal article on Generic attach has been added to the links page.

06/30/2007

Updates to the site have begun. The links page has been updated with some corrected links to old articles, and some new links to the IBM DB2 site, products, and downloads. A new podcast on logical recovery has been added. More coming very soon, Yipee!

06/27/2007

After several months of significant email and server problems we are finally on a new web server! Everything should be working normally now, and we are beginning a complete update of the site. Lots of new stuff coming really soon! If you recently sent an email or tried signing up for the mailing list and never got a response, please try again now!

03/22/2007

There's a new podcast out there on DB2 9 for z/OS. Our email problems have been repaired. We've added some information about optimistic locking and histogram statistics on the download page, as well as for the latest podcast. Also, the events page has been updated with tons of IDUG involvement. Finally, the links page has been updated with new V9 related DB2 links.

02/08/2007

More events have been added to the events page. The first podcast of our new series entitled Behind the Bar with The DB2 Cocktail Hour is now available on the podcast page. In addition, there are several multi-row fetch related downloads on both the podcast page for series 2, podcast 1, as well as the downloads page. This includes an article, presentation, and examples of multi-row fetch in a program.

12/26/2006

Several new links have been added to the links page, including several to IBM downloads. New events for 2007 have been added to the events page.

11/18/2006

The events page has been brought up to date, and a new podcast about predictive analysis has been added.

10/22/2006

The events page has been brought up to date, and the links page has been corrected for many of the article links.

10/07/2006

Our live podcast from IDUG Europe is now on the podcasts page

09/29/2006

An article on DB2 for z/OS version, and the need for tools has been posted on the downloads page. More events added on the events page.

09/24/2006

We've added yet another podcast on the podcasts page, and we're starting the plans for a new podcast series in 2007!. We've added two recusive SQL examples to the downloads page, as well as an article about the usefulness of tools with version 8 of DB2 for z/OS. Check out the events page with our jam-packed fall schedule, and see if you can get some YL&A education on the cheap!

07/21/2006

Another new podcast. Check out the updated events schedule for fall of 2006, and the cool poem on the home page!

05/08/2006

Two new podcasts. The web site is being totally redone with lots of new information coming on board. Stay tuned for updates!

04/08/2006

The second of our series on SQL tuning podcasts is here! There is a new explain query and a REXX reference now available on the downloads page. Also new on the links page is out latest zJournal article on minimizing the impact of change on the database. Our list of public upcoming speaches and classes continues to grow! Check out where you can see us present for free or attend a class on the cheap on the events page. Coming in May...Our first ever live podcast! Come join us at the Marriott Hotel in Tampa Florida! More info to come on the podcast page.

03/11/2006

Another new podcast is here! See the story of Susan Lawson in DB2 Magazine. Follow the link to the article on our links page. Also new on the links page is a link to using DB2 with PHP. We have a huge list of public upcoming speaches and classes! Check out where you can see us present for free or attend a class on the cheap on the events page. Coming in May...Our first ever live podcast! Come join us at the Marriott Hotel in Tampa Florida! More info to come on the podcast page.

02/14/2006

The new Valentine's Day podcast is here!

02/06/2006

So where is this month's podcast? The lack of a podcast means that we're extremely busy! It looks like 2006 is going to be a huge year for DB2 based upon the request for our services! While you wait for a new podcast in just a couple of weeks you can check out our extensive list of public classes on the services page and the events page. We also have a new download to convert an LRSN to a timestamp, and the links page has been updated with links to the DB2 V8 family reference guide and the CICS documentation library.

12/18/2005

Listen to our special Holiday podcast on minimizing change on the podcast page. The events page has also been updated with the fist public events of our 2006 schedule. Keep you eye on the events as we will quickly be adding many more early in January. We are now offering transition consulting, as well as transition classes. Also, our links page has been updated with a z/Journal article by Susan on z/OS statistics and diagnostics, and a link to our Compuware webinar on stored procedures.

11/08/2005

The RUGS page has been updated with featured seminars and presentations, making it easier for the regional groups to pick our what we feel are our best presentations and seminars.

10/31/2005

A very special podcast from IDUG Europe in Berlin, with some very special guests talking about the evolution of the DBA, so check it out. We also added the DB2 for z/OS EXPLAIN table DDL to the downloads page. Getting sick of looking for IBM manuals on the ever increasingly complex IBM website? Then check out the new links on our links page that take you right to the important pages for IBM manuals in pdf form.

10/08/2005

Another new podcast, on DB2 for z/OS version 8 is now available so check it out.

09/05/2005

Our new podcast, broadcast from South Africa on inserts is now available so check it out. Our fall event schedule is in full swing, and we'll once again have a strong presence at IDUG Europe and the North American IBM DB2 Data Management Technical Conference so if you're going to eith of these events please come say hi!

07/19/2005

Our podcast series continues on strongly, so grab a brew and check it out. We've made important updates to the listcat space parser and open dataset generator on the downloads page. Our fall event schedule is filling up, and we'll once again have a strong presence at IDUG Europe and the North American IBM DB2 Data Management Technical Conference.

06/07/2005

Another new podcast is available! This one's on dynamic SQL, as is available on the podcasts page. Get a drink, and have a listen! Compuware and YLA also have a new webinar on the proper use of stored procedures, UDFs, and triggers. Click here for the details.

05/04/2005

Our new podcast is available! This one's on sequential numbering, as is available on the podcasts page. Get a drink, and have a listen!

05/01/2005

We have a new useful tool on the downloads page. The DB2OPEN SQL statement generates REPAIR utility control cards for fast open of DB2 datasets. The events have been updated with our upcoming public appearences. Why not go to one of our pre-conference seminars at IDUG? The links page has been updated with a link to our latest article, and new DB2 links for Visual Explain and Estimator. The rugs page has been brought up to date with all of our latest presentations and seminars.

04/04/2005

The DB2EXPERT.COM website is now RSS enabled! We've got feeds for the news page, and the podcasts page. You can go to those pages to get the URLs, or get them here.

04/03/2005

Another new podcast! Check it out here! Also, the events have been updated, and there are new links, to Istek Consulting, and the DBAZine performance primer.

03/12/2005

New and exciting....PODCASTS. Check out how we implement this new technology with our first series of DB2 podcasts, "The DB2 Cocktail Hour, with Susan Lawson and Dan Luksetich"! We will be doing one of these a month, and they'll be an awesome way for you to hear the latest information about the hottest DB2 topics. Check it out here!

02/17/2005

Now available; A Russell Soundex function for DB2 for z/OS. An IBM enhancement? No, it's another YLA UDF. Check it out, along with a really useful index catalog query on the downloads page. As always we've got links to new articles on the links page, and lots of public speaking events on the events page. You can get great YLA education for less at IDUG North America. Be sure to take advantage of this opportunity. Check out the events page for the details.

10/27/2004

DB2 for z/OS Version 8 DBA Certification Guide (2nd Edition) is Now Available!. Go to the links page, and follow the link to order it from Amazon.com!

07/08/2004

Check the events page to see if our V8 preview, courtesy of Compuware, is coming to your town! Also, there are three new articles on the links page, and three upcoming public classes on the services page (Including the IBM Technical Conference). The rugs page has also been updated with a complete list of all of our available presentations and seminars!

03/01/2004

Another white paper about IFCIDs on the downloads page.

02/23/2004

New downloads include new UDFs TOTMON and JULIAN_DATE, and a new REXX program LCATSPCE. Updates to FAQs, and another white paper are in progress.

02/19/2004

The links page has received a serious update! New additions include links to YL&A books on sale at Amazon.com, along with many archived articles written by our consultants! BIG NEWS! YL&A is now offering a one to five day DB2 for z/OS version 8 transition class!

02/18/2004

Our Spring Speaking Schedule has been updated on the events page. Also, check out the latest offer from Compuware and YL&A here!

07/19/2003

Our fall speaking and teaching schedule is filling up! Check it out on the events page.

06/02/2003

Finally, more downloads! have been added, including some examples of simple REXX/DB2 programs, a REXX/DB2 stored procedure client program, Java stored procedure and UDF examples, and some plan table queries. More to come!

05/19/2003

Many more events have been added, including the new addition of our TechKnowledge course schedule! Look for YLA speakers at all of the major IDUG and IBM DB2 events! New downloads finally coming this week!

01/14/2003

The events page has been updated as our 2003 schedule is starting to come together. Coming soon, more additions to the FAQs, Links, and Downloads.

11/26/2002

The following has been added to the downloads page:

DB2 vs. Oracle TCO whitepaper
INSTJAR REXX routine to install a JAR file into the DB2 catalog
REPLJAR REXX routine to replace a JAR file in the DB2 catalog
YLAIDORD SQL/PSM procedure example

10/24/2002

Use the new email page to sign up for the email list, and keep up to date on all the new additions to this site.

10/23/2002

The events page has been updated with information about the Sprinfield Symposium, and the CA European Road Show! The downloads page has been updated with information about downloads that should be available within a few days.

09/25/2002

YLAPARSE is now available for download. This is a handy mainframe tool that eliminates white space from SQL statements, and can optionally remove SPUFI messages and add commits. Check it out on the downloads page.

We'd like to thank everyone who came out to our sessions at the DB2 Technical Conference, as well as all those who stopped by the booth! Look for more downloads and FAQs soon!

08/27/2002

The events page has been updated with our latest schedule, and new questions and answers have beened added to the FAQS page.

08/08/2002

The DB2 for OS/390 bufferpool effectiveness spreadsheet has been added to the download page! The events page has been updated with our latest schedule.

06/24/2002

A DB2LOOK command for DB2 for OS/390 has been added to the download page! The FAQS page has been updated with some utility questions. The events page has been updated with our latest schedule.

06/05/2002

All of Rich Fazio's REXX programs from his June 6th presentation are available for download on the download page!

05/21/2002

Check out the new queries on the download page! We're still working on more REXX downloads, and the YLAPARSE program. Check back for these tools, as we should have updates every week.

05/15/2002

Thanks to everyone who has stopped by the booth at IDUG, and spent some time to check out the web site, and some of the tools! For people who have asked, or are interested to know what we are without Richard, please take a look at the consultants page. We've dedicated ourselves to continuing his vision, and we have the talent, the relationship with IBM, and the will to do it!

05/11/2002

We're just getting the site up and going. We've got tons of downloads and FAQS to be uploaded to the site! Over the next several weeks you can expect this site to grow significantly. YL&A will have a strong presence at IDUG this year! Susan is doing an educational seminar on Sunday, and Susan, Dan, and Terry are all speaking. Please check the events page for details. Stop by our booth for free goodies, and a chance to talk with our consultants and developers! We'll have DB2 running on our PCs, and one of our mainframes, so we've got the opportunity to try out the things you're interested in!