powerdesigner Webportal and respository in DB2 on mainfame

[hvjus]

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

[former_member200945]

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.