Surekha Parekh's Posts (122)

Sort by


DB2 for Linux, Windows & UNIX


Olivier Bernin - DB2 Development Manager Dublin

DB2 BLU Acceleration: A primer for sysadmin and DBAs Olivier Bernin - DB2 Development Manager Dublin


Cris Molaro   DB2 Gold Consultant

DB2 LUW HADR and pureScale demystified Cris Molaro DB2 Gold Consultant


Roy Cecil - Performance Engineer DB2 Software Development
Time Breakdowns : A novel way to analyse Performance problems Roy Cecil - Performance Engineer DB2 Software Development Dublin


Dualta Ó Briain   DB2 Software Development

A description of how to enable and use JSON in DB2 as part of the BIG Data Dualta Ó Briain DB2 Software Development


Roy Cecil - Performance Engineer DB2 Software Development

Extend your DB2 pureScale® cluster to another city- Geographically Dispersed pureScale® Cluster


Read more…

Did you attend IDUG London DB2 for z/OS Track yesterday? 

If you missed the event don't worry we will be planning more events like this,  here are the

presentations,  subscribe to "World of DB2" to ensure you receive notifications of our events.

The LUW slides Click Here

Key Note    Julian Stuhler

A Time Traveller’s Guide to DB2: Technology Themes for 2014 and Beyond

John Campbell - IBM Distinguish Engineer. DB2 Development

DB2 11 for z/OS Technical Overview (part 1 & 2 )

Namik Hrle -IBM Distinguished Engineer

IBM DB2 Analytics Accelerator : TRENDS & DIRECTIONS

Namik Hrle -IBM Distinguished Engineer

 Efficient Monitoring & Tuning of Dynamic SQL in DB2 for z/OS


Ian Cook - IBM DB2 11 Beta Program Manager

 Planning and executing a DB22 11 for z/OS Migration by Ian Cook




Read more…

PDUG Poland DB2 Users Group - Kicks off another successful event - Read More

On March 6 to 7, 2014 in Piaseczno, Poland, the 3rd Poland DB2 Users Group (PDUG) conference was held. For those who are still not familiar with the initiative, PDUG is a non-profit association (NGO) that was formed in 2013 by DB2 users from the largest data processing centres in Poland. The association aims at educating and promoting the exchange and sharing of professional experiences in the field of IBM DB2 technology between its users (

Until recently, PDUG members recruited mostly from DB2 mainframe (z /OS) users. However, bearing in mind the fact that DB2 is also a technology dedicated to other platforms, such as Linux, Unix and Windows (LUW), the educational offer of Poland DB2 Users Group’s March conference for the first time was also addressed to LUW users.


As a result, the association managed to organize the conference where presentations were grouped into two separate thematic blocks: track DB2 z /OS and track DB2 LUW. DB2 users, as well as DB2 database software vendors, welcomed it with great interest. The conference brought together nearly one hundred professionals who in their everyday work deal with maintenance and development of database environments in the largest companies in Poland.

Among the invited speakers were the leading DB2 experts - Steven Thomas and Zeljen Stanic from CA Technologies, John Campbell from IBM Silicon Valley Lab, Marcin Marczewski and Jan Nelken from IBM Poland Software Lab, Piotr  Zawadzki from IBM BTO, Cristian Molaro, an independent consultant from Belgium, as well as DB2 users - Jakub Karasiński, Jacek Rafalak and Adam Pesta from Asseco Poland S.A. who shared their knowledge by presenting their experiences concerning the implementation of large and complex projects.

Among the invited attendees Poland DB2 Users Group hosted also Czech Republic and Slovakia DB2 Users Group (csDUG) representatives, Mariusz Koczar (Tieto) and Philippe Dubost (CA liaison) who were interested not only in the content of the agenda of the conference, but also in observing the practices of the Polish Group concerning educational activities and Group’s development. In these two fields PDUG can pride in getting very positive feedback.


It is worth noting that in October 2013, only after a few months of its operation, as the association was officially registered in March 2013, Poland DB2 Users Group was awarded “The Best New Users Group” by IBM in appreciation of its dynamic growth, its initiatives undertaken in terms of DB2 z/OS technology and its innovative approach in building the local DB2 community and its resources.


‘We strongly believe that in the upcoming months and years Poland DB2 Users Group will maintain the achieved high standard of the educational offer and its well-deserved image, now stronger with DB2 LUW users’-says Jacek Rafalak, the president of Poland DB2 Users Group-‘I’d like to invite all the DB2 administrators and developers to the next conference that is planned in autumn 2014’-he adds.

Together with the expansion concerning LUW users, Poland DB2 Users Group also celebrated the release of the first issue of PDUG’s magazine that accompanied the conference. What is worth underlying is that the association members themselves came up with an idea to extend the means of realising PDUG’s mission by publishing technical texts addressed to other group members and not only limit themselves to preparing seminars and presentations. Thus, all the articles of the “On DB2 Paths” magazine were written by the association members. The editorial team also recruited from them and both, the editorial works and graphics were done by PDUG members. This amateur initiative was warmly welcomed and highly evaluated in the feedback forms.


The organisation of the 3rd Poland DB2 Users Group Tech Conference wouldn’t have been such a success without the support provided to the association by companies: CA Technologies, IBM and Arrow ECS.


Read more…

DB2 11 for z/OS An IDUG User Technical Perspective - Download your  complimentary copy today!

In March 2013 the IDUG DB2 11 Editorial Committee was formed, comprised of volunteers from IDUG’s worldwide community of DB2 users and consultants. Working alongside IBM's formal Early Support Program (ESP), the Editorial Committee gained valuable insight into exactly what makes the new release tick. This White Paper contains their findings, including practical experiences and independent evaluations of the new features.
#IDUG : DB2 11 for z/OS An IDUG User Technical Perspective complimentary whitepaper

Read more…

Announcing three new best practice videos on the DB2 for zOS Best Practices developerWorks website ...  

Steps to investigate CPU performance on release migration presented by John Campbell
located here...

This best practice discusses methodologies and techniques to investigate a CPU performance regression across a release migration. When a regression occurs you need to be able to quantify it as well as try to determine the cause. You need to normalize results in a real world environment to compare results between DB2 releases. This web lecture shows you what to look for and how to go about the comparison. Specifics are given on how to use statistics and accounting trace workload indicators.

DB2 for zOS Data Sharing Tuning Group Buffer Pools presented by John Campbell
located here...

In a data sharing environment, tuning Group Buffer Pools is an important activity for keeping your system running smoothly. First, this web lecture goes through the functions and features of Group Buffer Pools to explain the processes involved in tuning. Then, it will show you a series of reports and explain how to interpret key metrics for Group Buffer Pool tuning. Recommended thresholds are described.

Best Practices for Optimal Access Path Selection During Migration presented by Tom Beavin
located here...

Access path regressions can be puzzling and can take much effort to diagnose. This best practice will help you understand how to prevent them when migrating to a new release of DB2. It explains what you need to capture on your current DB2 system prior to migration. Tips on what information you need and how to model your production environment are discussed. What role RUNSTATS and EXPLAIN play in this process is also discussed. Following this best practice will improve your migration process.

Check out these new titles and many more at the DB2 for z/OS Best Practice community --

Each title includes a video (either download or stream from YouTube), transcript, and slides.  If you stream from YouTube, you can view in HD with Closed Captions either on or off.

On each best practice page there is also a link to a survey to give us your feedback on the video.

Read more…



Reduces the risk of revenue loss and reputational damage
• Protects mission-critical operations with continuous business data protection
• Takes non-disruptive system-level DB2 backups of huge SAP databases in seconds
• Recovers SAP databases at system or table level to any prior point in time
• Enables consistent federated recoveries of independent DB2 systems used by multiple SAP systems
  that span business processes
• Creates online clone of SAP and DB2 systems based on existing backup
• Helps companies meet legal and regulatory requirements around data security
• Integrates seamlessly with disaster recovery solution for IBM System z hardware, providing ultimate  security


Read more…

Getting Excited about DB2 11? Get a Sneak Preview from

Jeff Josten - IBM DB2 for z/OS Chief Architect


Highlights On Demand Webcast  - Register NOW  


Speaker: Jeff Josten, Chief Architect, DB2 for z/OS, and IBM Distinguished Engineer, IBM Software Group
Replay: Available for your convenience, register now.
Developed for: IT and enterprise architects; IT managers; data analysts; database administrators and managers
Technical Level: Intermediate


Many of you will remember the first release of IBM® DB2®, launched in 1983, which marked the birth of the relational database. In 1983, there were many skeptics about the relational database. Thirty years later, it is still growing stronger and more valuable to businesses, and DB2 is still the market leader.

DB2 on z/OS®, or System z®, continues to deliver and meet the expectations of Fortune 100 CIOs and CxOs by improving operational efficiencies, reducing costs, and enabling businesses to adapt quickly to support business growth — all without sacrificing the resiliency required for today’s demanding business requirements.

Join us for this complimentary webcast and hear from Jeff Josten, IBM DB2 Chief Architect, as he shares the latest DB2 10 customer experiences with its new features and functions, including the IBM DB2 Analytics Accelerator and updates on DB2 synergy with zEnterprise® EC12. You’ll also get a glimpse into the future and IBM plans for the next release, DB2 11. It continues the DB2 history of addressing current challenges that organizations are facing, such as keeping pace with higher user expectations and, at the same time, adjusting to budget cuts. Jeff will also review the demand for more business analytics, and why it is now more important than ever to leverage existing investments for that competitive edge.

If your data resides on DB2 for z/OS — it’s a great time to exploit and maximize your investment.

Join us after the webcast for a live question-and-answer session. The webcast will also be available for replay after the event.

Read more…

We would love you to present and share your stories !  Call for Speakers is open for IBM Information On Demand 2013 until April 30 at 11:59 P.M. Eastern time !

We are looking for Customers, Business Partners and IBMers to share their real world experiences, lessons learned and case studies etc

We would like you to submit  sessions/topics around  DB2 Performance/Cost Savings, Application Development, Migration, Security,  Analytics ,  Data Warehousing , Tools, Utilities and
Big Data stories and experiences !

IBM Information On Demand is an experience that you will never forget . Submit your abstract now!

Read more…

IBM DB2 for z/OS Celebrates 30 years of Superior Innovation

Read more…

Did you know that TAW (Transaction Analysis Workbench) supports DB2 10?  Initially TAW 1.1 did not support DB2 10 but was corrected very quickly in APAR PM34534.  Additional improvements have been added via APARs PM39503, PM50250 and PM54715.  For best results with DB2 10, it is recommended that your version of Transaction Analysis Workbench be at PTF level UK91447

Read more…

15 new members joined  "The World of DB2 for z/OS in the last few hours we have over 2100 members, this is the only

virtual DB2 for z/OS community which is so active and dynamic.  Our mission is to support the DB2 for z/OS

community together in the virtual world so that you have access to DB2 professionals,  IBM developers, the latest news

on events, conferences, webcasts and new collateral such as whitepapers, books and demos .

We look forward to your feedback on how we can improve this virtual  community - so please do not hesitate to send us any feedback.


Read more…

This is just a quick "blog" to let you all know that we now have enabled the "On line Chat" in the World of DB2 for z/OS

This is a great feature and now that we have also enabled "The World of DB2 for z/OS" community for mobile devices so you can chat "anytime" "any place" with your fellow DB2 members

I was logged in to the community and I saw Bart Steegmans  who was surprised when I started chatting with him- see the conversation below of our live chat below . 


Read more…

Thinking of attending IBM Information On Demand 2012 Global Conference in Las Vegas ?  There are many reasons why you can't afford to miss this Global Conference if you are in the Information Management business.  Here are some of the reasons you may attend:-

Read more…

I know many of you have been waiting for DB2 10 Customer Case Studies - today we have an customer case study that we can share externally,  this will help other customers planning the upgrade to DB2 10 and also see the business benefits customers are reaping  . Primercia's overall impression is that they have already seen a roughly 6 percent performance increase by taking advantage of support for large [1 MB] pages in DB2 and project CPU savings of as much as 10 percent for some applications..

Read Full Case study today  Learn how Primerica upgraded to DB2 10 and improves efficiency,  gains more flexibility and reduced costs Click Here 

“DB2 provides us with a foundation such that two and three years down the road, we know we won’t be impeded in developing new applications with our partners or in rolling out new smartphone apps to our agents.”—Bill Raser, senior vice president of data administration and mainframe systems support, Primerica

Read more…

9524593694?profile=originalThis is the 16th year of SQLAdria’s existence. It was founded in 1994 as a local DB2 User Group and it has become the regional user group of IDUG the same year. The number of attendees at the conferences has been growing every year. SQLAdria Conference in Dubrovnik has already become the real international event.

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group of IDUG. The members of SQL Adria are companies, e.g. users of relational databases (mainly DB2) on the one hand, and vendors on the other. The members of SQL Adria are well known and distinctive companies from Croatia and Slovenia (banks, health and pension insurance institutes, finance agency, IS and IT support agency, company for electricity distribution,…).

As vendor members, CA, IBM, BMC, Compuware,… have been supporting our activities throughout past years. The main body of SQL Adria is the presidency, elected on annually basis. The presidency proposes and delivers the plan and the programme for every year, trying to address today’s challenges and interest of the members. It also confirms the terms of realization, and it manages incomes and expenses.

SQL Adria were awarded the "Best Managed DB2 for z/OS User Group " for 2011 - if you missed the conference this year check out here are some of the photos from the conference

DB2 for z/OS Facebook Fan page



Read more…
Read more…