Db2

Showing 1392 of 15539

Conversion DECIMAL do CHAR

We are in the process of migrating data from Db2 z/OS to Db2 LUW. In our many programs we convert DECIMAL data into CHAR, e.g. to display it on the reports in a readable format. Unfortunatelly Db2 LUW formats data diffrently than Db2 z/OS. Let us ...

10 months ago in Db2 / Application Development 1 Submitted

5 VOTE

Add a field in MON_GET_TABLE function to check whether Restrict on drop is enabled or not for a table

Missing Restrict on Drop clause while creating table can be costly! (DB2LUW) DB2 LUW provides a clause called "Restrict on drop". This clause should be used while creating a table. With Alter statement it can be disabled too. Why missing this clau...

5 months ago in Db2 / Tables/Index (Range MQ MDC etc.) 2 Functionality already exists

26 VOTE

dmctop for zLinux

We have several Db2 LUW running on zLinux. Because dmctop is not compatible with zLinux, we're still using db2top but would like to explore new functionalities/features offered in dmctop. Just to clarify: Currently, dmctop does not work on zLinux ...

over 2 years ago in Db2 / Monitoring 7 Not under consideration

85 VOTE

Table partitioning for column-organized tables

Column-organized tables are currently not supported for table partitioning (e.g. PARTITION BY RANGE)..At the same time, table partitioning is used by many data warehouse customers to speed up ETL activities - e.g.:(a) load new data into a separate...

over 7 years ago in Db2 / BLU Acceleration 0 Future consideration

39 VOTE

Allow IAM access for server to S3 to work for Db2 backups

AWS allows a server or container to have an IAM role that allows access to S3 and other resources without authentication. However, cataloging a storage alias requires a key and secret key to work, regardless of whether the IAM role is set up for t...

over 3 years ago in Db2 / Backup/Restore/ Rollforward/ Recover 4 Future consideration

2 VOTE

Support local authentication method to manage credentials on DB2 using Hashicorp Vault

Customers who are using local authentication for Informix need a way to utilize the password management features for Hashicorp Vault https://developer.hashicorp.com/vault/docs/secrets/databases/db2

2 months ago in Db2 / Security 0 Submitted

6 VOTE

Automatic migration of EXPLAIN tables in db2 LUW

Dear Team, We have seen whenever we migrate to higher version of db2 luw, the explain tables are not automatically migrated. We need to manually drop and recreate the explain tables to avoid errors like SQL0206N, SQL0220N, SQL1184N. As db2 modific...

7 months ago in Db2 / Installation & Upgrade 0 Submitted

55 VOTE

Online index reorg for pureScale

Currently online index reorganization is not supported in Db2 pureScale environments and will fail with SQL1419N.

about 5 years ago in Db2 / pureScale / Tables/Index (Range MQ MDC etc.) 2

18 VOTE

Optimizer does not use HIGH2KEY/LOW2KEY for columns with COLCARD 1

Optimization issue if a business_time_oriented table has only one row. In syscat.columns the content of the business_time columns are detected (high2key, low2key) but the value can not be found in the distribution statistics. This leads default fi...

over 1 year ago in Db2 / Statements (DDL and DML) 1 Future consideration

2 VOTE

Data Management Console: Using for monitoring the current Event Monitor Data, which are configured (DB2STATISTICS, DB2ACTIVITIES, DB2THRESHOLDS)

Using for monitoring the current Event Monitor Data, which are configured (DB2STATISTICS, DB2ACTIVITIES, DB2THRESHOLDS)

2 months ago in Db2 / Data Management Console 0 Submitted

Please enter your email address

FILTER BY CATEGORY