Db2 for z/OS

Showing 985 of 15597

Allow a Db2 z/OS Server to request clients set other JDBC Data Server Driver parameters, such as minTransportObjects or maxTransportObjects

In FL502 of Db2 13, IBM offers MODIFY DDF with the "RQSTWLB" option which allows the Db2 server to tell clients to enable Sysplex Workload Balancing (enableSysplexWLB=true) as long as the client doesn't explicitly set WLB to "false". It would be b...

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

1 VOTE

Db2: Recovery of Mainframe Db2 databases without applying changes.

When the DB2 is performing a recover it uses log and copy files, it may be some sitations where the log contains changes that we dont want to restore. For exemple we may have inserts made by an authorized program and also updates performed by an u...

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

6 VOTE

Log volume SYSUTILX

We have very large LOB objects (e.g. nnTBs). Due to the change (delete/insert/update) pattern of our applications, we have to use incremental image copies (IIC) very often to ensure recoverability for these objects. IIC for LOB objects generate lo...

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

13 VOTE

Reduce locking on XML-auxiliary tables

Locking on XML auxiliary tables can be very CPU cost intensive and can lead to problems with the threshold LOCKS PER USER.Tune DB2s locking algorithms so that locking on XML-auxiliary tableswill be reduced.

over 10 years ago in Db2 for z/OS 2 Not under consideration

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

over 8 years ago in Db2 for z/OS 7 Not under consideration

7 VOTE

I would like to force the use of the "DEFER" option on the creation of an index (using Zparm to make it optional).

We have DBAs that at times (accidently) run a "CREATE INDEX" and fail to include the "DEFER" option. This is rather easy to do because the reverse engineering tools fail to create syntax with the "DEFER" option. The creation of indexes can be very...

almost 6 years ago in Db2 for z/OS 3 Not under consideration

1 VOTE

LOAD Replace improvement for RI tables

We had a Db2 DDL change where a new table "b" was created with a RI constraint to a parent table "a" which was also modified (DROP/CREATE). Table "a" had several rows which were unloaded before the change and loaded back after the DDL changes (LOA...

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

8 VOTE

Allow RESUME NO with LOAD SHRLEVEL CHANGE

Allow RESUME NO with LOAD SHRLEVEL CHANGE to be sure that the table is really empty.

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

3 VOTE

externalize stop command failure

objects remain in STOPP when stop fails with no indication that it failed. a manual start followed by a manual stop is required to cause the object to proceed to a stop state. it's unfortunate, that issuing a start is required since that will allo...

over 2 years ago in Db2 for z/OS 3 Not under consideration

5 VOTE

Specia Register to change INVALIDATECACHE default in Db2v12

We have PeopleSoft Payroll application running on Db2 v12 z/OS. We noticed that the default value of INVALIDATECACHE in RUNSTATS has been changed from YES to NO in v12. This change has huge impact on the performance because RUNSTATS for temporary ...

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

Please enter your email address

FILTER BY CATEGORY