Hi there.

I have some indexes created on my tables. How do I find the sql for them?

Db2 v.8

thx.

db2look command. See the Command Reference manual.

If you have BMC Software Administrative Products installed at your site, you can view the DDL of the INDEX. By the way why do you need the DDL of index..? If you need to know the combination of keys involved i think you can query the catalog tables. I dont know about db2lookup.

Question to Marcus:
Is db2lookup available on all the platforms..? I wanted to know whether it works on Z/OS platform..?

Any suggestions would be greatfull. Thank you

about z/os I don't know, but you can run db2look -d dbname -e -l -x -o outname on a remote client for a remote database
you need to add -w password -i userid

the db2look utility actually worked perfectly.

I was able to see all sql pertinent to the database.

thanks.