Today's Technical Tip comes from a guest blogger, Angela Yang . Angela is an Advanced Technical Support Analyst for DB2. She has been working with DB2 for the past 8 years. Angela works out of IBM's Toronto Lab. Look for more blogs from Angela on other hot DB2 topics!
Section explain and section actuals are new Explain features that are useful for query performance problem determination. This blog introduced these two features and the usage of them through exercises.
Section explain is a new feature added in... [More]
It amazes me some times how innovative DBAs can be. Truly out of the box solutions and that I want to have on my DO list. Also amazed with unpleasant surprise on what silly things some DBAs Do or fail to do and I want to have on my Don’ts list. As you run into any of the Do's or Don’ts please share them with us. Here is one. Always take a back up then periodically verify that the backup is valid (DO). Don' wait until you have to restore to validate your backup (Don’ts).
As you have likely noticed, our IM Support team has been hard at work publishing technical tips since the IBM Centennial Celebration on June 16 2011. We're going to bring you 100 tips before June 16, 2012 as our little way of saying "Happy 100th, IBM!"
In this post, you can find links to all of our technical tips broken down by product/interest area. We hope that you find these tips useful and will keep watching for more in 2012!
#7: DB2 License key
#8: DB2 on LUW Problem Determination Guides #10:... [More]
Are you interested in helping to shape future enhancements to IBM Support Portal, Fix Central, My notifications,
Service Request, and other online tools? The IBM Electronic Support user experience team is currently recruiting
clients to participate in design reviews and usability testing. You can choose from several different opportunities to participate: Drive requirements for the future What: Join the 2013 IBM Electronic Support Client Advisory Panel Who: Ideal for clients who support
or use at least one IBM product and who... [More]
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!
Have you heard about IBM InfoSphere Guardium or Guardium product as it is usually called? If not, read below a brief description of what this product can do to protect your database access with a powerful product. Or, if you have heard or have experience using the product, please share your experiences. What is IBM InfoSphere Guardium: It is a product that can be a combination of dedicated hardware (appliance) and software or just software (a virtual appliance plus additional software) . It provides a solution for
assuring the privacy and... [More]
Things to know about db2connectactivate Server Activation Tool:
You can obtain db2connectactivate license key from DB2 Connect Unlimited Edition for system z via
DB2 Connect Unlimited Edition for System z CD or
By downloading the IBM DB2 Connect 9.7, Unlimited Edition for System z Quick Start and Activation for Linux, UNIX and Windows - CI36DML from Passport Advantage
Refer to: DB2 Version 9.7 Activation key part numbers
To be more specific, this utility is present... [More]
Do you have an IBM ID? If your answer is no, you will want to register for one today because you will now need to log-in to Fix Central using your IBM ID to download fixes. It only takes a few minutes to register for an IBM ID by clicking here . Not only will registering give you access to fixes on Fix Central, your IBM Registration ID is your single point of access to IBM web
applications that use IBM Registration. The benefits of having an IBM Registration ID will
increase over time as more and more IBM applications migrate to IBM... [More]
you have questions about
DataStage? Do you need help with a trace or connection issues?
I am happy to share with you new resources to answer some of those questions! Let
Education Assistant modules help.
Let's begin troubleshooting InfoSphere
The following IBM
Education Assistant modules will help you troubleshoot IBM InfoSphere
DataStage issues for versions 7.5, 8.0.1, and 8.1.
If you want to...
Check out this module... [More]
There are two approaches to table reorganization: classic reorganization (offline) and inplace reorganization (online).
During offline reorganization as the name suggests, you do not have access to the table where as an inplace table reorganization enables you to reorganize a table while you have full access to its data. To specify an online reorganization operation, use the INPLACE option on the REORG TABLE command.
Classic table reorganization uses a shadow copy approach, building a full... [More]
From DB2 V9.7 Batched INSERT statements can return automatically generated keys.
If batch execution of a PreparedStatement object returns automatically generated keys, you can call the DB2PreparedStatement.getDBGeneratedKeys
method to retrieve an array of ResultSet objects that contains the automatically generated keys.
Recently I had a customer trying to use getDBGeneratedKeys method with Batch inserts in a JDBC application using JCC driver and was looking for an example.
Here is an example of how to use the... [More]
IBM DB2 Support has put out the following developerworks page:
IBM DB2 High Availability Disaster Recovery (HADR) Simulator
This simulator will help you to better tune DB2 HADR and the network settings with out impacting current performance on the system. It is recommended you run the simulator when the systems are most active.
In addition you can use the db2flushsize.pl (perl script) against the largest log files you have to find the largest flush size. Once you have the... [More]
Take a Proactive Approach to Managing your Support Plans and Issues - with help from AVP (the Accelerated Value program)
IBM Subscription and Support provides world-class software support via award-winning tools and support personnel. AVP – aka the Accelerated Value Program - added to your S&S contract, provides comprehensive maintenance and support guidance and assistance for issues that occur across all phases of the software life-cycle .
With AVP, you can get assistance with tasks like file fixing, code reviews, and... [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.
DB2 LUW provides two ways of
determining if you are using the product according to the licenses
you have installed. One is the dblicm tool the other is the
ENV_FEATURE_INFO administrative view. The db2licm -l command lists
the product and feature licenses installed for each DB2 product at
the same build level as the instance the command was run under. For
example the following is db2licm -l output from a DB2 version 9.7 ESE
name: "DB2 Enterprise Server... [More]