Need online technical queries answered now for your IBM DB2 products running on Linux, Unix and Windows (LUW)? Please post your queries in the IBM dWAnswers forum for DB2 for our worldwide IBM DB2 experts as well as the user community to assist you. If you are an expert DB2 user, please feel free to contribute to the forum and make IBM developerWorks the premium spot for DB2 LUW queries and information. Thank you for your support and would love to read your suggestions, comments or feedback. Regards Robert... [More]
Join us for our upcoming Support Technical Exchange! Our speaker, Gary Foster, will guide us through a deep dive on I BM InfoServer DataStage PX Engine - Lookup Stage. Abstract: The parallel lookup stage is one of the most used stages in PX job design. In this presentation, Gary will show the options for use, case scenarios and how this stage works internally so you can make better decisions on how to use this stage in your job designs. With proper use, you can capitalize on available resources and maximize performance of your jobs. This... [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]
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]
The current JDBC driver shipped with DB2 called the IBM CLIENT DRIVER FOR JDBC AND SQLJ can function as both a JDBC Type 4 and JDBC type 2 driver. Type 4 Mode When functioning as a JDBC type 4 driver, the driver is independent of the DB2 Client and only the driver jar db2jcc.jar or db2jcc4.jar need be installed. In this mode all TCP/IP command execution and routing is done through Java. In type 4 mode the driver requires the TCP/IP name and port of the server and uses the name of the database alias at the server. If a Z/OS DB2... [More]
Today we'd like to share a very important reminder for any of our clients running DB2 version 9.5. You should be aware that DB2 version 9.5 will reach End of Support on April 30, 2015. Please see our DB2 EOS Technote , for answers and guidance on topics including: How do I purchase a Support Extension? Is there information to help me upgrade? What DB2 9.5 servers are affected? What if I have a special build or an older fix pack on DB2 9.5? Am I still supported? I am using DB2 9.5 as part of a bundle, am I still supported? Is the... [More]
We are pleased to share a new video available on the IBM Electronic Support YouTube Channel: Keeping Service Requests to a Single Issue Did you know that when you limit a Service Request to a single issue, IBM Support is better able to prioritize and update you on the issue's status? If you have more than one issue, you are welcome to open multiple requests (even for topics related to a single larger issue, such as an upgrade). By signing in to Service Request, you will be able to see all of your open requests... [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]
As 2012 winds to a close (wow... where the heck did the year go?!?!?) we would like to thank all of our readers for a fantastic 2012 ! Our team of Support experts really enjoyed bringing you over 130 blog posts about top technical support content for all of our Information Management Products. We hope that you have found our blogs interesting and useful. We've got a number of ideas already for 2013... we'll be back bigger and better than ever! Here are a few easy ways to find our blogs: View blog posts by tags -- we have tried to use... [More]
We'll keep this post short and sweet :) Fix pack 5 for DB2 for Linux, Unix, and Windows 9.7 was released today! Click here to download the fix pack . If you are looking for a Fix Pack for another version of DB2 for LUW, visit this page to view all available Fix Packs .
The Information on Demand Conference will get under way this weekend! If you aren't able to attend the event in person, there are many ways to connect with the event from home. Check out our suggestions below: On the conference Livestream , you can watch streaming video of the conference throughout the day. See the EXPO, listen to keynote speeches, watch interviews with key IBMers and IOD attendees. Connect with our Support team on Facebook and Twitter! Our team will be at the event and actively posting photos and information from the... [More]
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.
Hello! Recently I had opportunity to play around db2audit tool. db2audit tool is DBA's best friend when it comes find all the activities going on in database. DB2® database systems provide an audit facility to assist in the detection of unknown or unanticipated access to data. The DB2 audit facility generates and permits the maintenance of an audit trail for a series of predefined database events. For more information about db2audit command, refer Information Center db2audit can be divided in 5 main steps as : 1> Configure 2>... [More]
Andrew wanted to let you know about some new information that has been posted to iiug2014.org about this year's conference. Sessions are now available at iiug2014.org/sessions.php Hands on Labs are now available at iiug2014.org/hol.php Tutorials are now available at iiug2014.org/tutorials.php Keynote Speakers this year will be Beth Smith, General Manager IBM Information Management and good friend of the IIUG Jerry Keesee, Director of IBM Informix Development. You can find... [More]