The UK DB2 User Group is a Working Group of the UK GSE organisation and covers all aspects of DB2 on both the Mainframe (z/OS) and Distributed (LUW) platforms. We welcome anyone interested in DB2, whether Novice or Expert to join us. If you'd like to be added to our mailing list please contact our Membership Secretary, Russell Gee.
The next meeting will be part of the GSE conference on 5-6 November 2013 at Whittlebury Hall near Towcester.
The draft agenda for the DB2 on zSeries stream is as follows:
|Tuesday 5th November|
|10:45||DB2 10 Whats new since GA||Phil Grainger, BMC||DB2 10 GAd in October 2010. Since then, it has been evolving via PTFs. This presentation will cover what function has changed or been introduced to DB2 10 via the PTF stream since GA.|
|12:00||A Review of BIND and REBIND parameters in DB2 for z/OS||Steve Thomas, CA||Over the past few releases many new features have been added to DB2 which can be used to enhance the Performance and Availability of your Applications. Many of these are controlled by new keywords and parameters that have been added to the BIND and REBIND commands. This presentation will provide a useful summary and review of the most important newer capabilities, as well as taking another look at some of the more critical older options where the recommended settings may have changed since you started using DB2. Topics to be covered will include setting appropriate Isolation Levels and when to acquire and release resources, High Performance DBATs, controlling when Optimization occurs, providing hints to the Optimizer and managing access path degradation using Plan Stability and/or the new APREUSE and APCOMPARE functionality.|
|14:00||Using Real-Time Statistics with DB2 V10 to automatically help control your Utilities||Clive Harriss, IBM||What are Real-Time Statistics (RTS), how they have changed since DB2 V7, how they are populated and used, recent developments and use of IBM provided stored procedures (DSNACCOX) to help you manage and monitor DB2.|
|15:15||DB2 11 New SQL and Analytic features||Paul Read, IBM||This is a technical overview of the new SQL and Analytic features in DB2 11. There have been significant increases to DB2s ability to perform the analytics on the transactional data in place, instead of moving the data off to another platform for the analytics phase. As well as additional new features to handle Oracle SQL PL.|
|Wednesday 6th November|
|9:15||DB2 11 Expanded RBA/LRSN - Does this bit make my tail look big?||Phil Grainger, BMC||DB2 has had a 6 byte RBA since the beginning and a 6 byte LRSN since DB2 Version 4. IBM is introducing the ability to optionally expand the RBA and LRSN to 10 bytes in DB2 11.|
|10:30||DB2 11 - Application Compatibility||Julian Stuhler, Triton Consulting||Despite compelling business benefits to upgrade to new versions of DB2 for z/OS, many customers are unable to schedule migration projects in a timely manner. Two of the major issues responsible for these delays are scheduling the necessary remedial work to address any application incompatibilities introduced in the new release, and obtaining suitable change slots to allow the upgrade itself to proceed. This presentation provides an overview of the new features introduced in DB2 11 for z/OS that are intended to address these issues, and allow customers to upgrade their DB2 systems more quickly and with less disruption than before. Introduction Review of DB2 upgrade process and associated issues DB2 11 SQL compatibility feature DB2 11 online upgrade enhancements Summary and conclusions|
|12:00||What's Big About Big Data? The Volume? The Size? The Value?||Andy Ward, CA||Big Data is an oft used term. What does it really mean? This presentation will outline what Big Data is and why it is likely to significantly change what information we process and how we process it. It will also investigate how DB2 is getting in on the Big Data act and how it is making use of relatively new hardware to help deliver the information business is crying out for.|
|14:00||DB2 11 Migration Experiences (with/without OQCR)||Mike Skidmore, IBM||TBA|
|15:15||SAS Analytics on YOUR DB2 Data?||Andrew Gadsby, SAS||Your business decision makers want your data and they want it now - this session will show you why they want it and how you can deliver it! Somewhere in your organisation there is probably a group of SAS analytic users already making use of your DB2 data. However, the version of the data thaye are using is out of date and the process by which it was passed to them was extremely convoluted. As mainframe professionals you know that the best source of data is the transactional data and information held on your mainframe but the perceived wisdom has been that the data can only be used by decision makers after it has been loaded into an EDW. Come along to this session to see a new "art of the possible" as we explain how the IBM DB2 Analytics Accelerator and SAS components fit together.|
|16:00||Wrap-up & Feedback session|
There is no DB2 LUW stream this year.
The last meeting was on Tuesday 4th June at IBM South Bank in London. You can find the Presentation Materials arranged in Agenda order by clicking here, or on the Meetings Page. The material is also available organized by topic (along with all previous materials from our meetings over the past 10 years) on the Tech Info Page.
We're very pleased to be able to host a website for the SDUG Group based in Edinburgh. Notices of future meetings and all presentation materials from previous events can be found on the SDUG Page or by following the link at the top of any page. Presentations from past SDUG meetings can also be found sorted by topic on the Tech Info Page, along with our own materials.
Darwin is a very useful and popular utility that has been available from this website for some time. It provides an alternative to using DSNTEP2 for customers who don't use PL/I. It is provided in COBOL source form, with sample JCL and usage notes. Thanks to the generosity of Gary Joehlin and Sallie Mae Inc. in the USA we are now able to provide an improved version of DARWIN. This new version corrects truncation of DSNTIAR messages, increases the maximum size of SQL statements from 32Kb to 2Gb, and supports the DECIMAL(31) data type. To download a copy of this new improved version please go to the Shareware Page.
We have created a Group within the LinkedIn Networking site for those in the UK DB2 Community. This provides an easy method for members of the UK and Scottish User Groups and others associated with DB2 in the UK to contact each other, pass on useful information and ask questions. Please feel free to join at LinkedIn UK User Community. Other useful networking groups which you might be interested in joining include The World of DB2 for z/OS and DB2 z/OS What's On!
The IBM Betaworks team have prepared a Technical Education Series on topics related to DB2 9 for z/OS which are available to downloaded from the Web at no charge. Each session contains a Windows Media File containing a recording of the presentation and an Acrobat pdf file of the materials. To find the sessions, start at www.ibm.com/db2 and click on the DB2 for z/OS link in the body of the page. Next, click on the 'Support' link from the box on the left. Finally type "db2 betaworks" in the Search box and click Search. As at the time this page was updated there were 12 sessions available. Many thanks to Paul Fletcher of IBM for providing this information.
The following site contains a number of IBM webcasts, Teleconferences, Demos, Events and White Papers for both DB2 and IMS. The url is rather complex, so it's best to find it by following this link. You need to register to gain access to the content but doing so is free.
We regularly receive notices about Conferences and Web-based presentations which may be interesting to our members and which we publish in the table below. If you're interested in having your own event published here, please feel free email our webmaster, Raymond Bell. Please note that we will not advertise Tools and Utilities sessions here - the content must relate to core DB2 activities.
|Date and Time||Details and Link|
|Available On Demand||Replays of IBM Teleconferences and Webcasts can be found by following this link. The most recent of these sessions were:|
DB2 for z/OS Optimizing INSERT Performance presented by John Campbell
DB2 X for z/OS Technical Preview presented by Jeff Josten
Hints and tips to get the most out of IBM DB2 9 for z/OS presented by Namik Hrle
Looking to Upgrade to DB2 9 for z/OS and improve productivity & reduce costs? presented by Maria McCoy
DB2 10 for z/OS: Helping you improve operational efficiencies and gain competitive advantage by Roger Miller and David Beulke
|October 24th - 28th 2010||IBM InformationOnDemand conference was held at the Mandalay Bay Resort and Convention Centre in Las Vegas, Nevada in October 2010. See the IOD website for more details.|
|November 8th - 12th 2010||IDUG EMEA was held at the Hilton Vienna Hotel in Vienna, Austria in November 2010. See the IDUG EMEA website for more details.|
|Jan 25th 2011||Why is DB2 for z/OS better than Oracle RAC? was an IBM webcast highlighting the advantages DB2 for z/OS has over Oracle RAC. Click here for more details and to view the recorded session.|
|Feb 22nd 2011||Upgrading to DB2 9 or DB2 10 for z/OS How? When? What is the cost versus benefit? was a webcast by IBM's Roger Miller providing reasons why you should consider migrating to DB2 9 or DB2 10 for z/OS. Click here for more details and to view the recorded session.|
|May 2nd - 6th 2011||IDUG NA was held in Anaheim, California in May 2011. See the IDUG NA conference procedings website for more details.|
|November 14th - 18th 2011||IDUG EMEA was held in Prague, Czech Republic in November 2011. See the IDUG EMEA Conference procedings website for more details.|
|May 14th - 18th 2012||IDUG NA was held in Denver, Colorado in May 2012. See the IDUG NA website for more details.|
|November 4th - 9th 2012||IDUG EMEA was held in Berlin, Germany in November 2012. See the IDUG EMEA website for more details.|
The group would like to hear from you if you have had any interesting experiences with DB2, whether with new or little used functions, or perhaps using well known functions in a novel way. Remember you don't have to prepare a full length session - contributions of any length are always welcome and if you're a User you may qualify for one of our new Presentation Awards of up to £200. The audience is guaranteed to be a friendly one, and there's no better way of raising your profile in the industry and showing off your achievements.
If you have any experience that you feel could be of interest please contact Phil Nelson. Phil would also like to hear from you if you have any suggestions on future presentation topics which might be of interest, and we'll do our best to find a suitable speaker.
Suppliers of DB2 related products and services should be aware that we offer up to two optional 15 minute slots during the lunch break of our own meetings (but not during the UK GSE Conference) where companies can explain new offerings which might be of interest. Please follow this link for more details if you're interested in taking up one of these slots.
If you would you like to assist with the organisation and running of our group, and have the commitment, enthusiasm and time to participate, we'd love to hear from you. Details of the current committee can be found here - please feel free to contact any of us if you would like to volunteer or if you have any questions or issues.
Please email our webmaster, Raymond Bell with questions or comments about this web site.
Copyright © 2010 UK DB2 User Group
Last modified: October 18th, 2013