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 Varchar2 compatibility will be set... [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 to the... [More]
Hello everyone! 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 InfoSphere Information Server.... [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 and how they... [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 ... [More]
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 support... [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 subscription with one click.... [More]
The Puredata for Analytics (PDA) appliance uses a ‘serializable’ locking model. Typically this is a good choice for a warehousing system and results in very little contention between transactions. We are able to keep consistent views of data at a transaction level over very large datasets through use of transaction Ids and the way we implement this in the FPGA architecture in the appliance. Most people will go through their lives without worrying too much about this and it's implications. However there are a few... [More]
db2pd is a very powerful tool which can be used for troubleshooting many complex issue in DB2 like - high memory usage, locking issues, HADR, and collecting various statistics. It can also be used to find out a simple thing like how long the instance has been up. db2pd with a '-' option displays the uptime for an instance. It displays the number of days and hours the instance has been running. No database connection is required. $ db2pd - Database Member 0 -- Active -- Up 4 days 00:13:14 -- Date 2014-10-27-14.56.06.346538 If the... [More]
Six new IBM Education Assistant (IEA) training modules are now in production. Please see the details below: Subscribing to Platform Computing patch notifications - This video demonstrates how to subscribe to Platform Computing patch notifications using the IBM MyNotifications service. IBM Support Assistant 5.0 Team Server: New features - This video demonstrates new features introduced in IBM Support Assistant Team Server V5 Fix Pack 1. ... [More]
The topic for our November Support Technical Exchange has been announced! Join us on Thursday November 13 at 11:00am ET to learn how to troubleshoot hung InfoSphere Information Server DataStage parallel jobs . Sign up today for this FREE education session . Abstract This presentation will show how to determine if a DataStage parallel job is hung and, if so, it will describe the environment variables that need to be set and what information to collect during the job hang. Learn what to look for when you think a... [More]
Has your internal Site Technical contact left the company and you need to change it to another person? Are you not able to view a PMR created by a coworker via Service Request tool or by phone? Do you need to add coworkers to the Service Request tool? All these questions can be answered by visiting our IBM Service Request help website at https://www-946.ibm.com/sr/help/register.html
What do Kevin Spacey and Captain Phillips have in common? Among other things, IBM! See them and other highlights from the IBM Insight using InsightGO! InsightGO is an interactive digital platform, streaming live broadcasts straight to your laptop or mobile device. It's the next best thing to being in Vegas, but it doesn't stay in Vegas!
Problem(Abstract) Initializing InstallShield Wizard........ Launching InstallShield Wizard........ The wizard cannot continue because of the following error: could not load wizard specified in /wizard.inf (104) Cause Install can't locate java path Resolving the problem ./ids_install -javahome your_JRE_path This forces the installation script to use the bundled IBM Java Runtime Environment.