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.
Hello all, Did you know that you can chat with a DB2 tech support analyst right after opening a PMR using our new tech chat interface. Find out more here: Click here to learn more! We are standing by waiting to help you! If you have used or are having trouble using this option please comment below.
Handlers for SQL Routines. A handler is usually a section of user
declared code in an SQL routine that determines what to do when a
condition occurs. DB2 will look for handler code for several
conditions ranging from SQLWARNING to SQLEXCEPTION. One common type
of handler is the NOT FOUND condition handler. When a record is not
returned for a query or there are no more results DB2 will look for
a NOT FOUND condition handler and turn control of the routine over to
the section of code in this handler. This handler is often used... [More]
100 Tech Tips, #32 - Search with a Dash! There are any number of things to search for that would include a hyphen, or "dash": SQLCODEs, such as -930 Errors, like -25596 Commands, like db2set -all So, what's the problem? Search engines don't handle "-" very well at all. Google documents this under " Terms you want to exclude (-) " If you want to search for -25596, and you put that into a search engine which uses "-" to exclude, the engine will return everything EXCEPT things with 25596. Dash it all... [More]
There are 2 important fixpack related alerts published this week for MDMPIMv9.0 and MDMPIMv9.1 products. Important Product Versioning Update for Infosphere MDM Server for PIM 9.0.0 Release Important Product Versioning Update for Infosphere MDM Server for PIM 9.1.0 Release Abstract Effective July 1, 2012 the Infosphere MDM Server for PIM 9.0.0 release
will be merged with version 9.1.0. Future fixpack naming for all 9.x
releases will reflect this integration beginning with 9.1.0 FP009.
Top Ten Technical Support Documents Better than "Stupid Pets Tricks", the updated IBM Support Portal has introduced the TOP TEN for technical support content! Now, there you can see the 10 Most recent or 10 Most viewed documents for your products! With the new "Top Ten" portlet, you can quickly find the newest documents or check out the documents your peers were using most often. The Top Ten portlet is available on the Overview, Troubleshooting, Planning Installation, and Usage pages. Chance are your colleagues know about... [More]
The IBM Information Management best practices present advice on the optimal way to use a variety of IBM Information Management products. They include technical papers, presentations, and articles authored by leading experts in IBM's development and consulting teams and are designed to give you practical advice to improve the value of your IBM data servers and data integration products. Best practices for IBM InfoSphere Information Server These best practices papers present advice on ways you can leverage... [More]
There are two recently published InfoSphere Information Server related Education Assistant modules The first module points to an IBM Education Assistant module about starting node agents as a non-root user Agenda: Requirements Procedure Common Issues The second module points to an IBM Education Assistant module about how to import Infosphere Data Architect Models using IBM InfoSphere Metadata Asset Manager in Information Server version 8.7 Agenda: Logical and Physical Data Models Configuring InfoSphere Metadata Asset... [More]
We are very happy to announce that we have completed 50 DB2 Nuggets goal - 50 exclusive DB2 Blogs in Information Management support for 2014! Readers - thank you for your interest. We hope that you find our information relevant and helpful. Authors - thank you for your dedication, effort, expertise and help in promoting client self-assist. Here are the names of the authors who have contributed towards the goal. Adam Koile - USA Christopher Rose - USA Gord Owens - Canada John Gera - USA Jun Su Lee - Australia Mary Kassey - USA Matthew Choi -... [More]
Consider the following scenario, in a DB2 HADR configuration using ASYNC mode. Presently,the log files were extracted from TSM to a local file system on the standby server. Standby database was deactivated and re-activated causing the standby to go into LocalCatchUp state. However, its unable to read the local log file because its considered as a "stale" file and the standby re-enters a RemoteCatchUp state. This process was repeated two to three times and the standby fails to read the log file and switch HADR to RemoteCatchUp... [More]
SQL4728W : A priority setting was assigned to a service class that is higher than the priority setting of the default system service class SYSDEFAULTSYSTEMCLASS and this might negatively impact performance. To ensure that system work can take precedence over user work, the priority settings of the default system service class SYSDEFAULTSYSTEMCLASS should always be higher than the priorities that were set for all other service classes. Failure to assign higher priority settings to the default system service class can result in a negative impact... [More]
Recently we implemented changes in our Service Request process and appliance entitlements. When opening a Service request using the Service Request Tool for your PureData System for Analytics Appliance, you may be asked to provide your machine type and serial number. Providing your machine type and serial number allows our Support Engineers to know exactly which parts are used in your Appliance, saving time and improving accuracy as we address your issue. Along with this change, we have updated the Product Names in the Service... [More]
After upgrading to IIS 8.5 FP2 , Does Datastage Designer derivation editor in the transformer stage emit error "Unexpected error; quitting" If yes,it is a known issue and refer to the technote As mentioned in the technote you might apply temporary fix or installing the patch by contacting IBM Support for the fix
Known problems for InfoSphere Information Server, Version 9.1.2, are documented in APARs and technotes, which are available on the IBM Support Portal. The following table provides links for customized queries for APARs and technotes for Version 9.1.2. InfoSphere Information Server InfoSphere Business Glossary InfoSphere Business Glossary Anywhere InfoSphere DataStage InfoSphere FastTrack InfoSphere Information Analyzer ... [More]
Can you believe it is already that special season of the year again? You know, that magical time known as... the lead up to the biggest and best Information Management, Business Analytics, and Enterprise Content Management event of the year: IBM Information On Demand ! The conference is officially 66 days away, so your Support team is busy getting ready to meet with you. We're gathering the latest product updates, support tips, Electronic Support advancements, and much more to share with you at the event.
As we have done for the past... [More]