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.
Keeping track of your Netezza product names and model numbers can be tricky. The list below summarizes this information in a quick reference table. IBM Netezza product names and models numbers Product Line A : PureData System For Hadoop Models : H1001-010 Product Line B : PureData System for Analytics Models : "TwinFin product line": IBM Netezza 100-1 Skimmer N1001-002 N1001-005 1/2 rack N1001-010 Full rack N1001-015 1 + 1/2... [More]
Commitment is hard. It's much easier to put your effort toward a quick goal, get it done, and move on. But achieving a quick goal doesn't always provide the best long term results. Last June, our blog authors made a commitment - 100 posts to honor IBM's Centennial anniversary. This post marks the completion of that commitment, and we'd like to say "Thanks" to everyone.
Readers - thank you for your interest. We hope that you find our information relevant and helpful.
Here are the names of some of the authors who have... [More]
If you have a typo when you run the preprpnode command, and would like to reverse the changes that the preprpnode command made, you can either remove (read NOTE below) or rename the following files: /var/ct/cfg/ctrmc.acls /var/ct/cfg/ct_has.thl NOTE: We do not recommend removing/deleting the above files as there are other applications that use RSCT's security infrastructure. If you are not 100% sure about which applications are using CTRMC then you should rename the file to something that makes sense to you just in case you need to restore it... [More]
We know that when you need access to a fix, you want a smart and simple way to download and install it. And even more importantly, you want to find and download the fix as quickly as possible . We are pleased to share that the IBM Fix Central Support Site has been significantly improved. Many of these improvements stemmed from suggestions made by YOU. Thank you for sharing your feedback with us, and please continue to share your thoughts and suggestions on this upgraded version of Fix Central. Today's tip is to spend some time exploring Fix... [More]
100 Tech Tips, #94 How Can I re-balance my HDFS data in BigInsights? The Rebalance command in BigInsights only balances the data across data nodes. How can BigInsights HDFS data be re-balanced across all the disk drives within a cluster's data nodes? Click here for the solution...
Have Technical Support (24x7) contact number and your organization ICN
(Ibm Customer Number) handy at all times. You just never know when you
need them. #Informix (24/7) Emergency Service Line : 1-888-876-9797. Non-Emergency : 1-800-IBM-SERV Also read on getting a service request online https://www-946.ibm.com/support/servicerequest/help/srHelp.action
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]
There is recently published redbook "InfoSphere DataStage for Enterprise XML Data Integration" that guides you trough XML integration in Datastage and contains few chapters about the XML Stage in detail. These chapters describe how the XSD maps to the schema structure in XML Stage, Schema Library Manager, creating/composing/transforming XML documents and also the use of the other steps in XML Stage. There is also a separate chapter for Datastage performance and XML You can click on the link to access the site for this interesting book... [More]
Looking for options to monitor the remote client connections
in a DB2 Connect gateway and want to uniquely identify the remote application
connected to the DB2 Connect? There are two options: Using
the GET SNAPSHOT commands: There are five snapshot commands useful for monitoring DCS
information. They are: GET
SNAPSHOT FOR ALL DCS DATABASES GET SNAPSHOT FOR ALL DCS
APPLICATIONS GET SNAPSHOT FOR DCS
APPLICATION ... GET SNAPSHOT FOR DCS DATABASE
ON db_alias GET SNAPSHOT FOR DCS
APPLICATIONS ON db_alias... [More]
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! DB2
#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 LUW? Looking for trial... [More]
100 Tech Tips, #95 IBM InfoSphere Streams RedBook titled Assembling Continuous Insight in the Information Revolution draft is now available . This IBM® Redbooks® publication discusses and describes the positioning,
functions, capabilities, and advanced programming techniques for IBM
InfoSphere™ Streams (V2), a new paradigm and key component of IBM Big Data
platform. Most of our data is traditionally stored in files or databases, and then analyzed by queries and
applications. This RedBook exposes how stream
computing, analysis is... [More]
Informix introduced the PSM (Primary Storage Manager); a new backup storage manager in version 12.10 that replaced the previous ISM (Informix Storage Manager). The PSM manages storage devices used for backup and restore requests that are issued by Onbar. This storage manager supports both serial and parallel processing for backup and restore requests. PSM is easier to set up and use, even in embedded environments. You just need to perform four simple steps to configure PSM and take an Onbar backup: Decide where you will create the PSM catalog.... [More]
Need to check the status of your service request on the go? IBM Service Request is available on your mobile device! You can view a list of PMRs, check status, view detailed information, add comments, search by PMR number or customer number, and more. Watch this new two minute video to see Service Request Mobile in action and learn more! To access IBM Service Request from your mobile device, visit ibm.com/support/servicerequest.
How to restore critical administrative files with onbar utility? It is already known to us that onbar backs up some critical administrative files during storage space backup. These critical files are as follows: The onconfig file UNIX: The sqlhosts file The ON-Bar emergency boot file: ixbar.servernum The server boot file: oncfg_servername.servernum There may be a situation when you need to restore one of these files, for example: replace disks, restore to a second computer system (imported restore) etc. However, previously there was no easy way... [More]
The IBM Service Request Tool is the best way to report a problem or open a PMR with IBM. If you are already a user of the Service Request Tool, you are probably familiar with some of its benefits. If you haven't used it before, try it the next time you need to contact IBM Support. To see one of the many advantages of Service Request, watch our new video showing you how you can view and update PMRs quickly and easily on the web. To access the Service Request Tool, visit the IBM Support Portal and click the Service Requests & PMRs tab.... [More]