ADD A NEW IDEA

Db2

Showing 986

DB object version control

Idea of versioning objects: UDFs, views, mqts and procedures. When we are replacing mentioned above objects with new statements we have to save old statements in notepad (or sth similar) in case if we want to return to previous version.
almost 9 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

support of the new data type NUMERIC from Teradata

Creating a nickname to a teradata server ends with error: SQL3324N Column "xxxx" has a type of "N " which is not recognized. Target column type NUMERIC is not recognized
almost 9 years ago in Db2 / Federation 0 Not under consideration

Optimization profile mimic

add a new option to the explain tool to create an xml document containing the optimization guidelines matching the access path
almost 9 years ago in Db2 / Serviceability 0 Not under consideration

Add an optional control to stop HADR when non-logged operation occurred on primary

Currently, if there were non-logged operation such as loading data into a table on HADR primary, the log replay will continue on standby and the HADR state is still peer. But that table on standby can't be accessed. The application may not work on...
almost 9 years ago in Db2 / High Availability and/or Disaster Recovery 0 Not under consideration

DB2 trace capture diagnostics on configured error

For IBM DSDriver we need a SLIP TRAP that triggers on a specific SQLCODE like DB2/ZOS. It needs to trap errors that occur either at the client/server. Currently we need to take a client trace and server trace and try to match the timestamps. The c...
almost 9 years ago in Db2 / Serviceability 0 Not under consideration

FED DB2 WIN 10.5 - MS SQL - DATE & TIME Columns converted to VARCHAR in DB2 NICKNAMES

IBM DB2 LUW Support Team asked me to use the SQL Server driver 6.01.7601.17514 for my FEDERATION between a DB2 10.5 FP6 WINDOWS and MS SQL2012.This, to solve an issue with bad conversion of VARCHAR & VARBINARY (max).Now, I've another issue rel...
almost 9 years ago in Db2 / Federation 0 Not under consideration

Support for parallel execution of complex DML statements

Intra-query parallelism does not provide any benefits for the "INSERT ... SELECT..." statements, even when insert is performed into a temporary table. While preparing a PoC for the customer planning to use DB2 for LUW in 1C:Enterprise application ...
almost 9 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

db2stop quiecse for single partition

Be able to issue db2stop quiesce for a single partition server. Currently its for a single partition server only.... Rob Lemeiux
almost 9 years ago in Db2 / Serviceability 0 Not under consideration

Alternate load copy path

New option to specify an alternate load copy path during a load of a table.
almost 9 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

XMLQUERY Not working in the JOINS

Currently we need to use the XMLQUERY in our LEFT OUTER JOINS during view creation. The views are created with no error, While querying the view it fails with below error. An ON clause associated with a JOIN operator or in a MERGE statement is not...
almost 9 years ago in Db2 / Analytical Functions 0 Not under consideration

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.