Problems connecting to Repository

[L.Collins]

Where is that file located that we need to modify? We
searched and have not been able to find it.

>Hi
>
> have you created the tables on the mainframe with your
> user as creator ? PD tries to find a PMUSER table where
> the creator is the same as the userid you used to connect
> to the host with.
>
> In my installation we have created the repository with a
> creator called POT0 - and because the users connect to the
> mainframe with their own userid we have made a special
> database-alias in the db2cli.ini-file - look at the
> following:
>
> [TDB2POT0]
> SCHEMALIST='POT0'
> DESCRIPTION=POT0 TIL PD
> DBALIAS=TDB2POT0
>
> the SCHEMALIST parameter does the difference - now PD
> looks (or the ODBC-driver) for tables where the creator is
> POT0.
>
> Hope the helps - otherwise write again.
>
> Best regards
> Helle
>
>
>
> >Mike,
> > Yes
> > Yes
> > No, I can't query the table when I use the Execute SQL.
> >
> > L. Collins
> > > I haven't had this problem.
> > > Lets run through everything. You have an ODBC source
> > > created that uses the right permissions and user to
> > > get to the PM tables? You defined the repository
> > > connection using that ODBC source? Can you use that
> > > ODBC source to query the tables? From the repository
> > > menu, use the Execute SQL item to try the queries.
> > Does that work? >
> > > --
> > > Mike Nicewarner [TeamSybase]
> > > http://www.datamodel.org
> > > mike@nospam!datamodel.org
> > > Sybase product enhancement requests:
> > > http://www.isug.com/cgi-bin/ISUG2/submit_enhancement
> > >
> > > <L. Collins> wrote in message
> > > news:3fbe4b70.40...@sybase.com... I am using
> > > the latest version of Studio PD (9.5.2.908 EBF4) and
> > > am having problems connecting to my DB2 (OS/390 v6.1)
> > > Repository. I followed the instructions in the
> > > "Installing the PowerDesigner MetaWorks Repository in
> > > IBM DB2 for OS/390" document.
> > > The edited script was run independently of PD to
> > > create the Repository. However, I cannot connect to
> > > the Repository from PD.
> > > I receive two different errors:
> > > 1. NEON error: SQL -204 userid.PMUSER is an undefined
> > > name (I queried the database table and the userid is
> > > defined in the table.)
> > > 2. PD error: The connection failed because the
> > > repository has not been installed on this database.
> > >
> > > I'm completely lost. Are there some additional steps
> > > I should perform since the Repository was created
> > > outside of PD?
> > > Any help is appreciated.
> > >
> > > Thanks,
> > > L. Collins
> > >
> > >

[Mike Nicewarner]

The db2cli.ini file should be located in your DB2 folder. If you don't have
it, then you aren't using DB2 client enabler (the IBM ODBC driver) to access
your DB2, and Helle's suggestion is meaningless for you.

--
Mike Nicewarner [TeamSybase]
http://www.datamodel.org
mike@nospam!datamodel.org
Sybase product enhancement requests:
http://www.isug.com/cgi-bin/ISUG2/submit_enhancement

<L.Collins> wrote in message news:3fd9eaca.38...@sybase.com...

[l._collins]

That's correct, we use a NEON Client to access DB2.

Since I was not able to use Execute SQL to query the tables,
do you have any suggestions? Do I have some parms that are
set wrong?

[Mike Nicewarner]

Well, try again using the IBM ODBC driver.

--
Mike Nicewarner [TeamSybase]
http://www.datamodel.org
mike@nospam!datamodel.org
Sybase product enhancement requests:
http://www.isug.com/cgi-bin/ISUG2/submit_enhancement

<L. Collins> wrote in message news:3fe22bbf.58...@sybase.com...