DDL Generation via DB2 Estimator

Shital S Raja

DDL Generation via DB2 Estimator
I imported all Tables, indexes and related stats into DB2 Estimator. It is
not readily apparent to me, how to go about generating DDL for export.
Does anybody have any insight?
Your reply is highly appreciated.

Shital Raja



Shaun LOMBARD

Re: DDL Generation via DB2 Estimator
(in response to Shital S Raja)
As far as I know DB2 Estimator does not generate DDL, at least not the
version I have.

-----Original Message-----
From: Raja, Shital S [mailto:[login to unmask email]
Sent: Wednesday, 20 December 2000 3:01
To: [login to unmask email]
Subject: DDL Generation via DB2 Estimator


I imported all Tables, indexes and related stats into DB2 Estimator. It is
not readily apparent to me, how to go about generating DDL for export.
Does anybody have any insight?
Your reply is highly appreciated.

Shital Raja








Ashish Mohan

Re: DDL Generation via DB2 Estimator
(in response to Shaun LOMBARD)
DB2LOOK might be a utility to look at for generating DDLs.

Thanks.
Ashish.

-----Original Message-----
From: LOMBARD,Shaun [SMTP:[login to unmask email]
Sent: Tuesday, December 19, 2000 2:34 PM
To: [login to unmask email]
Subject: Re: DDL Generation via DB2 Estimator

As far as I know DB2 Estimator does not generate DDL, at least not
the
version I have.

-----Original Message-----
From: Raja, Shital S [mailto:[login to unmask email]
Sent: Wednesday, 20 December 2000 3:01
To: [login to unmask email]
Subject: DDL Generation via DB2 Estimator


I imported all Tables, indexes and related stats into DB2 Estimator.
It is
not readily apparent to me, how to go about generating DDL for
export.
Does anybody have any insight?
Your reply is highly appreciated.

Shital Raja



visit the
DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list
can be





can



Shital S Raja

Re: DDL Generation via DB2 Estimator
(in response to Ashish Mohan)
Thanks Ashish,
You know if DB2Look is a downloadable utility or what? if
yes, from where can I download ?
Thanks
Shital

-----Original Message-----
From: Mohan, Ashish [mailto:[login to unmask email]
Sent: Tuesday, December 19, 2000 4:48 PM
To: [login to unmask email]
Subject: Re: DDL Generation via DB2 Estimator


DB2LOOK might be a utility to look at for generating DDLs.

Thanks.
Ashish.

-----Original Message-----
From: LOMBARD,Shaun [SMTP:[login to unmask email]
Sent: Tuesday, December 19, 2000 2:34 PM
To: [login to unmask email]
Subject: Re: DDL Generation via DB2 Estimator

As far as I know DB2 Estimator does not generate DDL, at least not
the
version I have.

-----Original Message-----
From: Raja, Shital S [mailto:[login to unmask email]
Sent: Wednesday, 20 December 2000 3:01
To: [login to unmask email]
Subject: DDL Generation via DB2 Estimator


I imported all Tables, indexes and related stats into DB2 Estimator.
It is
not readily apparent to me, how to go about generating DDL for
export.
Does anybody have any insight?
Your reply is highly appreciated.

Shital Raja



visit the
DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list
can be





can








Adrian Savory

Re: DDL Generation via DB2 Estimator
(in response to Shital S Raja)
Shital,

DB2LOOK is a command that you can use with DB2 UDB (Unix/NT, etc.) to
generate table definitions.

On a similar note, how does everybody compare UDB database structures in
different instances? So far I've tried comparing db2look output or comparing
the results of catalog queries. Neither is really very satisfactory.

Come back Migrator/Change Manager, all is forgiven :-(

Adrian Savory
ACSIS Limited

-----Original Message-----
From: Raja, Shital S [mailto:[login to unmask email]
Sent: 19 December 2000 23:24
To: [login to unmask email]
Subject: Re: DDL Generation via DB2 Estimator


Thanks Ashish,
You know if DB2Look is a downloadable utility or what? if
yes, from where can I download ?
Thanks
Shital

-----Original Message-----
From: Mohan, Ashish [mailto:[login to unmask email]
Sent: Tuesday, December 19, 2000 4:48 PM
To: [login to unmask email]
Subject: Re: DDL Generation via DB2 Estimator


DB2LOOK might be a utility to look at for generating DDLs.

Thanks.
Ashish.

-----Original Message-----
From: LOMBARD,Shaun [SMTP:[login to unmask email]
Sent: Tuesday, December 19, 2000 2:34 PM
To: [login to unmask email]
Subject: Re: DDL Generation via DB2 Estimator

As far as I know DB2 Estimator does not generate DDL, at least not
the
version I have.

-----Original Message-----
From: Raja, Shital S [mailto:[login to unmask email]
Sent: Wednesday, 20 December 2000 3:01
To: [login to unmask email]
Subject: DDL Generation via DB2 Estimator


I imported all Tables, indexes and related stats into DB2 Estimator.
It is
not readily apparent to me, how to go about generating DDL for
export.
Does anybody have any insight?
Your reply is highly appreciated.

Shital Raja



visit the
DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list
can be





can











------------------------------------------------------------------------
Privileged or confidential information may be contained in this message or
its attachments.

If you are the addressee of this message and you would prefer not to
receive e-mails from workthing at this address please notify the sender by
return.

If you are not the addressee indicated in this message (or responsible for
delivery of the message to the addressee), you may not copy this message
or deliver it to anyone other than the addressee. In such case,
please delete this message and notify the sender by reply email.
Please take all appropriate steps to check any attachments to this message
for viruses or other damaging code.


Workthing Limited
Registered in England and Wales
Registered Number: 3873867
Registered Office: 164 Deansgate, Manchester, M60 2RR



Andy Lankester

Re: DDL Generation via DB2 Estimator
(in response to Adrian Savory)
<vendor reply>
Well there IS a Change Manager for UDB! Similar function to the OS/390
version (including compare) but with beefed up ability to propagate changes
to multiple (eg 100s) of targets.

Andy Lankester
BMC Sofwatre Ltd

PATROL DB CHANGE MANAGER for UDB for xxxx where xxxx is major Unixes and NT

Please see
http://www.bmc.com/RightSite/getcontent/bmcdoc.html?dmw_objectid=09003201802
cdb7b&dmw_format=html

-----Original Message-----
From: Adrian Savory [mailto:[login to unmask email]
Sent: 20 December 2000 14:56
To: [login to unmask email]
Subject: Re: DDL Generation via DB2 Estimator


Shital,

DB2LOOK is a command that you can use with DB2 UDB (Unix/NT, etc.) to
generate table definitions.

On a similar note, how does everybody compare UDB database structures in
different instances? So far I've tried comparing db2look output or comparing
the results of catalog queries. Neither is really very satisfactory.

Come back Migrator/Change Manager, all is forgiven :-(

Adrian Savory
ACSIS Limited

-----Original Message-----
From: Raja, Shital S [mailto:[login to unmask email]
Sent: 19 December 2000 23:24
To: [login to unmask email]
Subject: Re: DDL Generation via DB2 Estimator


Thanks Ashish,
You know if DB2Look is a downloadable utility or what? if
yes, from where can I download ?
Thanks
Shital

-----Original Message-----
From: Mohan, Ashish [mailto:[login to unmask email]
Sent: Tuesday, December 19, 2000 4:48 PM
To: [login to unmask email]
Subject: Re: DDL Generation via DB2 Estimator


DB2LOOK might be a utility to look at for generating DDLs.

Thanks.
Ashish.

-----Original Message-----
From: LOMBARD,Shaun [SMTP:[login to unmask email]
Sent: Tuesday, December 19, 2000 2:34 PM
To: [login to unmask email]
Subject: Re: DDL Generation via DB2 Estimator

As far as I know DB2 Estimator does not generate DDL, at least not
the
version I have.

-----Original Message-----
From: Raja, Shital S [mailto:[login to unmask email]
Sent: Wednesday, 20 December 2000 3:01
To: [login to unmask email]
Subject: DDL Generation via DB2 Estimator


I imported all Tables, indexes and related stats into DB2 Estimator.
It is
not readily apparent to me, how to go about generating DDL for
export.
Does anybody have any insight?
Your reply is highly appreciated.

Shital Raja



visit the
DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list
can be





can











------------------------------------------------------------------------
Privileged or confidential information may be contained in this message or
its attachments.

If you are the addressee of this message and you would prefer not to
receive e-mails from workthing at this address please notify the sender by
return.

If you are not the addressee indicated in this message (or responsible for
delivery of the message to the addressee), you may not copy this message
or deliver it to anyone other than the addressee. In such case,
please delete this message and notify the sender by reply email.
Please take all appropriate steps to check any attachments to this message
for viruses or other damaging code.


Workthing Limited
Registered in England and Wales
Registered Number: 3873867
Registered Office: 164 Deansgate, Manchester, M60 2RR