The APAR is IY13655. IBM has added a new option, -z, which provides the
same functionality that the -u option used to provide before they "fixed"
it.
Some background: according to IBM, the -u option's behavior did not match
the documentation of how it was supposed to work. APAR IY11255 was
included in a v6.1 fixpack (4c) which "corrected" this "problem", and
caused -u to not work the way it used to. I opened a PMR with IBM
complaining about this, and made a case for needing it to work the old way.
They agreed to add a new option, -z, which would allow you to specify a
schema name for db2look.
IY13655 is included in fixpack 3 for v7.1, and in fixpack 7 for v6.1.
Bill Gallagher, DBA
Phoenix Life Insurance
Enfield, CT
"Jeremy Dodd"
<jeremy.dodd@ To: [EMAIL PROTECTED]
WHICH.NET> cc:
Sent by: "DB2 Subject: Re: GEN DDL using V7.1.2 UDB
Client and V6.1 DB Server
Data Base
Discussion
List"
<[EMAIL PROTECTED]
OM>
06/19/01
03:44 PM
Please
respond to
jeremy.dodd
Joel,
I have seen this. If it is the same thing, it was intorduced as a bug fix
in version 6.
The -u flag is for the creator of the table - which is a pain if you are
looking for all tables belonging to a particluar schema. In version 5.2 it
fetched all tables belonging to a
schema. I believe that there is an APAR open about it.
Jeremy
Joel Pankonin wrote:
> Okay.... let's try this again,
>
> Right now we support multipal version of UDB on several platforms. We
> recently went to UDB V7.1.2 on our client while still running V6.1 on the
> UNIX/DB server. When trying to GEN DDL we get nothing but the following:
>
> command executed:
>
> echo db2look: /db2/usuasb02/sqllib/db2_19.out
>
> db2look -d DVSCE200 -u EVSC -e -c -o db2_19.out
>
> Results:
>
> -- This CLP file was created using DB2LOOK Version 6.0
> -- Timestamp: Tue Jun 19 11:43:40 2001
> -- Database Name: DVSCE200
> -- Database Manager Version: DB2/6000 Version 6.1.0
> -- Database Codepage: 1252
>
> CONNECT TO DVSCE200;
>
> COMMIT WORK;
>
> CONNECT RESET;
>
> TERMINATE;
>
> Has anyone seen this before?
>
> ================================================
> To change your subscription options or to cancel your subscription visit
the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can
be reached at [EMAIL PROTECTED]
================================================
To change your subscription options or to cancel your subscription visit
the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can
be reached at [EMAIL PROTECTED]
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
