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.
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 works. ... [More]
Yesterday, we shared the top Informix technical docs and, of course, we don't want our DB2 LUW friends to feel left out! So, without further ado, here are the most popular technical documents for DB2 for Linux, Unix, and Windows:
27 Oct 2011: DB2 Fix Packs by version for DB2 for Linux, UNIX, and Windows 16 Apr 2011: DB2 UDB Version 8 - End of Support date 30 Apr 2012: DB2 UDB Version 9 - End of Support date 15 Jun 2011: DB2 database product documentation 30 May 2011: DB2 UDB Version 8 Product Manuals 30 May 2011: DB2 Version 9.1 for Linux,... [More]
Consider the following scenario, in a DB2 HADR configuration using ASYNC mode. Presently,the log files were extracted from TSM to a local file system on the standby server. Standby database was deactivated and re-activated causing the standby to go into LocalCatchUp state. However, its unable to read the local log file because its considered as a "stale" file and the standby re-enters a RemoteCatchUp state. This process was repeated two to three times and the standby fails to read the log file and switch HADR to RemoteCatchUp... [More]
Here is a simple DB2 command which will display the DB2 products that are installed on the system: db2ls - it displays the Install path, product level, fix pack details, Special Install Number, Installation date , Installer UID. The db2ls command is the only method to list all DB2 product at Version 9 or later. However you cannot use the db2ls command on Windows operating systems. $ db2ls Install... [More]
Hello! Many have been utilizing the light weight deployment solution i.e. IBM Data Server Driver Package that provides run-time support for applications without the need to install Run-time Client/Data Server Client. We already have DS Driver install demos for Windows out there, but not for Unix platforms, So, I would like to take this opportunity to share a demo of IBM Data Server Driver install in a Unix environment. The documentation is in our Knowledge Center:... [More]
Hello db2 DBAs Have you encountered any db2 instance hang situations where in the db2fodc -hang command also hung? Fear Not! I have created a template that walks through the commands to execute at various levels i.e. db2 instance / database etc manually to collect the hang diagnostics and provide that to the support team. It would make the diagnosis of the hang much easier :) Step 0. Clean out sqllib/db2dump directory, move or remove any FODC_* directories from this directory to keep the db2support.zip file small. ... [More]
When installing DB2 Universal Database for Linux, Unix, and Windows version 10.5, the installation script no longer lists the "ESE" (Enterprise Server Edition) and "AESE" (Advanced Enterprise Server Edition) options as it did with earlier versions. They have both been replaced with the option of "SERVER". The other options have remained the same. The reason for this is that whether you have "ESE" or "AESE" depends solely on the license you install (EG the actual libraries that are installed are... [More]
Using a simple test case. This can be easily observed. Document was exported using a utility that applies a byte order mark to text documents. db2 "create table numbers (col1 char(10),col2 char(10),col3 char(10))" DB20000I The SQL command completed successfully. [db2v97@ts-carose2 ~]$ db2 import from numbers.csv of del insert into numbers SQL3109N The utility is beginning to load data from file "numbers.csv". SQL3110N The utility has completed processing. "2" rows... [More]
I am quite sure that most of you are using 'svmon' utility with various option to monitor the memory utilisation on AIX box. The most useful option I found is 'P'. It quickly shows you the approximate memory consumption at process level: $ svmon -G size inuse free pin virtual ... [More]
Hello All, Need help navigating through Passport Advantage to find your DB2 license key. Then you're in luck because we have put together the following to help you with that: Purchasing a License for DB2 LUW V9 How do I download my DB2 license from Passport Advantage Passport Advantage and Passport Advantage ExpressPerform more complex management of your product list Still have trouble or just have a question about your DB2 License key, then comment below.
New Video - How IBM uses Knowledge-Centered Support (KCS) In Information Management Technical Support, we've invested a lot of time, training, and effort improving our Knowledge Base by implementing Knowledge-Centered Support (KCS). I'm excited that a new video has been posted which helps explain the KCS process in IBM: Together, we are making support better!
Do you know how to get the status of the section of a package in DB2, here's an easy command to retrieve this information by querying the system catalogs: DB2 on zos: Verify the status of the section from DB2 Client against DB2 zos by issuing the below statement: (Normally this is handy when SQ0525N bind error occurs) db2 "select contoken, SEQNO, STMTNO , SECTNO, STATUS FROM SYSIBM.SYSPACKSTMT WHERE COLLID = 'NULLID' AND NAME = 'SQLUAK20'" C Compiled -... [More]
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]
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]
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). Buffer... [More]