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]
==============================================================================


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