If I would like to extract ddl for an index on a specific table, can i
customize this ??
Again, I just want to know the ddl for index. nothing else.



On Thu, February 22, 2007 3:55 pm, Chip McAllister wrote:
>

> Pavan,
>
>
> Try this:
> ################################################
> # to generate ddl for tablepaces, tables,indexes, contraints, view,
> foriegn keys, # grants at the database and table level, dbm and db config
> changes # pretty much everyting in the databasse
> ################################################
>
>
> db2look -p -x -f -e -a -l -d <database name> -o output
>
> Chip McAllister
> UDB DBA
> Tie 293-2505 outside 845-433-2505
> BLD 003 2455 South Road Poughkeepsie NY 12601
> [Email address protected]
>
>
>
>
> "pavan"
> <db2udbdba-ezmlms
> hield-x13728642.x To
> [Email Address Removed] "LazyDBA Discussion"
> a.com> <[Email address protected] cc 02/22/2007 10:35
> AM Subject
> db2look to extract only indexes.
>
>
>
>
>
>
>
>
>
>
> Gurus,
> I have used db2look few times but now am not able to figure out the exact
> command to extract the ddl for indexes on a given set of tables. The idea
> is to drop these non-primary indexes to load data (to make it faster) and
> then re-create these dropped indexes. Can someone help me in generating
> the ddl for non-primary indexes on a given set of 10-15 tables. thanks.
>
>
>
> ---------------------------------------------------------------------
> 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
>
>
>
>
> ---------------------------------------------------------------------
> 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