db2-luw Archives

non-optimal use of index

By adminPosted on December 15, 2022

Question : I’m somewhat puzzled by the scenario below. The table involved (relevant parts) is defined as: CREATE TABLE Nya. […]

By adminPosted on June 21, 2022

Question : I am testing the performance of an application that links to a DB2 database engine at the back […]

By adminPosted on February 19, 2022

Question : What is the best way to retrieve an auto-generated keys after an INSERT statement ? After searching online […]

By adminPosted on January 11, 2022

Question : I’m trying to evaluate the impact of a new index on various queries that run against a DB2 […]

By adminPosted on December 23, 2021

Question : Is there a way to retain the backups or configure the interval when they are deleted? According the […]

By adminPosted on November 7, 2021

Question : I have a large-ish data warehouse staging table (~2.5 million rows) that is using a mapping table to […]

By adminPosted on October 8, 2021

Question : In Db2 v11.1 on Linux we have a request to create a new user with access only to […]

By adminPosted on August 24, 2021

Question : I am currently trying to convert a SQL Server database to DB2. I am using the Data Conversion […]

By adminPosted on June 10, 2021

Question : I am writing a script to restore databases from backup. The script should need as little input as […]

By adminPosted on May 14, 2021

Question : I received a task from one of my colleagues to check why he always receives high CPU load […]