• April 9, 2020

AUTHOR DETAILS

  • Paul Bartak

    Paul Bartak5 Posts

    Paul Bartak has been working with IBM databases since 1985, including the first version of DB2 on MVS. As an IBM customer for 14 years Paul worked in Application Development, Database Administration, and DBA. He joined IBM in 1999 as an Information Management Technical Specialist, teaming with the Sales force to present, design, install, demonstrate, and evaluate IBM Information Management solutions in a pre-sales environment; gaining multiple certifications in Database Administration, Data Replication, Blockchain, and Cloud Computing. Paul developed the four generations of the DB2 Migration Planning Workshops from DB2 V8 for z/OS, to DB2 11 for z/OS; and enablement for Db2 for z/OS pureXML and Temporal features. Currently, as a Principal Solutions Architect with Rocket Software, Paul is focused on the tools used to maximize DB2 for z/OS value, with emphasis in database cloning and DevOps processes. He supports multiple Db2 User Groups, has been a speaker at several IDUG and Insight/Think conferences, is a Redbook/Redpaper author, and IBM Champion.

Devops

DB2 Cloning Tool: Enabling Db2 for z/OS Provisioning (PH00169)

Are you looking for a way for Db2 for z/OS to participate in your company’s DevOps processes? Have the requests for test object and data creation, and refreshes, in support of Agile sprints, increased as developers strive to meet business demands? The Cloning Tool stands ready to help. Sure, the IBM Db2 Cloning Tool can […]

Application Modernization

People are asking “What is Db2 DevOps Experience for z/OS?”

This article was originally published on the IBM community blog and was written in collaboration with Patrick Bossman, an STSM for Db2 for z/OS at IBM, Paul McWilliams, an Information Developer for Db2 for z/OS at IBM, and Paul Bartak, Principle Solutions Advisor for Db2 Tools for z/OS at Rocket Software. IBM Db2 DevOps Experience […]

Devops Mainframe

Db2 Cloning Tool: Enhanced App Cloning Index Processing (PI99726)

If you perform Application (Tablespace) Cloning with the Cloning Tool, chances are that you will experience a free performance boost after applying APAR PI99726 (PTF UI57180). It is likely that indexes are included in your cloning LISTDEF definition or via the COPY parameter, ALWAYS-COPY-INDEXSPACES. With this enhancement, the Cloning Tool Source job will be able […]

Devops Mainframe

Db2 Cloning Tool: What is Skeleton Cloning?

Unless you’ve seen a presentation on the Cloning Tool, you may not be aware of support for something called Skeleton Cloning. The only references to “skeleton” in the user guide are in the context of ISPF, and there’s no mention of it in the panels or profiles.  Skeleton Cloning is a subset of Subsystem Cloning, […]

Devops Mainframe

Db2 Cloning Tool Version Mismatch Processing

Db2 Online/Pending alters are a great thing for Db2 schema evolution. This does, however, create an interesting challenge for application cloning operations. This results in rows being versioned within the pageset, and can cause compatibility checking issues between the source and target system. In a nutshell: CREATE TABLE T1 (COL1 INT) + ALTER TABLE T1 […]