Adam Koile 270000GAYM Visits (1115)
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.
Need help navigating through Passport Advantage to find your DB2 license key. Then you're in luck because we have put together the following to help you with that:
Still have trouble or just have a question about your DB2 License key, then comment below.
Slakshmi 060001JD9S Visits (1993)
Looking for some ideas to troubleshoot problems with DB2 on LUW?
Check out our available self-help problem determination guides.
Each guide has 4 different sections to help you troubleshoot the issue:
amccarl 100000AY2G Visits (1886)
IBM significantly updated the
For more detail, see the article "IBM Support Portal - recently updated based on your feedback"!
Adam Koile 270000GAYM Visits (1765)
Need help with common DB2 security issues, than your in luck because we have put together the following links to help you with that:
Still have trouble or just have a question about DB2 security issue, then please comment below.
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!
Slakshmi 060001JD9S Visits (3435)
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:
amccarl 100000AY2G Visits (1457)
Chat More Chat!
KateDawson 060001TQ2C Visits (2661)
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
KateDawson 060001TQ2C Visits (1471)
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.