Db2

Showing 1373

Change the mapping of a timestamp with timezone from varchar to a Db2 timezone for a Postgres database source

Currently the timestamp with timezone in a Postgres source database is mapped to a varchar and that limits how you can query and manage it. Other data sources map this data type to a timestamp allowing for normal processing using the various time ...

about 2 months ago in Db2 / Federation 0 Submitted

1 VOTE

Improve SQL0293N when creating database on 4K sector size disk

On CREATE DATABASE db2 reports a very generic error message SQL0293N when there is a write access to a 4K sector size disk. Instead should do a check when creating containers e.g. read 512 bytes, if this does not work, read 4K block. If 4K block c...

about 2 months ago in Db2 / Serviceability 0 Submitted

36 VOTE

Poor performance on DB2 V11.1 due to changes in build process

Some customers are noticing performance degradations moving from v105 ESE to v111 ESE on the same hardware.These degradations are most pronounced in OLTP workloads, with an emphasis on INSERT and UPDATE operations. Db2 Support has confirmed that t...

over 5 years ago in Db2 / Serviceability 0 Not under consideration

22 VOTE

Advanced Network compression for DB2 HADR

Advanced data compression in network technique provide a way to convert data into alternate data formats which use less size. These techniques can be helpful to compress data to be transmitted over network at the sending side and then convert back...

over 3 years ago in Db2 / Replication 3 Not under consideration

40 VOTE

Parallel log file archival and retrieval

Log archival / retrieval is performed by a single thread. This can lead to log archival stuck e.g. if log file need to be retrieved to be added to online backup include logs. This is also problematic if multiple log files need to be retrieved duri...

about 6 years ago in Db2 / Backup/Restore/ Rollforward/ Recover 1 Future consideration

9 VOTE

Increase the db2 licence limit for the DMC repository db.

16 VPC is a 2 VP value based on my server.(2core) I have more than 15 DBs to monitor, but the licence limit makes it difficult to increase the CPU. I apologize for the lack of clarity in my explanation. The bundled DB2 license for the DMC repos...

over 1 year ago in Db2 / Data Management Console 2 Not under consideration

9 VOTE

When setting 'DB2_COMPATIBILITY_VECTOR=ORA' in non-ora DB, the resulting string length is different.

when it's going to setup "db2set DB2_COMPATIBILITY_VECTOR=ORA"~ $ db2set DB2_COMPATIBILITY_VECTOR=ORA$ db2stop force03/27/2023 18:05:52 0 0 SQL1064N DB2STOP processing was successful.SQL1064N DB2STOP processing was successful.$ db2start03/27/2023 ...

over 1 year ago in Db2 / Application Development 4 Not under consideration

9 VOTE

Change replace System-defined in db2 luw to consider NLS characters in search.

Wrong result when executing the replace function with certain characters in the codeset euc-kr DB. (It comes out fine for utf-8 DB, but not for euc-kr.) Case No : TS012082536 *L3 team comment* ##################################################### ...

over 1 year ago in Db2 / Application Development 0 Not under consideration

16 VOTE

Enhance SQLCODE SQL3015N details

When we receive the following error message (during LOAD): SQL3015N An SQL error "-551" occurred during processing. we only know, that it is an authorization issue. The detail information (authorization-id, operation, object-name) are not availabl...

over 2 years ago in Db2 / Serviceability 0 Future consideration

25 VOTE

Allow a WHERE clause for ADMIN_MOVE_TABLE to delete data while moving a table

One of the most painful things to do is to delete a huge amount of data. One workaround for this is to export the data needed and then LOAD/REPLACE back into the same table, but this requires an outage of the table to accomplish. If a WHERE clause...

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

Please enter your email address

FILTER BY CATEGORY