Skip to Content

powerdesigner Webportal and respository in DB2 on mainfame

Hi - we have our repository in DB2 (v. 11) on mainframe - and when we access it through the Powerdesigner client, we have made a repository entry with a datasourcename - and then we have modified the db2.cfg file on the client machines to contain an entry with the datasourcename which have the 'CurrentSchema' option - so when the users access the repository - they get tables with the CurrentSchema value instead of their own user - but how do I get the web-portal to act the same way? now it looks for a repository with the user as owner:

ERROR http-apr-3030-exec-3 2019/07/12 16:05:00 CEST com.sybase.cmr.infra.server.configuration.management.RepositoryIdManagerImpl.getRepositoryParameters(RepositoryIdManagerImpl.java:202) Load server parameters exception

com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=U820.PMOPTS, DRIVER=3.69.71 this is the parameter I would like to have changed

at com.ibm.db2.jcc.am.gd.a(gd.java:749)

we run Powerdesigner v. 16.6.5.1 (5554)

Br

Helle Justesen

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Aug 24 at 05:41 PM

    Powerdesigner client uses ODBC. Portal Server uses JDBC.

    Does JDBC accept CurrentSchema option?

    You can test it by creating a JDBC connection in Powerdesigner client.

    Download JDBC driver

    Open a PDM. Go to Database->Configure Connections. Click Connection Profiles.

    Add new profile by clicking the second icon.

    In Connection type field, select JDBC. Fill in all necessary info.

    Add comment
    10|10000 characters needed characters exceeded