All ideas

Showing 15415

Improve poor query compilation performance due to long lock list traversal in DB2 10.1 and later

Beginning with DB2 LUW 10.1 DGTT-referencing DML started to take catalog locks and therefore we have to free them and potentially traverse long lock chain if the DML is a part of a long-running transaction potentially holding millions of locks. Th...

almost 10 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

1 VOTE

The rewrite from non-correlated sub-select to a correlated sub-select should happen in additional cases

This was submitted initially as a case with ID TS002883559. The following query is not rewritten by Db2 (from non-correlated to correlated): SELECT *FROMPDBR111.VLCR004_NODELS TLCRTABLE0X0_ LEFT OUTER JOIN(SELECT * FROM PDBR111.TLCR002 A WHERE A...

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

1 VOTE

Enhancing names of docker images for different instances

Information from Case numbers: TS002979327 and TS002990656 We are testing datastage 11.7.1 (kubernetes version) In case# TS002979327, following was recommended: ----- 2) you needed to modify your /etc/hosts file on your client machine with:<...

almost 5 years ago in DataStage 0 Not under consideration

1 VOTE

Support Automatically Convert Numeric SQL Type(to Decimal or etc) for File Connector Stage to Parquet Format

Problem : We need to migrate data from SQL Server to Parquet Format. One of the data type in the SQL Server is Numeric type. We will run the migration job process using RCP. Workaround : 1. We need to change data type to another type, but we ar...

almost 5 years ago in DataStage 2 Not under consideration

2 VOTE

Query History - Ability to mask the key value on SQL Text

Stored procedures SYSPROC.ACCEL_GET_QUERIES andSYSPROC.ACCEL_GET_QUERY_DETAILS return information about past queries and queries that are currently running onan accelerator. We need capability to be able to turn mask the key values on the SQL text...

almost 10 years ago in Db2 Analytics Accelerator for z/OS 0 Not under consideration

2 VOTE

Enable RTM to honour usergroup permissions so that a user can control all jobs via RTM that they can via LSF

We have configured many of our usergroups to be their own admin, which means that any member of that usergroup can manage any job submitted by any user via that usergroup. However, in RTM Grid->Job Info ->Details page the user can only contr...

almost 10 years ago in Spectrum LSF 3 Not under consideration

1 VOTE

Ability to append to a file when performing an export

When exporting data to files, every export should be in a different file. And it the business requirement is to have all data in the same file, then it is necessary to do that manually with something external to db2.

almost 5 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

2 VOTE

support for snapshot isolation in .Net code

Microsoft already supports IsolationLevel.Snapshot in .Net code.Informix has LAST COMMITTED isolation level which is equivalent.For some reasons in .NET code IsolationLevel.Snapshot is not supported on Informix database. Also there is no way to se...

almost 10 years ago in Informix / Informix Client Products 1 Not under consideration

1 VOTE

Have License Scheduler Automatically Prune its Database

LSF License Scheduler can create a database directory that log's token usage by feature. Over years, this directory can become cluttered, and impact License Scheduler performance. There should be a setting in License Scheduler to prune that direct...

almost 5 years ago in Spectrum LSF / License Management 0 Not under consideration

1 VOTE

Improve RAS of License Scheduler

"Presently, License Scheduler, when placed in debug mode it becomes unstable, and will not respond to client requests due to all the blocking loops inside of the tool, including logging. It also lacks TRACE levels that improve the tuning of debug ...

almost 5 years ago in Spectrum LSF 1 Not under consideration

Please enter your email address

FILTER BY CATEGORY