Db2 for z/OS

Showing 965

Stop of utilities during migration except for SYSADM

During Migration it would be nice to turn off all utilities through a DB2 issued online command except for utilities submitted by SYSADM. This would guarantee that utilities would not be able to run during the migration on any datasharing member b...

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

14 VOTE

Expand DB2 Profile Wildcard Support to Client Property Parameters

We need DB2 Profile table wildcard support to extend to the client property parameters: CLIENT_APPLNAME, CLIENT_USERID and CLIENT_WRKSTNNAME.

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

8 VOTE

Add/improve support for JSON Publishing and Parsing functions

Currently the JSON functions on DB2 z/OS are lagging behind other platforms (LUW, iSeries) by atleast 3-4 years. There is no support for building JSON document using functions like JSON_ARRAY, JSON_OBJECT, JSON_ARRAYAGG, JSON_OBJECTAGG which are a...

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

1 VOTE

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

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

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

11 VOTE

CAF plan name new feature

There are applications that have hardcoded the plan name in their programs using CAF. In some cases, it is wide spread that it will take a lot of work coding and testing due to program change. To avoid the cost of coding and testing, can there be ...

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

2 VOTE

Set object status to prohibit data access

Before we drop a Db2 table we need to make sure that noone use the object in any way. We solve this now by stopping the tablespace and keeping it stopped for about six months. This means that noone can access the data and noone can run a utility a...

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

2 VOTE

Have new authority for REFRESH of MQT that does not require high privilege levels

We historically have an application batch userid that has DBADM authority. We are limiting all access to this ID to the minimally required authority it requires such as load, imagecopy and runstats at the DB level. When we started converting our t...

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

19 VOTE

Rename Foreign Key

Up to now a RENAME FOREIGN KEY is only possible by dropping and re-creating it, thus asking for a CHECK UTILITY to be run.The enhancement of the ALTER to a RENAME would make those actions superfluous and would be much faster.

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

8 VOTE

the SYSPACKAGE's column "lastused" needs to update more frequently

Hi IBM, As you see below in description of "lastused" column on SYSIBM.SYSPACKAGE, the updated must be done "whenever" the package is used but it's not true, so due to this doubt that we have when we saw that this column was not updated after pack...

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

Please enter your email address

FILTER BY CATEGORY