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.
Are you considering ‘Admin move table’ for reorganization work of your tables ? And are you finding the way to reduce time of last ‘SWAP’ of admin move table work ? Nowadays, our database systems have so many number of tables and the tables are getting bigger. And as a database administrator, we are facing the reality that we need to do the time consuming work for maintaining huge tables and business departments usually do not permit enough time to work on those on weekends offline maintenance work time windows.... [More]
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 simultaneously:... [More]
Issue: NullPointerException was thrown when one of our customers tried to load latest DB2 JCC driver (db2jcc.jar - V10.1 and above) using a custom class loader ( like open source module NestedJarClassLoader). The same worked while loading old DB2 V8.2 db2jcc.jar driver (2.11.24). Here is the error stack: Caused by: java.lang.NullPointerException at com.ibm.db2.jcc.am.md.run(md.java:49) at java.security.AccessController.doPrivileged(Native Method)... [More]
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]
One of the most valued assets that IBM Information Management Support has... is YOU! You provide valuable feedback to our technical support process through your insights when talking with us, providing feedback to our documentation, engaging with us here, on Facebook, or on Twitter, or anytime and any way you interact with IBM. For that, thank you! Now, we're "test piloting" a new way for you to engage, called "discuss on developerWorks". We've targeted a select set of technical support... [More]
First off, Happy New Year! I hope 2011 finds you and yours safe and well. Second, we want to share a compliment we are very proud of: In December, we posted a video to help explain how IM Support uses Knowledge-Centered Support (KCS) and some of the benefits: http://ow.ly/3yKEO David Kay, one of the leading voices in KM and KCS, just posted a "pat on the back" for the video in his blog: Communicating KM to Customers: IBM does it right We're still maturing as an organization using KCS, but hopefully you've seen... [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 db2 stop... [More]
Abstract: 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. Troubleshooting: 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 boxes, then db2pd needs to be run on... [More]
You are invited to join us for a free education session covering Upgrading from Initiate 10.1 to IBM SE MDM V11.4. Date: Wednesday May 13 Time: 10:00 AM - 11:00 AM Eastern Registration Link: https://events.na.collabserv.com/register.php?id=4991bb3d43&l=en-US Abstract: In this presentation we will provide an overview on upgrading from Initiate v10.1 to IBM InfoSphere MDM v11.4. The steps to upgrade the Initiate database to MDM v11.4, to point the new MDM installation to the upgraded database and verification of the upgrade process will be... [More]
Connections being rejected on a V9.8 pureScale environment Any connections being made to the database that is on a v9.8 pureScale instance is experiencing a connection hang and instance may experience a 'hang' like situation. If we take a few iteration of stacks (db2pd -stacks all -rep 10 5), and the stack analysis may have the following output: 0x0900000000533990 _p_nsleep + 0x10 0x0900000000038BE4 nsleep + 0xE4 0x090000000015B290 nanosleep + 0x190 0x0900000007058B60 ossSleep + 0x80 ... [More]
During crash recovery, if many load operations have to be replayed, then it might take a long time to complete. The load operation will keep the pending operations in transaction logs no matter if it is recoverable load or non-recoverable. These pending operations will be kept in transaction log just before the table status is changed back from "load in progress" state to "normal" state. If the crash recovery starting point - min(lowtranlsn, minbufflsn) is before load pending operations then db2 will have to replay... [More]
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 firstname.lastname@example.org 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]