Planet DB2

Quick notes on using FIDO2 security keys on Linux

2019-10-07T14:40:26Z

Using FIDO2 keys for 2FA Most of you know that I am using a Linux laptop. Thus, experimenting with FIDO2 hardware security keys as discussed in the earlier blog post requires some extra setup. But...

(Read more)

Using your FIDO2 key for 2FA on IBM Cloud apps

2019-10-07T10:30:08Z

Architecture: End-to-end security Last week I read the blog on how to protect cloud apps with App ID by using the IBM Cloud Identity user directory. That blog discusses how to configure IBM Cloud...

(Read more)

The DB2Night Show #218: Db2 Automatic Statistics Deep Dive

2019-10-04T13:57:37Z

Presented by: John Hornibrook STSM, IBM Toronto Lab "The DB2Night Show #218: Db2 Automatic Statistics Deep Dive" Replays available in WMV and M4V formats! 100% of our studio audience learned something!John presented how automatic statistics make your life easier. Watch the replay...

(Read more)

The DB2Night Show Z99: Db2 for z/OS Know your Limits!

2019-10-04T11:32:43Z

Presented by: Roy Boxwell Sr. DB2 Product Specialist Segus / Software Engineering Db2 for z/OS Know your Limits EVERYBODY (100%) in our audience learned something! Roy described the impact of limits on Db2 processing and their effect on Db2 processing. To learn what's new, watch, learn and enjoy...

(Read more)

New tutorial discuss how to enhance cloud app security

2019-10-04T07:08:49Z

Recently, I wrote a new tutorial as part of the IBM Cloud solution tutorials. Have you already developed and deployed an application on IBM Cloud? Then, may be, you followed the introductory tutorial...

(Read more)

DB2 Administrative SQL Cookbook: Finding Statements in the Package Cache using a lot of Temporary Space

2019-10-02T12:00:03Z

Trip report: Sustainability management and reporting

2019-10-02T10:55:49Z

Last Friday, I attended the annual conference of the Bodensee Innovation Cluster for digital change (changes due to digitalization). The conference had several interesting talks and included...

(Read more)

Db2 12 for z/OS - Let's Talk About MAXDBAT in ZPARM

2019-09-30T23:45:36Z

"ZPARMs" is a reference to the parameters in the Db2 for z/OS module called DSNZPARM - these are essentially the configuration parameters for a Db2 subsystem. Two of the ZPARMs that are closely related to each other are CONDBAT and MAXDBAT. CONDBAT specifies the maximum number of connections that network-attached applications (i.e., applications that access the Db2 system via the Db2 distributed data facility, aka DDF) can have with the Db2 system at any one time. MAXDBAT is,...

(Read more)

New Features in Navicat Data Modeler 3.0

2019-09-26T15:49:38Z

Before implementing a database of any kind, a sound model of the data needs to be developed. This process, known as data modeling, requires an analysis of the things of interest to your organization...

(Read more)

Fall Class Highlights

2019-09-18T15:24:24Z

Learn new Db2 skills and help your organization leverage the best features and functionality available in the Db2 product family. The classes below are our Fall, 2019 top picks! Virtual and...

(Read more)

IBM Unleashes the z15 Mainframe

2019-09-17T19:24:00Z

In New York City, on September 12, 2019, IBM announced the latest and greatest iteration of its Z systems mainframe computing platform, the IBM z15. And I was lucky enough to be there for the unveiling. The official IBM announcement letter can be found here if you want to dive into the details. But before you go there, consier first reading what I have to say about it below. Before going any...

(Read more)

Implementing a Database Infrastructure

2019-09-16T12:15:20Z

I recently received a question about how to put together a database environment from scratch. This is a quick question that requires an in-depth answer — usually moreso than can adequately be...

(Read more)

Join Gold Consultants for a V12 Upgrade Webinar Wednesday, October 9th

2019-09-10T18:16:31Z

The Time is NOW! Upgrade to Db2 12 for z/OS! Date: Wednesday, October 9, 2019 Time: 11:00am EDT Register: HERE You are invited to join a live webcast hosted by IBM Gold...

(Read more)

The DB2Night Show #217: Light at the End of the Encrypted Tunnel

2019-09-08T00:19:13Z

Presented by: Greg Stager Developer, IBM Toronto Lab "The DB2Night Show #217: Light at the End of the Encrypted Tunnel" Replays available in WMV and M4V formats! 100% of our studio audience learned something!Greg presented a thorough introduction to using TLS with Db2 LUW 11.5. Watch the replay...

(Read more)

Ancelus: an Intriguing New Type of Database

2019-09-05T14:52:40Z

There are many different DBMS types and products on the market these days. We have relational, key/value, document, wide column stores, graph, in-memory, multi-model, and even pre-relational DBMS...

(Read more)

Ember Speaking at Midwest Users Groups Meetings September 10 and 11

2019-09-05T13:56:27Z

One of the things I most enjoy in my career is speaking – whether it is at conferences or for Users Groups. I’ll be speaking at Users Groups in St. Louis and Milwaukee September 10 and 11.

Also speaking will be one of my favorite speakers – Pavel Sustr.… Read the rest

The Power of Data Masking for Data Protection

2019-09-04T16:18:00Z

Data privacy regulations and the desire to protect sensitive data requires methods to mask production data for test purposes. Data masking tools create structurally similar data that is not the same as the actual data, but can be used by application systems the same way as the actual data. The capability to mask data is important to be in compliance with regulations like GDPR and PCI-DSS, which...

(Read more)

#IBMz #IDAA v7.1 Webinar Recording and Material #Db2

2019-09-02T19:49:51Z

Extending appreciation to all who participated in the IBM Db2 Analytics Accelerator (IDAA) v7.1 webinar on August 28, 2019. If you weren’t able to join us, here is the webcast recording. In a...

(Read more)

Updated: Cloud App Security - an introduction

2019-08-30T12:56:37Z

IBM Cloud offers security services Two years back, I had created two blog articles providing an introduction to cloud app security with an overview of topics, then discussing details on how to...

(Read more)

The Two Aspects of Db2 for z/OS Support for JSON Data

2019-08-29T21:56:06Z

JSON (JavaScript Object Notation) is a form of data representation that is popular with people who develop what you might call "very modern" applications, including those that are cloud-based and those that have a mobile front-end. One reason this is so: a JSON document is easy for a program (or a person) to parse, as you'll see from examples I've included a bit further down in this blog entry. As interest in JSON has grown, more folks have asked about the support that Db2 for z/OS provides...

(Read more)

IBM Replication Featured at Upcoming Baltimore/Washington Db2 Users Group

2019-08-28T13:36:45Z

IBM is hosting the September meeting of the Baltimore/Washington Db2 Users Group to be held at the BWI Hilton on Wednesday, September 11th. IBM’s Kenishia Sapp and Anthony Ciabattoni will be...

(Read more)

Track API key usage by combining IBM Cloud IAM and LogDNA search

2019-08-19T12:49:21Z

Which key is still in use...? Recently, I blogged about tracking account activity from the command line. I showed you how to search IBM Cloud Activity Tracker with LogDNA records using a Python...

(Read more)

Offboarding on IBM Cloud: Considerations when removing a user

2019-08-19T06:48:41Z

Only authorized persons have access Over my past blog posts I have looked into how to rotate credentials in different compute environments. I looked at Cloud Foundry on IBM Cloud, Cloud Functions...

(Read more)

Join My Team at IBM

2019-08-19T01:59:14Z

This is a heads up that my team has several developer positions available. The job post is not live yet, but it will be shortly. If you are interested and you meet the requirements below, feel free...

...

BMC AMI for DevOps Intelligently Integrates Db2 for z/OS Schema Changes

2019-08-15T18:00:00Z

Organizations of all types and sizes have adopted a DevOps approach to building applications because it effectively implements small and frequent code changes using agile development techniques. This approach can significantly improve the time to value for application development. The DevOps approach is quite mature on distributed platforms, but it is also gaining traction on the mainframe. As...

(Read more)

Join Frank for a Free Webinar: IDAA Afternoon Show

2019-08-12T15:37:29Z

Several people who registered for The Fillmore Group’s Columbus IDAA class in July were unable to attend, so we’ve decided to borrow the “Db2 Night Show” format, with Frank hosting the “IDAA...

(Read more)

Get some REST with Db2

2019-08-12T10:24:58Z

Db2 has a REST API Many of the IBM Cloud services have a REST API, an overview of REST APIs is here in the IBM Cloud docs. Recently, I realized that I had not yet tried the Db2 on Cloud API and the...

(Read more)

Track it from the command line: Search audit events in LogDNA using Python

2019-08-07T08:04:44Z

Take a look at security logs Earlier this year, IBM and LogDNA announced an integrated offering Activity Tracker with LogDNA. It allows to manage and search activity events in LogDNA instances on...

(Read more)

DevOps is Coming to Db2 for z/OS

2019-08-01T15:11:00Z

Mainframe development teams are relying on DevOps practices more extensively, bringing the need to incorporate Db2 for z/OS database changes into the toolset that is supporting their software development lifecycle (SDLC). But most mainframe professionals have only heard a little about DevOps and are not really savvy as to what it entails. DevOps is an amalgamation of Development and Operations....

(Read more)

Use a Delivery Pipeline to rotate credentials

2019-08-01T11:45:47Z

Job in Delivery Pipeline to rotate keys In my recent posts I touched on updating credentials for solutions deployed on IBM Cloud Functions or using Cloud Foundry on IBM Cloud. Today, I am showing...

(Read more)

Db2 for z/OS - Talking About APPLCOMPAT (Part 2)

2019-08-01T00:14:51Z

Last month, I posted to this blog part 1 of a 2-part entry on the APPLCOMPAT option of the Db2 for z/OS BIND PACKAGE command. In that entry I covered several aspects of APPLCOMPAT. In this part 2 piece, I will focus on one particular matter pertaining to APPLCOMPAT - namely, the management of this option for packages associated with the IBM Data Server Driver (or its predecessor, Db2 Connect) in a Db2 12 for z/OS environment. The IBM Data Server Driver is used by client application programs...

(Read more)

Webinar: DevOps and Database Change Management for Db2 for z/OS - August 13, 2019

2019-07-29T13:41:00Z

DevOps practices are gaining popularity on all development platforms and the mainframe is no exception. DevOps relies heavily on agile development and automated software delivery. However, the ability to integrate and orchestrate database changes has lagged. To learn more about DevOps, change management, and Db2 for z/OS, I am delivering a webinar on this topic along with John Barry of BMC. We...

(Read more)