decor
 

planetDB2 logo

Planet DB2 is an aggregator of blogs about the IBM DB2 database server. We combine and republish posts by bloggers around the world. Email us to have your blog included.

 

August 18, 2017


Robert Catterall

Db2 12 for z/OS SQL Enhancements: a Better MERGE

Greetings, and welcome to the third in a series of entries covering my favorite Db2 12 for z/OS SQL enhancements. The first two posts in the series described piece-wise DELETE and result set pagination. This entry focuses on the new and very much improved MERGE functionality delivered via Db2 12 (usable at function level V12R1M500 and above). The MERGE statement, introduced with Db2 9 for z/OS, is sometimes referred to as the "upsert" statement, because it enabled, via a combination of...

(Read more)
 

August 16, 2017


Kim May

QMF Analytics for Multiplatforms – September Baltimore/Washington DB2 Users Group

Frank Fillmore just finished delivering a webcast with IBM’s Steve Mink and Doug Anderson, hosted by Blanca Borden, on the just-released QMF Analytics for Multiplatforms solution.  For the many...

(Read more)

Henrik Loeser

Combining Db2 and Cloud Object Storage

Db2 and Cloud Storage happily combined Since a while, Db2 has built-in support to directly access Cloud Object Storage (COS) like Amazon S3 and IBM COS (Softlayer / IBM Bluemix IaaS). It allows to...

(Read more)
 

August 15, 2017


DB2utor

System z Apprentice Program

Long-time readers of this blog know I've often discussed the mainframe skills shortage and cited various initiatives that aim to attract the next generation of talent. I came across new organization while attending last month's SHARE conference: LEAD-IT (Leadership, Empowerment, Apprenticeship and Diversity in Information Technology).

Henrik Loeser

Secure Your Db2 Data Base - Using Trusted Contexts

Db2 Security - Trusted Context You have that new app, maybe even in the cloud, with that user needing read and write access to the database? Don't want to open the floodgates for that favorite...

(Read more)
 

August 09, 2017


Data and Technology

Have You Thought About the Impact of eDiscovery on Your Data Management Strategy?

When thinking about data management it is unlikely that your first thought is about legal requirements. Nevertheless, the legal side of data management must be considered in this day and age of...

(Read more)

Kim May

Webcast: Introducing QMF Analytics for Multiplatforms

QMF is bringing its power and ease to the distributed platforms! In July QMF Analytics for Multiplatforms became generally available.  This distributed platform only solution is aimed at customers...

(Read more)

Henrik Loeser

Introduction to Cloud App Security - Part 2

(This is a continuation from part 1 of this introduction to Cloud App Security.) Providing a secure app or application is a fundamental requirement. This is especially true in a cloud environment....

(Read more)

Henrik Loeser

Introduction to Cloud App Security - Part 1

Security for Cloud Apps Providing a secure app or application is a fundamental requirement. This is especially true in a cloud environment. In my post about “Securing Workloads on the IBM Cloud” I...

(Read more)
 

August 08, 2017


DB2utor

New Function Level 501: Continuous Delivery Makes its First Delivery

Db2 12 introduces continuous delivery. Making it possible for customers to rapidly put new features into production through normal maintenance is huge for the mainframe's continued viability. Businesses will now have a more positive view of running applications on DB2 for z/OS because they know they'll no longer have to wait years for required features.
 

August 04, 2017

 

August 03, 2017


Henrik Loeser

Db2 Quiz: Oh what files!?

Today, it is time for another Db2-related quiz. Take a look at the screenshot below. What do you see, what is it? Db2 Quiz Need a hint? The quiz is related to my upcoming presentations at the...

(Read more)
 

August 02, 2017


Kim May

IBM Reinvents Partnerworld – Ravages the Partner Ecosystem

I just received an email from IBM’s Partnerworld program notifying me that as of August 1, 2017, The Fillmore Group, after ten years as a Premier IBM Business Partner (the highest program...

(Read more)

Dave Beulke

New z14 IBM’s Mainframe Server

The announcement last week of IBM’s new mainframe server z14 discusses how the new hardware brings more capacity and flexibility to computing than ever before. The new z14 mainframe server is a technology behemoth and has so many features that it takes a huge amount of documentation that details...

(Read more)
 

August 01, 2017


Henrik Loeser

Db2 Catalog - A Guided Tour

The title of this blog entry is how I have named a new presentation I am currently preparing. It hope that this tour will provide fun and many useful insights into understanding the Db2 catalog and...

(Read more)

Craig Mullins

The DB2 12 for z/OS Blog Series - Part 14: Improved MERGE SQL Statement

A very common requirement for application developers is to be able to read through new data – from a table, a file or as entered by an end user – and either INSERT the data if it does not already exist or UPDATE data that does exist with new values. The ANSI SQL standard defines the MERGE statement for this purpose. The purpose of the MERGE statement is to take two “tables” and merge the...

(Read more)

DB2utor

Db2 12 Automated Statistics Collection

Terry Purcell, who leads the Db2 Optimizer team, recently told me that at least 80 percent of all SQL access path performance problems reported to IBM could be avoided if customers had collected proper runstats.
 

July 25, 2017


Leons Petrazickis

Brace expansion to match multiple files in Bash

Bash has handy brace expansion powers that I’ve belatedly discovered. [crayon-5977a675a7e28542992445/] For example, you can quickly diff a file with and without a suffix:...

(Read more)

DB2utor

The New z/14 and Pervasive Encryption

Last week IBM unveiled the newest mainframe system--the z14. As noted in the announcement letter, the z14 is intended to provide the cornerstone for the "trust economy."
 

July 21, 2017

 

July 19, 2017

Jack Vamvas

How to block database connections

During a recent consultation there was a requirement to block DB2 LUW database connections. The purpose was to test monitoring alerts and assess the correct response when a database connection could not be established.

The requirement was to maintain the DB2 instance active and all the other databases as online

An easy way to block database connections is to use the MAXAPPLS database configurable. This parameter specifies the maximum number of concurrent applications that can be connected (both local and remote) to a database.

The trick is to set the DB2 LUW database MAXAPPLS configurable to 1, and ensure that you obtain the database connection. Any other database connection will fail, regardless of whether it is remote or local.

You may discover some issues applying MAXAPPLS to 1. Adjusting MAXAPPLS is closely associated to MAXLOCKS . But the decisions to adjust the MAXLOCKS is dependant on how you currently have the database configured   

db2 update db cfg for MTTESTDB using MAXAPPLS 1

 

 

 

July 18, 2017


Data and Technology

What the Null? Handling Missing Information in Database Systems

In relational database systems, a null represents missing or unknown information at the column level. A null is not the same as 0 (zero) or blank. Null means no entry has been made for the column and...

(Read more)

DB2utor

A Happy 10 Years

Ten years ago this week--July 16, 2007, to be specific--this blog published its first post, on Universal Table Space. IBM Systems Magazine had asked me if I would consider writing a blog about Db2 for z/OS. I'm not exaggerating when I say I felt like the luckiest guy in the world.
 

July 17, 2017


Craig Mullins

The IBM z14: There's a New Mainframe Coming!

Today, July 17, 2017, IBM announced the next iteration of its stalwart mainframe hardware, the IBM z14. The news comes a little more than two years since the previous version, the IBM z13. The hardware will be generally available later this year. The big news is that IBM delivering pervasive encryption as part of the IBM z14. With pervasive encryption you can encrypt and protect all...

(Read more)

Henrik Loeser

Best practices for lively chatbots

TJBot as lively chatbot More and more chatbots are being developed and there are good reasons for it. Not all chatbot projects succeed. Often, missing user acceptance is stated. The dialog system...

(Read more)
 

July 13, 2017


Henrik Loeser

Chatbots: Testing Contexts

Watson Conversation Tool in action Some weeks ago I blogged about a tool I wrote for the IBM Watson Conversation Service (WCS). It allows you to manage your conversation workspaces from the command...

(Read more)
 

July 12, 2017


Craig Mullins

The DB2 12 for z/OS Blog Series - Part 13: DRDA Fast Load

Have you ever had a situation where you needed to load data into a DB2 table, but the file with the data was not on the mainframe? So you had to PTF that data to the mainframe and then load it. Well, with DB2 12 for z/OS you get a new capability to load the data to the mainframe without moving the file. The DRDA fast load feature provides you with an efficient way to load data to DB2 for z/OS...

(Read more)
 

July 11, 2017


DB2utor

Db2: A Small but Significant Change

If you scan IBM websites, or you're on Twitter looking for news about Db2, or you're following those who have a hand in its direction, you may have noticed something: DB2 is now Db2. The b is lower-case.
 

July 10, 2017


Kim May

Tealeaf Fatigue

I have been reviewing our first half of 2017 and trying to get a handle on where our DB2 world is headed in the second half of this confusing year.  Frankly, I’m baffled!  While the year...

(Read more)

Leons Petrazickis

Command line client for Sentry (Bash)

Sentry is a great error aggregation service. We use it for every service we deploy at work. A command line client for Sentry lets you log Bash errors. The post Command line client for Sentry (Bash)...

(Read more)

Triton Consulting

Three is the Magic Number – Triton Trio to Present at IDUG EMEA 2017

We are delighted to announce that three members of the Triton Consulting team will be heading to Lisbon this year to present at Europe’s biggest and most prestigious DB2 technical conference, IDUG EMEA*. This year’s conference will take place at … Continue reading →

(Read more)
 

July 07, 2017

Subscribe by email

 

About

planetDB2 is an aggregator of blogs about the IBM DB2 database server. We combine and republish posts by bloggers around the world. Email us to have your blog included.
 

Bloggers

decor