Skip to Main Content
ADD A NEW IDEA

All ideas

Showing 10185

z/OS sever does not return Arabic data if substr is used for LIKE predicate. String transformation is needed as part of proce

z/OS sever does not return Arabic data if substr is used for LIKE predicate. String transformation is needed as part of processing. Host: z10 – z/OS V1R11DB2 for z/OS version 8.xx (PUT level is current as site is in the process of migrating to D...
almost 12 years ago in Db2 for z/OS 1 Not under consideration

Increased flexibility for Resource Limit Facility (RLF)

Currently RLF can govern threads based on the number of service units used. Could it be changed to also cancel thread that exceed either an elapsed time, a number of getpages, a number of sync reads, or a number of async reads. The following would...
almost 12 years ago in Db2 for z/OS 1 Not under consideration

-DIS DB(*) SP(*) ADV(AREST) or -DIS DB(*) SP(*) RESTRICT(AREST)

Also se PMR 75265.010.678 i would like to have a command that specific display the AREST restricted state for pagesets DSNI023I -DEP6 DSNIERST PAGESET WP41001D.SCHEDTS 710 PART (n/a) IS AREST ON BEHALF OF UR A773F44FF5E6. BACKOUT TO LRSN CA1F7C7BF...
almost 12 years ago in Db2 for z/OS 1 Not under consideration

JOBSTEP NAME PASSED TO DB2 ACCOUNTING TRACES FOR BATCH JOBS

IN the DB2 accounting trace it is not possible to see the step name for a jcl. that is seen as correlation name. So if the same program is called more than once in the same jcl , it is very hard to guess the step which calls the one with the highe...
almost 12 years ago in Db2 for z/OS 1 Not under consideration

Allow Additional Predicate Consideration to a Spatial Search for Enhanced Selectivity and Performance

Add support to the spatial index definition/management logic to allow the definition of the ST_POINT spatial index in conjunction with other columns. This very common compound index approach would enhance performance by cutting down on GETPAGES at...
almost 12 years ago in Db2 for z/OS 1 Not under consideration

Temporal Database for DB2 Configuration parameters and catalog information

With the New Feature of Temporal Database , It may be possible to keep System Configuration information - like Instance ,configuration Database configuration , along with snapshot information if possible for performace audit , analysis etc
about 12 years ago in Db2 for z/OS 1 Not under consideration

Enhance DB2 to allow for a dynamic refresh of DB2 exit load modules via a command interface.

Enhance DB2 to allow for a dynamic refresh of DB2 exit load modules via a command interface.
about 12 years ago in Db2 for z/OS 1 Not under consideration

DB2 should be enhanced in order to use a parmlib dataset to contain initialization parameters (ZPARMS), rather than requiring

DB2 should be enhanced in order to use a parmlib dataset to contain initialization parameters (ZPARMS), rather than requiring an assembly and link-edit of a load module to contain them.
about 12 years ago in Db2 for z/OS 2 Not under consideration

DSNTIAUL INVALID PARMS check

For DSNTIAUL, TOLWARN parm YES indicate DSNTIAUL continues to retrieve rows after receiving an SQL warning. Correct parm format is PARMS('SQL,num,TOLWARN(YES)'). When using invalid format, incorrect output occurs.
over 12 years ago in Db2 for z/OS 1 Not under consideration

Create DPSI with "unique within partition" option

Customer would like to have the option to create a DPSI on a very large partitioned tablespace where NPI is not desired which is "unique within partition". In the particular case where this would be especially useful, the partitioning is done with...
over 12 years ago in Db2 for z/OS 1 Not under consideration