Re: [WDSCI-L] Database cataloging

["Mark Phippard" <MarkP@xxxxxxxxxxxxxxx>]

You have to use the filters on the connection to limit it to only a couple
of libraries.  Use the SCHEMA filter and the equals value with a specific
library name.

Otherwise, it processes your entire system and takes forever.

If you search the archives of this mailing list, there are more complete
explanations.

Mark



      To:   wdsci-l@xxxxxxxxxxxx
      cc:
      bcc:
      Subject:    [WDSCI-L] Database cataloging
<jododu@xxxxxxx>
Sent by: wdsci-l-bounces@xxxxxxxxxxxx
05/06/2003 03:27 PM AST
Please respond to Websphere Development Studio Client for iSeries
<font size=-1></font>





















Running WDSc 4.0.  Using the WebPage accessing database wizard
Database vendor type: DB2 UDB for iSeries, V4R5
JDBC driver: IBM DB2 AS/400 NET DRIVER
Class location: c:\WDSC\java\jt400.jar

I click on Connect to Database, put in my user profile and password (user
profile's JOBD has only QTEMP and another library in the USRLIBL
portion...and the library only has 2 physical files).
QZDASOINIT job starts in QSERVER accessing SYSCOLUMNS, SYSTABLES, etc, and
runs for hours.

What am I doing wrong?

Thanks for any assistance.

_______________________________________________
This is the Websphere Development Studio Client for iSeries  (WDSCI-L)
mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.