You can't - there's no ALTER INDEX command. Drop and recreate the index,
runstats, rebind ...

-----Original Message-----
From: Saldana Jose G
[mailto:db2udbdba-ezmlmshield-x12398855.[Email address protected]
Sent: 9 May 2008 15:21
To: LazyDBA Discussion
Subject: Altering PCTFREE for an index


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



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