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...
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]
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
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]
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]
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]
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]
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.
IBM PureData System for Analytics is excited to announce the publication of APARs as part of the problem reporting process! An APAR - Authorized Program Analysis Report - is a formal report to IBM development of a problem caused by a suspected defect, published so that it is visible to supported customers. If IBM development is able to confirm the defect, they will update the APAR with any known workarounds and perhaps an indication of which future release they intend to target for a formal fix to the defect. APARs are easy to find... [More]
Informix RFE ( R equest F or E nhancement) Process Learn how the RFE process works in the IBM RFE Community. In the RFE Community, you can collaborate with IBM development teams and other product users through your ability to search, view, comment on, submit, and track product requests for enhancement (RFEs ) Submit from the IM RFE site – simply complete the RFE form and click Submit when ready Many fields will be auto-filled as a convenience for you Note that fields with the ‘key’ field e.g. Company Name and Business... [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]