Blogs

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
Be the first person to recommend 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
Be the first person to recommend 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
1 person recommends this.
by Philip Nelson In 2017, Philip Nelson posted the following article as part of our content. We've recently learned that the article was truncated and I am reposting the content here. It is pretty obvious to even the most casual observers of the IT landscape that there is a big focus on “cloud computing”, which is defined on the IBM website as “the delivery of on-demand computing resources—everything from applications to data centers—over the Internet on a pay-for-use basis”. DB2 for LUW has undergone a lot of changes to become more “cloud friendly”. There has been a focus on ease of use and autonomics, which make running DB2 in a cloud environment ...
0 comments
Be the first person to recommend this.
We’re in the final countdown to the kickoff of the IDUG NA Virtual Db2 Tech Conference , and this year is shaping up to be an incredible experience for all attendees. In 2020, the shift to virtual happened so swiftly, we were forced to scale back some of our vision. But this year, we’re poised to deliver double the content compared to 2020, including a whole slate of hands-on sessions, educational seminars, and workshops to allow you to get real-world experience with new solutions. Throughout the years, IDUG has become well-known in the data community for delivering rich technical content. This year is no exception; we have over 100 dynamic sessions that ...
1 comment
1 person recommends this.
We’re in the final countdown to the kickoff of the IDUG NA Virtual Db2 Tech Conference , and this year is shaping up to be an incredible experience for all attendees. In 2020, the shift to virtual happened so swiftly, we were forced to scale back some of our vision. But this year, we’re poised to deliver double the content compared to 2020, including a whole slate of hands-on sessions, educational seminars, and workshops to allow you to get real-world experience with new solutions. Throughout the years, IDUG has become well-known in the data community for delivering rich technical content. This year is no exception; we have over 100 dynamic sessions that will ...
0 comments
Be the first person to recommend this.
Sign Up Now Not seeing the email properly? View as Webpage Pre-Register for Our Workshops and Hands-On Labs Week two of the IDUG NA Virtual Conference features workshops and hands-on labs to give you real-world experience at no additional cost. Some of these sessions do require pre-registration so that we can give attendees access to session materials. To add these ...
0 comments
Be the first person to recommend this.
0 comments
Be the first person to recommend this.
It is a now common requirement for Db2 Z to provide secure and encrypted network communication to all clients. This includes end-user workstations which may run distributed tools like Data Studio or IBM Data Server client. And of course, this includes application servers who get application data from Db2 Z. Encrypted network communication provides security against nefarious individuals who may have access to the internal company network but do not have access to Db2! After all, the mainframe is almost never directly visible outside the company network. Network encryption is protecting us from people inside the network already! I suppose ...
0 comments