Db2 for z/OS

Showing 984

DSNTIJRT need option to DISABLE GRANTs

When using DB2/RACF security you might have a requirement from your security auditors, that you don't perform any GRANT at all. This could be a general parameter in DB2OPT or a procedure specific option GRANTTO(NONE) in CFIGIN (both in the DSNTIJR...

almost 11 years ago in Db2 for z/OS 3 Planned for future release

8 VOTE

DISPLAY PROCEDURE add ability to filter started/stopped procedures

the current -DISPLAY PROCEDURE only allows to display all procedures with a scope of group or local, in all statuses. The ability to filter on procedures that are in a particular state would be significant for error checking and system up time.

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

3 VOTE

improved estimation for potential use of Huffman Compression

Requirement for more accurate estimates of DASD space savings when using Huffman Compression. Problem is that estimates produced by DSN1COMP can be significantly inaccurate i.e., as much as +/- 30%. The solution required is a new option on the REO...

over 2 years ago in Db2 for z/OS 0 Future consideration

2 VOTE

Db2 zOS: Provide support for period-clause FOR PORTION OF BUSINESS_TIME for update operation within MERGE statement

Idea is to extend functionality of MERGE statement in Db2 z/OS by providing support for the period clause FOR PORTION OF BUSINESS_TIME for an update operation (and delete operation) within the MERGE statement. The statement would look like this: ...

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

7 VOTE

Enable temporal history to catalog to query DDL at points in time.

Having the ability to enabling system temporal history for catalog objects that contain schema information would allow the ability to rapidly restore a table to a prior point in time that has had a schema change.

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

6 VOTE

Add DSNTIAUL comments support in SYSIN

We normally use DSNTIAUL with several SELECT statment coming from other applications. We would like to use them in the SYSIN statement but because some of this queries has the comment row that begins with '--' characters, it does not work. To allo...

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

5 VOTE

Make REGEXP SQL functions available in Db2 for z/OS without IDAA

We recently had a developer who wanted to use a REGEXP_LIKE clause in SQL for an application. He was told that this functionality was available in Db2 12 for z/OS. However, on further investigation, the functionality requires IDAA. We assume that ...

over 4 years ago in Db2 for z/OS 1 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

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

6 VOTE

Deployment friendly implicit LOB naming

The Db2 feature to implicitly create LOB structures could be very helpfull for us. But we are facing a big problem with the implicitly created objects. Db2 for example names the auxiliary table with an random prefix (as well for LOB tablespace, au...

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

5 VOTE

Access data of SP's WLM DSSPRINT DD in execution time when called from external program (ex. Cobol)

Hi IBM, We opened CASE TS003473597 to treat this issue but as we did not have solution from you we decide to ask it by "new idea". So we have some maintenance COBOL programs that make the call to the SP DSNUTILU to run some db2 utilities, so then ...

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

Please enter your email address

FILTER BY CATEGORY