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.
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 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11, and 18.104.22.168 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]
Writing data to Microsoft Excel with Information Server DataStage 11.3 - The objectives of this presentation are to show how to create a DataStage job that reads from a Sequential File stage and writes to a Microsoft Excel spreadsheet using the Unstructured Data stage. This presentation includes step-by-step instructions starting from creation and configuration of the job to running the job and viewing the target data. DCF #7043633
We're pleased to announce that the first Support newsletter for IBM PureData System for Analytics is now available! This quarterly publication was sent to My Notifications subscribers last week and is also available here .
If you use or are interested in PureData for Analytics, you can subscribe to receive the newsletter through the subscribe link at the bottom of the newsletter OR (better yet!) subscribe to PureData for Analytics through My Notifications to receive this newsletter as well as additional proactive... [More]
Are you aware..... of 'Allocated entitlement' an invaluable IBM function that allows you... to maintain one centralised purchasing site, while enabling additional WW sites for tech support... local time zones for sev 2-4, sev1 24x7....and product delivery.
PA customers only, can apply via their Primary contact on your PA Online site...Go to "User Functions" and enable "Update authorization for Allocate Entitlement", (ensure you exit PA On-line and close the browser for the update to take... [More]
IBM My Notifications released a brand new interface today, and let me tell you... I really like it!
It is now so much simpler to find and subscribe to receive automated support information about IBM products. You can also easily manage your subscriptions -- change the frequency of your updates or unsubscribe with the click of a button.
Here is a quick view of my My Notifications page with enhancements highlighted:
Blue box -- Search for new products by typing the product name into the Product Lookup field. Add a new... [More]