Part of the IBM Analytics family, focused on Analytic Platform product support. This blog is administered by Andrew McCarl (amccarl) and Kate Nichols (KateDawson), and follows the IBM Social Computing Guidelines.
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... [More]
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... [More]
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
DBI1264E This program failed. Errors encountered during execution were
written to the installation log file. Program name:
db2iupgrade. Log file name:... [More]
Today, I came across an interesting issue and I would like to walk through the problem and the details taken to resolve the issue.
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.
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... [More]
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... [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.
When the problem happens, multiple DB2 prefetchers (EDU name 'db2pfchr') can be observed competing for 'SQLO_LT_SQLB_POOL_CB__olbRangeLotch'.
1. 'db2bm' EDU is stuck in following stack trace, waiting... [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
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'"
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]
No, you don't. Few days back, customer asked me "Why DB2 needs exclusive connection while retrieving just logs? We do understand that during restore DB2 may need exclusive connection but we are trying to restore just logs here".
This is my repro of what customer was saying:
db2 backup database DSTEST97 online include logs
Backup successful. The timestamp for this backup image is : 20150416113124
<<Here in other session I created a connection to... [More]
Rocks, Paper, Scissors?
Heads or Tail?
Good guess's but none of the above.
A tiebreaker is a object used in a DB2 HA (High Availability) cluster environment comprised of even number of nodes.
In such a cluster environment, when both nodes cannot communicate with each other, the tiebreaker is used by both nodes to see which node is still active and can continue to host cluster resources. This in essence, is " breaking a tie ", hence, a tiebreaker.
A tiebreaker... [More]
In DPF environment, the lock timeout issue could be caused by indoubt transactions. The indoubt transactions cannot be automatically committed or rollback by database manager therefore whenever the application restarts the lock timeout issue occurs.
Collect the locking data by:
db2pd -db <dbname> -alldbp -wlock -app -trans -repeat 5 10
Note that the above db2pd must have -alldbp option which runs on each logical node on one physical box, if there are multiple physical... [More]
Most default installations of DB2 when bundled with other products lays out the database and storage spaces in its most basic form. Usually it has USERSPACE1 where all of the data are stored by default. Over time as the data grows your so does the time it takes to backup your database bringing it to unacceptable levels.
It has also been observed that in such situations a restore operation of the same database completes in a fraction of the time. To explain this phenomenon it is important to understand the Buffer Manipulator (BM).
After yesterday's blog announcing our May 14 Support Technical Exchange session , we're back with yet another opportunity for you to build your skills in May!
Register for our May 21 Support Technical Exchange: Configuring the Complex Flat File Stage in InfoSphere Information Server
Access to data in mainframe files is on the rise and poses tricky challenges to extract this critical data. The Complex Flat File stage is a file stage designed to process complex EBCDIC and ASCII... [More]
Join us for our upcoming Support Technical Exchange! Our speaker, Gary Foster, will guide us through a deep dive on I BM InfoServer DataStage PX Engine - Lookup Stage.
The parallel lookup stage is one of the most used stages in PX job design. In this presentation, Gary will show the options for use, case scenarios and how this stage works internally so you can make better decisions on how to use this stage in your job designs. With proper use, you can capitalize on available resources and maximize performance of your jobs.... [More]