In a DB2 HA environment using TSAMP, here is what goes on in the background when certain DB2 commands are run.
Running db2stop will lock the Instance resource group where the stop is issued against. Consequently the HADR Database will fall out of peer state and the DB2 engine will request that the HADR resource group gets locked, preventing the resources from being restarted automatically by TSA.
Running db2start will unlock the instance resrouce group, once the DB automatically reintegrates, the lock... [More]
I was working on a DB2 installation issue using db2setup wizard with 9.7 GA (FP0) on AIX 7.1, JDK 5 , the installation was failing with Segmentation fault error, the installer has generated java cores, similar to the one shown here below:
Type= Segmentation error vmState=0x00000000
In general, basic things to look at when these kind of errors happen are:
Looking for supported combination of DB2 Client and DB2 Server versions on Linux,Unix and Windows?
For DB2 V9.7 on LUW:
Supported combination of DB2 Client and DB2 Server
Supported combination of DB2 Connect on LUW and DB2 on I-Series / DB2 on Z/OS servers
Supported combination of IBM Data Server Driver for JDBC / SQLJ driver and DB2 database version
For DB2 V9.5 on LUW:
Supported combination of DB2 Client and DB2 Server
Supported combination of DB2 Connect on LUW and DB2 on I-Series / DB2 on Z/OS... [More]
In the beginning of May, IBM significantly updated the IBM Support Portal support site, with improvements to make this worldwide one-stop site for technical resources for all IBM products even more effective and useful for our clients. Some are adjustments our clients have requested, others are redesigns to improve our clients' efficiency finding the information they need. Here's a quick rundown of new capabilities to look for.
Several enhancements have been made to the product selection function.
In the “Choose your products”... [More]
Are you new to DB2 for Linux,Unix and Windows? Here are some of the useful links for you to bookmark: DB2 for Linux, UNIX and Windows Trial Downloads can be found here: http://www.ibm.com/software/data/db2/linux-unix-windows/download.html DB2 Fixpaks by version can be downloaded from here: https://www.ibm.com/support/docview.wss?uid=swg27007053 How to obtain DB2 License: https://www.ibm.com/support/docview.wss?uid=swg21305417 DB2 Product manuals and links to information centers: ... [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... [More]
This technote describes how the number of jobs that a DataStage project can have may be impacted by Operating Systems' limitations. When you reach the maximum number of folders the OS allows then you won't be able to create new jobs. Please refer to the technote that lists some suggestions about how to address this problem.
Looking for some help on how to resolve the error DBA7908E .
Then you're in luck because we have put together the following tech doc
to help you with that: DBA7908E error upon connection to a new DB2 for z/OS system. Still seeing the error or have questions about it, then please feel free to comment below.
I had opportunity to implement AES encryption from a Java program using a DB2 JDBC driver with ORACLE Java. Here are all the steps I took:
1> On client machine, installed ORACLE Java 7:
C:\Program Files\Java\jdk1.7.0_45\jre\bin>java -version
java version "1.7.0_45"
Java(TM) SE Runtime Environment (build 1.7.0_45-b18)
Java HotSpot(TM) Client VM (build 24.45-b08, mixed mode, sharing)
2> On server, I changed the... [More]
In this blog,you will find few Standardization Rules Designer related resources available for you
1. Education Assistant: Using the QualityStage Standardization Rules Designer in the InfoSphere Information Server Version 9.1
This link points to an IBM Education Assistant module about how to use the Standardization Rules Designer in InfoSphere Information Server QualityStage Version 9.1
2. Tutorial: Enhancing an address rule set in the Standardization Rules Designer
In this tutorial , you will use the IBM... [More]
If you have a .NET application utilizing DB2 drivers on Windows 64-bit that is crashing in the following stack (in MS dumps), what would you do to fix the problem?
44 Id: 1350.b98 Suspend: 1 Teb: 000007ff`ffeb0000 Unfrozen
Child-SP RetAddr : Args to Child
: Call Site
00000000`0a31acc8 000007fe`fd3a10dc : 00000000`00000000
00000000`07eb3eab 00000000`00000000 00000000`00000000 :
00000000`0a31acd0 00000000`07d457bd : 00000000`00000000... [More]
100 Tech Tips: #82: Find IBM Netezza on the Support Portal! Attention IBM Netezza Clients: You can now search for and select IBM Netezza in the Support Portal to find IBM Netezza information, technical documents, sign up for automated notifications about your Appliance, and open service requests. Click this link to access the Support Portal with IBM Netezza already selected in your product list. As you become familiar with the Portal, here are a few tips: The following images are from the Support Home tab of the Portal.
We'll keep this post short and sweet :)
Fix pack 5 for DB2 for Linux, Unix, and Windows 9.7 was released today! Click here to download the fix pack . If you are looking for a Fix Pack for another version of DB2 for LUW, visit this page to view all available Fix Packs .
The Power of Collecting
Your IBM software isn't working as you expected it to, so you're ready
to call IBM Support to get the help you need. Before you pick up the
phone, search the IBM knowledge base and see if there is a Collecting
Data document related to your situation.
Collecting data documents (formerly MustGather documents) aid in
problem determination and save time resolving problems by explaining
what information needs to be gathered before calling IBM.
Collecting data documents are an extension of the... [More]
We have completed our series of 100 technical support tips! See our blog to mark the end of the series here! A few of you have asked for a full summary of our tips broken down by product area... so here you go!
#7: DB2 License key
#8: DB2 on LUW Problem Determination Guides #10: Common DB2 Security Issues
#14: New Explain feature in DB2 9.7: section explain & ... section actuals #16: Where can I find the NES 32 and 64 bit index migation tool for Windows?
#18: Frequently Asked DB2 Questions
#19: New to DB2 for... [More]