Blogs

Be the first person to recommend this.
A very Happy New Year to all of you. I hope everyone had a good break and managed to spend some quality time with family and friends. We started 2021 with high expectations of a relatively better year in terms of Covid-19 restrictions. And it was, as vaccinations ramped up, albeit in the second half of the year. However, not enough to bring life back to complete normality. Like everyone else, IDUG had to make the difficult decision to convert the planned face-to-face IDUG EMEA conference in Edinburgh to a virtual one. The risks for an onsite conference were just too high. And once again, our volunteers adapted and stepped up, and together with the support ...
0 comments
Be the first person to recommend this.
This is not a pipe, it’s a pipeline: becoming a DevOps DBA – part 2 Written by: Marcus Davage CEng CITP MBCS Lead Product Developer Intelligent Z Optimization and Transformation BMC Software Last time, I quoted Belgian surrealist artist René Magritte, his ‘This is not a pipe’ painting and his comment that ‘Perception always intercedes between reality and ourselves.’ To bring yourself up to speed, you can read part 1 here The point I was making was that, when it comes to DevOps and databases, DBAs need to be involved from the outset of project design. Developers (including development DBAs) and operations ...
0 comments
Be the first person to recommend this.
This is not a pipe, it’s a pipeline: becoming a DevOps DBA – part 1 Written by: Marcus Davage CEng CITP MBCS Lead Product Developer Intelligent Z Optimization and Transformation BMC Software In 1929, Belgian surrealist artist René Magritte painted ‘The Treachery of Images’ aka ‘This is not a pipe’. He said, ‘Perception always intercedes between reality and ourselves.’ Pipes were ubiquitous then, as smartphones are today. Let’s consider a smartphone. It is far, far more than a phone. It is an all-in-one communications, entertainment and retail centre; this is not a phone. It satisfies modern demands ...
0 comments
Be the first person to recommend this.
With an uptake of more and more people being vaccinated against Covid-19, countries have opened their borders for travel over the past few months. This has opened the doors for IDUG committees to conduct their meetings face to face after almost two years. Face to face interaction is important for all of us at our workplace and more so for IDUG volunteers who give up some of their out of work time to help IDUG conduct it’s many activities. It helps rejuvenate what we believe in and keeps us motivated. A big thank you to all our volunteers for adapting to an online world over the past couple of years and continuing to help and support IDUG. This month, the first ...
1 comment
1 person recommends this.
Javier Estrada Benavides javier.strad@gmail.com Setting your Db2 zParms to the right values can be a never ending task, but luckily the previous article from Emil Kotrc ( found in here ), gave a structure on what you’ll find, and several pointers so you can study some recommendations from other Db2 users and see how that fits to your site. The other side of the picture, as it is also mentioned there, is that we live in a big world of “it depends” situations. zParms will take an effect over the entire Db2 subsystem and its applications, therefore it means that in most cases you’ll need to take the following steps: Study your environment over time. ...
0 comments

About zParms

1 person recommends this.
About zParms Emil.Kotrc@broadcom.com zParms, also known as DSNZPARMs, SYSPARMS, or just subsystem parameters, are crucial configuration parameters for a Db2 for z/OS subsystem that define the operating characteristics. There are more (used to be) than 300 zParms and they've come a long history of additions, removals, and default changes. Do you ever have a chance to review them since they were initially implemented in your shop? Do you have a chance to monitor what is new in this space? Changes in zParms may have significant impact on the entire subsystem and because of that proper planning and testing is always important, and unfortunately not always simple. ...
0 comments
1 person recommends this.
Gartner has kicked off Magic Quadrant research for the Cloud Database Management Systems. We are seeking delighted IBM Data and AI users who will participate in the Gartner Magic Quadrant research. Participation will only take about 15-20 minutes of your time , and your answers will be aggregated anonymously: Gartner will not publish your name, nor your organization's name. Why participate? This is an excellent way for you to: 1) help shape market opinion about IBM products, 2) help your industry peers learn from your experience, and 3) help our product teams learn from your product experience from the published Magic Quadrant. To ...
0 comments
Be the first person to recommend this.
September is usually a "back to" month. Back from holiday, back to work, back to school, and more. The "back from holiday" was missing for most of us last year as we adapted to living under COVID-19 restrictions and I hope everyone had a chance to take a much-needed break with their families and loved ones this summer. As we closed in on summer, ripples of sadness were felt throughout the Db2 community as we grappled with the unexpected loss of a dear, long standing Db2 member from COVID-19 on August 18. Scott Hayes was a Db2 community leader, technical expert, mentor, speaker, and Gold consultant. He was indeed a Db2 legend (and so much more ). His sudden ...
0 comments
Be the first person to recommend this.
It is with great sadness that IDUG shares with our members that Scott Hayes passed away on August 18, 2021, at the age of 59. Scott served on the IDUG Board of Directors and was a constant presence at our events (he was quite proud to have attended all on-site North American conferences). He was always a top speaker and sponsor and was the founder and host of the Db2Night Show. He always challenged the status quo, and was a key voice in IDUG management strategy. Scott is being remembered as a generous mentor, a great friend and a lover of life. We encourage you to share your thoughts and your remembrances here: https://www.dignitymemorial.com/obituaries/lakeway-tx/scott-hayes-10313704 ...
0 comments
1 person recommends this.
Time series analysis for people in a rush, survival analysis We’ve seen it in many situations and not just as DBAs. For many cases where we control and constantly watch metrics, whether it’s Db2 monitoring, application tuning, or even non-technical everyday events, there’s a “magic metric” that, if it reaches a certain number, it’s an indicator or a trigger for undesired events. When the number of GETPAGE requests of a Buffer Pool is greater than X, you need to take an action. When the total number of connections in DDF approaches 90% of the CONDBAT ZPARM, you need to be alerted. We also have several indicators in our RTS tables to tell us when to ...
0 comments
Be the first person to recommend this.
The road to become a new “Mainframer” Manik Kainth Mainframe, a word that is still unknown for many university students pursuing computer science, software engineering or even unknown for the recent graduates too. Most of the people who are working on Mainframes or those who are retired never thought of being a “Mainframer” when they were in their universities or started to work in the IT. Taking the decision Generally, the recent graduates get to know the word “Mainframe” when they start looking for a job in the IT market. Slowly out of curiosity when they actually start to look about the Mainframe then there is a lot of information on web that ...
0 comments
1 person recommends this.
Gosh, “time flies” resonates more so now than ever. I clearly remember the day in 2012 at the IDUG EMEA Conference in Berlin when I was drafted in to join the IDUG EMEA Conference Planning Committee (CPC), and there has been no looking back. I took on various roles on the CPC, becoming Chair in 2016 for the IDUG EMEA Conference in Brussels, before moving on to serve on the IDUG Board of Directors in 2017. And lo and behold, in the recent change of guards, Bob passed over the President's position to me. It’s an honor to be leading this great organization which I so strongly believe in. I would like to thank Bob for leading us through an unprecedented ...
1 comment
Be the first person to recommend this.
Businesses and their customers rely on applications being consistently available along with the databases that store their information. Database outages can cause enormous business problems. If there is a failure that requires us to recover a very large database, we are looking at a near disaster for the business. Db2 and z/OS work together with hardware features to minimize the need to recover our data while keeping our applications available. It may sounds silly, but the key to high availability is to avoid outages. Avoiding those outages requires a certain amount of redundancy. Each hardware component that may fail (and that's all of them) needs to have at ...
0 comments
1 person recommends this.
Today’s world, or better said, today’s Db2, is not the same as any other previous generation. If I were to say it with my (personal) opinion, there’s an information overload for pretty much everything, and Db2, regardless of the platform, is no exception: Where we get information. Tools at our disposal. New techniques. Anything else that is being pushed by new trends, people, brands, etc. What happens out of all this? Officially (by behavioral psychology), the name is “choice overload bias”, which can be better stated as “choice paralysis”. It is the effect when we feel overwhelmed when we are presented with a large number of options to choose ...
0 comments
Be the first person to recommend this.
Recap on NUMLKUS and NUMLKTS To enforce good application standards and avoid bad designed applications taking too much space in the lock structure, Db2 provides two system level parameters to control the locking limits. NUMLKUS - The NUMLKUS subsystem parameter specifies the maximum number of page, row, or LOB locks that a single application can hold concurrently for all table spaces. A value of 0 indicates that there is no limit to the number of data and row locks that a program can acquire. These values are constraints for a single application. Each concurrent application can hold the maximum number of locks specified here. To avoid exhausting ...
0 comments
1 person recommends this.
The principle of security in IBM Db2 Data Management Console (DMC) is to integrate with the existing security architecture in the company. First, let’s take a look at how to set up a repository connection using Kerberos Ticket-Granting Ticket to connect to the repository. Step 1 : Config Kerberos realm in the /etc/krb5.conf on the DMC installed server, user can just change the lines that need user input. Basically, the user needs to configure the default-realm, the realm mapping to which domains, and the realm point to which target Kerberos key distribution center server. # To opt out of the system crypto-policies configuration of krb5, remove the # ...
0 comments
Be the first person to recommend this.
HURRY SIGN UP TIME IS HURRYING OUT John John Campbell IBM Distinguished Engineer and Db2 12 clients on this first of a kind live panel https://ibm.biz/Db212ClientPanel Sign up for this virtual Db2 12 client panel today Summary Db2 for z/OS is the strategic enterprise database that has evolved and adapted to meet client needs for over 35 years. John Campbell IBM Distinguished Engineer has been one of key developers from IBM Silicon Valley Lab that has been extremely influential in driving some of the innovation around the core strengths and business value of Db2 for z/OS. ...
0 comments
Be the first person to recommend this.
IDUG 2021 North America included many exceptional women technologists in the speaker lineup. With so many sessions to choose from, you may have missed some so be sure to check out the replays of their sessions. Maryela Weihrauch, IBM Optimizing Data Transformation with Db2 for z/OS and Db2 Analytics Accelerator Watch Session Recording Akiko Hoshikawa, IBM Db2 for z/OS Performance Improvement Opportunities Watch Session Recording Lethika Panicker, Worldpay Db2 12 for z/OS User Experience at Worldpay from FIS Watch Session Recording Ember Crooks ...
0 comments

Looking Back and Then Forward

Be the first person to recommend this.
My family and I recently attended a wedding that had been delayed for over a year. The reception was a maskless affair with over 150 guests. It felt great to be back out with so many friends, most of whom we have not seen for over a year. Many parts of the world are opening, but others are still dealing with many restrictions. My IDUG presidency began during our first all-virtual event and, hopefully, my term will end during what will end up being our organization’s last all-virtual event. We expect to hold onsite and/or hybrid events in the foreseeable future. Despite all the challenges we faced during the past year, we have continued to support IDUG’s mission. ...
1 comment

SQl XML Basics

1 person recommends this.
SQL XML BASICS: Ever get confused on XML terminology? This article lays out the basics of processing and querying of XML stored documents in Db2 and helps to better understand the differences in terms. Db2 pureXML : pureXML is the native XML storage feature in IBM Db2. It not only stores and manages your XML database in its native hierarchical format, but provide querying capabilities, storage, and indexing technologies. Db2 stores traditional Db2 data types (CHAR, SMALLINT, DATE, ETC.) and has a datatype specific for assigning to XML documents (XML is the datatype). By assigning this datatype to a column name, Db2 stores the contents of a document ...
0 comments