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.
As guardians of data we are constantly faced with the challenge of moving data from one platform to another for a multitude of reasons. We faced such challenge at one of my favorite client location where most databases were being migrated to reside on private cloud environment. A standard procedure in order migrate a few hundred database instance into a Linux cloud farm was built.... [More]
When using DB2 HADR the local service/port (HADR_LOCAL_SVC) and remote service/port (HADR_REMOTE_SVC) are defined. But, why netstat output shows that hadr is using other port numbers too ? Both HADR_LOCAL_SVC and HADR_REMOTE_SVC are used as the lower level TCP server listener port numbers only. The client side of the TCP uses free ports available from OS from that side. HADR uses TCP server and TCP client at the lower level. In this context, one HADR db side listens on its hadr_local_svc port as TCP server, the... [More]
As of now, DB2 on Windows supports ActivestatePerl (both 32bit and 64 bit) and Strawberry Perl (32 bit ONLY). To get the 32 bit DBD::DB2 binaries supported with 32 bit Strawberry Perl, you must email email@example.com or contact IBM support for the required binaries. 64 bit Strawberry Perl is not supported yet. Thanks!
Attention MDM users! We are pleased to share a FREE education session available in April: Upgrading to MDM v11 . This session is now complete. Click here to watch the replay . Date: April 7, 2015 Time: 10:00am - 11:00am ET Session description: In this presentation, we will perform a comprehensive overview of the MDM v11 upgrade process. We will begin the session by reviewing how MDM v11 differs from our previous releases of MDM Advanced Edition and MDM Standard Edition from a technical perspective. Next we will outline... [More]
Hello everyone, Today, we're pleased to share a new blog series running in the IBM PureData-Enzee Community. The series will cover 50 Nuggets of Wisdom from our experts in the PureData for Analytics support team! You can see the blogs in the series by regularly visiting the Community and following the nuggets tag . The first blog in the series covers step-by-step instructions to Collect a Health Check Report from your system. Find the blog by clicking the link above. Looking forward to reading the great tips from the PDS... [More]
When performing a DB2 fixpack upgrade (rolling upgrade), for example from DB2 V9.7 FP8 to DB2 V9.7 FP9, in an HADR environment where HADR_SYNCMODE is set to SUPERASYNC as shown below : HADR database role = PRIMARY HADR local host... [More]
There are 6 new InfoSphere Information Server IEA modules in production and 2 existing InfoSphere Information Server IEA modules have been revised and deployed to production. New: Configuring LDAP with Information Server 11.3 with WebSphere Liberty - This presentation discusses how to configure Information Server version 11.3 for LDAP authentication with WebSphereLiberty.... [More]
Have you ever wondered why during a DB2 fixpack upgrade on a DPF environment, db2iupdt fails with DBI1167E "DPF instance cannot be updated from non instance owning nodes."? Beginning in DB2 V9.5, fixpack upgrade was enhanced on Unix and Linux platforms to only run db2iupdt on instance owning node. Prior to DB2 V9.5, db2iupdat didn't do a hostname check. This was first introduced in DB2 V9.5. This check was done to ensure that the instance update only happens on the node defined on the first line of db2nodes.cfg for DPF instances.... [More]
Hello DB2 DBAs Hope you are having a nice time during this holiday season! I recently helped a diligent DBA who was concerned about this security bulletin and ended up providing more details. So wanted to share with you all especially the ones who end up supporting this Text Search extender. Here is the link to this tech advisory which is very cryptic. http://www-01.ibm.com/support/docview.wss?uid=swg21682096 Security Bulletin: IBM DB2 Accessories Suite for Linux, UNIX and Windows denial of service vulneribility (CVE-2013-5879)... [More]
Hello DB2 DBAs! Hope you are having a nice time during this holiday season! I recently helped a customer who was running into the disk full condition causing the database to hang with a twist . So wanted to share with you all!! Typically it would be due to a open transaction which caused the transactions to exceeed log primary + log secondary logs. db2diag.log would have details about that errant application handle which caused the log full condition to occur. A typical entry would be like this.... [More]
There are 3 error messages that commonly occur related to Stored Procedures and Functions (collectively referred to as routines). These are SQL0440, SQL1131 and SQL0443. A SQL0440 returns an error indicating the routine does not exist. Usually when this error occurs the routine does exist but is being called incorrectly. Routines can be overloaded so two or more routines can be created using the same schema and name if they use either a different number of input or return variables (3 input as opposed to 2) or different data types... [More]
How do you keep the result of overall SQL performance data in your DB2 system ? I could see many DB2 mates have used our long last friend DB2 dynamic SQL snapshot for checking performance statistics of SQL statements. And we have another friend 'mon_get_pkg_cache_stmt' who shows more performance aspect especially in elapsed time perspective. Some smart DBAs regularly gather this result and keep in a table to see the changes and trend. It's also good idea to load the data into other database if you have. Somebody call it as... [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]
Are you stuck with DB2 installation/upgrade/migration? I am listing down few common check points to start with: 1. Please look for any db2 related processes running on the system. You may run 'ps -elf | grep -i db2' on unix or look for db2* processes in task manager on windows and see what db2 processes are running. You may want to shutdown/kill the process if it is not required. 2. Please make sure *all* db2 filesystems are mounted and accessible. 3. Please make sure you have enough free space under /opt, /tmp and db2 instance's... [More]
Hello, To troubleshoot an issue with complex CLI application, DB2 CLI script with similar functionality can be used. In many cases, customers usually have a complex CLI application that run into issues. To simplify the issue and to quickly gather diagnostics, we often ask customers to try with a simple DB2 CLI script. Here are some Windows based examples: 1. To test the CLI connectivity to the remote database from the DB2 Client where the application... [More]