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]
Here is a simple DB2 command which will display the DB2 products that are installed on the system: db2ls - it displays the Install path, product level, fix pack details, Special Install Number, Installation date , Installer UID. The db2ls command is the only method to list all DB2 product at Version 9 or later. However you cannot use the db2ls command on Windows operating systems. $ db2ls Install... [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]
There are 3 error messages that commonly occur related to Stored Procedures and Functions (collectively referred to as routines). These are SQL0440, SQL1131 and SQL0443. A SQL0440 returns an error indicating the routine does not exist. Usually when this error occurs the routine does exist but is being called incorrectly. Routines can be overloaded so two or more routines can be created using the same schema and name if they use either a different number of input or return variables (3 input as opposed to 2) or different data types... [More]
How do you keep the result of overall SQL performance data in your DB2 system ? I could see many DB2 mates have used our long last friend DB2 dynamic SQL snapshot for checking performance statistics of SQL statements. And we have another friend 'mon_get_pkg_cache_stmt' who shows more performance aspect especially in elapsed time perspective. Some smart DBAs regularly gather this result and keep in a table to see the changes and trend. It's also good idea to load the data into other database if you have. Somebody call it as... [More]
Hello! Many have been utilizing the light weight deployment solution i.e. IBM Data Server Driver Package that provides run-time support for applications without the need to install Run-time Client/Data Server Client. We already have DS Driver install demos for Windows out there, but not for Unix platforms, So, I would like to take this opportunity to share a demo of IBM Data Server Driver install in a Unix environment. The documentation is in our Knowledge Center:... [More]
Are you stuck with DB2 installation/upgrade/migration? I am listing down few common check points to start with: 1. Please look for any db2 related processes running on the system. You may run 'ps -elf | grep -i db2' on unix or look for db2* processes in task manager on windows and see what db2 processes are running. You may want to shutdown/kill the process if it is not required. 2. Please make sure *all* db2 filesystems are mounted and accessible. 3. Please make sure you have enough free space under /opt, /tmp and db2 instance's... [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.