Adam Koile 270000GAYM Visits (1544)
Always wanted to know what the package name was for each bind file in our fix packs. Then you're in luck because we have put together the following tech docs to help you with that:
Still have questions about a DB2 package name, then comment below.
Genek64 060001NR1T Visits (1517)
you want to relocate the Xmeta repository, perform administration and
configuration activities for Xmeta or the WebSphere Application
Server, or configure WebSphere 7.0 to use Secure Sockets Layer to be used with the
Information Server version 8.5
Let's see how IBM Education Assistant modules can help.
Keep following this blog
to read all of the tips!
Posted by Gene Knapp
Adam Koile 270000GAYM Visits (1599)
Looking for some helpful JDBC links then check these out:
Still have trouble or just have a question about the IBM JDBC driver, then comment below.
Genek64 060001NR1T Visits (1531)
Tip number 23 talked about traces and troubleshooting. This time we hope to help answer your questions about InfoSphere DataStage and QualityStage administration and configuration.
Let's see how these IBM Education Assistant modules can help.
Posted by Gene Knapp
KateDawson 060001TQ2C Visits (2269)
Do you have questions about InfoSphere DataStage? Do you need help with a trace or connection issues? I am happy to share with you new resources to answer some of those questions! Let IBM Education Assistant modules help.
Let's begin troubleshooting InfoSphere DataStage now.
The following IBM Education Assistant modules will help you troubleshoot IBM InfoSphere DataStage issues for versions 7.5, 8.0.1, and 8.1.
Posted by Gene Knapp
Take a Proactive Approach to Managing your Support Plans and Issues - with help from AVP (the Accelerated Value program)
IBM Subscription and Support provides world-class software support via award-winning tools and support personnel. AVP – aka the Accelerated Value Program - added to your S&S contract, provides comprehensive maintenance and support guidance and assistance for issues that occur across all phases of the software life-cycle .
With AVP, you can get assistance with tasks like file fixing, code reviews, and upgrade tasks, as well as advanced support activities like defining your support plan, doing support readiness reviews, and assistance managing issue resolution activities.
Assigned senior IBM Support experts will provide you with personalized, proactive, and prioritized support management and issue assistance. Depending on the type and level of help you need, you'll have an AVL (Accelerated Value Leader) or AVS (Accelerated Value Specialist) who knows your software infrastructure and understand your business needs. When issues arise, your AVP expert will help you get back on track quickly, and if needed, can also help with the planning, execution, and management of a personalized Support strategy that focuses on issue prevention.
AVP also helps improve the availability of both mission-critical applications and system deployment times, which in turn, helps optimize how in-house support teams work.
With AVP, your assigned AVL or AVS:
AVP also provides other benefits, like priority call handling, access to technical skills-sharing events, and no-cost Certification Vouchers (where applicable – talk to your AVP Seller for details)
Find out more at IOD 2011!
Visit the AVP Red Carpet Lounge (space 431) and learn how comprehensive Software lifecycle support along with proactive assistance for issue prevention can help your work smarter.
A haven for Support mavens, the AVP Red Carpet Lounge has experts on-staff throughout the day to talk about how proactive advice and help from the Accelerated Value Program can help you get quicker returns on your software investments. Inside the Lounge, current AVP customers can take a break from the conference action and join our daily Tech Talks or just drop by for a quick cup of coffee and a chat with your peers.
We'll also be hosting daily discussions and presentations throughout the day, showcasing real-life examples of how AVP helped customers resolve issues quicker, saving both time and money. We encourage you to stop by the Lounge to find out how IBM AVP can help you improve the stability, performance, and availability of your IBM Software.
The AVL Red Carpet Lounge is open during all EXPO hours:
Enjoy IOD 2011 and make sure to plan ahead to get the most out of your conference experience!
KateDawson 060001TQ2C Visits (1522)
Folks who are interested in IBM InfoSphere Guardium will be happy to know that there is a brand new forum on developerWorks specifically to address IBM InfoSphere Guardium questions! This community forum will allow you to exchange ideas, ask questions and share solutions with your peers.
The InfoSphere Guardium forum is a great addition to our already active Information Management Forums on developerWorks!
What is IBM InfoSphere Guardium?
Slakshmi 060001JD9S Visits (1322)
Are you new to DB2 for Linux,Unix and Windows? Here are some of the useful links for you to bookmark:
DB2 for Linux, UNIX and Windows Trial Downloads can be found here:
DB2 Fixpaks by version can be downloaded from here:
How to obtain DB2 License:
DB2 Product manuals and links to information centers:
DB2 external support portal helps you to get up-to-date information about the product.
Adam Koile 270000GAYM Visits (2028)
amccarl 100000AY2G Visits (1206)
What does Information On Demand 2011 have to offer???
.... the numbers go on and on!
Don't just SEE the numbers - BE the numbers!
Join the numbers of people from around the world attending Information On Demand 2011!
Watch the video http
KateDawson 060001TQ2C Visits (1434)
Chances are, you have heard of the IBM Support Portal by now. However, have you had a chance to really try it out? Have you taken the time to learn about all the Support Portal features and how they can save you time and keep you productive? Today's tech tip is to reserve six minutes and sixteen seconds today to discover the value of the Portal!
IBM Electronic Support has recently published a new video on YouTube to walk you though the IBM Support Portal and help you get the most from this unified, centralized view of all technical support tools and information for IBM systems, software, and services worldwide.
KateDawson 060001TQ2C Visits (2599)
Today's Technical Tip comes from a guest blogger, Angela Yang. Angela is an Advanced Technical Support Analyst for DB2. She has been working with DB2 for the past 8 years. Angela works out of IBM's Toronto Lab. Look for more blogs from Angela on other hot DB2 topics!
Section explain and section actuals are new Explain features that are useful for query performance problem determination. This blog introduced these two features and the usage of them through exercises.
Section explain is a new feature added in DB2 9.7. Using the regular explain mode, users need to re-run the query in explain mode. With section explain, users do not need to re-run the query, they can directly obtain the explain information from the section as long as the section is still available either in the memory or catalogs. This exercise is designed to help you become familiar with various explain stored procedures that allow explain the plan from section.
Note: when you compare section explain and regular explain in this exercise, please keep in mind that not all regular explain information can be retrieved from section. Some non-critical information is not saved to avoid expanding the section too much.
Exercise 1: expl
The difference between section explain and regular explain is documented here.
Exercise 2: expl
Note: This exercise is designed to help you get familiar with usin
Exercise 3: explain_from_data The section data could be captured and stored in a monitor table. Please refer to the Info Center for this feature.
Section actuals is a new feature added in V97FP1. Explain from section actuals will report actual rows returned from each operator in the plan. The optimizer estimates number of rows based on statistics. Users can compare the estimate rows and the actual rows, to see if any operator has estimated rows far off from the actual rows. If any case like that happens, it usually means the statistics need to be updated.
There are 2 ways to enable actuals collection. One way is to use a stored proc
In this exercise, we will use wlm_set_conn_env.
Explain level: Explain from section
amccarl 100000AY2G Visits (1426)
Chat More Chat!
Slakshmi 060001JD9S Visits (3244)
Ever wonder how to determine the severity of an issue while opening a PMR with IBM Technical support?
Here are some tips that you can refer:
Severity levels are determined based on the business impact of the issue. If a customer designates a problem as a Severity 1 with critical business impact or System down situation, IBM will work on it 7 days a week, 24 hours a day, providing the customer is also available to work during those hours. Customers can change the severity level of a problem if circumstances change from when it was first entered to match current business impact conditions.
Here are the various Severity level situations and examples :
Severity 1 Critical Impact/System Down: Business critical software component is inoperable or critical interface has failed. This usually applies to a production environment and indicates you are unable to use the program resulting in a critical impact on operations. This condition requires an immediate solution. Support analyst will respond to your service request within one business hour. IBM will work on it 7 days a week, 24 hours a day, until the issue is solved.
Severity 2 Significant business impact: A software component is severely restricted in its use or you are in jeopardy of missing business deadlines because of problems with a new application rollout. These service requests will be handled only during the business hours of the prime shift.
Severity 3 Some business impact: Indicates the program is usable with less significant features (not critical to operations) unavailable. These service requests will be handled only during the business hours of the prime shift.
Severity 4 Minimal business impact: A non-critical software component is malfunctioning, causing minimal impact, or a non-technical request is made. These service requests will be handled only during the business hours of the prime shift.
Here is the software support handbook you can refer before opening a PMR:
Most of the technical tips on our 100 Technical Support Tip blog series focus on the real nitty gritty information you need to stay current with your IM product. However, from time to time we will also suggest other ways to keep your skills current. One of the best ways to validate your expert knowledge on one of our IM products is through IBM's industry-recognized certification program.
Here are a few steps you can take if you'd like to earn a new IM Certification:
So there you have it -- four steps to validating your skills through IM Certification. Best of luck with your exams!