Db2 for z/OS

Showing 793

Stop Package invalidation on Enable/Disable System Time

System time has proven to be a very valuable resource, but there are some limitations that make it difficult to administer. One of those limitations is that when system time is enabled or disabled it invalidates any static package accessing the ba...

over 4 years ago in Db2 for z/OS 0 Not under consideration

9 VOTE

Materialized Query tables in DB2 z/OS with refresh immediate option

MQT's - Materialized Query tables - are a well known feature in all advanced relational database systems. The DB2 family has this feature since more than 10 years. If you look at this functionality in DB2 LUW and DB2 z/OS the MQT functionality loo...

almost 8 years ago in Db2 for z/OS 4 Not under consideration

9 VOTE

Support JSON index on array in DB2 Z/OS as it is in DB2 LUW

support json index on array in db2 for z/os in order to have adequate performance in the ultimate database for mobile,as it already is in databases not so ultimate

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

1 VOTE

Adding new values to CHECK Constraints should not put Table in CHECK PENDING

There are many instances today when existing CHECK Constraints have to be modified to add additional values. Currently, making any modifications to CHECK Constraints to add or remove values requires that the Constraint be dropped and re-created. T...

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

1 VOTE

Allow customers to specify a name for SYSINSTL ID instead of forcing "SYSINSTL"

Currently, IBM allows customers to install Db2 for z/OS under Install SYSOPR authority. This requires that the customer specify "SYSINSTL" as the installer ID in several key steps of the DB2 Install CLIST. "SYSINSTL" is then used for definition of...

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

5 VOTE

DSNB328I to be issued when all attempts to automatically recover GRECP are exhausted in all scenarios

During DR testing on several occassions the DBAs at Walmart have found that there are circumstances where neither DSNB328I nor DSNB317I are issued and Db2 z/OS has exhausted all tries to automatically recover GRECPs. In these scenarios they were s...

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

7 VOTE

Altering table with a CLONE disruption

Currently, when altering a table with a CLONE on it, the clone needs to be dropped and to add it back the following procedure must be followed:1) REORG the tablespace 2) run MODIFY RECOVERY TABLESPACE DSNUM ALL DELETE AGE (*) 3) run an image copy ...

about 6 years ago in Db2 for z/OS 0 Not under consideration

7 VOTE

432 VLDB - Reorg to Over-ride/ignore parms

We reorg a list of Tablespaces with a template and use STACK=YES. If a tablespace has an underlying LOB the reorg is abended. The requirement is to not have the REORG abend if the parameters are valid for the base table. SUGGESTION: We would like ...

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

7 VOTE

LOCK1-Structure

By drop database with many objects (TS,IX,Part) and a lot of statistic data, it can happen that the Lock1 structure gets full. Other possible reasons for LOCK1-Structure full conditions during DDL (DROP): - Object has to many entries in SYSIBM.SYS...

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

2 VOTE

Repair DBD Utility wont abend with dump while trigger found on a none existing table

regular running check repair DBD on systems. repair dbd abends when a database was found with triggers pointing on tables objects that does not existist any longer.

almost 2 years ago in Db2 for z/OS 1 Not under consideration

Please enter your email address

FILTER BY CATEGORY