It's about that time of year again... time to get ready to head to Vegas for the largest big data conference in the world! This year, there are a few important changes you should know about: Information on Demand is now IBM Insight! The name has changed for a reason: It's no longer just about information; it's what you can do with the information and how you can use data as a competitive advantage. See the conference website . Insight runs from October 26-30, 2014. Your Support team will be there... and... [More]
Diagnosing a hung Information Server V8.1 - 9.1 DataStage parallel job on Windows - This presentation discusses how to rule out known issues, show how to determine if a parallel job is hung, and if so, it describes the environment variables that need to be set and what information to collect during the hang. DCF #7042477
Relocating QualityStage Match Designer Database - This presentation explains the steps that are required to change the configuration to relocate InfoSphere QualityStage Match Designer database. This is a component of InfoSphere QualityStage that stores the results of match test passes by the InfoSphere QualityStage Match Designer stage. DCF #7042467
Hello db2 DBAs Have you encountered any db2 instance hang situations where in the db2fodc -hang command also hung? Fear Not! I have created a template that walks through the commands to execute at various levels i.e. db2 instance / database etc manually to collect the hang diagnostics and provide that to the support team. It would make the diagnosis of the hang much easier :) Step 0. Clean out sqllib/db2dump directory, move or remove any FODC_* directories from this directory to keep the db2support.zip file small. ... [More]
To ensure you are ready for the Optim z/OS products reaching EOS in September , here is a summary. You can view the original EOS announcement here . Product Name Version Policy Type Product ID General Availability End Of Support Optim Database Relationship Analyzer for z/OS 2.1.0 S 5655-V69 30-Oct-09 30-Sep-14 InfoSphere Optim Solution for Application Retirement for z/OS for PeopleSoft Enterprise 7.1.0 S 5655-OAR 27-May-11 30-Sep-14 Optim Solution for Application Retirement for z/OS for PeopleSoft Enterprise 6.2.0 S 5655-V25... [More]
Hello, Here are the links with details on what to collect when you run into any issues with IBM Infosphere Federation Server. Gathering this information before calling IBM support will help you familiarize with the troubleshooting process and save you time. Collecting data for installation failures for InfoSphere Federation Server versions 9.x Collecting data for InfoSphere Federation Server Data Source Configuration Issues... [More]
New self-assist IBM Education Assistant video in production - Accelerated Value Program features of the IBM Support Portal . This video demonstrates the added benefits that IBM Accelerated Value Program clients receive from the IBM Support Portal.
New IBM Education Assistant presentation - How to relocate an IBM InfoSphere Information Analyzer analysis database (IADB) to a new location . Related techdoc #7042099 . This presentation discusses both the restrictions and requirements for relocating the IADB database. It also walks you through the overall process and steps that are required to relocate IADB. This presentation is valid for Information Analyzer version 9.1.
More education content on InfoSphere Information Server - Relocating Information Server 9.1 InfoSphere Data Quality Console exceptions database (ESDB) . Related techdoc #7041978 . This presentation discusses how to relocate the InfoSphere® Data Quality Console exceptions database to another server. It assumes that you are still using the same services tier to manage repository registration in the same metadata repository. This presentation is valid for Information Server version 9.1.
Another new InfoSphere Information Server education available - Relocating Information Server 9.1 IBM® InfoSphere® QualityStage® Standardization Rules Designer database (QSSRDDB) . Related techdoc #7041979 . This presentation discusses how to relocate the IBM InfoSphere® QualityStage Standardization Rules Designer database to another server. It assumes that you are still using the same services tier to manage repository registration in the same metadata repository. This... [More]
New InfoSphere Information Server education in Knowledge Center - Relocating Information Server 9.1 InfoSphere DataStage® and QualityStage® operations database (DSODB) . Related techdoc #7041980 . This presentation discusses how to relocate the InfoSphere® DataStage® and QualityStage operations database to another server. It assumes that you are still using the same services tier to manage repository registration in the same metadata repository. This presentation is valid for... [More]
New InfoSphere Information Server education presentation - Relocating Information Server 9.1 xmeta and xmetasr repositories with standalone WebSphere . Related techdoc #7041975 . The objectives of this presentation are to describe the databases and repositories that Information Server version 9.1 includes, how to check what you need to relocate, what you need to back up, and how to update xmeta and xmetasr including the Information Services Framework configuration, referred to as the ISF... [More]
New IP&S IBM Education Assistant content available - Relocating Information Server 9.1 xmeta and xmetasr repositories with a WebSphere cluster . Related techdoc ID is #7041974 . The objectives of this presentation are to describe the databases and repositories that Information Server version 9.1 includes, how to check what you need to relocate, what you need to back up, and how to update xmeta and xmetasr including the Information Services Framework configuration, referred to as the ISF... [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]
Hi there! When you open a Problem Management Record (PMR) with DB2 Support team, first thing we are interested in looking at is db2support.zip. Its a great handy tool collecting background information on your environment. Ever wondered what it has? Extracting the db2support.zip file, the following files and directories were collected: DB2CONFIG/ - Configuration information (for example, database, database manager, BP, CLI, db2 node configuration and Java developer kit, among others) The files have “supp_cfg” as the file... [More]
Does DB2 Replication center GUI tool use db2dsdriver.cfg file? The answer is No. db2dsdriver.cfg does not work with Replication Center, it uses command line catalog entries, you would need to catalog the node/db manually to be able to work with Replication Center. Here is a quick demo: C:\Program Files\IBM\SQLLIB_01\BIN>db2level DB21085I This instance or install (instance name, where applicable: "DB2_01") uses "64" bits and DB2 code release "SQL10013" with level identifier... [More]
Do you want to know how to integrate the db2 and AIX WLM classes ? You can do that while defining the db2 WLM class using the outbound correlator string constant. Refer : http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.sql.ref.doc/doc/r0050550.html OUTBOUND CORRELATOR NONE or OUTBOUND CORRELATOR string-constant Specifies whether or not to associate threads from this service class to an external workload manager service class. If OUTBOUND CORRELATOR is set to a string-constant for the... [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]
This is the last of the blog series concerning the Optim distributed End of Service (EOS) for September 2014. The next blog series will highlight the Optim for z/OS EOS products. To ensure you are ready for the Optim for Siebel Customer Relationship Management (CRM) products reaching EOS in September , here is a summary. Product Name Version Policy Type Product ID General Availability End Of Support Optim Test Data Management Solution for Siebel Customer Relationship Management** 3.2.3 S 5724-U62 26-Aug-11... [More]