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.
Here is a list of license documents that may help resolve the DB2 license errors you encounter with DB2 on Linux, Unix and Windows: Knowledge Collection DB2 License Issues Useful DB2 license references from our Information Center: DB2 License Files db2licm - License management tool command License Center overview db2connectactivate -Server License Activation Utility Activating the license key for DB2 Connect Unlimited Edition (system z) Setting the DB2 license policy using the db2licm command Setting the DB2 license policy using the License... [More]
While running redistribute in a DPF environment, the following suggestions may help improve redistribute performance Starting DB2 V9.5 FP1 and V9.7 GA, the "NOT ROLLFORWARD RECOVERABLE" parameter was introduced. With this option logging is minimal because the data is moved in bulk instead of by internal insert and delete operations which improves performance. (But please consider recovery implications as there is minimal logging.) Some other options to help performance would be to tune the following parameters: DATA BUFFER :... [More]
100 Tech Tip #77: IBM InfoSphere Information Server MustGather documents aid in problem determination and save time resolving Problem Management Records (PMRs). You
can gather the necessary information to improve the accuracy and
completeness of the data collection process. This gathering of
information can be done as follows: * Automated gathering -
Use the ISALite for InfoSphere Information Server collectors to gather
log files and other artifacts. Refer to the link for automated information gathering. * Manual gathering -... [More]
100 Tech Tips: #76: BigInsights V1.3 Fix Pack 1 AQL file with no output views is not automatically compiled when dependent AQL files are compiled. When Text Analytics Project A depends on Text Analytics Project B, compiling Project B does not automatically trigger the compilation of Project A when Project A contains an AQL with no output views. Click here for more information...
Back in December 2011, when we were way back at tip #44, we posted a summary of our Technical Support tips categorized by product/interest area. Since we are now about 75% complete on our goal of posting 100 Tech Tips by June 16 2012 (one tip for every year IBM has been in business), we have updated our summary and below you'll find links to 75 pieces of valuable technical support information!! We hope you find this list useful. Please share it with colleagues who may benefit from this list and let us know if you'd like to see a particular... [More]
Does runstats seem to be running longer than usual? There could be a few explinations for this. First you should consider if there is a significant amount of data than before, this could just be normal. If you are in a situation where you will be working with a larger volume of data, you may consider different sampling options with runstats. When collecting detailed statistics collection can consume considerable CPU and memory for large tables, and may take longer than planned. The various sampling options can provide accurate statistics... [More]
100 Tech Tips: #74: Stay informed about upcoming EOS dates Do you know how to check the End of Support (EOS) date for your products? All EOS dates are available on the IBM Product Lifecycle page. Since we have a number of important products reaching EOS on April 30, 2012, we thought now would be a great time to remind you to check the Product Lifecycle page regularly or sign up to receive updates through RSS. Click here to view a summary of Information Management Products listed by their End of Support dates. Here is a summary of some of... [More]
100 Tech Tips: #73 If a non-default console port is chosen during InfoSphere BigInsights V1.3.0 Fix Pack 1 installation, it can cause problems while building dynamic collections in BigSheets During InfoSphere BigInsights V1.3.0 Fix Pack 1 installation, if you change the BigInsights console HTTP port to a non-default port (e.g. 8081), the BigSheets back-end server port and PigServer port will also change from their default values, This, in turn, might create a port conflict that can cause problems while building dynamic collections in... [More]
100 Tech Tips: #72: IBM Red Brick attach segment requires moving existing data How do you avoid "** ERROR ** (859) The attach or change range would require movement of data from segment"? Click here to learn more on avoiding this error.
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: #70: Informix Support at IIUG The International Informix User Group (IIUG) is holding their annual conference in San Diego, CA from April 22 - 25. As always, our Informix Support team will be there and is looking forward to meeting with those of you who will be attending. Here is a quick snapshot of where Informix Support will be at the event and how you can find us: The Support both will be located on the main level of the San Diego Marriott Mission Valley hotel in the conference area At the Support booth, we will be... [More]
Only the named callers can see PMRs for their company; basic callers can only see PMRs they have opened. Nobody else can see their PMRs and they cannot see anything else. If you are the named caller, to find all of your Service Requests (PMRs) for your company, please follow these steps: 1. Log into SR - http://www.ibm.com/support/servicerequest 2. Select the "Search service requests" link from the left nav menu. 3. Choose the radio button for "Search all service requests", (select customer number if applicable). ... [More]
A new development community has been launched for IBM software customers submitting enhancement requests for products. There you have an opportunity to collaborate directly with the IBM product development teams and other product users. The discussions are free and public. You can view the Top 20 watched or voted Feature Requests, along with those that are submitted, planned, or delivered. See it here: http://www.ibm.com/developerworks/rfe/ Note: Currently, only DB/2 for z/OS, DB2 Utilities Suite, DB2 Sort for z/OS, and DB2 Automation... [More]
100 Tech Tips: #67 IBM announces InfoSphere Warehouse V10.1 IBM® InfoSphere® Warehouse V10.1 makes it easier for you to develop your business analytics solutions, helps speed your warehouse deployment and management, and helps reduce your overall licensing, administration, and storage costs. InfoSphere Warehouse V10.1 offers: Simplified administration and optimal use of you data storage resources with multi-temperature storage Adaptive compression, helping to lower storage costs Real-time analytics with enhanced zigzag join and continuous data... [More]
100 Tech Tips, #66: Updated DB2 for LUW best practices paper One of our most popular best practices papers for DB2 for Linux, UNIX, and Windows has been significantly updated and is available for download: http://www.ibm.com/developerworks/data/bestpractices/databasedesign/ The paper, titled "Best Practices: Physical database design for OLTP environments" , was reviewed by a large team of DB2 experts and covers the following topics: Introduction to physical database design OLTP workload characteristics Data modeling Storage systems... [More]