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 on Tuesday 4th June at IBM South Bank in London. It promises to be a cracker of a meeting with presentations by DB2 Architect and Distinguished Engineer Jeff Josten, and Gold Consultants Cristian Molaro and Julian Stuhler. As 2013 is the 30th anniversary of DB2 this year, IBM will be giving away a few items on the day. And if we manage to get 70 or more attendees IBM will treat one lucky person to complimentary attendance at IDUG EMEA this November in Barcelona!
Please see the Meetings page for details on how to register.
The last meeting was part of the GSE conference on 13-14 November 2012 at Whittlebury Hall near Towcester. 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: May 13th, 2013