gorddbds 060001JCXS Visits (1373)
100 Tech Tips: #86 What information is in the name of the db2fmp
The db2fmp or DB2 Fenced Mode Process is used to run untrusted external routines. These routines can be created in a variety of languages and can be thread-safe (meaning it is safe to run them in a multi-threaded db2fmp process with other unrelated routines), or not thread-safe (meaning they will be run in a single db2fmp process). The name of the db2fmp in the ps output can be used to determine the language and thread-safeness of the db2fmp. The name also indicates if the db2fmp is associated with one or more agents or is currently in the fenced pool. For example here is the output of the command ps -elf | grep db2fmp
242001 A nobody 6881336 10616948
0 60 20 850f65590 39372 * Apr 30 - 0:03 db2fmp
242001 A nobody 7143552 13697146
0 60 20 8f36cf590 4024 * 16:00:10 - 0:00 db2fmp (C)
242001 A nobody 36831440 22282262
0 60 20 892889590 2176 * 09:19:08 - 0:00 db2fmp
242001 A nobody 8913102 10616948 0 60 20 963616590 3876 * 14:54:10 - 0:00 db2fmp (idle)
The first db2fmp in the output with the (Java) in its name is associated with one or more agents and is being used to run thread-safe Java routines.
The second db2fmp with the (C) in its name is also associated with one or more agents and is being used to run thread-safe C routines.
The db2fmp with the (2829) in its name is currently associated with a single agent with the thread or process id that matches the number in the brackets. The routine run by this db2fmp is not thread-safe. If it were thread-safe the db2fmp name would contain the name of the routine's programming language instead of a number.
The db2fmp with (idle) in its name is currently in the fenced pool waiting for reuse and not associated with an agent.
Ale_Parra 060000DG7U Visits (1358)
During the process of Problem Determination with IBM Support Team, you will probably listen to the terms APAR and FixPack. As follows, an explanation for them:
What is an APAR?
An Authorized Program Analysis Report (APAR) documents and tracks software defects reported by you, the IBM customer. Support Team creates an APAR when it determines that a problem that a customer is experiencing is a suspected defect.
After an APAR is a created, a corresponding Software Problem Report (SPR) is created. Any SPR with a related APAR is a customer reported defect, while any SPR without an APAR is an internally reported defect that either the customer has not experienced or reported yet.
APARs contain information about a single defect that one or more customers have experienced. The APARs listed in a Fix List are reported customer defects that have been corrected in a release or that are planned for a future maintenance release.
If you have been given an APAR number to track a reported defect, you can find information about the defect through the Product Fix List.
APARs have unique identifiers. For example, "IY53671" and "JR19727". Each APAR is specific to a particular version of a product (for example, DB2 version 8 or DB2 version 7).
The APAR process
The first step in the APAR process is that a Level-2 representative from the support organization enters an APAR containing a description of your problem into the RETAIN® system. If you have a means of getting round the problem, details of this are entered as well. Your name is also entered, so that your support organization knows who to contact if the service team need to ask anything further about the APAR documentation.
At this stage, you are given an APAR number. This number is always associated with the APAR and its resolution and, if a code change is required, is associated with the fix as well.
The service team may ask for additional backup documentation, normally via the Level-2 representative. The specific documentation required will vary from problem to problem, and depends on what information has already been supplied during the PMR stage.
During the investigation, you can ask your support organization at any time about how your APAR is progressing, particularly if it is a problem of high severity.
What are the FixPaks?
A FixPak contains updates and fixes for problems (Authorized Program Analysis Reports, or "APARs"). These APARs address problems found during testing at IBM(R), as well as fixes for problems reported by customers.
FixPaks are cumulative. This means that the latest FixPak for any given version of the product contains all of the updates from previous FixPaks for the same version of the product. It is recommended that you keep your environment running at the latest FixPak level to ensure problem-free operation.
Viewing APAR content
Every FixPak is accompanied by a document, an APAR list, which lists the APARs contained in the FixPak. The full description of the APAR can be found on the IBM Products Support website for all available platforms.
100 Tech Tips: #84 Tuning IBM Infosphere Information Server to achieve good performance on Microsoft Windows 2008 Server
ubektas 27000478GM Visits (825)
It covers the following areas:
Configuring the parallel engine
Configuring the Windows Registry: Enabling auto-tuning for paged pool size
Configuring the Windows Registry: Enabling auto-tuning for system page size
Configuring the Windows registry: Increasing the noninteractive desktop heap size
Configuring the Windows registry: Specifying TCP/IP settings
You can refer to that technote in the link
100 Tech Tips: #83 The exact list of older versions of IBM InfoSphere Information Server's product modules with end of service
ubektas 27000478GM Visits (955)
IBM has announced the exact list of InfoSphere Information Server product modules that reached their end of service on April 30th,2012
The list of products with end of service :
* IBM WebSphere DataStage version 7.5.0, 7.5x2, 7.5A, 7.5.1, 7.5.1A-OEM, and 7.5.1A
* IBM WebSphere QualityStage version 7.5.0 and 7.5.1
* IBM WebSphere MetaStage version 7.5.0, 7.5r2, 7.5r4, 7.5r5, 7.5.1, 7.5.1r1, and 7.5.1r2
* IBM WebSphere MetaStage Explorer version 7.5.0, 7.5r2, 7.5r4, 7.5r5, 7.5.1, 7.5.1r1, and 7.5.1r2
* IBM WebSphere ProfileStage version 7.5.0, 7.5r1, and 7.5.1
* IBM WebSphere ProfileStage Designer version 7.5.0, 7.5r1, and 7.5.1
* IBM WebSphere Real-time Integration version 7.5.0, 7.5.1, and 7.5.1r1
You can access the published announcement by clicking on the link. You will also find version replacement information there
KateDawson 060001TQ2C Visits (1231)
100 Tech Tips: #82: Find IBM Netezza on the Support Portal!
Attention IBM Netezza Clients: You can now search for and select IBM Netezza in the Support Portal to find IBM Netezza information, technical documents, sign up for automated notifications about your Appliance, and open service requests.
Click this link to access the Support Portal with IBM Netezza already selected in your product list.
As you become familiar with the Portal, here are a few tips:
The following images are from the Support Home tab of the Portal.