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.
Have you tried taking DB2 database backup and restoring it in DPF using Single System View?
DB2 Version 9.5 (or later) provides the Single System View (SSV) function which allows backing up multiple database partitions at once. In earlier releases, partitioned databases needed to be backed up one partition at a time which can be time consuming and prone to errors. The backup timestamp associated with all database partitions is the same. I am listing down the commands with minimum clauses to illustrate how SSV can be used.... [More]
The following self-assist IBM Education Assistant modules have been updated and were deployed to the Knowledge Center on 12/19/2014.
Using IBM's Software Product Compatibility Reports
How to subscribe to MyNotifications
We love feedback
Here are some starting links to get familiar with IBM Information Sever version 11.3.1
IBM InfoSphere Information Server, Version 11.3.1 release notes:
These release notes contain information to ensure the successful installation and operation of IBM® InfoSphere® Information Server
IBM InfoSphere Information Server, Version 11.3.1 fix list
Summary of fixes included in the IBM InfoSphere Information Server, Version 11.3.1 release
New features and changes for Version 11.3... [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.
Security Bulletin: IBM DB2 Accessories Suite for Linux, UNIX and Windows denial of service... [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.
Merry Christmas. DB2 mates !!
Holiday is actually good timing for writing blogs for me. Today I would like to write a topic a bit aside from DB2 but very necessary in some difficult performance cases.
When we need hands from OS team and expert, it's better to understand what kind of OS tools are necessary and how it works.
Actually these tools boost up the problem investigation and provide a smoking gun evidence very shortly.
If we don't know much about right tool for a case, we may sometimes spend lots of time to... [More]
Looking to take advantage of your Passport Advantage accounts?
Passport Advantage Online provides customers with the latest program information plus access to tools that will help you manage your Passport Advatage accounts.
Tools and information include:
Software download and media access
Purchase and renewal
Proof of Entitlements (PoE)
For more information on Passport Advantage Online go to... [More]
We have compiled a list of the ten most read Thoughts from Information Management Support (TFIMS) blogs in 2014. If you missed any, now is your chance to read blogs of interest to you :)
Wishing all of our readers a wonderful holiday,
Your TFIMS Blogging Team
New to InfoSphere DataStage? First step... download product!
By Alejandra Parra
Tech Tip: What the db2fmp process does
By Gord Owens
The "How to upload a Java API class file to the Docstore and invoke it" IBM Education Assistant module went to production on 12/12/2014. This presentation covers the topic of how to upload directly to the docstore and use a class file that has a Java API implementation. Techdoc ID #7043954
It's always important to stay informed about your products to keep them current. Today, we wanted to make sure you are aware of two key ways to stay informed:
My Notifications is a simple way to subscribe to receive information about your product(s) directly in your inbox or favorite RSS reader. My Notification was recently updates to make it easier for you to subscribe and unsubscribe, and set your subscription settings. Learn more about My Notification here. You can... [More]
Getting "SQL0407N Assignment of a NULL value to a NOT NULL column" error when inserting an empty string.
An empty string is not a NULL value in DB2.
The root cause of the issue is due to the following db cfg parameter.
Varchar2 compatibility = ON
The VARCHAR2 and NVARCHAR2 data types are introduced to support applications that use the Oracle VARCHAR2 and NVARCHAR2 data type.
If DB2_COMPATIBILITY_VECTOR=ORA set in your instance environment and then when you create a database, the value of the... [More]
For NPS 22.214.171.124, 126.96.36.199, 188.8.131.52, 184.108.40.206, and 220.127.116.11 releases (and later fix packs and patches in those releases) automatically install the Netezza Software Support Tools. Each NPS kit also includes a standalone Software Support Tools kit (nz-sw-support-tools- version .tar.gz) to allow you to install the latest tools without upgrading the NPS appliance release.
IMPORTANT : The Netezza Software Support Tools are no longer available as a separate Fix Center menu download component. To install or upgrade to the latest tools, go... [More]
Although it is hard to believe, we're putting our first Support Technical Exchange in the calendar for 2015 and we hope you'll join us!
Date and time: Tuesday January 13, 2015, 11:00am - 12:00pm ET
Our topic: IBM InfoSphere Information Server Support & Serviceability
In this presentation we’ll go over resources that are available via the IBM Knowledge Center, Support Portal, developerWorks, RedBooks as well as other sources to help you optimize your overall experience with... [More]
Groom basics - When you complete this session, you will understand the purpose of Groom. You will know the situations that will prompt the need to perform Groom. You will also understand the importance of the relationship between the backup process and Groom and how that affects the scheduling of those two maintenance activities. DCF #7043597
What are zone maps and how can you exploit them? - The main objective of the presentation is to explain zone maps to you... [More]