Db2

Showing 982

Page-level recovery request.

DB2 is not able to repair a single bad page, i.e. to perform a page-level recovery.This causes a downtime because the only solution is the execution of the OFFLINE procedures, like RESTORE/RECOVER/db2dart.

over 9 years ago in Db2 / Backup/Restore/ Rollforward/ Recover 0 Not under consideration

13 VOTE

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

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

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

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

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

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

7 VOTE

Add support AIX 7.1 for Db2 11.5.4

I support my customers system which runs DB2 ESE on AIX 7.1. We were on DB2 10.5 and upgraded this Summer to 11.5 which compatibility reports showed as a supported configuration. Now that we are looking at applying 11.5.4 fixpacks, I'm finding the...

over 4 years ago in Db2 / Operating System/Virtualization 2 Not under consideration

12 VOTE

DBA needs control over Jobs from Automatic Maintenance

We recently had an outage due to automatic maintenance - reorg on a table to reclaim extents. Application A (db2hmon) was running a reorg reclaim on a table and Application B which was already connected to the database and was running a job, as a ...

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

16 VOTE

Redesign of cleanup on remote cursor load of LOB data

Customer migrated from DB2 9.1 on Solaris to DB2 9.7 onLinux. As restore is not supported between different endianarchitecture, load by remote cursor was used for datamovement. There was one single table storing about 400 GB ofLOB data (BLOB), tot...

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

Please enter your email address

FILTER BY CATEGORY