Willie Favero |
APAR Friday: Five for FridayI'm back with my Friday APAR hunt. This week I thought I would concentrate a few HIPERs. They are more critical and there are probably more folk tracking them on a weekly basis. This first APAR HIPER resolves a DB2 9 issue with returning too few rows from a query.PK62865: INCORROUT (MISSING ROWS) IN APPLICATION, THE PROBLEM QUER |
Last updated: May 12, 2008 All times are UTC.
Bloggers
- Adam Gartenberg
- Anant Jhingran
- Antonio Cangiano
- Bernd Kuennen
- Boris Bialek
- Chris Eaton
- Chris Gruber
- Craig Mullins
- DB2 Diary
- DB2 Express-C team
- DB2 Malaysia
- DB2 on Rails
- DB2 on Twitter
- DB2Mag.com Blogs
- DB2utor
- Dan Krook
- Fred Sobotka
- FreeDB2
- Grant Hutchison
- IBM Press Room
- Ian Hakes
- Kate Dawson
- Leon Katsnelson
- Leons Petrazickis
- Omer Brandis
- Peggy Zagelow
- Philip Nelson
- Rav Ahuja - Podcasts
- Robert Catterall
- Susan Visser
- Vincent McBurney
- Willie Favero
- developerWorks
- planetDB2 News
Adam Gartenberg |
Hello PlanetDB2!I'd like to say a big hello to everyone reading this from PlanetDB2! For those of you to whom I may be a new face, please allow me to introduce myself for a minute. I recently joined the IBM Data Management group as the team lead for Social Marketing initiatives. ...… |
planetDB2 News |
Welcome, AdamAdam Gartenberg is the latest blogger to join PlanetDB2. To have your blog added, drop us a line at join@planetdb2.com.In other news, DB2 is now on Twitter.… |
|
Adam Gartenberg |
IBM’s Social Computing GuidelinesThanks to Andy Piper for blogging about the recent updates to IBM's Social Computing guidelines, which now extend beyond blogging to include participation in social networks, media sharing sites, virt ...… |
|
Adam Gartenberg |
What’s your favorite user group website?I know many of you currently or in the past have travelled in multiple technology circles. I'm curious what your favorite (or least favorite) user group website(s) are, and why? How does (or shoul ...… |
DB2 on Twitter |
db2: IBM is offering free Information Management Online Certification Assessment Testing: http://tinyurl.com/5k6vse. Are you ready? ;-)db2: IBM is offering free Information Management Online Certification Assessment Testing: http://tinyurl.com/5k6vse. Are you ready? ;-) |
Kate Dawson |
IDUG Members: Take a free online assessment exam!If you are planning to take a certification exam at the IDUG North America Conference, May 18 – 22, 2008, you’ll be interested in this offer! Information Management is offering free online assessment exams prior to and during the event, May 4 through May 22, 2008. These assessment exams are a great way to determine if you are ready to ace a certification exam and normally cost $10 USD each. Assessment test quantities are limited and there is only one complimentary assessment test per person. To learn more and get your access code, visit the IDUG website.
Good luck! P.S. While you are at IDUG, check out the Skills Hub located near the bookstore to find info about everything related to education. |
developerWorks |
Data Web Services on WebSphere Application Server, Part 2: Enable transport-level securityConfigure the sample Data Web Service application from Part 1 of this series to use basic HTTP authentication and authorization. |
|
developerWorks |
The information perspective of SOA design, Part 7: The execution approach for the data quality analysis pattern in SOAThis is the seventh paper in a series called the “The Information Aspect of SOA Design." The purpose of this article is to demonstrate to an architect community the execution approach of detailed data quality analysis in the context of an SOA environment. This article focuses on the implementation of data quality analysis regardless of the specific technology in use, and will be followed by a related article that describes in more detail how the related IBM products (WebSphere Information Analyzer) can be used in this context. |
|
developerWorks |
XForms and DB2 pureXMLUnderstand the end-to-end exchange of XML data from an XForms-based browser to an IBM DB2 database with full XML support. Learn how easy it is to create XForms and have them communicate with a DB2 database, where XML data can be stored, retrieved, or deleted. Learn, also, how to create the XForms that access the DB2 pureXML through Universal Services. |
|
DB2 on Twitter |
db2: The API team just released a new update (0.2.9) to the Python driver and SQLAlchemy components for DB2: http://code.google.com/p/ibm-db/.db2: The API team just released a new update (0.2.9) to the Python driver and SQLAlchemy components for DB2: http://code.google.com/p/ibm-db/. |
|
Willie Favero |
Index CompressionI guess it 's time to get back to blogging about how stuff works. I have a little more time to think right now; in between articles and have no presentations due to any conferences in the near future, so I will use the few minutes of extra time for some good old fashion tech blogging. Although DB2 adds index compression in DB2 9, the term compression is where similarities to data compression quickly end: |
Vincent McBurney |
Microsoft Subpoenas Oracle for the Dirt on the JuxtaComm DealMicrosoft has issued a Subpoena on Oracle to release the details of a confidential patent infringement settlement with JuxtaComm to help with their own patent infringement battle. |
DB2Mag.com Blogs |
DB2 for Linux, UNIX, and Windows Versions 8, 9.1 and 9.5 Security Vulnerabilities and HIPER APARsDid you catch the 21 April 2008 IBM Flash Alert? Since not everyone subscribes to IBM alerts, I thought it prudent to bring your attention to new fixpacks here. It seems IBM acted reasonably swiftly and appropriately to create these new fixpacks for V8, V9, and V9.5, which address the documented vulnerabilities. |
|
DB2Mag.com Blogs |
DB2 Certification: Creating objects from the Control Center and understanding Import command optionsIDUG North America and the free certification opportunities it presents are just weeks away. Brush up by glancing through these certification sample questions and many others. All questions are from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press, and are reprinted with permission. Check back each week for more. QUESTION 33 A. Buffer pool QUESTION 34 A. ALLOW NO ACCESS |
Robert Catterall |
Your Other JobIt's been a while since my last post on a non-technical subject. I'm inclined to do write such an entry today, and its my blog so I'm going to. [It's fun now and again to do something because you can - that is, because you're in a position to do so. I remember when U.S. President George H. W. Bush (father of the current President) invoked executive privilege when explaining his food likes and dislikes: "I'm the President and I don't have to eat broccoli."]<b… |
|
Willie Favero |
Have PowerPoint, Will Travel (plus some shameless begging)Sound familiar? It should. I used it in a post I made last year. And just as I asked back then, does anyone remember Paladin? If you do, then you know where I "borrowed" the title for today's post. Paladin was the "gun for hire" (but also the good guy... go figure!) in the 1957 TV series "Have Gun, Will Travel". The role of Paladin made Richard Boone famous. Now on a complete tangent, did y |
IBM Press Room |
IBM Prepares Students in Asia to Meet Global Software Skills DemandIBM today announced a new program to help university students in Asia enhance their skills to compete in a global market. The new program will allow students at more than 2,100 institutions in India, China, Singapore and Vietnam to enhance their credentials and better compete for the growing number of technology positions available in the region.
|
|
IBM Press Room |
IBM Prepares Students in Asia to Meet Global Software Skills DemandIBM today announced a new program to help university students in Asia enhance their skills to compete in a global market. The new program will allow students at more than 2,100 institutions in India, China, Singapore and Vietnam to enhance their credentials and better compete for the growing number of technology positions available in the region.
|
DB2utor |
How to Write Efficient SQLNote: This blog entry is part one of a three-part series. What's the most efficient SQL statement you could ever write? The answer is one... |
|
DB2Mag.com Blogs |
Finding the Right Page Size for Your Indexes on InformixIn my last blog we took a look at storing indexes in a dbspace with a large page size to try to decrease the number of levels in an index and increase performance by reducing the number of I/Os required to traverse the index. Using the largest page size available, 16K, we were able to decrease the number of levels in our test index from 5 to 4, but only realized a slight performance gain if--and only if--we increased our resident segment (buffers) from 512 MB to 1.5 GB to compensate for the larger, less selective page size and larger cache miss penalty of a 16K disk read vs a 2K disk read. I ended the blog with the suggestion that the best solution would be to find the smallest page size that still reduces the number of levels, giving us the benefits of better caching through smaller index pages and the benefits of reduced index levels when using larger page sizes. |
Omer Brandis |
SAP Archiving FoesToday I'd like to shed some light on the biggest problem I have faced when it came to archiving sap data. its not the technological complexity of setting up the archiving server, it's not related to performance... the number one problem i have faced is ... |
|
Kate Dawson |
Attention Informix DetectivesIf you are looking for a fun way to learn the basics of IBM Informix and relational databases, I’ve got the answer for you. Play the IDS Detective Game and see how technology can be used to solve real-life problems, such as a crime scene investigation, while practicing relational database concepts. With this game you can:
You have to have IBM IDS 11 installed, the IDSGame database loaded, and the clue file running to play. Check it out at ibm.com/developerworks/edu/dm-dw-dm-0804moffatt-i.html.
Enjoy the game! P.S. Other games are available for DB2. Play the DB2 Detective and the DB2 Business games here: ibm.com/software/data/education/games.html. |
|
IBM Press Room |
IBM Boosts Business Intelligence Software Performance on BladeCenter ServersIBM today announced breakthrough scalability and performance running the SAP NetWeaver(R) Business Intelligence Accelerator (SAP NetWeaver BI Accelerator) component of the SAP NetWeaver platform on IBM BladeCenter servers.
|
DB2 on Rails |
The status of DB2 and Rails 2.xI’d like to take a moment to provide a small status update on what’s been going on in the DB2 on Rails world. The Alphaworks starter toolkit hasn’t been update for a long time, so someone may wrongly assume that the project is not maintained, but nothing could be further from the truth. The toolkit [...]… |
|
Robert Catterall |
DB2 for z/OS Accounting: And a One, And a Two...When people analyze DB2 for z/OS monitor accounting reports or online DB2 monitor displays of thread detail data, they often pay particular attention (with good reason) to the elapsed and CPU time figures contained therein. Some of these same folks are a little confused as to the meaning of the numbers they are examining. They see columns of figures under headings that read (depending on the monitor product) "Class 1" and "Class 2" or "In-Application" and "In… |
|
Vincent McBurney |
10 Ways to Make DataStage Run SlowerEveryone wants to tell you how to make your ETL jobs run faster, well here is how to make them slower! |
|
Kate Dawson |
Get ready for IOD, October 2008I’ll admit that this post seems a bit early… the Information on Demand Conference isn’t happening until October. But it seems like just yesterday it was January so time is definitely flying this year. Now is the time to start thinking about the conference, particularly if you plan to take advantage of the three complimentary Information Management certification exams registered attendees can take. Step one: Planning Step two: Studying
Step three: Assessing Step four: Testing
Step five: Relaxing
Good luck! |
|
DB2utor |
Implementing an Online COLUMN Rename in DB2 V9DB2 V9 includes the capability to rename a COLUMN on a table without having to drop the table and recreate it. Given how time-consuming it... |
Craig Mullins |
On the Road AgainIf you live in or around Birmingham, Alabama or Dallas, Texas or Phoenix, Arizona I will be in your neck of the woods the next two weeks speaking at the local DB2 user groups.On April 30th, 2008 I'll be speaking at Alabama DB2 User Group on the topic of Managing Data For Long Retention Periods. Then, on May 2nd, I mosey on over to Dallas to speak on two topics at the DB2 Forum meeting… |
Susan Visser |
Good headphones...I recently invested in good headphones... and I'm glad I did. I've already used them for an ILO course, listened to the many podcasts, watched the new IBM commercials on YouTube, watched the videos on ChannelDB2, and will likely find many more purposes. IBM's list of ILO courses is growing steadily. My recommendation... Make sure that you fully test your headphones and mic BEFORE the session. You'll have… |
|
Omer Brandis |
A classic tale of problem determinationA few minutes after I arrived at work, I started smelling this awful smell. No surprise I thought, the last time I cleaned my desk was two years ago. A few mins after cleaning my desk, I could still smell something was horribly wrong, so... |