Iqbal Goralwalla Wows the Audience with DB2 9.7 Fix Pack “Pearls” on DB2Night Show™

Were you unfortunate enough to miss IBM Champion Iqbal Goralwalla talk about DB2 LUW 9.7 Fix Pack “Pearls” on the latest DB2Night Show™? It was a great show. Luckily replays are still available, so why not take time out to hear Iqbal’s advice on the latest Fix Pack commands, as well as his top techie tips.

In addition to code fixes, a plethora of new features have been introduced in DB2 9.7 Fix Packs 1-5. In the DB2Night Show, Iqbal talks about some neat features that were introduced without much fanfare, but have enabled him to “shine” at various customer engagements.

Learn something and discover a pearl, 100% of the audience did!

Click here for the DB2Night Show replay.

Posted in DB2, DB2 9.7, DB2 LUW, DBI, IBM, Iqbal Goralwalla | Tagged , , , , | Leave a comment

GDPC – Expert Guidance From Triton Consulting

It’s well known that DB2 pureScale is an IT department’s ‘must-have’ product to cope with its customers’ growing workloads.  It provides outstanding database scalability which is unlimited, plus continuous availability and application transparency.  However, any single-site system, even a DB2 pureScale system, can be vulnerable to external events that could affect power or communications, or heaven forbid, cause physical damage to the system with loss in revenue and confidence.

Geographically Dispersed DB2 pureScale Cluster (GDPC) provides the scalability and application transparency of a regular single-site DB2 pureScale cluster, but in a cross-site configuration which enables ‘active/active’ system availability.  Should a power failure or fire disable a single business site, by utilising GDPC, separate IT functions on two sites allow business to continue as normal.    

James Gill, Principal Consultant at Triton Consulting explains that ‘The active/active element is really important because during normal operation, the DB2 pureScale members at both sites share the workload between them as usual.  So the second site is not a ‘standby’ site which is used only in the case of something going wrong, but instead pulls its weight.  In this way there’s value for investment even during day-to-day operation.’

There are of course system prerequisites for a geographically dispersed DB2 pureScale cluster, plus important steps to take in its implementation.  As DB2 experts and IBM Premier Business Partners, Triton Consulting can advise on all aspects of DB2 pureScale and GDPC. 

James elaborates: ‘by extending the range of the Infiniband interconnects, and utilising SAN-attached GPFS clustered storage, the solution is able to provide an active-active configuration spread over two data centres.  The range that the cluster can be extended to will depend on the workload being performed – the higher the volume of update work, the shorter the separation without adverse impact on application throughput.  Importantly, with DB2 pureScale there is no need to change your application code and it’s possible to grow your application to meet the most demanding of business requirements.’

Triton Consulting specialise in DB2 for mainframe and midrange customers, providing consultancy and support to customers throughout the UK, Ireland and Europe.  For more information click here.

Posted in DB2, DB2 10, DB2 Geek, DB2 LUW, GDPC, IBM, James Gill, pureScale | Tagged , , , , , , , , , , , | Leave a comment

IBM Comes Top Of The Tree in The Forrester Report

In a recent Forrester Report, ‘The Forrester Wave™: Enterprise Hadoop Solutions Q1 2012’, IBM has received praise for its Hadoop solutions within strong enterprise data warehousing portfolios.

Hadoop is the emerging open source, cloud-oriented approach which originated in the mid-2000s via technologies from Yahoo, Google and other Web 2.0 pioneers.  The cost, proprietary nature, inflexibility and scalability issues of some massively parallel processing (MPP) enterprise data warehouses (EDWs) has made the advent of Hadoop central to the big strategies of enterprises, service providers and other organisations.  Many EDW vendors including IBM are now evolving their services to support Hadoop.

As an established EDW vendor, IBM has its own Hadoop distribution network.  The Forrester Report found it has an extensive professional services force working on Hadoop projects; extensive R&D programs developing Hadoop technologies; a considerable number of Hadoop solutions and services customers, plus software, appliance and cloud offerings.  Within the Report, IBM was classed as ‘Strong’, the highest rating, in both the categories of ‘Strategy’ and ‘Market Presence’, scoring 5 out of 5.  IBM’s rating in ‘Current Offering’ also scored a high 4.62 out of 5.

Triton Consulting are IBM Premier Business Partners and provide comprehensive support on DB2 Data Management Products, being the leading provider of IBM Information Management Consultancy in the UK.  Click here for further information.

Posted in Big Data, DB2, Hadoop, IBM, Information Management, Uncategorized | Tagged , , , , , | Leave a comment

Triton’s Solution for Out of Support DB2 LUW Software

As IBM Premier Business Partners, Triton Consulting is in the process of making customers aware of the impending need to migrate their DB2 LUW software versions 9.1 and older.

We recognise that sometimes it’s necessary for organisations to remain on older, unsupported versions, but this can mean a considerable amount of risk should any problems arise.  To illustrate this, one of our partners, DBI Software, analysed which DB2 versions its viewers were using during a recent online DB2Night Show. What’s really worrying is that a startling 20% were on v8.2 or earlier.  Furthermore almost 20% of viewers were on version 9.1, which will also be out of support from 30th April 2012.

Migration is the ideal option but when this is impossible either due to budgetary, time or application constraints, we can provide you with an alternative.  ‘Consultancy on Demand’ is a great insurance policy for your DB2 database.  It’s available on all versions of DB2 including those which are officially out of support from IBM as per the dates above, meaning that you can still benefit from access to top DB2 skills should problems arise.

Available in packages of 20, 50 or 100 units (one unit equalling one hour of consultancy), you can call on support when you need it over the course of 12 months.  We recognise that users’ requirements are different and you may need help with carrying out a DB2 health check for example, or maybe you need a source of expertise for the tricky technical questions which often crop up with older versions.  Either way, the easy pre-purchasing of units means that help is both on tap and cost-effective.  Click here for more information. 

Triton’s industry leading Remote DBA service is also available for older DB2 versions, providing round the clock support for all components of your DB2 infrastructure. Triton’s Remote DBA service offers the reassurance of stable, secure management for all components of a client’s DB2 infrastructure, without the associated staffing and technical issues.

Clients can choose from Remote DBA Office which provides support Monday-Friday during usual working hours or Remote DBA 24/7 for round the clock support.  Each package has a fixed monthly cost with no hidden extras.

Click here for our full Remote DBA package details.

Posted in CoD, DB2, DB2 LUW, DB2 Support, DBI, Iqbal Goralwalla, Remote DBA | Tagged , , , , , , , | Leave a comment

Triton DB2 Experts Recognised as IBM Champions for a Successive Year

London UK – 14th March:  IBM this week announced Julian Stuhler, Solutions Delivery Director and Iqbal Goralwalla, Head of DB2 Midrange Services, Triton Consulting as two of their Information Champions for 2012.

IBM introduced the Information Champion Program in 2008 to recognise and honour individuals who have made exceptional contributions to the IBM Data Management Community over the previous 12- 18 months.   Exceptional community members were nominated by peers in their field.  A panel of IBM employees then reviewed the contributions of each nominee.

Iqbal comments “I am delighted to be chosen as a 2012 IBM Champion for Data Management for a successive year. Once again I would like to thank IBM for this recognition and have every intention to continue sharing my knowledge and experience with the DB2 community. “

Triton Consulting is thrilled to maintain two IBM Information Champions among their team for a second successive year. Julian Stuhler, Solutions Delivery Director at Triton, has been an Information Champion since the program was first introduced.

Posted in DB2, DB2 10, DB2 9, DB2 Administration, DB2 Geek, DB2 LUW, DB2 Monitoring, DB2 Support, DB2 Tools, IBM, Iqbal Goralwalla, Julian Stuhler, Remote DBA, db2 pureScale, pureScale | Tagged , , , , , , | Leave a comment

Gold Consultants go Behind the Scenes in Silicon Valley

By Julian Stuhler

Wow, what a week. A couple of months ago I was thrilled to receive an invite to IBM’s annual zIM Bootcamp at the Silicon Valley Labs in California, the home of DB2 (and many other IM products) . The bootcamp is the main source of information for IBM mainframe technical professionals around the world and usually open to IBM internal staff only, but this year a few Gold Consultants and Information Champions were also invited and I was fortunate enough to be among them.

Unfortunately most of what we learned during the week was under non-disclosure and will have to remain under wraps until it is formally announced over the coming months. However I can share a few of the general themes:

- DB2 10 for z/OS remains very popular, and the trend for customers migrating to the new release much more aggressively than usual continues. A good number of sites are already in full production and many others are planning to be there by the end of 2012. The imminent withdrawal from service of DB2 V8 this April is a big contributor to these timescales, but DB2 9 has now been available for nearly 5 years and the clock is definitely ticking for that release too – expect an announcement very soon that will set an end date on DB2 9 support and focus the minds of those V9 customers who have not yet made their DB2 10 migration plans.

- Meanwhile, work is well under way for the next major release of DB2 for z/OS, codenamed Sequoia. IBM will of course share more details of specific new functionality as the content of the release is finalised, but in the meantime you can expect a continuation of the excellent scalability and performance work delivered in DB2 10. One interesting tidbit – if you’re one of those sites suffering from “rebindaphobia” with plans or packages dating back several releases/decades, you need to finally mend your ways. From Sequoia onwards the only plans/packages supported will be from in-service DB2 releases (meaning DB2 9 and DB2 10). You have been warned.

- For many years, the DB2 performance monitors provided by the various vendors (including IBM) all did a pretty good, but pretty similar, job. One of the ongoing challenges is monitoring and problem diagnosis for distributed applications, where the DB2 monitor can only show part of the story – if the end user is experiencing a slowdown it could be down to the client, the app server, the network, DB2 or many other things (although in my experience it is usually the poor DB2 guy that gets the blame first!). During the bootcamp I had the opportunity to learn about and use the Extended Insight feature of IBM’s Omegamon Performance Expert tool, and I was very impressed with the ability to display information on the end-to-end response time for distributed applications. It’s not perfect, but it’s a huge leap forward from the traditional piecemeal approach and a real competitive differentiator for IBM’s toolset.

- An amazing amount of work has been done in enhancing the IBM DB2 Analytics Accelerator (IDAA, previously known as IBM Smart Analytics Opimizer, or ISAO). Less than 15 months after completing the acquisition of Netezza, IBM has V2 of the innovative DB2 for z/OS query offload system on the market and this removes many of the restrictions imposed by its predecessor (such as the need to use a star schema). Early customer results are very positive, with results of 2000x elapsed time improvements being quoted. This technology promises to deliver some unique business benefits for z/OS customers, but will undoubtedly pose additional DB2 technical challenges as well. I’ll be following its progress with great interest, and look forward to helping customers evaluate and maybe even implement it sometime soon.

I’ve been to the SVL labs quite a few times over the years but I never fail to be impressed by both the facilities and the beauty of the rolling countryside in which they reside. Couple that with an unseasonably warm week of Californian sunshine and I’m really not looking forward to facing the English winter when I fly back this afternoon. However the trip back also represents an opportunity to put all of my new experiences to good use and that is a much more tempting prospect.

Posted in DB2 10, Julian Stuhler | Tagged , , | Leave a comment

41-54% DB2 CPU Reduction Achieved using zIIP

In a current customer engagement we are enabling zIIP to reduce CPU consumption.  Our first overnight install has been a great success.  On the 1st mainframe LPAR (out of 4) we are seeing initial signs of 41-54% DB2 CPU reduction – this will equate to big CPU savings for the customer.

For some time now, DB2 for z/OS has been the major user and benefactor of the zIIP engine: one of a number of System z technologies collectively known as “speciality processors”.  The System z Integrated Information Processor (zIIP) is the most recent addition to the speciality engine family, and has been available since 2006. It is designed to offload specific types of data and transaction processing workloads for business intelligence, ERP and CRM, and network encryption. No changes are required to the application in order to make use of a zIIP – once it has been enabled, eligible workloads can take advantage of it immediately.

For more information in zIIP read our DB2 Geek article and watch this space for further updates on our progress!

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

What to do when you’re forced to stay on out of date software

In an ideal world all organisations would be running the latest software versions and upgrading when new versions came out, in order to benefit from the latest innovations and also to ensure that software was officially supported by the vendor.

Unfortunately, as we know, this is not an ideal world.  IT teams live in the real world and know that much as they would like to be constantly on the cutting edge, this just isn’t always an option.  There are a whole host of reasons as to why an organisation may need to stay on an unsupported database version:

Budgetary issues – perhaps the cost of an upgrade cannot be justified at the present time.  IT budgets have been slashed in recent years and this has put immense pressure on organisations in deciding where to best allocate precious funds.

Time constraints – the time (and therefore budget again) which is involved in an upgrade can vary greatly and is often a real issue for smaller teams meaning that they have to stay on old software, at least for an agreed period of time until sufficient resource can be allocated.

Application issues – perhaps the application which you’re running on your “out of support” database doesn’t work on the latest version, thus forcing you to stay where you are.

The consequences of this really depend on what software we’re talking about.  In database terms it could well mean that the skills to maintain that database version are no longer, or are dwindling, within the organisation.  It could also mean that your IT infrastructure is more susceptible to issues of reliability and availability.  There could even be regulatory implications.

Using a service such as Consultancy on Demand for out of support versions of DB2 is a great “insurance policy” for your DB2 database.  Available in packages of 20, 50 or 100 hours of consultancy which can be called off as and when needed it’s highly cost effective.

You can use Consultancy on Demand hours however you like over 12 months. Perhaps you need a DB2 health check or maybe you need a readily available source of expertise for those tricky technical questions which often come up on older versions.

Find out more here.

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

Customer says best feature in DB2 9.7 is Storage Optimization…

…it gave compression of up to 5 times resulting in more space savings and enhanced performance.

In 2011 we worked with one of our longest standing customers, Holiday Extras, on a migration project and helped them migrate from their DB2 9.5 environment to a virtualised environment running DB2 9.7. 

It wasn’t a case of a simple back-up and restore onto the new system because of differences in the engines of the different systems. It was necessary to recreate the entire database again for each database. This included all the tables and stored procedures and then exporting and reloading all of the data. This covered 600 tables and over 1000 stored procedures, all of which had to be moved and tested individually.

Triton provided the expertise and knowledge that Holiday Extras did not have in-house. Although they are very competent in DB2 they did not have the relevant practical experience of this type of migration. Triton also helped Holiday Extras to leverage all the available new features in DB2 9.7 to their best advantage to improve query times, scalability and reliability.

Posted in DB2, DB2 9.7, DB2 Administration, DB2 LUW, DB2 Support, Uncategorized | Tagged , , , , | Leave a comment

DB2 10 Security Enhancements

As part of the Migration Month focus on DB2 10 Migration we ran an additional webcast yesterday with Julian Stuhler of Triton Consulting and Mike Bracey of IBM.  This webcast focussed on the security enhancements introduced in DB2 10.  The presentation slides can be viewed below and you can view the replay here.  Visit Migration Month to view any of the previous DB2 10 migration webcasts.

Posted in DB2, DB2 10 | Leave a comment