Db2 for z/OS

Showing 777

Add View Support to temporal time tables

Add support for views to tables which contain both SYSTEM and BUSINESS TIME. For single table views, please limit restrictions on ISRT / UPDT so that the view can be utilized in much the same manner as any other view.

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

2 VOTE

Add timestamp to all -DISPLAY command outputs

More and more companies are using multiple DISPLAY commands to track for problems or usage statistics etc. The problem is that the TIMESTAMP when the command was issued is not in the output (apart from DISPLAY BLOCKERS) It would be really good to ...

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

2 VOTE

REPORT RECOVERY - new syntax requested to externalise just the image copy and log datasets

REPORT RECOVERY provides the CURRENT and SUMMARY keywords but even for these options the job output is either very verbose (Unit of Recovery, SYSCOPY entries, Archive log datasets, volume numbers for the LOG datasets etc) or too little (just the v...

6 months ago in Db2 for z/OS 2 Not under consideration

2 VOTE

High CPU utilisation in CF structure xxxx_SCA

We have noticed that the structure DB2P_SCA in production the reason for high CPU consumption in the Coupling Facility is. Our reporting proofs this behaviour. We opened a case and did a deeper dive with IBM’s experts into. At the end we can say t...

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

2 VOTE

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...

6 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...

7 months ago in Db2 for z/OS 1 Not under 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...

9 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...

11 months ago in Db2 for z/OS 3 Not under 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...

11 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...

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

Please enter your email address

FILTER BY CATEGORY