Here is a collection of useful DB2 Performance Tips from our DB2 Advanced Problem Determination team, please visit this link for details which currently includes the following blogs:
Mystery behind SQL1229 error on DPF systems
What to do when CPU spikes up
Range Partitioned tables and long compile times
How to track and collect data for a long running query
Looking for step by step instructions for Installing DB2 on Windows?
Here are the education modules available with detailed description of each step in DB2 installation on Windows Operating System.
Installation of DB2 on Windows - Overview
DB2 installation on Windows
Fix pack upgrade installation on Windows
Refresh, modify, or repair an installation on Windows
There are situations where in a HADR environment, transaction on the Primary are blocked(applications will seem to hang) when the HADR database is in peer state and there is a network event (network congestion/network down or the Primary does not receive ACK from the Standby-Standby log buffer full). This can be explained with the help of Brewer's CAP theorem.
Brewer's CAP Theorem:
Brewer's CAP theorem states that, in a Distributed Computer System, we can guarantee only two of the following... [More]
Looking for a way to test Automatic Client Re-route using a simple JDBC program that uses IBM data server driver for JDBC & SQLJ (JCC) & JDBC DriverManager Connection?
Here are the steps to follow:
Step 1 : UPDATE ALTERNATE SERVER INFORMATION in BOTH PRIMARY & STANDBY SERVERS:
Lets assume that following are the Primary and Standby Server's hostnames and Port numbers.
Database: SAMPLE on both systems.
a) On DB2 Primary system:... [More]
Do you know the instance memory limitations for DB2 Workgroup Server Restricted License for different DB2 versions?
First of all, I would like to explain what DB2 Workgroup Server Edition (WSE) Restricted License (db2wse_o.lic) means. Its nothing but that your DB2 database product was obtained as part of another IBM® product. In this case, the license terms of the bundling product takes precedence over the usual DB2 Version Workgroup Server Edition license terms.
The DB2 license command ' db2licm -l ' will display the... [More]
Recently I came across a PMR, customer was using sysproc.automaint_set_policyfile to perform reorg check. More details about sysproc.automaint_set_policyfile here . After performing reorg, customer wanted to remove the policy file. We can set automatic maintenance off using different ways i.e set db cfg parameter auto_maint off, or turn auto_reorg to off in db cfg. However this is not what customer wanted to do. Customer was interested in removing the policy file than just turning off automatic maintenance. Even with automatic... [More]
DB2 LUW has two basic edition classifications Clients and Servers. Clients include drivers and full DB2 clients. Servers include both DB2 and DB2 Connect servers. DB2 Clients do not require a license to use when connecting to DB2 LUW servers. DB2 servers include DB2 client code and if no permanent license is installed the server functionality will be unavailable once the trial period expires but the client code may still be used. To license purchased DB2 LUW server products two licenses will need to be installed.
One license referred to... [More]
DB2 LUW is capable of running stored procedures and functions coded in several languages. Among these languages is Java. Since Java stored procedures and functions, (collectively referred to as routines) require a JVM there are some configuration settings that are specific to this type of routine. DB2 comes with a JDK and by default it is this JDK that is used to run Java routines. It is possible to alter DB2 to use another JDK to run Java routines. JDKs that are supported to run routines are documented in the DB2 infocenter for each release.... [More]
Export from 64-bit windows - machine 1, import to 64-bit Windows- machine 2:
- db2cfexp with template/backup option on machine 1 (may contain both 32 and 64-bit ODBC DSN)
example: db2cfexp template <template.txt>
- db2cfimp on machine 2
example: db2cfimp template.txt
64-bit ODBC DSN:
All 64-bit ODBC DSN's are imported. No additional steps required
32-bit ODBC SYSTEM DSN:
Manually issue: db2cli32 registerdsn -add -alldsn... [More]
Hello DB2 Readers!
Looking for useful tips to solve some DB2 for Linux, Unix and Windows common problems. Here is a knowledge Collection of new DB2 Technotes published in Q1 2014 organized under different categories. Please review.
"The registry does not exist" error messages in db2diag.log for file global.reg
db2pd errors out with 'Failure: pdRememberInstanceOwnerID, rc: 0x870F00B4'
Here is a quick way to find the enhancements included in Fix Packs for DB2 For Linux, Unix and Windows for different versions:
DB2 Version 10.5 for Linux, UNIX, and Windows fix pack summary
DB2 Version 10.1 for Linux, UNIX, and Windows fix pack summary
DB2 Version 9.7 for Linux, UNIX, and... [More]
Here are some of the interesting DB2 on LUW resources:
The DB2Night Show:
SQL Tips for DB2 LUW:
Continuous availibility is the concept that enables 24/7 access to IT-enabled business functions, processes and applications.
And minimizing planned downtime is what business and IT departments consider seriously nowadays.
Especially, minimizing and setting the appropriate downtime is a bit challenging decision in case of DB2 version upgrade or migration to another system, because we also need to consider the time for getting back to original system in preparation for any unexpected problem after the planned change... [More]
I had opportunity to implement AES encryption from a Java program using a DB2 JDBC driver with ORACLE Java. Here are all the steps I took:
1> On client machine, installed ORACLE Java 7:
C:\Program Files\Java\jdk1.7.0_45\jre\bin>java -version
java version "1.7.0_45"
Java(TM) SE Runtime Environment (build 1.7.0_45-b18)
Java HotSpot(TM) Client VM (build 24.45-b08, mixed mode, sharing)
2> On server, I changed the... [More]
Last week, I ran into a customer problem where the 32-bit ODBC User DSN test from 32-bit ODBC Data Source Administrator (C:\Windows\sysWow64\odbcad32.exe) for a remote database running on AIX was failing with below error with 32-bit DB2 Data Server Driver Package 9.7 FP0 on Windows 7 64-bit:
We tried to create a new User DSN from 32-bit ODBC Data Source Administrator, but we could not, since it failed with the same error.
On their Windows XP, machine they have the same setup, the DSN... [More]