Question : I’m somewhat puzzled by the scenario below. The table involved (relevant parts) is defined as: CREATE TABLE Nya. […]
Tag: db2-luw
How to determine the root cause of a performance spike during a heavy load on DB2?
Question : I am testing the performance of an application that links to a DB2 database engine at the back […]
Retrieving auto-generated keys for an INSERT statement
Question : What is the best way to retrieve an auto-generated keys after an INSERT statement ? After searching online […]
Can indexes be deactivated for particular queries in DB2?
Question : I’m trying to evaluate the impact of a new index on various queries that run against a DB2 […]
How to retain backups if automatic backup is enabled
Question : Is there a way to retain the backups or configure the interval when they are deleted? According the […]
Improving performance of mapping standardized values with non equi joins – LIKE operator
Question : I have a large-ish data warehouse staging table (~2.5 million rows) that is using a mapping table to […]
How to assign minimal privileges for create view
Question : In Db2 v11.1 on Linux we have a request to create a new user with access only to […]
Why do SQL Server uniqueidentifier values look different when converted to Db2?
Question : I am currently trying to convert a SQL Server database to DB2. I am using the Data Conversion […]
db2ckbkp – How to determine what tablespaces are temp-tablespace
Question : I am writing a script to restore databases from backup. The script should need as little input as […]
DB2 huge IREF and lots of scans
Question : I received a task from one of my colleagues to check why he always receives high CPU load […]
- 1
- 2