MVSFORUMS.com

vmbigot · Posted: Thu May 25, 2006 12:22 pm Post subject: DB2 Control center and DDL

I am currently running DB2 8.1 on z/OS 1.4, using Control Center on Windows to manage my mainframe databases. We have recently acquired the expertise of a DB2 consultant who also uses Control Center to manage his DB2 databases at other locations. He has informed us that there is a Control Center function missing in our Control Center. He tells us that by "right-clicking" on a table in Control Center should give us several options, including one called "Generate DDL". We don't have this option in our Control Center and I can't seem to find any reference to it in the manuals.

Does anyone know how to enable or configure this "Generate DDL" option in Control Center? Any insight to this would be very helpful!

Thanks,

vmbigot
_________________
Inside every older man is a young boy asking this question. What the heck happened?!?

kolusu · Posted: Thu May 25, 2006 1:18 pm Post subject:

vmbigot,

Check this link which might be of help

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.cc.doc/db2_udb/generatingddlstatements.htm

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

vmbigot · Posted: Thu May 25, 2006 1:57 pm Post subject:

kolusu,

Thanks for the link. It does verify that I should have the right-click option to generate DDL, but my Control Center doesn't display that option. I suspect that if I had it, it would run db2look under the covers and I can probably use db2look to get what I need, but the GUI right-click would be nice. You wouldn't happen to know how to enable that feature, would you?

Thanks,
vmbigot
_________________
Inside every older man is a young boy asking this question. What the heck happened?!?

kolusu · Posted: Thu May 25, 2006 2:17 pm Post subject:

Vmbigot,

I haven't used the control center , so can't tell you how to enable that feature. Check this link which explains some tips about customizing the views

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.cc.doc/db2_udb/intro.htm

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

vmbigot · Posted: Thu May 25, 2006 3:30 pm Post subject:

Kolusu,

Thanks for the assistance. I'll keep digging to find out how to enable this feature in Control Center and update this post when I find out more info. Sooner or later someone else is going to have the same problem!

vmbigot
_________________
Inside every older man is a young boy asking this question. What the heck happened?!?

Manas Biswal · Posted: Fri Jun 02, 2006 1:10 pm Post subject:

vmbigot,

Do you get the generate DDL options for local DB2 UDB on Windows DB tables.

Regards,
Manas
_________________
There is no path to peace. Peace is the path.
- Mahatma Gandhi (1869-1948)

vmbigot · Posted: Fri Jun 02, 2006 1:34 pm Post subject:

Manas,

We don't have any DB2 UDB for Windows databases here at the office, just DB2 on z/OS. However, I downloaded IBM's free DB2 the other day on my PC at home so I'll test the Control Center generate DDL option on those databases. Thanks for the tip!

vmbigot
_________________
Inside every older man is a young boy asking this question. What the heck happened?!?