How to use “package” access path information to solve a real-life application issue! Get access path from the “package”! The new SQL EXPLAIN statement options! There are NEW (as of Db2 for z/OS V10) SQL “EXPLAIN” statement options to get the hidden details of the actual access path...
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...
1 Comment - no search term matches found in comments.
Over the years as Db2 has traded real storage exploitation for CPU and zIIP MIPS reductions, customers have become more aggressive at utilizing these techniques. Db2 buffer pool expansion, EDM and authorization cache pools, as well as persisting threads through the use of KEEPDYNAMIC and RELEASE...
IBM Db2, DBAs and Zowe CLI A DBA Overview of Zowe CLI and the IBM Db2 Database Plugin for Zowe CLI Rose Sakach Do you want to learn more about the Zowe CLI and the IBM Db2 Database Plugin for Zowe CLI? Click here to read the full article by Rose Sakach. (IDUG login required).
Quick start: Integrating Db2 stored procedures and Zowe CLI Richelle Anne Craw Db2 stored procedures by themselves have the benefit of improving programming productivity. What if you combine that with the power of Zowe CLI? Photo by israel palacio on ...
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...
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. ...
Deprecated Objects and APPLCOMPAT DBA's are notoriously conservative when it comes to migrating data to new types of objects. Our theme seems to be "if it ain't broke, don't fix it!" IBM has decided to encourage those of us on DB2 for z/OS to migrate our data to Universal Table Spaces (UTS)...
La historia de IDUG en México comenzó oficialmente el mes pasado en el día 22 de Agosto, en donde tuvo lugar el primer seminario organizado por IDUG y así, atraer a la comunidad de Db2 para unirse a la comunidad que IDUG ha estado promoviendo desde hace varios años, pero tal vez esta historia...
There have been several high visibility data exposures in the news over the last year or so. As a Db2 DBA, one of your responsibilities is the protection of the data your business needs to run. Your auditors, internal and external, may be demanding action to protect your valuable Db2 data from...