Thank you Thanks & Regards
Venkata Rama Rajesh IT Specialist - Mainframe DB2 DBA IBM
Certified Database Administrator IBM Certified Solution
DeveloperIBM Certified Database AssociateEmail :
[login to unmask email]: +91-7338817414 IBM Services -----
Original message -----
From: Michael Hannan <[login to unmask email]>
To: [login to unmask email]
Subject: [DB2-L] - RE: APPEND YES MEMBER CLUSTER YES FREEPAGE 0
PCTFREE 0 TRACKMODE NO
Date: Fri, Jul 13, 2018 2:58 PM
In Reply to venkata rama rajesh mallina: Making FREEPAGE 0 and
PCTFREE 0 for indexes also improves INSERT performance ?
These are instructions for Reorg or Load. They don't really affect
Insert performance. However in the special case MC00, it is used as
a hint to append where Append was not specified.
It is best you try to understand what things are actually there for
rather than learn rules.
The advice to go PCTFREE 0 and FREEPAGE 0 is based on the
assumption if you insert at the end you won't be using any
freespace spread throughout the table, put there by reorg or Load,
so pages might as well be full unless Update will come along and
increase row length.
So if you use Append, will PCTFREE 5 be harmful to your INSERT? No,
not at all. It may affect cost of scans though slightly, as
potentially less rows per page after a Reorg.
DB2 Application Performance Specialist
CPT Global Ltd Site Links: View post online View
mailing list online Start new thread via
email Unsubscribe from this mailing list
Manage your subscription
This email has been sent to: [login to unmask email]
Faster data refresh is here! The long waits and babysitting of
unload/load jobs is over. Contact
ESAi to learn about BCV5 & XDM. Be a hero to users with fast
on-demand test/QA data provisioning.See
Use of this email content is governed by the terms of service