Db2 for z/OS

Showing 786

Enhance TRANSLATE working on character basis

The current TRANSLATE function is working on Byte Basis which is OK for EBCDIC but not for Unicode Data. Please provide a similar function as SUBSTRING which is working on character basis regardless of Underlying codepage! PMR23932,060,618

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

1 VOTE

Track Data Volume

1.How can I track volume of data for a minute ( How many insertions, Hoe many deletions, How many reads, How many writes..etc ). I am able to see the percentage but I need numbers. 2.How can I set the only two ranges ( Min and Max for System CPU,D...

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

20 VOTE

Avoid Reorg Abends by improving estimation of average row length

Today, for estimating the average row length being passed to sort, REORG gets that from catalog statistics with either AVGROWLEN or COMPRESSRATIO. The reason RTS stats is not used, is because RTS only contains the compressed data size.

almost 5 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 all...

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

3 VOTE

UNION should automatically be rewritten to "UNION ALL" when it is logically equivalent

In the following query, the developer coded "UNION". Because it is part of a "WHERE EXISTS" subselect, replacing the UNION with "UNION ALL" will perform much better and deliver the same results: SELECT * FROM PDBR111.VCLI095_SELECT V01WHERE V01.A...

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

11 VOTE

Have GET generate a useful Swagger doc for REST services that call native SQL SPs

Within a REST client like Postman or SoapUI, you can call the URI for a Db2 REST service with the GET command and the client will, from information passed to it from Db2, build a Swagger document that describes the data being sent to/from the REST...

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

3 VOTE

Recover Statistics based on Statistic History Tables

In most cases an up-to-date RUNSTATS will result in better execution plans and SQL performance. But there are also cases, where new statistics result in worser execution plans and performance. For static SQL we have many possibilities to control t...

almost 5 years ago in Db2 for z/OS 0 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...

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

5 VOTE

Add catalog information about how a compression dictionary was created (INSERT, LOAD, REORG)

Db2 is able to create a compression dictionary by INSERT, LOAD and REORG. If INSERT and LOAD are responsible, than the first x rows were not compressed (Db2 reads them to build a proper dictionary). If REORG is responsible for creating a compressi...

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

8 VOTE

DSN1COMP - provide an option to write the output to a table

We have a lot of objects being uncompressed today and where we like to check, if compression would be usefull. Therefore DSN1COMP is a great tool, but it requires us, to check each output manually. That to much effort to do it for all uncompressed...

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

Please enter your email address

FILTER BY CATEGORY