Skip to Main Content
ADD A NEW IDEA

Db2 for z/OS

Showing 963 of 14951

CREATE TABLE LIKE "table-controlled partitioning" should create the table with same partitioning scheme and rules

When a table that uses table-controlled partitioning is identified in the LIKE clause, the new table should automatic inherit the partitioning scheme of that table and create an uts PBR.
5 months ago in Db2 for z/OS 1 Not under consideration

COPY UTILITY ENCHANTMENT

We would like the the COPY UTILITY will have an option to COPY CATALOG and it will know to backup and copy the catalog and directory objects ,every migration or catalog level , the order might be changed and a System DBA who is responsible for the...
about 6 years ago in Db2 for z/OS 1 Not under consideration

Show DB2 Recovery progress status in the db2 master log

Improve the messaging in the db2 log in order to be able to have a better idea of the progress of a recovery and how long it might take. For instance, currently message DSNR048I is issued every 2 minutes during abort recovery. It would be very hel...
over 8 years ago in Db2 for z/OS 0 Not under consideration

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

More options for PROFILE tables for canceling long runing threads

There isn't any way by db2 to Automatically cancel thread that runing more than x seconds or used more than x cpu. Please add these option and other cancel options to MONITOR THREADS. It is similar to DB24ZOS-I-635 There are many options that toda...
about 2 years ago in Db2 for z/OS 1 Not under consideration

No RECP state after abnormal termination with LOAD RESUME YES and no rows loaded

MR0729057126 DBDB2D/N04004
almost 12 years ago in Db2 for z/OS 1 Not under consideration

Allow 3 different options for statement concentration.

We would like 3 options for statement concentration. It is importantthat all three options are available. 1. No concentration. (already exists) 2. Concentrate queries that have no parameter markers (Current DB2 concentration) 3. Concentrate querie...
almost 11 years ago in Db2 for z/OS 1 Not under consideration

Enhance the DISPLAY LOG COMMAND to show if a specific active log dataset belonging to one member of a data sharing group is allocated to 1 or more other members in the data sharing group.

This command would be useful to allow DB2 SYSPROGS/DBAs to see if a specific active log dataset belonging to one member of a data sharing group is allocated to 1 or more other members in the data sharing group. This would allow the REMOVAL PENDING...
over 1 year ago in Db2 for z/OS 1 Not under consideration

DB2 V13 REMOVE LOG command - SET LOG REMOVE LOG

Hi, Please could the DB2 V13 command SET LOG REMOVELOG be updated as follows: 1. An option is provided so the the command either works or fails? We want the option to not have REMOVAL PENDING logs in our BSDS after a SET LOG REMOVELOG command is i...
over 1 year ago in Db2 for z/OS 2 Future consideration

Allow the SQL ALTER statement to convert SYNONYMS into ALIASES.

We have over 800,000 synonyms across 100+ DB2 subsystems/data sharing groups to convert to aliases. In our production environments, the conversion of synonyms to aliases (DROP SYNONYM/CREATE ALIAS) is going to cause carnage because all of our prod...
over 1 year ago in Db2 for z/OS 1 Not under consideration