Db2

Showing 1401 of 15429

SQLCODE SQL0302N should give hint which parameter is too long.

Scenario: prepared statementsError: host variable too longProblem: SQL0302N should give a hint which parameter is affected. Details:Using prepared statements with parameter markers such as INSERT INTO TESTTAB (COL1, COL2) VALUES (?, ?)"); DB2 thro...

over 7 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

16 VOTE

Add a new security role to read the logs

Add a new security privileges to allow and restrict the log reads and history file.

over 9 years ago in Db2 / Security 0 Future consideration

6 VOTE

Externel table support for: parquet, orc (big data formats)

Currently a DB2 external table support file formats like: CSV nad TXT; and there is also support for external cloud locations like S3, COS, Azure. The option to load data directly from a cloud data lake in hadoop file formats like: parquet, orc, a...

over 3 years ago in Db2 / NoSQL 1 Future consideration

8 VOTE

Add db2move option to read/write compressed files

Sometimes during a migration diskspace runs low. It would be great to have an option for db2move, which reads/writes files compressed or pipe it through gzip/bz2/... This would lead to a storage reduction during migrations of roughly 80% plus redu...

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

4 VOTE

Stop requiring Db2 to be run in a --privileged container

Using the ibmcom_db2 docker image, even when adding a license to it, or installing licensed Db2 to a container based on a supported O/S requires running in a docker container with the --privileged switch. This is not a good practice and cannot be ...

over 2 years ago in Db2 / Installation & Upgrade 1 Future consideration

13 VOTE

Grant 'create, drop and alter a tablespace' authority to specific user

The Sysctl group can create, drop and alter a tablespace in db2 and also have all authorities of SYSMAINT and SYSMON. Customer just want to give tablespace control authority to specific user.

almost 8 years ago in Db2 / Security 0 Not under consideration

2 VOTE

Enhance db2move to use remote LOAD from CLIENT

For migration of on premise Db2 database to a cloud service, the usability of db2move would help a lot.For now you have to use manual LOAD commands to load data for each single table to the Db2 on cloud service.db2move can be used from the on prem...

about 1 year ago in Db2 / Utilities (Export Import Load db2look etc) 0 Future consideration

9 VOTE

Add URL Shortener to KC Pages

If you try to properly source knowledge center or promote a feature within knowledge center (say via twitter or linked-in), you copy and paste a URL that is easily over 100+ characters long. If you lose the ability to cut/paste (say in the PDF of ...

over 5 years ago in Db2 / Other/Unknown 0 Not under consideration

11 VOTE

Make the Db2 jdbc driver available in public Maven repository

Copy of an idea from here: https://ibmcloud.ideas.aha.io/ideas/IDEA-I-2616.One thing I really like about open source databases is that they are so easy to start developing with.In java for example, I can create a project add the maven details for ...

over 6 years ago in Db2 / Application Development 1 Not under consideration

9 VOTE

Enhance SYSIBM.SQLFUNCTIONS to deliver meta data required by JCC (JDBC V4)

This is a quite old story. Back in 2015 this had already been addresses by COGNOS team IBM internally, but due to the possible impact to existing applications, it was refused to open an APAR for this issue. But RFE or DCR has not been opened by CO...

over 5 years ago in Db2 / Application Development 0 Not under consideration

Please enter your email address

FILTER BY CATEGORY