Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (4)

Resolved DB2 connection in Powerserver

  1. Advice
0
Votes
Undo
  1. Joseph John
    Joseph John
  2. PowerServer 2020 or older (Obsolete)
  3. Friday, 30 November 2018 14:31 PM UTC

Hi Experts,

Anybody knows Appeon Powerserver can connect DB2 version 8.1 running on z/os ( mainframe ) ?. 

if so, how is it possible? through Data source type ODBC or IBM DB2 native driver?.

Please note that I'm making a POC application using Powerserver Trial version.

TIA,

Joseph

 

 

  1. Database Driver
Edge Chromium for Powerserver apps
External file isn't beeing downloaded to the clien...
Responses (4)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 30 November 2018 16:41 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Hi Joseph;

  You have two options in PowerServer for DB/2 - either using a) ODBC (like you would from the PB IDE) or b) PS's native DB/2 driver.

  Note that for the native option, you would need to install the DB/2 native client software from IBM via their SDK for DB/2.

HTH

Regards ... Chris

Comment
Joseph John
  1. Joseph John
  2. Monday, 3 December 2018 13:43 PM UTC
Hi Chris,

Thanks for your replay.

It works with DB2 native driver but it runs very slow in the web. is there any way to improve the performance?



on the other hand, the same application works very fast when it connects through ODBC and run as a client-server application through powerbuilder 2017 R3.

I can successfully configure/connected my DB2 DB with DataSource Type as ODBC through AEM . but while I'm connecting through my POC program, SQLCA.SQLErrText showing 'Invalid argument'

below is my DBParam settings ( even i tried with servername,LogId ,LogPass but all are in vain )



SQLCA.DBParm="CacheName='ODBCDB2' "

SQLCA.DBMS = "ODB-DB2"

connect using sqlca;

Regards,

Joseph











  1. Helpful
There are no comments made yet.
Mark Lundell
Mark Lundell Accepted Answer Pending Moderation
  1. Wednesday, 18 March 2020 18:17 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

I am having the same issue using the Native Client in AEM and my App, running in IE or in IAW.  In AEW I can have 2 connections to the same database.  One will take 20 or more seconds, the other one is quick. In the app a simple select statement returning 20 or so rows will take 20 seconds.

Attachments (2)
AppeonServer.pdf
AppeonError.pdf
Comment
Kai Zhao @Appeon
  1. Kai Zhao @Appeon
  2. Thursday, 19 March 2020 01:15 AM UTC
Hi Mark,



I find you are using DataWindow Data Cache( AEM > Application > Performance > DataWindow Data Cache > %your application% ), Please try disabled it.



The DataWindow Data Cache required some configuration on database server, I suggest you only cache the datawindow object which has big & infrequently changing data.

https://docs.appeon.com/appeon_online_help/ps2019/server_configuration_guide_for_net/Cache.html#DataWindow_object_cache_settings



Regards,

ZhaoKai

  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 18 March 2020 20:39 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 3

Hi Mark;

   In your DB/2 "Data Source" in PowerServer (view in AEM) ....

1) Are you using the native (IBM DB/2 Drver) setting?

2) What is your Minimum Connection Pool setting?

3) What is your Miaximum Connection Pool setting?

4) Does your D.S. have "pooling" ON?

For example ...

Regards ... Chris

 

Comment
There are no comments made yet.
Kai Zhao @Appeon
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Thursday, 19 March 2020 01:32 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 4

Hi Joseph,

PowerSever support DB2 native driver but not ODBC driver, and PowerServer official suport DB2 9.7, please refer to article below for details.
https://docs.appeon.com/appeon_online_help/ps2019/server_configuration_guide_for_net/supported_database_drivers.html

The performance of the application depends on the complexity of the application itself and how it is coded, the hardware and the network connection, etc.. Please try both PB application and PowerServer application on PowerServer machine to see if it is work well.

Regards,
ZhaoKai

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.