DB2 10 Webcasts with DB2 Experts from Triton & IBM

With many organiations already in the planning stages of their next DB2 for z/OS version upgrade and V8 going out of support in just 4 months we decided that November really should be Migration Month!

With that in mind we have arranged 3 webcasts covering different DB2 10 topics:

DB2 Overview – Get Ready to Plan Your Migration – 3rd November – Register here
If you’re about to start planning or you’re already in the planning stage of your upgrade then this webcast is ideally timed for you!  Julian Stuhler, Triton Director, IBM Gold Consultant and IBM Data Champion will be leading this webcast.  He’ll take you through some of the key new technologies introduced in DB2 10 and then move on to give some practical advice on planning the migration process for V8 skip migrations and DB2 9-10 migrations.  Julian will also be joined by IBM Client Technical Specialist Tom Crocker, both of whom will be available for a live Q&A at the end of the webcast.

DB2 10 – Justifying the Upgrade – 10th November – Register here
Perhaps you’re not quite at the planning stage yet and are still trying to get budget agreed and having to make recommendations as to how an upgrade to DB2 10 will benefit your organisation.  If that’s your current position then this is the webcast for you.  Julian will bring to life the key concepts which make the business justification for migrating to DB2 10 so compelling and there will be a live Q&A session at the end.

DB2 10 – The Secrets of Scalability – 1st December – Register here
Once you’ve made the move to DB2 10, or at least made the decision to move it’s vital that you make the most of all the available benefits.  There has been a lot of information put out about the very significant potential of the CPU/cost savings DB2 10 can offer.  However, less has been said about the release’s scalability which could be equally valuable to many organisations struggling to cope with the demands of ever-increasing workloads.

In this webcast Julian will be joined by IBM Distinguished Engineer Jeff Josten.  Together they will  focus on DB2 10’s features for reducing virtual storage constraints, improving catalog concurrency and removing other scalability barriers.  The session will cover:

  • The need for scalability
  • Virtual storage constraint relief
  • Latch contention reduction
  • Catalogue concurrency enhancements
  • SMF compression
  • Other scalability enhancements

If all that wasn’t enough, Julian Stuhler & James Gill of Triton Consulting will also be speaking at the GSE UK Conference on 2nd November.  Their presentation “Time Travel with DB2 10″ will look at the new Temporal Data functions in DB2 10. For more info visit the event website.

DB2 10 Resources

Skip Migration from DB2 V8
Pre-requisites, process and services

Upgrading from DB2 V9

DB2 10 for z/OS
Training & Migration Planning Workshops

Posted in DB2, DB2 10, DB2 Support, z/OS | Tagged , , , | Leave a comment

DB2DART – Hints & Tips for the DBA

In his recent presentation on the DB2Night Show, Iqbal Goralwalla shared with attendees hints and tips on using DB2DART to achieve storage reclamation, address index corruption, extract data and remove backup pending status.  100% of attendees at the live show said they learned something!  Listen now or view the presentation below to find out why DB2DART should be your top tool!

For more top DBA tips visit http://www.triton.co.uk/confessions-of-a-db2-geek/

Posted in DB2, DB2 LUW, DB2 Monitoring, DB2 Support, DB2 Tools | Tagged , , , | Leave a comment

DB2 Support Video – Monitoring transaction times

In our latest video demo our Remote DBA team show how they use Brother-Thoroughbred® from DBI Software to measure customer’s transaction times, time distributions and service level attainments.
 

Posted in DB2, DB2 LUW, DB2 Monitoring, DB2 Support, DB2 Tools | Tagged , , , | Leave a comment

Triton Expert Headlining the DB2Night Show™ – All About DB2DART

We’re excited that one of our top DB2 Geeks, Iqbal Goralwalla will be presenting on next weeks’ DB2Night Show.  His specialist subject will be DB2DART.

There are several powerful and important commands in DB2 LUW and “db2dart” is among the most powerful yet least understood.  DB2DART stands for “Database Analysis and Reporting Tool Command”, but it can do much more than reporting!  It slices, it dices, it can repair your broken pages, and much more.

In his presentation Iqbal will help you to get a better understanding of how this powerful tool can be used. 

Register here – https://www2.gotomeeting.com/register/522919986 

Anyone attending IDUG next month will be able to meet Iqbal and put any technical questions to him in person.

Posted in DB2, DB2 Geek, DB2 LUW, DB2 Monitoring, DB2 Support, DB2 Tools, IDUG EMEA 2011, Iqbal Goralwalla | Tagged , , , | Leave a comment

Remote DBA In Action

 

Find out how Remote DBA works!  We have produced a series of videos to show exactly what DB2 support from Triton is all about.  The below video gives an outline of the service and an overview of the performance monitoring and reporting tools we use.  You can see further videos on our youtube channel www.youtube.com/tritonconsulting

Posted in DB2, DB2 Monitoring, DB2 Support | Tagged , , | Leave a comment

DB2 Performance Tuning in Action

Triton have released a series of product demos showing the industry leading database performance monitoring and tuning software from DBI Software.

Our Remote DBA team use these tools to proactively monitor customer databases.  Triton Consulting are partners with Texas based DBI Software. This partnership combines DBI’s revolutionary database monitoring tools with Triton’s Remote DBA service to bring a truly powerful DB2 database support solution to the market.

Visit www.youtube.com/tritonconsulting for more DBI demos.

Posted in DB2, DB2 LUW, DB2 Monitoring, DB2 Support | Tagged , , , , , , , | Leave a comment

Bringing Business Analytics to Big Iron

Traditionally DB2 for z/OS was considered to be primarily an OLTP data server, with the DB2 for Linux, Unix and Windows variant being a more common choice for analytics and data warehousing duties. This approach is often dictated by cost concerns or historical inertia, but the superior resilience and scalability of the System z platform, combined with the increasing popularity of real-time warehousing, is leading many customers to re-examine this decision.

DB2 9 delivered some significant new functionality to support business analytics workloads, including improvements to indexing, query optimisation and SQL extensions.  This emphasis continues within DB2 10, with a large number of new and enhanced features.

IBM Smart Analytics Optimizer

As DB2 for z/OS becomes more attractive as a host for large-scale analytics and analytics workloads, the requirement to deliver high performance with minimal administration and tuning overheads increases accordingly. 

In recognition of this trend, IBM has developed an innovative solution that combines DB2 for z/OS and a dedicated blade server capable of executing the complex queries typically found in analytics with fast and predictable response times.  Known as the IBM Smart Analytics Optimiser, this solution is deeply integrated with DB2 10 and allows DB2 to offload eligible query components to the locally attached blade. 

This architecture is able to deliver up to 10x performance gains for qualifying queries when compared to traditional DB2 processing.  As the DB2 optimiser decides what work to offload to the appliance, no application changes are required in order to take advantage of the Smart Analytics Optimizer once it is made available. 

To find out more about migrating to DB2 10 visit http://www.triton.co.uk/migration/

Posted in DB2, DB2 10, System Z | Tagged , , , , | Leave a comment

DB2Night Show – DB2 z/OS & Java – What’s New?

This week Julian Stuhler appeared on the ever popular DB2Night Show and presented on DB2 z/OS and Java – What’s New?

If you missed this episode you catch download it from the DB2Night Show website and below is a copy of the presentation.  98% of attendees said they learnt something new!

Posted in DB2, System Z, Uncategorized | Tagged , , | Leave a comment

Early results from the IDUG DB2 z/OS Version Migration Survey

IDUG (International DB2 User Group) have been running a worldwide survey to measure DB2 10 upgrade intentions across the IDUG community.  Julian Stuhler of Triton Consulting and former IDUG President, has been managing the survey and has posted the early results in the IDUG Community Form – http://www.idug.org/p/fo/si/topic=169

Some top stats include:

  • 25% of DB2 z/OS users describe resource constraints as the biggest single barrier to upgrading the DB2 version – is resource an issue in your organisation?  Let us help.
  • Half of all respondents planning an upgrade to DB2 10 were at v8 and considering a skip migration.
  • We’re now in the busiest period for DB2 version migrations with 30% of respondents stating that they would begin their migration between July –December 2011.  The first half of next year looks to be a busy time for version migrations as well with 25% stating that they would begin their migrations between January-June 2012.
  • By far the most important benefit organisations are hoping to gain from an upgrade to DB2 10 is CPU/Cost Savings.  70% of respondents cited this as their most important.  25% see new functions such as Temporal Data as their top benefit.

Any IDUG members who haven’t already completed the survey can do so here:

http://www.esurveyspro.com/Survey.aspx?id=9526985a-d3c5-427a-9075-ad7c64101b17

Posted in DB2, DB2 10, IDUG | Tagged , , , | Leave a comment

IDUG EMEA Highlights – DB2 pureScale

We’ve been huge fans of DB2 pureScale ever since it was first announced back in October 2009 and we’ve done a lot of reasearch and work on our own DB2 pureScale installation.  So, we’re delighted to see that there are some interesting sessions on DB2 pureScale coming up at IDUG EMEA in November:

  • DB2 pureScale : Internals and Best Practices for DBAs
  • DB2 pureScale on Linux – Anixter Case Study
  • DB2 pureScale Performance – the Significant Bits About Configuration, Monitoring and Tuning
  • For more information take a look at the full IDUG EMEA agenda.

    If you’re not able to attend IDUG but would like to hear about DB2 pureScale from IBM and Triton experts we have several webcasts available to view on demand:

    DB2 pureScale Overview – view now

    DB2 pureScale – Installation, Instance Management & Monitoring – view now

    DB2 pureScale – Availability & Data Recovery – view now

    DB2 pureScale – Performance & Tuning – view now

    DB2 pureScale Vs Oracle RAC – view now

    Or visit our youtube channel to view our DB2 pureScale live demo videos.

    Posted in DB2, DB2 LUW, Oracle Vs DB2, db2 pureScale | Tagged , | Leave a comment