DB2LOOK question

DB2 DBA

DB2LOOK question
List:
Happy New Year.

Ref: UDB V8.2/Win2003

db2look -d dbname -e -u db2admin -z schema1 -o filename -a is missing bunch of views and indexes.

Even I tried from control-center (gui) to generate DDLs for entire Database specifying user all-users and creator schema1.(I generate auth statements etc too)

What am I missing here. Please advise.

-VG


---------------------------------
Yahoo! Photos
Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever.

---------------------------------------------------------------------------------
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

Frank Crissy

Re: DB2LOOK question
(in response to DB2 DBA)
I use -d <dbname> -a -e -x -l -o<outputfile> and get everything except
stored procs and triggers. I don't think db2look supports those yet.
Frank

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]
On Behalf Of DB2 Database Solutions Port
Sent: Wednesday, January 04, 2006 10:17 AM
To: [login to unmask email]
Subject: [DB2-L] DB2LOOK question


List:
Happy New Year.

Ref: UDB V8.2/Win2003

db2look -d dbname -e -u db2admin -z schema1 -o filename -a is
missing bunch of views and indexes.

Even I tried from control-center (gui) to generate DDLs for
entire Database specifying user all-users and creator schema1.(I
generate auth statements etc too)

What am I missing here. Please advise.

-VG


________________________________

Yahoo! Photos
Ring in the New Year with Photo Calendars
<http://us.rd.yahoo.com/mail_us/taglines/photos/*http://pg.photos.yahoo.
com/ph//page?.file=calendar_splash.html&.dir=> . Add photos, events,
holidays, whatever.
------------------------------------------------------------------------
--------- 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

Michael Piontkowski

Re: DB2LOOK question
(in response to Frank Crissy)
On DB2 V8.2 Win2003, I use "db2look -d <dbname> -a -e -l -x -f >> <outfile>" and it generates stored procedures and triggers.

Mike
----- Original Message ----
From: "Crissy, Frank" <[login to unmask email]>
To: [login to unmask email]
Sent: Wednesday, January 04, 2006 11:21:36
Subject: Re: [DB2-L] DB2LOOK question


I use -d <dbname> -a -e -x -l -o<outputfile> and get everything except stored procs and triggers. I don't think db2look supports those yet.
Frank
-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of DB2 Database Solutions Port
Sent: Wednesday, January 04, 2006 10:17 AM
To: [login to unmask email]
Subject: [DB2-L] DB2LOOK question


List:
Happy New Year.

Ref: UDB V8.2/Win2003

db2look -d dbname -e -u db2admin -z schema1 -o filename -a is missing bunch of views and indexes.

Even I tried from control-center (gui) to generate DDLs for entire Database specifying user all-users and creator schema1.(I generate auth statements etc too)

What am I missing here. Please advise.

-VG


Yahoo! Photos
Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever. --------------------------------------------------------------------------------- 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 canbe 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

Ian Bjorhovde

Re: DB2LOOK question
(in response to Michael Piontkowski)
On 1/4/06, DB2 Database Solutions Port <[login to unmask email]> wrote:
> List:
> Happy New Year.
>
> Ref: UDB V8.2/Win2003
>
> db2look -d dbname -e -u db2admin -z schema1 -o filename -a is missing bunch
> of views and indexes.

That's because you are effectively querying for objects

WHERE creator = 'DB2ADMIN' AND schema = 'SCHEMA1'

The '-u' option isn't very useful unless you are very strict about who
creates objects in the database. If you drop that option (and have
only '-z schema1') I think you'll probably get what you are expecting.


Good luck,

---------------------------------------------------------------------------------
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

Michael Piontkowski

Re: DB2LOOK question
(in response to Ian Bjorhovde)
Forgot the [-td x] option... "db2look -d <dbname> -a -e -l -x -f -td ? >> <outfile>"

From db2look -h:
-td: Specifies x to be statement delimiter (default is semicolon(;))
Should be used with -e option if triggers or SQL routines present

Mike

----- Original Message ----
From: Michael Piontkowski <[login to unmask email]>
To: [login to unmask email]
Sent: Wednesday, January 04, 2006 11:46:26
Subject: Re: [DB2-L] DB2LOOK question


On DB2 V8.2 Win2003, I use "db2look -d <dbname> -a -e -l -x -f >> <outfile>" and it generates stored procedures and triggers.

Mike
----- Original Message ----
From: "Crissy, Frank" <[login to unmask email]>
To: [login to unmask email]
Sent: Wednesday, January 04, 2006 11:21:36
Subject: Re: [DB2-L] DB2LOOK question


I use -d <dbname> -a -e -x -l -o<outputfile> and get everything except stored procs and triggers. I don't think db2look supports those yet.
Frank
-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of DB2 Database Solutions Port
Sent: Wednesday, January 04, 2006 10:17 AM
To: [login to unmask email]
Subject: [DB2-L] DB2LOOK question


List:
Happy New Year.

Ref: UDB V8.2/Win2003

db2look -d dbname -e -u db2admin -z schema1 -o filename -a is missing bunch of views and indexes.

Even I tried from control-center (gui) to generate DDLs for entire Database specifying user all-users and creator schema1.(I generate auth statements etc too)

What am I missing here. Please advise.

-VG


Yahoo! Photos
Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever. --------------------------------------------------------------------------------- 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 canbe 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

---------------------------------------------------------------------------------
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