July 2004
Intermediate to advanced
446 pages
10h 34m
English
book
Implementing and Administering WebSphere Business Integration Server V4.2.2
by Geert Van de Putte, Andreas Eggenschwiler, Alicia Harvey, Manuel Carlos Rodriguez Alvarez-Querol, Satyavani Suryadevara, Francois van der Merwe
Content preview from Implementing and Administering WebSphere Business Integration Server V4.2.2
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 11. Tuning a WebSphere Business Integration Server infrastructure 395
for evaluating a query. Statistics are maintained on tables and indexes. Examples
of statistics include the number of rows in a table, and the number of distinct
values in a certain column of a table. These statistics are not maintained by DB2
in real time; statistics are updated by DB2 commands that are typically run by the
DBA. If statistics are not updated on a regular basis, the DB2 query optimizer
may create poor-performing access plans for evaluating queries. The following
command can be used to update statistics on all tables in the database:
db2 -v reorgchk update statistics on table all
More information about maintaining catalog statistics can be found in ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.