An industry first!

A special edition episode on October 1, 2010, at 11am Eastern.

During this special edition, DBI will be interviewing our top candidates for our open Software Consultant Engineer position (see http://www.dbisoftware.com/careers.php for details). Each candidate will be given 8 minutes to describe a DB2 LUW challenge they faced and how they conquered it, 1 minute to offer a quick DB2 tip, and 1 minute to "make their case" for why they are our best candidate.

Studio Audience members will get to vote on the candidates. Your votes will influence DBIs selection committee (but the final decision rests with DBI), determine the prize that each of our candidates will win, and everyone in the studio audience that participates in candidate voting will earn a $5 Amazon.com gift certificate (limited to the first 100 attendees that arrive).

Free Webinar on Optim portfolio expansion in 2009 and looking ahead
to 2010 THIS WEDNESDAY NOVEMBER 4.

Since IBM acquired Princeton Softech in 2007, IBM has
invested heavily in the portfolio. In 2009, IBM has delivered several new
products to the Optim family. The Optim portfolio is designed to offer
integrated capabilities to manage enterprise application data from requirements
to retirement. With Optim, teams can share data artifacts (like models, policies
and metadata) to align data management with business goals and improve
collaboration.

Learn More: Join an overview discussion of this portfolio and gain
insight into future trends and directions. The Optim portfolio will be reviewed, portfolio integration will be explained and you'll learn how to leverage the
expanded Optim portfolio.

And it looks like I missed another DB2Night Show episode! This one was for the z/OS side and featured Julian Stuhler. If you missed it as well, get the replay.

Details about the episode:

In episode #Z08, special guest Julian Stuhler (IBM Gold Consultant, IBM Champion and former IDUG president) gave an excellent overview of the many ways you can exploit DB2 using the Java programming language; varying from simple JDBC to PureQuery. But he also discussed the impedance mismatch between Java and Relational Databases and the new features in DB2 9 and DB2 10 which Java can benefit from. If you are into Java then this DB2Night Show episode is a must!

The DB2Night Show is back for it’s 4th season and what a great start to the
season! Join hosts Scott Hayes and Martin Hubel along with their
special guests. Scott and Martin are both IBM Champions (aka IBM’s Best
Friends).

First off is two shows featuring Steve Rees who will share the ANSWERS
to many Frequently Asked DB2 LUW Performance Questions. Steve is a Performance
Specialist and is often a speaker at IDUG.

Next Thursday (November 10th, 12:30 PM - 2:00 PM Eastern), you can attend a free webinar that will teach you about the performance management and optimization solutions that are available from IBM. You’ll learn about:

Don’t miss these experts as they discuss how the performance management solutions delivered by IBM helps you implement a best-practice methodology to identify, diagnose, solve and prevent performance related bottlenecks before they affect your production environment.

Register Now for this webinar on November 10th, 12:30 PM - 2:00 PM Eastern to take charge and manage performance of your data environment before it impacts your business.

Berni
Schiefer is the guest on this week’s DB2Night Show. Berni is a DB2
performance legend and you’ll greatly benefit from hearing his talk.
Berni will share the latest news, tips and advice about DB2 LUW 10.Thanks to IBM Champions and hosts of this fabulous show: Scott Hayes and Martin Hubel

This webcast is perfect for anyone who wants to jumpstart their career in software! Individuals are all too easily confined by the scope of their current position. Gain insight into how to create your own path toward greater success through inspiring advice and real-life stories from author Sam Lightstone. Discover how to:

Accelerate your career, and promotions, with integrity

Master the nontechnical skills crucial to your success

"Work the org" to move up rapidly

Successfully manage your time, projects and life

Move up to "medium-shot," " big-shot" and finally "visionary"

The software business is constantly changing, to make it big you need a finger on the pulse of today's realities.

Sam Lightstone is the creator of MakingItBigCareers.com as well as Program Director and Senior Technical Staff Member with IBM’s Software Group, where he works on product strategy and R&D for one of the world’s largest software engineering teams. Sam is a sought-after public speaker, author, and prolific inventor who still spends a good part of his professional time recruiting and mentoring software engineers.

If you’re a regular reader of my blog, you’ll remember a few other entries I’ve posted in relation to Sam’s book.

Yes, I have heard Sam speak about his book several times, but can tell you that he changes the topic for each talk. His book is so rich with advice that he could do quite a few more sessions before he runs out of topics.

In this timely Webinar, my good friend Rebecca Bond, independent security consultant and author of Understanding DB2 9 Security, will share important DB2 Security Tips and Best Practices with participants. People who know Rebecca personally also know that she is a part-time comic and capable of turning the dullest, most boring topics, into something truly entertaining, informative, and memorable.

Here is a sampling of topics Rebecca might cover if she doesn't have a headache:

Security features in V9.1 & V9.5

Cost, Risk, Mitigation, People

Disaster Recovery & Trust

Don't do these STUPID things

Touching DB2's Best Known Tickle Points

Authorizations, Privileges, Roles, LBAC, Trusted Contexts

HOT Data & Encryption

Auditing

Thinking like a Hacker, but avoiding Jail

Performance versus Security Smackdown

Other cool things too numerous to list

SPEAKER BIOGRAPHY:"Rebecca Bond is an independent DB2 LUW Security Consultant. With a background in government, healthcare and financial DB2 consulting, she is adept at designing efficient, secure database architectures that balance the twin needs of performance and protection. Rebecca is the author of Understanding DB2 9 Security, published by IBM Press, and has written articles on security topics for the IDUG Solutions Journal. She holds numerous DB2 certifications and has been designated by IBM as a Subject Matter Expert."

One lucky Webinar Attendee will be randomly selected to win a $50 Amazon.com gift certificate - enough cash to buy the security book plus other fun things!

US and European Phone numbers will be provided, as well as VoIP.

We look forward to seeing you online! Title:Musings on DB2 Security for the DB2 LUW DBADate:Thursday, May 7, 2009Time:9:30 AM - 10:30 AM CDT After registering you will receive a confirmation email containing information about joining the Webinar.

Join DB2 expert Kelly Schlamb and panelists Ben Ream and Debbie Hauss as they discuss The New Rules Of Always-On Retailing in a free webinar.Date: Tuesday, December 18th, 2012Time: 1:00 pm ETRetailers
have specific database needs, especially this time of year. Any outages
to a retailer's computer systems, quickly means loss of revenue. To
help retailers ensure that their systems can handle unexpected
transaction spikes and to adjust to new demands quickly, retailers must
deploy and manage a continuously available environment. A continuously
available environment means transactional data can be accessed in real
time.The
best data management systems evaluate the performance of each specific
task, offering new levels of availability and scalability on distributed
platforms and enabling extreme workload capacity while cutting costs
across the enterprise. Learn how DB2 pureScale can minimize outages and
keep systems up and running.Register for this webinar
to hear how retailers can leverage advanced data management in order to
maximize their capacity to fill orders and process transactions.
Attendees also will learn how to respond to demand spikes easily, meet
SLA demands with proper workload management, and address performance
concerns in order to ‘keep the lights on’ at all times.Panelists• Kelly Schlamb, WW IM Technical Sales Acceleration, IBM• Ben Ream, Principal Retail Analyst, Ream Consulting Services• Debbie Hauss, Editor-in-Chief, Retail TouchPoints

Related content:Ember Crooks writes a blog called DB2 Commerce and she focuses on issues related to the retail industry.Two recent articles in the IBM Data Management Magazine were about retailing and were written by IBM Champion Scott Hayes:

Maria Schwenger is a member of the Competitive Software &
Power Systems team at IBM, North America, where she works in a “high
touch” model with early release participants to promote the newest IBM
and DB2 Technologies, their early adoption, feedback and references on
pre-released products, and enablement of applications written for competitive
databases on to DB2.

In the last 3 years, Maria specialized in architecture and implementation of
active-active high availability database solutions utilizing DB2 pureScale
feature. Currently, Maria works with customers on adoption of PureApplication
System as part of the newest IBM offering of Expert Integrated Systems. Maria
has over 15 years experience in performance engineering, database architecture,
administration and development on DB2, Oracle and MS SQL server as well as
extensive experience in migration from legacy systems to relational databases.
She is an author of articles, presentations, tutorials, and IBM Redbook about
DB2 9.7 SQL Compatibility feature and DB2 pureScale.

Sheryl Larson top #DB2 SQL Expert, IBM GOLD Consultant, is our special guest on The DB2Night Show 8 October 2010 at 10am Central. Learn SQL tips from the master.

This week, the DB2Night Show is going "Cross Platform DB2" presented by Sheryl M. Larsen, IBM DB2 GOLD Consultant and President of SMLSQL (www.SMLSQL.com).

The Lessons Learned from SQL Performance Review presentation divulges discoveries and recommendations from various SQL performance review assignments across platforms. Come see if you have similar SQL performance issues and get the instructions on how to fix them. Issues discussed include non-optimal index design, access paths gone wild, residual predicates, misuse of SQL, excessive sorting, delayed filtering, lack of implementation of powerful new SQL features.

The DB2Night Show on Twitter: twitter.com/db2nightshow for the latest news about new episodes and interactive discussion. Use the hash tag #DB2Night in your Tweets.

The DB2Night Show on LinkedIn Group - join us to stay up to date on our show and discuss show episodes! The group registration link can be found on www.DB2NightShow.com.

If you’ve missed a show, remember that you can always get the recorded replay.

As
usual, host & IBM Champion Scott Hayes has some interesting shows
lined up on his award winning webinar series: The DB2Night Show.October 5, 2012; 11:00 AM – 12:00 PM"You CAN Teach an Old Programmer New Tricks” with Bonnie Baker, IBM DB2 Gold ConsultantOctober 12, 2012; 11:00 AM – 12:00 PMBREAKING NEWS from IBM!
Special guest, Les King, Director, Information Management Solutions
& Warehouse Development at IBM, tells us he'll have some exciting
"breaking" news to share!October 19, 2012; 11:00 AM – 12:00 PM“The Joys of Big Data” with Dave Beulke If
you’ve missed any of the shows in the past, remember that they have
been recorded and are available for you to watch anytime you like. Here
are a few that I’ve blogged about in the past:

There are only a few shows remaining in the rest of this season’s collection of DB2Night Show episodes. Mark your calendar for these up coming events and take a look at previous shows that you may have missed. The education opportunity to you is huge.

Did you know you can "force" the DB2 LUW optimizer to choose a specific access strategy of your choosing? The secret is out... Special guest John Hornibrook from the IBM Toronto Lab presented in Episode #52 where he talked about best practices for query tuning. In this show he’ll teach you how to exploit DB2 LUW Optimizer "hints", or, maybe more properly, how to tell the DB2 optimizer how to execute your queries.

Note that this show is scheduled for 90 minutes so that John can share all of his incredible presentation with you and have time for questions.

#z04 - What's new from the optimizer in DB2 10 for z/OS?

DB2 10 for z/OS is no exception to the goal of delivering incremental query optimization enhancements to the world’s most respected cost based optimizer. With skip-release migration supported, it is expected that many more customers may adopt DB2 10 in the coming year - so understanding the performance enhancements can be critical for those customers. Terry Purcell will share the insight uncovered from beta customer and early adopters, and provide the motivation for each enhancement including:

Special guest Burt Vialpando from IBM presented in Episode #22 which was the 15th most downloaded show in 2010. He talked about Comparing DB2 LUW and Oracle, Architectures and Administration. In this episode, Burt will give you an overview of each of the DB2 core engine data movement utilities: Load, Import, Export (with db2look), db2move, ADMIN_COPY_SCHEMA, ADMIN_MOVE_TABLE, db2relocatedb, restore from backup and split mirror. These will be compared to each other so that you can get a good idea of when to use and not to use each of these. To help round out the discussion, a comparison to the Oracle database core engine data movement utilities will be made to these DB2 utilities.

#z05 - B2 V10 Migration Planning and Early User Experiences

In this episode, host Klaas Brant and guest John Campbell will introduce and discuss early experiences and lessons to be learned with DB2 10 for z/OS. It will provide quick hints on preparing for and executing the migration, performance expectations and opportunities, virtual storage constraint relief, some instrumentation changes, use of 1MB real storage frame size, use of hash access, value of rebind, etc. Key topics covered will include:

Lessons learned

Surprises and pitfalls

Provide hints and tips

Address some myths

Provide additional planning information

Provide usage guidelines

Provide positioning on new enhancements

#55 - DB2 LUW Multi-Temperature Data Management

Did you know that data has temperatures? Can data run a fever? What happens if your data catches a cold? Or rather, turns cold from hot? What can and should you do? What techniques are available for optimizing performance in databases where some data is more popular (hot) than other data? In this episode of The DB2Night Show, various IBM experts will help us answer these challenging questions! Kate Kurtz along with team members from the IBM Smart Analytics Systems Best Practices team will share with us their expertise!

#56 Season #2 Finale! - Data Warehouse Performance Tuning!

Kate Kurtz and her IBM Smart Analytics Systems Best Practices team return again to share with us IBM recommendations and suggested best practices for optimizing performance of Data Warehouse Databases. If you're trying to make DPF or multi-partition databases run queries as fast as possible, then you should sign up for this show!

Hard to believe another season is over already! Thanks Scott Hayes and Klaas Brant for Entertaining, Informing, and best of all, EDUCATING us! We look forward to see what amazing ideas you come up with next season.