Triton Consulting Header
November 2009
Good Afternoon      
Welcome to your new newsletter.  It is important to us that we bring you news and information which is really relevant.  With this in mind we have split our newsletter in two!  You are now receiving our DB2 z/OS newsletter.
If you would prefer to receive the DB2 for LUW newsletter or you would like to receive both then please click here to amend your subscriptions. 
As ever, we love to hear from you so please
email us with any comments or suggestions. 
If you wish to unsubscribe from this communication please follow the link at the bottom.
Position Power - V9 Spatial Features
Most businesses today already store extensive location data, for customers, suppliers, competitors, branches and many other items. For many large corporations, that data is stored in DB2 for z/OS. The availability of spatial features within DB2 for z/OS will allow those organisations to derive valuable new information and deliver new capabilities to their customers. 
So, what exactly is spatial data? Here's a simple definition:
Spatial data represents real-world features and their relationship to one another. This includes geographic features (rivers, cities, mountains, forests, seas, lakes, etc), areas (flood zones, military exclusion zones, sales territories, etc and even events that occur at a specific location (a car accident, a crime, etc).

In its most basic form, spatial data is made up of one or more sets of co-ordinates that specify a location (usually but not always on planet Earth!).

When combined with conventional data (customer information, sales data, etc) it can be surprisingly useful in a whole variety of different applications, across virtually any industry. 
Click here for the full article.
DB2 x Preview
IBM recently ran a DB2 x preview teleconference.  If you missed it you can download the replay - click here
Major enhancements for discussion include: 
  • Ease of porting across multiple platforms with improved SQL and data definition compatability with other DB2 platforms.
  • Improvements in large object performance and flexibility
  • Near-linea scalability for mission critical SAP, ERP and CRM requirements
  • New XML helps minimize the time and effort it takes to persist and use XML data
 Click here to download the presentation.
IOD Update
By Julian Stuhler 
Aspart of the IBM Gold Consultant Program I spent 4 days in Las Vegas at the "Gold Briefing" session prior to IBM's Information on Demand event.
There was an amazing array of information and new announcements at this years event. 
Below is my blog from day 3 which included an update on all things mainframe:
"More and more details are being made available regarding the next release of DB2 for z/OS (cunningly codenamed "DB2 X" as a way of concealing the real version number from those that don't understand Roman numerals!). I'll cover the contents of this release in more depth in future blog entries and will also produce a new version of the "Business Value" white paper series to assist with upgrade justification and planning. In the meantime, the headline features that most people seem to be most excited about here at IOD are the anticipated CPU savings (potentially helping to claw back some or all of the performance regression that may have been experienced in the move to 64-bit at Version and the new temporal data support (which allows DB2 to store historical versions of a row and enables the developer to select data as of a given timestamp and see what the row looked like at that time).  

There's a major push on Analytics here, as part of the Information-Led Transformation strategy I talked about a couple of days ago. The mainframe is not immune to this, and in addition to some nice extensions to the core database engine in DB2 X to support warehousing queries, IBM has also begun to talk of a much more fundamental and exciting development in the shape of its "Smart Analytics Optimizer".  This is essentially a BI/analytics appliance aimed at boosting the database query performance of the servers that it's attached to. The big news is that this will be available to connect to System z servers very soon, allowing DB2 for z/OS to offload suitable workload to the SAO for processing (with all of the attendant performance and cost advantages). I hope to be in a position to talk more about this exciting new development as more details are announced!

Visit our IOD blog to read the other entries.
Managing Growing Data Volumes 
With budgets under ever more scrutiny it is essential for companies to strip out unnecessary expenditure. Proactively managing the size of production databases by archiving non-current data on a daily basis delivers significant and ongoing cost savings.
Take a look at our on demand webinar on Managing the Data Explosion.
In our Data Growth Management resource centre you'll find a range of articles and white papers - click here to view.
In This Issue
Technical Overview - V9 Spatial Features
DB2 x Preview
IOD Update - Mainframe news
FEATURE - Managing Growing Data Volumes
If you missed the recent DB2 x for z/OS Technical Preview call then you can view the replay by registering here - REPLAY 

If you have a bespoke training requirement contact us today
Triton Consulting Header