I recently changed employer, and I'm now working with DB2 on mainframe.

Does db2look exist for DB2 on z/OS or is there another tool the can do the same thing (generate the DDL scripts for an existing database)?

I'm used to look up things about db2 (LUW) on http://publib.boulder.ibm.com/infocenter/db2luw/v8//index.jsp. Is there something similar for DB2 on z/OS available ?

There is a db2look for ZOS using REXX and ISPF Panels in IDUG Insider.

http://www.idug.org/user/userlogin.asp

Register, logon and go to 'Codeplace'

Sathyaram