Is there any way to extract the DDL of the existing wrapper on the database ?

I know we can do it by running db2look -d dbname -wrapper and grep for the create wrapper or create server statement but because db2look with -wrapper option is returning the DDL for all its federated objects, the box is going out of memory. So I need a workaround to extract the DDL of just the wrapper/server create statements. Any help would be appreciated.

Not sure what you mean by "going out of memory". If you are concerned about the disk space, you can pipe db2look output directly through grep, without writing the script to disk.

The only other alternatives would be to find some other tool (if there are any) or to piece together the statements based on the DB2 catalog tables. That's what db2look is doing as well.

Thanks stolze