Just in case anyone else hits this issue, here's my understanding of it.

If you're running a DB2 version 8 database locally, and you can't see your local database instances, it's because TOAD is using a version 9 client. You see the exact same issue if you install your own client without TOAD.

IBM's article about migration from v8 to v9 (see this section: Migration restrictions for DB2 clients ):

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.uprun.doc/doc/t0022632.htm

Which states:

Migration restrictions for DB2 clients

Review migration restrictions for DB2 servers regarding instance migration and operating system support. These restrictions also apply to DB2 clients and can impact the migration of your DB2 clients.

If you installed V8 DB2 client is located on the same system as a DB2 Version 9 server, local connections using Interprocess Communication (IPC) are not supported. You should migrate both the DB2 server and the DB2 client to DB2 Version 9 to access the migrated databases using the existing local database directory. If you do not migrate the V8 DB2 client, you can only access migrated databases that were catalogued as remote databases. You need to recatalog migrated databases using IPC as remote.

So you can workaround the issue by creating a catalog entry for your local database through a remote TCPIP connection. For example (replace MYLOCAL with anything, and my_db with your database name):

CATALOG TCPIP NODE MYLOCAL
 REMOTE localhost
 SERVER 50000
 REMOTE_INSTANCE MYLOCAL
 OSTYPE WIN;

CATALOG DATABASE my_db
 AS my_db
 AT NODE MYLOCAL;

Paul

--- In toad_db2@yahoogroups.com, "Angel Tran" <Angel.Tran@...> wrote:
>
> Hi Martin,
> I've attached the screenshot. See if you can see it.
>
> Thanks,
> Angel
>
> ________________________________
> From: toad_db2@yahoogroups.com [mailto:toad_db2@yahoogroups.com] On Behalf Of dawnandmartin
> Sent: Friday, September 28, 2007 8:17 AM
> To: toad_db2@yahoogroups.com
> Subject: [toad_db2] Re: Toad Freeware 3.0 - how to connect to local databases?
>
>
> Angel
> I can't see the screenshot!
> Cheers
> Martin
> --- In toad_db2@yahoogroups.com<mailto:toad_db2%40yahoogroups.com>, "Angel Tran" Angel.Tran@ wrote:
> >
> > Hello DawnandMartinl
> >
> > Toad for DB2 3.0 comes with its own DB2 client version 9.1.100.129.
> When you start Toad did you get this message below? Did you select
> your DB2 client to automatically transfer the catalog profile to Toad,
> like the screenshot show below?
> >
> > Sincerely,
> > Angel
> >
> >
> > [cid:image001.jpg@]
> > ________________________________
> > From: toad_db2@yahoogroups.com<mailto:toad_db2%40yahoogroups.com> [mailto:toad_db2@yahoogroups.com<mailto:toad_db2%40yahoogroups.com>] On
> Behalf Of dawnandmartin
> > Sent: Thursday, September 27, 2007 7:26 AM
> > To: toad_db2@yahoogroups.com<mailto:toad_db2%40yahoogroups.com>
> > Subject: [toad_db2] Toad Freeware 3.0 - how to connect to local
> databases?
> >
> >
> > I've added aliases for my local databases in the DB2 configuration
> > assistant, and added an ODBC data source for them, but I cannot see
> > how to connect to them with Toad. The list of aliases in the new
> > connection window only shows remote databases. I have DB2 ESE V9.1 FP3
> > installed. Is this a limitation of the freeware version?
> >
>