Db2 for z/OS

Showing 71

Add schema to ifcid 62

Hi! I use IFCID 62 to track DDL usage and I have always found it a little bit annoying that the SCHEMA name is not part of the IFCID062 ouput. You get everything else but not the schema... this makes it difficult to impossible to see exactly what ...

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

7 VOTE

Allow more granular control over what SQL will result in Statistics Profiles updates

Unnecessary statistics can increase RUNSTATS collection elapsed and CPU time, sometimes exponentially, and impact BIND/PREPARE performance because the optimizer must read in all available statistics to determine what is and is not useful for each ...

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

10 VOTE

DB2: Enhancing DB2 decision making during starting up in DEFER ALL mode

We would like to enhance the DB2 product when starting a database with the "defer all" zparm parameter. It is unfortunate that there is a limit of 2500 in place, and it is also unfortunate that the trusted context is not automatically built, even ...

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

14 VOTE

Display IAG2 on object level

Sometimes IAG2 will be disabled, in some situations this is clear and ok, in some situations it is strange and not expected. To implement reliable automation we need e.g. an enhancement to DISPLAY DATABASE SPACENAM with IAG, which shows which inse...

6 months ago in Db2 for z/OS 0 Future 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...

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

2 VOTE

Provide more granular subsetting option for MONITOR product-type CONNECTIONS FOR SECURITY profiles

The new option to tighten security requirements for connections to Db2 with : MONITOR product-type CONNECTIONS FOR SECURITY Is a great option to enforce certain authentication options. But currently there is not option to subset these profiles to ...

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

6 VOTE

Provide capability to set DSSIZE for implicitly created LOB Auxiliary Tablespaces

Currently an implicitly created LOB Auxiliary TS DSSIZE is set to 4G and does not adhere to the zparm IMPDSSIZE or the base TS DSSIZE. We would like the capability to influence the default DSSIZE for LOBs.This would also make it consistent with th...

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

27 VOTE

Db2Z INSERT with VALUES should allow multiple rows

Db2 LUW and many other RDMS allow one INSERT with VALUES to insert multiple rows at once. Db2 Z does not allow that syntax. Db2 Z INSERT with VALUES only allows one row at a time So if you have multiple rows you want to insert with the INSERT usin...

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

15 VOTE

REBIND allocated plan

Before going to Db2 13 we have to rebind some plans that were last bound in Db2 10. We have also previously got the recommendation to rebind all plans when we have migrated to a new Db2 version. We have a problem with plans that are always allocat...

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

10 VOTE

DISPLAY EARLY CODE command

Good to know what the level of of the DB2 early code. IBM currently make viewing the early code level far more difficult than it needs to be.

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

Please enter your email address

FILTER BY CATEGORY