Team with the best
Db2® LUW Performance Tools
company in the World

The DB2Night Show #138: Upgrading to DB2 V10.5 Best Practices!

September 5, 2014, 2:58 pm
Posted by scott in DB2 LUW
Melanie Stopfer on LinkedIn
@mstopfer1

Special Guest: Melanie Stopfer, DB2 Brain Surgeon, IBM Software Group

Upgrading to IBM DB2 LUW V10.5 Best Practices and tips!

100% of our audience learned something! Our studio audience was filled with inspiration and gratitude for Melanie's presentation! Watch our replay and you will see a complete cookbook for how to upgrade, what to watch out for, undocumented tricks that will speed up your upgrade, and even a recipe for falling back to your original release if your upgrade has a hiccup! With 34% of our DB2 community currently running V10.5, the timing for this presentation is "just right" and it will undoubtedly be in our top Replays for 2014! Enjoy...


Show Host Scott Hayes Commentary

Everyone in the DB2 for LUW community knows, or should know, Melanie Stopfer. I took DB2 Common Server classes from her back in 1992, then DB2 UDB (V5) upgrade classes, then DB2 LUW classes at every IBM and IDUG conference. Melanie has a warm, wonderful, and impactful way of teaching, and I think it'd be fair to say that SHE is one of the top three IBM people in the world that have most impacted DB2 LUW's success. She loves chocolate chip cookies too!

Here's just a few things you are going to learn about: Upgrade Roadmap, SC27-5513-00, upgrade database, db2iupdt, db2cfexp, db2cfimp, upgrade servers before clients, db2licm, HADR, many deprecated and discontinued commands - mostly in the realm of monitoring, db2batch, db2exfmt, db2iupgrade, how to upgrade your Explain tables (db2exmig), db2prereqcheck command, db2setup is now the preferred installation command, db2ckupgrade, db2val, db2pd - new options, db2swtch, db2ls, db2fs, disk space requirements for SYSCATSPACE and TEMPSPACE1, -REBINDALL, bind files, runstats changes, reorg changes, upgrading event monitor tables, db2convert, page_age_trgt_mcr and page_age_trgt_gcr, BUFFPAGE and SOFTMAX deprecated, db2cat, db2support, installFixPack, changes to LOAD and statistics collection, my favorite "db2 REORG TABLE T1 INPLACE CLEANUP OVERFLOWS", my other favorite feature - indexes on expressions, such as "CREATE INDEX EMP_UPPERNAME ON EMPLOYEE (UPPER(NAME), ID)", AND MUCH MORE!

Did you attend IDUG in Phoenix?

Check out the 100's of uploaded pictures HERE and see if you can find your picture! If you took pictures, upload them!


A message from our sponsor:
DBI Software

Don't fast forward through today's educational commercial from DBI! Melanie was talking about the importance of comparing performance before and after your upgrade to DB2 V10.5. Please watch our short commercial and discover how DBI makes comprehensive comparisons very easy!

Magic Hat Money Working with DBI is like making money magically appear!

Typical customers enjoy 30-60% CPU utilization reductions in the first week, plus measurably faster transaction and query response times. More importantly, your time savings will be substantial! Read our newest SUCCESS STORY with HealthPlan Services, do your due diligence, and speak with as many references as you have time to call.

We saved a health care company $250,000 in one afternoon, solved a performance problem in two hours that two senior DBAs were unable to solve in six months, and we have helped top brand name retailers achieve top ranked e-Commerce performance on Black Friday multiple years in a row. 7 of the Top 25 Retailers, plus others, plus top Banks, State Governments, Manufacturers, Insurers, and more rely on DBI. How can we help you? Contact DBI


Join The DB2Night Show™ LinkedIn Group

The DB2Night Show™ has a LinkedIn Group. The "closed" group is open to any LinkedIn member. Join to receive LinkedIn group updates including future shows and replay information, and, if you like, start some discussions about the show! Join The DB2Night Show LinkedIn Group!

Get the Download Replays

WMV Format - approximately 105MB

To download a recorded replay of Episode #138 in WMV format, right click on the link below and choose "Save As..."
Episode #138, 5 September 2014, Upgrading to DB2 V10.5 Best Practices with guest Melanie Stopfer!

MP4 Format - standard resolution - 132MB

Have an iLife, iDevice, iPod, iPad, or iPhone? Right click and download the MP4 ( M4V ) format!

BONUS!! PDF Handout!

We can't do this with all of our guests, but Melanie has given permission for us to make a PDF handout of her presentation available. Don't skip the replays! GET THE PDF!

Did you learn something from this show?

See that "Mail this" link below? Click it and do a friend a favor - share this blog post and show with one of your friends or peers. THANKS! icon_biggrin

Share a great show with your friends and followers! Let's get this tweeted and retweeted like crazy to celebrate Paul's contributions to the DB2 LUW community!

Printer friendly