Db2 for z/OS

Showing 954

Register all dependencies in SYSPACKDEP

Today SYSPACKDEP records the dependencies of packages - but not dependencies related to RI. That means that a user or a tool needs to run additional queries to understand all dependencies to e.g. answer the question: which packages do I need to RE...

7 months ago in Db2 for z/OS 3 Not under consideration

2 VOTE

Reduce message flooding on system console using Db2 System Profile Monitoring for security profiles when detecting non-secure connections and WARNING_DIAGLEVEL3

This Aha idea is being opened on behalf of Commerzbank (Ute Kleyensteuber). Security profiles are used with System Profile Monitoring filter LOCATION=*, ATTR1=WARNING_ DIAGLEVEL3, ATTR3=1 (TLS required) to discover all incoming non-secure connecti...

8 months ago in Db2 for z/OS 1 Not under consideration

2 VOTE

Masking function with GRANT per column

Column masking has been great help in managing sensitive data and complying with the General Data Protection Regulation (GDPR).But today’s solution to know if a user has access to data without masking is to create a Mask using a CASE with SESSION_...

9 months ago in Db2 for z/OS 2 Future consideration

2 VOTE

Set object status to prohibit data access

Before we drop a Db2 table we need to make sure that noone use the object in any way. We solve this now by stopping the tablespace and keeping it stopped for about six months. This means that noone can access the data and noone can run a utility a...

10 months ago in Db2 for z/OS 0 Future consideration

2 VOTE

Have new authority for REFRESH of MQT that does not require high privilege levels

We historically have an application batch userid that has DBADM authority. We are limiting all access to this ID to the minimally required authority it requires such as load, imagecopy and runstats at the DB level. When we started converting our t...

10 months ago in Db2 for z/OS 1 Not under consideration

2 VOTE

Allow DB2 to Insert more than 32KB data into a CLOB column

SQL Server Management Studio, Toad for Oracle allow inserts with more than 32 KB column size but DB2 doesn't allow the same and this is a show stopper for few projects to come into DB2 ZoS as data fixes by application team is not possible in produ...

12 months ago in Db2 for z/OS 3 Not under consideration

2 VOTE

Provide incremental progress messages through a DB2 group restart

During a recent DR activity our Db2 had issues during group recovery and it was challenging to determine at what point Db2 had gone as far as it could before requiring the other member to be restarted to resolve any locks RC00C200EB . The MSTR log...

12 months ago in Db2 for z/OS 1 Future consideration

2 VOTE

Ability to stop AOT and other db2 tables on IDAA

When we STOP or start for UT ,spaces of tables that are loaded to IDAA or spaces that relate to AOT's, these spaces are still available for the IDAA. We can SELECT data from the IDAA for these tables and for AOT's' we can also update them. We need...

12 months ago in Db2 for z/OS 1 Not under consideration

2 VOTE

Enhance Db2 FTB analytics function Db2 V12

Started last weeks activating FTB in development systems by using ZPARM DSN6SPRM.INDEX_MEMORY_CONTROL. Tried to get information using -DISPLAY STATS(INDEXMEMORYUSAGE) LIMIT(*) -DISPLAY STATS(INDEXTRAVERSECOUNT). i thought i will get deeper to it b...

about 1 year ago in Db2 for z/OS 1 Not under consideration

2 VOTE

Externalize high water marker for EDM pool in Db2 trace on Db2 V12

This stat is useful and required to tune EDM pool appropriately. This would be useful for DB2 systems programmer and DB2 Performance Teams. We had a case opened and the decision is to externalize this feature only with v13. It would be great to ha...

about 1 year ago in Db2 for z/OS 0 Future consideration

Please enter your email address

FILTER BY CATEGORY