Db2

Showing 1389 of 15584

CSV or Delimited result set function in SQL

My result set final format needs to be CSV. It would be awesome if I could use SELECT CSV(*) FROM TABLEA to return my result set as a column of CSV format. so for instance I have a requirement to produce a csv file of variable record lengths SELEC...

over 3 years ago in Db2 / Data Types 0 Future consideration

5 VOTE

DMC format for time metrics needs to be smarter for values bellow ms range

This started as a discussion in IBM Db2 community. https://community.ibm.com/community/user/hybriddatamanagement/communities/community-home/digestviewer/viewthread?GroupId=2983&MessageKey=8802cd2f-d91d-46aa-a114-aa6cc5ec88df&CommunityKey=e...

over 3 years ago in Db2 / Data Management Console 0 Future consideration

2 VOTE

Estimate the optimal BLU columnar compression rate by sampling data

A technique is needed to determine optimal data compression rates for BLU columnar tables. Such a utility should estimate the optimal compression rate without and with the new string compression enhancements delivered in Db2 11.5 code stream. In e...

over 1 year ago in Db2 / BLU Acceleration 1 Functionality already exists

12 VOTE

Platform switch Windows-Linux using OFFLINE database backup image

A platform switch from Windows to Linux (or Linux to Windows), would be much easier if one can use the DB2 backup image itself. Not necessary between two different DB2 versions, and it doesn't have to be an online backup, and of course platforms a...

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

3 VOTE

Add ALTER COLUMN options to modify numeric column length and allow rename column names for ((bi)temporal) column organized tables

Db2’s capabilities to perform schema changes on any form of ((bi)temporal) column organized tables lacks behind it’s row organized counterparts. This prevents effective database schema evolution and therefore limits the use of column organized tab...

about 2 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

6 VOTE

Rewind the current database from logs

Opposite to roll forward, it will be great to have the possibility to perform a rewind of a database (in roll-forward state or normal one), to a previous state with the logs. It will be like uncommit, or a general rollback.

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

2 VOTE

"delete cascade" does not work with "not enforced"

The option "not enforced" on a foreign key invalidates an already set "on delete cascade" option, although this is not visible anywhere within the data model or documentation. In my opinion, setting one of these options should prohibit the other o...

over 1 year ago in Db2 / Tables/Index (Range MQ MDC etc.) 0 Not under consideration

10 VOTE

Include a comment in the backup

It will be great to include a comment each time a backup is executed. The comment value is included in the history file, it only needs to be used by the backup command.

over 7 years ago in Db2 / Backup/Restore/ Rollforward/ Recover 3 Not under consideration

8 VOTE

Create User Temporary Tables in round robin

Assuming that there is more than one temp tablespace with the same page size and 'IN TABLESPACE' clause is not specified in the DECLARE GLOBAL TEMPORARY TABLE command, then DB2 optimizer should allocate the temp tables across all temporary tablesp...

almost 6 years ago in Db2 / BLU Acceleration 0 Not under consideration

9 VOTE

remove all world writable permissions on files and directorys see also 79173

Our Security does not want to see files and directorys which have the world writeable permission set se also fea 79173 PMR is case TS000140222

over 6 years ago in Db2 / Security 0 Not under consideration

Please enter your email address

FILTER BY CATEGORY