Search results: Db2 for z/OS

Showing 43 of 1810

Add support for CREATE OR REPLACE VIEW syntax

I've seen that Db2 LUW and other types of databases support the syntax to do CREATE OR REPLACE VIEW. This can be useful as you don't have to have a separate statement to drop a view before rerunning a create statement. I had a new DB2 DBA on our t...

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

1 VOTE

Allow for clear text NEWAUTHID in SYSIBM.USERNAMES

We use SYSPROC.DSNLEUSR to encrypt usernames and passwords that are stored in the DSNLEUSR table, The procedure encrypts both NEWAUTHID and PASSWORD. It becomes difficult to manage the SYSIBM.USERNAMES table as we cannot see the NEWAUTHID in clear...

4 months ago in Db2 for z/OS 0 Under review

10 VOTE

DIS LOCATION - Show entries for multiple drivers versions from a single server

DIS LOCATION caches the PRDID for the first connection from a remote server. Additional traffic from the same server using different drivers is not dynamically displayed. For example if a test connect uses the JCC driver and all additional traffic...

almost 4 years ago in Db2 for z/OS 0 Future consideration

1 VOTE

Authorization for DROP ALIAS for table or view

We have sort of a CI/CD pipeline for Db2 objects. We sometimes get into trouble when we need to drop an alias for a table or view. To do that you need ownership of the alias or a high privilege. Ownership cannot be changed for aliases without drop...

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

16 MERGED

ALLOW Database DBADM to DROP VIEW

Merged

Our application development team have the authority to manage application databases in our non-production environments. Using Database DBADM authority they are able to do pretty much everything EXCEPT for DROP VIEW. We need to do this for them (us...

about 7 years ago in Db2 for z/OS 0 Delivered

6 VOTE

Deadlock need to avoid for ALTER TABLE JOB

ALTER TABLE ALTER COLUMN job should be able to break-in RTS process. Currently, the deadlock may happen between ALTER TABLE ALTER COLUMN job and CORRELATION-ID=014.RTSTST00. We open CASE TS011962039 for the deadlock. From user point of view, the f...

over 2 years ago in Db2 for z/OS 4 Delivered

5 VOTE

DB2 for zOS correlated column behavior

Problem statement - unqualified column name interpreted as correlated reference. As per example below: DELETE FROM SYSADM.T1 WHERE COL3 IN (SELECT COL3 FROM SYSADM.T2)--> DSNT404I SQLCODE = 012, WARNING: THE UNQUALIFIED COLUMN NAME COL3 WAS INT...

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

12 VOTE

Improve partial RTS externalization comunication to the user

Currently, during RTS externalization if the object being externalized is being accessed at one member of DSG via utility for example, the related member RTS information will now be skipped giving the false RTS view on the object. It is especially...

over 6 years ago in Db2 for z/OS 1 Delivered

21 MERGED

User, who created a view, should also be allowed to drop and use the view

Merged

As a DBA I can create a view for other people, but if the view was not correct or should be changed, the DBA cannot drop the view, nor he can use the view, e.g. for select, also he has select privilege on the underlying tables.

about 13 years ago in Db2 for z/OS 1 Delivered

13 MERGED

allow DBADM to select on view created by the same DBADM

Merged

Currently if a DBADM has SELECT authority on a table or multiple tables, he/she can create a view under a schema base on those tables, but this DBADM may have no SELECT authority on the view, so SYSADM has to get involved to SET CURRENT SQLID to t...

almost 9 years ago in Db2 for z/OS 1 Delivered

Please enter your email address

FILTER BY CATEGORY