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