Hey memo,
Will this extract the DDL for the indexes?
Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Guillermo Jorge Moreno Miguez [mailto:db2udbdba-ezmlmshield-x49095632.[Email address protected]
Sent: Thursday, February 22, 2007 12:49 PM
To: LazyDBA Discussion
Subject: RE: db2look to extract only indexes.
Suresh,
there is the sql for one index jut put the other ones or all
SELECT DISTINCT
A.TABSCHEMA,
A.TABNAME,
A.TYPE,
A.TBSPACE,
A.INDEX_TBSPACE,
A.LONG_TBSPACE,
A.DATACAPTURE,
A.DEFINER,
A.REMARKS
FROM SYSCAT.TABLES A, SYSIBM.SYSINDEXES B WHERE (A.TYPE IN ('T','S')
AND A.TABNAME=B.TBNAME AND A.TABSCHEMA=B.TBCREATOR
AND B.NAME='PK_AS'AND B.CREATOR='VIR') FOR FETCH ONLY;
possunt quia posse videntur
They can because they seem to be able to
("`-''-/").___..--''"`-._
`6_ 6 ) `-. ( ).`-.__.`)
(_Y_.)' ._ ) `._ `. ``-..-'
_..`--'_..-_/ /--'_.' ,'
(((' (((-((('' ((((
Guillermo J.. Moreno M.
Softtek Mexico
IMPORTANTE: Los documentos y archivos que se acompañan a esta transmisión, contienen información confidencial la cual es legalmente secreta. Esta información puede ser usada únicamente por el destinatario cuyo nombre aparece inserto en esta transmisión. Si usted ha recibido esta transmisión por error, notifíquenos inmediatamente por esta misma vía, y borre el archivo y sus anexos. Se hace de su conocimiento por medio de esta nota, que cualquier divulgación, copia, distribución o toma de cualquier acción derivada de la información confiada en esta transmisión, queda estrictamente prohibido, el incumplimiento de esto genera responsabilidad legal.
________________________________
From: Suresh [mailto:db2udbdba-ezmlmshield-x33372901.[Email address protected]
Sent: Thu 2/22/2007 10:46 AM
To: LazyDBA Discussion
Subject: Re: db2look to extract only indexes.
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.
---------------------------------------------------------------------
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