The developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this blog will no longer be available. More details available on our FAQ.Blogs
Blogs
Matching:
skew
X
X
| Display: |
IBM Db2: Investigating Automatic Storage Table Spaces and Data Skew Community Blog
If you have an IBM Db2 database, chances are it might be using automatic storage table spaces. With Db2 automatic storage table spaces, storage is managed automatically by Db2. Because Db2 controls the table space containers, users cannot configure the...
from Blog: IBM Redbooks Software Blog
Modified on by MarcelaAdanRochester
|
|
50 PureData Nuggets #44 : How to check for tables with skew if one or few dataslices(not all) are showing high usage Community Blog
How to check for tables with skew if one or few dataslices(not all) are showing high usage. You may see below message in nzhealthcheck or you may get nzalert with "dataslice exceeding 80(or 85%) usage. Issue Detected : Data slices getting full ...
from Blog: IBM PureData-Enzee Community
|
|
Importance of setting the right distribution key for improved performance in Netezza Ideation Blog
DeepashriKrishnaraja
Tags:
slice
unique
data
hash
performance
distribute
distribution
key
ampp
join
response
redistribute
collocated
time
random
skew
netezza
5 Comments
61,248 Views
Performance, thy name is Netezza. One of the key factors which contribute to this aspect is the intelligent data distribution owing to the AMPP architecture of Netezza. This efficient data distribution is determined by a good distribution key. First of...
from Blog: IBM PureData-Netezza Developer Network (NDN)
Modified on by DeepashriKrishnaraja
|
2 votes |
Window to the Sanctum
"What's this?" asked the CFO of the Data Warehousing Director, now holding a fresh-off-the-press request for more hardware. "We've hit capacity," said the Director with a sigh, lowering himself wearily into a padded chair. " What? That...
from Blog: Netezza Underground
|
|
Distribution - what's up with that?
One of the most significant questions to answer on the Netezza platform is that of "distribution" - what does it mean? how does it apply? and all that. If you are a Netezza aficionado, be warned that the following commentary serves as a bit of a...
from Blog: Netezza Underground
Modified on by DavidBirmingham
|
