What is the difference between instance upgrade and update?  Upgrade refers to the fact that you are moving from a different release of DB2 to a higher level of release. Meaning, if you are currently on V9.5 of DB2, then you moving to V9.7, V10.1, V10.5 or any higher release available would mean you are upgrading.   Update would mean that you are on the same release, but you are moving up on the fixpack level of the same release you are on. An example would be, if you are currently on V9.7fp5 (DB2 release V9.7, fixpack 5), and... [More]

Tags:  update db2 instance 75_db2demystify db2_techtip upgrade

Data explosion with the increased use of cloud and mobile services has resulted in organizations looking for efficient ways to manage data.  In the past we had several disparate product used to manage in-depth specific attributes of data which resulted in too many tools, repositories, installs and management overhead. In IBM Data Server Manager we have introduced a light weight, easy deployment, performance and scalable tool that provides performance monitoring, configuration management, database administration, SQL and workload tuning all... [More]

Tags:  manager db2 data tools dsm server

Problem:   When trying to upgrade a V9.7 instance to V10.5 instance, upgrade fails with the following message:   A minor error occurred during the execution.   For more information see the DB2 installation log at "/tmp/db2iupgrade.log.30983". DBI1264E  This program failed. Errors encountered during execution were       written to the installation log file. Program name:       db2iupgrade. Log file name: /tmp/db2iupgrade.log.30983.     Checking /tmp/db2iupgrade.log.30983 , we... [More]

Tags:  invalid db2iupgrade 75_db2demystify component db2_techtip dbi1453e

Today, I came across an interesting issue and I would like to walk through the problem and the details taken to resolve the issue.   Problem: db2icrt fails with, ERROR: DBI1281E The database manager configuration file could not be initialized.   I have a repro to illustrate this.   [root@hobbits instance]# ./db2icrt -d -u instedi instedi DBI1446I  The db2icrt command is running.     DB2 installation is being initialized.    Total number of tasks to be performed: 4 Total estimated time for all tasks to be... [More]

Tags:  dbi1281e db2_techtip the error: db2icrt 75_db2demystify configuration dbi1264e

Abstract: There would be a requirement for locating the top N heavy accessing tables in the database for the performance diagnostic purpose. A common tool called db2top is mostly used by DBAs for tracking such performance metrics. However, db2top monitoring has a big performance impact because it uses db2 snapshot mechanism to maintain the counters in the monitor heap which incurs a lot of performance overhead. This article introduces an easy and quick method to detect your top N  heavy scanned tables in the database by using db2pd. db2pd... [More]

Tags:  75_db2demystify db2pd db2_techtip performance heavy tables scanned

In an automated High Availability Disaster Recovery (HADR) environment, rolling upgrade procedure will not work when upgrading from an earlier to a later version of a DB2 database system. For example, you cannot use this procedure to upgrade from a DB2 Version 9.7 to Version 10.x. Use this procedure in an automated HADR environment when you upgrade your DB2 versions 10.1 and 10.5 from DB2 Version 9.7. The following steps must be completed:   1. From CLP, as the instance owner, stop HADR on both standby and primary servers by using db2 stop... [More]

ONLINE BACKUP could encounter performance issue in pureScale environment. This is because of contention on SQLO_LT_SQLB_POOL_CB__olbRangeLotch' ( Online Backup range latch) The problem happens in pureScale only. Non-pureScale environment isn't vulnerable. Symptom: When the problem happens, multiple DB2 prefetchers (EDU name 'db2pfchr') can be observed competing for 'SQLO_LT_SQLB_POOL_CB__olbRangeLotch'. More specifically: 1. 'db2bm' EDU is stuck in following stack trace, waiting on data from prefetchers:... [More]

What is an orphan row in DB2 system catalog tables? Orphan rows in system catalog tables are entries for which corresponding dependent entry in another sytem catalog table is missing Example: Let's consider a SAMPLE database which has table DEPARTMENT and view VDEPT. There will be records in SYSIBM.SYSTABLES for DEPARTMENT and a dependency record in SYSIBM.SYSVIEWDEP for VDEPT db2 "select creator, name from sysibm.systables where name='DEPARTMENT'" CREATOR NAME ----------------------------- SKHARCHE DEPARTMENT 1 record(s)... [More]

Hello,          Are you looking for sample response files to install DB2 using silent installation? A response file is a text file that contains setup and configuration values. The file is read by the DB2 Setup program and the installation is performed according to the values that have been specified. A response file installation is also referred to as a silent installation. 1)   The sample response files are located in the DB2 Image downloaded: Under: ...<extracted... [More]