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.
Answer : What is the coolest thing from IBM right now?
Question : Elementary - Watson!
In February, Watson is going to be competing with two top champions to answers questions on America's tough game show, Jeopardy. How cool is that? And going forward, what questions could Watson help to answer for you?!?
Check it out:
Navigate using a QR code scanner
Open your prefered QR code scanner.... [More]
Analyze This! Let's continue last week's scenario: your IBM software isn't working as you expected it to, but instead of calling IBM right away, you found an appropriate Collecting Data document. You've collected the data, but wait--there is still one more step you can take before you pick up that phone. You can return to the IBM knowledge base and find an Analyzing Data document related to your situation. Analyzing Data documents explain how to analyze the data captured in the Collecting Data document. They document the best... [More]
The Power of Collecting
Your IBM software isn't working as you expected it to, so you're ready
to call IBM Support to get the help you need. Before you pick up the
phone, search the IBM knowledge base and see if there is a Collecting
Data document related to your situation.
Collecting data documents (formerly MustGather documents) aid in
problem determination and save time resolving problems by explaining
what information needs to be gathered before calling IBM.
Collecting data documents are an extension of the... [More]
This year's IIUG Conference is now only days away. Our Informix Support team is ready to go and is looking forward to speaking with you. Here is a quick overview of where you can find us at IIUG:
Check out this blog post for our activities during the IIUG Sunday Tutorials.
Like last year, you'll find many of us at the Support Kiosk between the hours of 10am and 2pm daily. At the kiosk, you can:
Find out how your Informix Database can benefit from a FREE Health Check Lite
Talk to the... [More]
This technote describes how the number of jobs that a DataStage project can have may be impacted by Operating Systems' limitations. When you reach the maximum number of folders the OS allows then you won't be able to create new jobs. Please refer to the technote that lists some suggestions about how to address this problem.
100 Tech Tips: #82: Find IBM Netezza on the Support Portal! Attention IBM Netezza Clients: You can now search for and select IBM Netezza in the Support Portal to find IBM Netezza information, technical documents, sign up for automated notifications about your Appliance, and open service requests. Click this link to access the Support Portal with IBM Netezza already selected in your product list. As you become familiar with the Portal, here are a few tips: The following images are from the Support Home tab of the Portal.
The db2ReadLog API is used to read log records from the DB2® database logs, or queries the Log Manager for current log state information.
Before a Embedded SQLC program can be used it has to be precompiled, bound, compiled and linked. Here is an example on how to use the db2ReadLog API using the dblogconn.sqc sample SQLC program that is provide with the DB2 sample scripts. This program reads the database log files asynchronously with a database connection using the db2ReadLog API.
Copy the sample c scripts from... [More]
Using a simple test case. This can be easily observed. Document was exported using a utility that applies a byte order mark to text documents.
db2 "create table numbers (col1 char(10),col2 char(10),col3 char(10))"
DB20000I The SQL command completed successfully.
[db2v97@ts-carose2 ~]$ db2 import from numbers.csv of del insert into numbers
SQL3109N The utility is beginning to load data from file "numbers.csv".
SQL3110N The utility has... [More]
The best-fit Java class for an Informix DATETIME value is java.sql.Timestamp. Java.sql.Timestamp technically inherits from java.util.Date; although, there are some semantic differences which are not typical of inheritance relationships. All the constructors, getters, and setters which are not deprecated for Date and Timestamp use values based on Greenwich Mean Time (GMT). They are offsets in milliseconds from the epoch, January 1, 1970 00:00:00 GMT. So, it would be logically consistent for Timestamps to convert to DATETIMEs using the GMT... [More]
100 Tech Tips: #71: If a non-default console port of 8081 is chosen during InfoSphere BigInsights V1.3.0 Fix Pack 1 installation, the Web Console will fail to start due to a port conflict. During BigInsights V1.3.0 Fix Pack 1 installation, if you change the BigInsights console HTTP port to a non-default port value of 8081, the PortOffset value in WAS CE will be set to 1, resulting in a new value of 9999 (default +1) for JMXSecurePort. This will create a port conflict because the default port for Hive web interface is 9999. For more... [More]
100 Tech Tips, #55: InfoSphere Warehouse Operation System higher
level support technote is updated to be more generic
Installing InfoSphere Warehouse (ISW) 9.7.x on an Operation
System (OS) whose intermediate upgrade that was not available at the general availability
of an ISW 9.7.x release may cause the ISW installer’s OS check to fail. The “How to complete the installation of InfoSphere Warehouse V9.7x when the level of your operating system is higher than the levels that are recognized by the installation program.” technical... [More]
What's new for you? Thanks to everyone who has been out there rating our documents on the web, we're now able to show you a list of the top rated documents in Support Portal. This is in addition to the "Most recent" and "Most viewed". So, if you are working in "browse" mode, trying to be proactive by visiting the Support Portal to keep an eye on - what's new, of course - then you need to check out the "Overview top ten" portlet! Enjoy!!!
I was working on a DB2 installation issue using db2setup wizard with 9.7 GA (FP0) on AIX 7.1, JDK 5 , the installation was failing with Segmentation fault error, the installer has generated java cores, similar to the one shown here below:
Type= Segmentation error vmState=0x00000000
In general, basic things to look at when these kind of errors happen are:
We have completed our series of 100 technical support tips! See our blog to mark the end of the series here! A few of you have asked for a full summary of our tips broken down by product area... so here you go!
#7: DB2 License key
#8: DB2 on LUW Problem Determination Guides #10: Common DB2 Security Issues
#14: New Explain feature in DB2 9.7: section explain & ... section actuals #16: Where can I find the NES 32 and 64 bit index migation tool for Windows?
#18: Frequently Asked DB2 Questions
#19: New to DB2 for... [More]
Here is a list of the Top Ten viewed technical documents for DB2 for Linux, Unix, and Windows:
12 Oct 2010:
DB2 Fix Packs by version for DB2 for Linux,...
20 Jul 2010:
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX,...
26 May 2010:
DB2 database product documentation
30 Aug 2010:
DB2 UDB Version 8 - End of Support date is...
23 Feb 2010:
DB2 UDB Version 8 Product Manuals
01 Jul 2010:
DB2 UDB Version 8 FixPaks & client downloads...
16 Sep 2010:
DB2 Version... [More]