Thank you, I know is possible in z/OS, but I don't think is the same for
DB29 LUW...


-----Original Message-----
From: JAMES PARK
[mailto:db2udbdba-ezmlmshield-x61848285.[Email address protected]
Sent: Friday, May 09, 2008 2:11 PM
To: LazyDBA Discussion
Subject: Re: Altering PCTFREE for an index

In z/OS v7, I see this alter statement.


ALTER INDEX index name
PCTFREE integer


Thanks,

James Park
Database Specialist II
Annapolis Data Center
410-260-7489
[Email address protected]



>>> "Saldana Jose G " <db2udbdba-ezmlmshield-x12398855.[Email address
protected] 5/9/2008 10:20 AM >>>
Hi everyone,



Please help,



How would you alter and index changing the pctfree option? I'm
currently using DB2 LUW 9.1 please provide an example



Thank you



gabe



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




------------------------------------------------------------------------
------
This email and any file transmitted with it may be confidential and are
intended solely for the use of the individual or entity to whom they are
addressed. If you received this email in error, please notify the
Comptroller's System Manager by forwarding this message to [Email
address protected]
========================================================================
======



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page