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 Load server parameters exception DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=U820.PMOPTS, DRIVER=3.69.71 this is the parameter I would like to have changed


we run Powerdesigner v. (5554)


Helle Justesen

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Posted on Aug 24, 2019 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