Try -z (schema), -t (table) flags to limit the output to a table level )

Suresh G.




"pavan" <db2udbdba-ezmlmshield-x55757074.[Email address protected]
02/22/2007 10:30 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
Re: db2look to extract only indexes.






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




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



CONFIDENTIALITY NOTICE:
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited.
If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000.

CAUTION:
Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time
without any further consent.


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