(Tammie Dang and Paul McWilliams) Db2 12 function level 505 (activation enabled by APAR PH09191) introduces a new REBIND phase-in capability for application packages, which enables DBAs to issue REBIND PACKAGE commands successfully when target packages are being concurrently executed.
Tag: IBM
Using your FIDO2 key for 2FA on IBM Cloud apps
(Henrik Loeser) Last week I read the blog on how to protect cloud apps with App ID by using the IBM Cloud Identity user directory.
The DB2Night Show #218: Db2 Automatic Statistics Deep Dive
(Martin) 100% of our studio audience learned something!John presented how automatic statistics make your life easier.
New SMPE product base tape simplifies Db2 12 installation and migration
(Paul_McWilliams) IBM has simplified installation and migration for Db2 12 by integrating 1,070 Db2 12 PTFs (more than 33 months of maintenance) in a new SMPE SUP (service update) product base tape for new SMPE installation of Db2 12 for z/OS.
Jenkins and z/OS – Groovy Pipelines
(James Gill) If you’re thinking of using Jenkins to orchestrate some or all of your DevOps automation, you will need to look at how to produce your own bespoke pipelines, or automation scripts. In Jenkins these are written in Apache’s Groovy language, which is a Java-like scripting language.
Db2 11 End of Support and Db2 12 for z/OS migration resources
(Mo Townsend and Paul McWilliams) Are you ready? The End of Support (EOS) for Db2 11 for z/OS is coming fast, just 12 months away on September 30, 2020!
New tutorial discuss how to enhance cloud app security
(Henrik Loeser) 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?
DB2 Administrative SQL Cookbook: Finding Statements in the Package Cache using a lot of Temporary Space
(Ember Crooks) To find recently executed statements that have used a lot of temporary space in Db2. Sometimes temp space will fill up, and particularly if temp space is not on its own file system, it can cause database-wide issues.
Guru: Edit Result Sets in Run SQL Scripts
(Paul Tuohy) Before getting into the detail in this article, I want it to be clear that I do NOT (in any way) advocate the direct editing of data in a production database. But when it comes to a test database, then the ability to directly edit data is invaluable.
Implementing a Connect Procedure to Enhance Database Security
(James Cockayne) Introduced in DB2 v9.7 Fix Pack 3, the CONNECT_PROC database configuration parameter allows you to specify a stored procedure that will be executed when a user attempts to connect to the database.