Search

1 to 10 of 82
Sort by

Blog Entry
DB2 FOR Z/OS PCTFREE FOR UPDATE FOR PERFORMANCE

Nota del editor: Este artículo fue publicado originalmente en inglés . Con la aprobación del autor, el equipo de IDUG ha creado la traducción que a continuación se presenta. El contenido de este artículo es de aplicación Db2 12 for z/OS y Universal Table Spaces (UTS) Es...


Blog Entry
Where has the Db2 Connect Gateway gone?

Abstract The path taken by application requests to reach the Db2 data store on z/OS for many years pivoted around the, “classic” Db2 client and the Db2 Connect gateway. These pieces of software, for Db2, bridged the gap between the “distributed” (Db2 for LUW) environment and the host (Db2 for...


Blog Entry
Migrating a database using continuous rolling forward

In most traditional migrations towards a new environment, one will most probably come up with the most current ideas to get the job done, but what about migrating a multi-terabyte sized database with a minimal down time? First, we opted to set up HADR, but that would imply a second down time...

Eddy Coppens's profile image

Blog Entry
New V12 functionality - UNLOAD authority! Why? What is the point?

Db2 for zOS V12 introduces a new UNLOAD authority permission for tables. This is “beside” the good-old-fashioned classic table authority permissions for SELECTAUTH, INSERTAUTH, DELETEAUTH, UPDATEAUTH, etc. etc. This UNLOAD authority controls the ability to use the UNLOAD utility on the...

Brian Laube's profile image

Blog Entry
Db2 SQL for the DBA

Db2 SQL for the DBA - Using Modern SQL for DBA Tasks Recent releases of Db2 have introduced new SQL functionality that improves the functionality and productivity of application developers. But the DBA can also take advantage of some of the “new” Db2 SQL to improve their own productivity. ...

Brian Laube's profile image

Blog Entry
Aspirations for Being a Lazy DBA? Maybe DevOps is the Answer!

Aspirations for Being a Lazy DBA? Maybe DevOps is the Answer! Julia Carter When I was much younger, even more naïve and less cynical than I am now, I was amazed by one of my colleagues who created some ISPF panels with some REXX and Cobol behind them to automate the process to accomplish one...

Julia Carter's profile image


Blog Entry
Partition By Growth Table Spaces - Partition 2, Living with PBGs

Partition By Growth Table Spaces - Partition 2, Living with PBGs In Part 1 of this blog we looked at the different ways to create or convert to Partition by Growth (PBG) table spaces. In this part we will review the advantages and disadvantages of PBGs, when it might be appropriate to use them...

Julia Carter's profile image

Blog Entry
Partition By Growth Table Spaces - Partition 1, Getting Started

Partition By Growth Table Spaces - Partition 1, Getting Started Universal Table Space (UTS) Universal Table Spaces (UTS) were introduced in Db2 9 to bring together the advantages of partitioned table spaces, where you can have a capacity >64Gb, and segmented table...

Julia Carter's profile image