ddl for Tablespaces

Gerrit Groenendaal

ddl for Tablespaces
Hi list,



Just a question,



We have a database on Z/OS db2 V7 and a copy on Windows UDB V 7.2, from the DDL on the mainframe we want to generate the DDL for Windows. We are using Erwin and we know DB2look, but both don't support the DDL for the table space.



Has anyone an idea?



Regards,



MVA

Gerrit Groenendaal



---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Peter J Krawetzky

Re: ddl for Tablespaces
(in response to Gerrit Groenendaal)

The mainframe platform DDL is different from the midrange platform. You
should be able to convert the tablespace DDL in Erwin by selecting a
different destination database. I believe UDB is one of the options.
Erwin should handle the converstion.

If not, you will have to write an SQL statement to extract the
information from the mainframe DB2 catalog and properly format the
midrange tablespace DDL.



Peter J. Krawetzky, DBA
IBM Certified Solution Expert DB2 UDB V7.1 Database Administration for
Unix, Windows and OS/2


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Gerrit Groenendaal
Sent: Wednesday, January 14, 2004 2:02 PM
To: [login to unmask email]
Subject: ddl for Tablespaces



Hi list,



Just a question,



We have a database on Z/OS db2 V7 and a copy on Windows UDB V 7.2, from
the DDL on the mainframe we want to generate the DDL for Windows. We are
using Erwin and we know DB2look, but both don't support the DDL for the
table space.



Has anyone an idea?



Regards,



MVA

Gerrit Groenendaal



------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm



This e-mail may contain confidential or privileged information. If you
think you have received this e-mail in error, please advise the sender by
reply e-mail and then delete this e-mail immediately. Thank you. Aetna

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Min Zhang

Re: ddl for Tablespaces
(in response to Peter J Krawetzky)
Gerrit Groenendaal.

Another option is reverse engineering by using the DDL that generated from your z/OS to create the data model(s) in the Erwin, then generate the DDL for the Window DB2 UDB.

Enjoy,

DB2 DBA
703.876.4320

>>> [login to unmask email] 01/14/04 02:24PM >>>

The mainframe platform DDL is different from the midrange platform. You
should be able to convert the tablespace DDL in Erwin by selecting a
different destination database. I believe UDB is one of the options.
Erwin should handle the converstion.

If not, you will have to write an SQL statement to extract the
information from the mainframe DB2 catalog and properly format the
midrange tablespace DDL.



Peter J. Krawetzky, DBA
IBM Certified Solution Expert DB2 UDB V7.1 Database Administration for
Unix, Windows and OS/2


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Gerrit Groenendaal
Sent: Wednesday, January 14, 2004 2:02 PM
To: [login to unmask email]
Subject: ddl for Tablespaces



Hi list,



Just a question,



We have a database on Z/OS db2 V7 and a copy on Windows UDB V 7.2, from
the DDL on the mainframe we want to generate the DDL for Windows. We are
using Erwin and we know DB2look, but both don't support the DDL for the
table space.



Has anyone an idea?



Regards,



MVA

Gerrit Groenendaal



------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm



This e-mail may contain confidential or privileged information. If you
think you have received this e-mail in error, please advise the sender by
reply e-mail and then delete this e-mail immediately. Thank you. Aetna

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm