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.
The IBM Insight conference kicks off on October 26! Find your Smarter Support team in the Smarter Support Zone in the EXPO, booth 405 . A big part of the Zone is our Hands-On Lab. In the lab, you'll find over 50 self-paced workshops covering IBM products from Information Management, Business Analytics, and Enterprise Content Management. Today, we'll share the workshops available for Information Management products: Information Server command line tools across our products for automating tasks LDAP Filtering and LDAP Attribute Mapping... [More]
IBM InfoSphere Streams is a software platform that enables the development and execution of applications that process information in data streams. IBM InfoSphere DataStage is an ETL tool that integrates data across multiple systems using a high-performance parallel framework, and it supports extended metadata management and enterprise connectivity. Integration of InfoSphere DataStage and InfoSphere Streams applications involves flowing data streams between the applications and configuring them to use the data. This presentation provides... [More]
Hello everyone, It is hard to believe that by this time next week, IBM Insight 2014 will be in full swing! We look forward to meeting everyone who is attending in the Smarter Support Zone, booth 405! See our Tumblr page for more info about Smarter Support and how you can connect with us. Today, we bring you an update from our friends over at BA Support Link! They recently shared an excellent blog on certification at Insight, so we thought we would pass it along. Read the blog here or we've included the content below. See... [More]
Hello All, I will be providing quick shortcuts to open various DB2 Control Center tools. If you are still using DB2 Control Center that will save you some time! Activity Monitor – db2am Control Center – db2cc Configuration Assistant – db2ca Development Center – db2dc Event Analyzer – db2eva Health Center – db2hc Indoubt Transaction Manager - db2indbt License Center – db2lc Memory Visualizer – db2memvis Query Patroller Center – db2qpc Replication Center – db2rc Task Center – db2tc... [More]
How to remove Duplicate Rows in a nonfragmented IBM Informix Dynamic Server (IDS) Table . Use the SQL in this article to remove duplicate rows from a nonfragmented table. Note: This method does not work on fragmented tables. Rowid's must exist on the table. STEPS Create and run this SQL to remove duplicate rows from a table: SELECT rowid FROM table_name WHERE rowid NOT IN ( SELECT MIN(rowid) FROM table_name GROUP BY column_name ) INTO TEMP temp_name; DELETE FROM table_name WHERE rowid = ( SELECT rowid FROM temp_name WHERE table_name.rowid =... [More]
-1213 A character to numeric conversion process failed. A character value is being converted to numeric form for storage in a numeric column or variable. However, the character string cannot be interpreted as a number. It contains some characters other than white space, digits, a sign, a decimal, or the letter e; or the parts are in the wrong order, so the number cannot be deciphered. Cause Your query is causing Informix to attempt to explicitly or implicitly cast non-numeric data in a character column to a number. Example: You have a table... [More]