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.
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]
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]
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!
Recently worked on an issue with DB2 Fault Monitor (FM) process failing to start on a Linux RHEL 6 platform. After following the steps in the technical note below: http://www.ibm.com/support/docview.wss?uid=swg21209001 the DB2 Fault Monitor process was failing with the following message : # su - db2inst1 $ . ./sqllib/db2profile $ db2fm -s -S Gcf module 'fault monitor' is INSTALLED PROPERLY but NOT ALIVE Gcf module '/opt/IBM/DB2/lib64/libdb2gcf.so' is INSTALLED PROPERLY but NOT ALIVE As a result, the DB2 instance will not... [More]
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]
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]
IIUG 2015 promises to be one our best events ever. IIUG will have: a full day of tutorials, over 80 sessions, several hands-on labs and this year, they will be celebrating 20 years of the IIUG. If you miss this year's event, you're going to be missing a lot. There will be several sessions on new technologies: NoSQL and Internet of Things (IoT) both of which play well with Informix. Who can resist the ever popular sessions on performance tuning, security... [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]
One scenario you may have !! You attend a monthly DB operation meeting. Each DB administrator team from Oracle, DB2 and Sybase presents monthly events and various monitoring results. On first turn, an Oracle guy indicates a performance issue on a specific day and says an SQL has triggered the issue. And.......he shows the historical performance data for the SQL by keeping on track of the change day by day. Actually the hash key value ' SQL_ID ' of Oracle enables this kind of analysis. ... [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]
I-Spy returns an authentication error 951 when a user opens a database. Example : $ dbaccess sysmaster - 746: I-Spy: SQLERR -951 connecting to shadow server These are some possible solutions for the 951 error: Set INFORMIXSERVER to the shadowserver (database server name) in order to bypass I-Spy. If you are still seeing the 951 error, search other documents specific to the Informix server that addresses the 951 error. Check if the password for this user has expired. Check the permissions on the $ISPY_DIR/bin/realbin/ispy... [More]
Hello! I am happy because I am going to get one more second to work on my PMRs! How? Leap Second! So what is a leap second? This is a definition from Wikipedia : A leap second is a one-second adjustment that is occasionally applied to Coordinated Universal Time (UTC) in order to keep its time of day close to the mean solar time. Without such a correction, time reckoned by Earth's rotation drifts away from atomic time because of irregularities in the Earth's rate of rotation. Since this system of correction was implemented in... [More]
Information Management Bootcamps are technical workshops in a classroom setting. They are held throughout the year in different regions worldwide. These bootcamps contain detailed lectures and labs for deep-dive learning of the concerned product: Some of InfoSphere Informatiion Server specific bootcamps are listed also below : InfoSphere Information Server Bootcamp This technical workshop is for IBM Business Partners. It provides training on IBM InfoSphere Information Server, IBM InfoSphere Foundation Tools, IBM InfoSphere... [More]
InfoSphere Information Server Pack for SAP Applications helps optimize time-to-value & lower total cost of ownership by automating integration efforts for SAP applications. IBM InfoSphere Information Server Pack for SAP BW helps enhance the openness of SAP NetWeaver Business Intelligence (BI) by rapidly integrating non-SAP data into SAP BW Please find few links that are related to InfoSphere Information Server and SAP integration topics: Installing IBM InfoSphere Information Server Pack for SAP Applications 7.1 Refer to the... [More]
Hello all, I am sharing one small script to monitor the changes in HADR state. If you know better way to monitor it, please share it in comments section. Thank you! Script: #!/usr/bin/ksh set +x ###################################################################################################### # Objective: # Monitor the change in HADR state # How it works? # This is a cron job that needs to be set at OS level as DB2 instance user. # It needs to be run for every 10 minutes interval. # This script will scan... [More]