Just posting my response to the posting, on the newsgroup so others
can see:
1) To connect to DB2 on the mainframe, you can either establish a
direct connection using the built in DB2 connect client or use your
own db2 connect gateway. In case you are using the built in client,
you may not be able to take advantage of sysplex etc that you get
with DB2 connect enterprise edition/connection concentrator. If you
choose to use your own DB2 connect gateway, you can just catalog a
connection to the gateway like you would catalog a DB2 luw
connection.

2) ERROR [42601] [IBM][DB2] SQL0104N - You see this error when you
connect to a DB2 v7 database. DB2 v7 is not supported in Toad v2.
Verified with the user that that was the problem.


--- In toaddb2beta@yahoogroups.com, Petr_Smely@... wrote:
>
> the configuration of a connection is really clumsy and took me
some time to
> figure out. importing some profile is not documented and not
obvious what
> connection-profile is expected there. for corporations and big
rollouts,
> some other method must be in place anyway. the dialog for manual
> configuration gives unappropriate catalog info, at least the
sysplex-info
> is missing and must be entered by editing the resulting catalog-
commands.
>
> target db is db2v8.1 on zos1.7
>
> finally following error appears:
>
> ERROR [42601] [IBM][DB2] SQL0104N An unexpected token "(" was
found
> following "". Expected tokens may include: "IS <HEXSTRING>
<CHARSTRING>
> <GRAPHSTRING> ". SQLSTATE=42601
>
> what now? the connection is in a strange state, giving me the
option to
> disconnect, but also the object-palette is grayed out. opening any
window
> gives above error again.
>

> Petr
Smely

>

>

>

> Global Infrastructure hotline: +41 43
285 94 84 (service hours)
>
Services

> CCIIGZ/DS - GIS
Data

>
Services

> ~ where your data feels
@

> home
~

>

> website: Data
Services Homepage
>

> email: DB2
Admin
> Oracle
Admin
> MSSQL
Admin
>

>

>

>
>
>
>
>
>
> This e-mail, including attachments, is intended for the person(s)
or
> company named and may contain confidential and/or legally
privileged
> information. Unauthorized disclosure, copying or use of this
information
> may be unlawful and is prohibited. If you are not the intended
recipient,
> please delete this message and notify the sender
>