Question

2
Replies
53
Views
Darko Lenart (DarkoL35)
Infosys
Principal Consultant
Infosys
AU
DarkoL35 Member since 2016 2 posts
Infosys
Posted: January 15, 2020
Last activity: 2 weeks 2 days ago
Posted: 15 Jan 2020 18:50 EST
Last activity: 2 Jun 2021 7:31 EDT
Closed

Pega 8.31 installation on Unix fails: configuration - > Pega on Tomcat/Linux connecting to the DB2/zos

DB2 ZOS and DB2 LUW “create table ..” statements differ: Zos db2 Statement: create table ECERULES.pr4_rule_declare_expression ( "PZINSKEY" VARCHAR(256) NOT NULL, "PXOBJCLASS" VARCHAR(96), ………………………………………….. "PXHOSTID" VARCHAR(32), "PYCONTEXTBEHAVIOR" VARCHAR(128), "PYMODE" VARCHAR(255), "PYPAGECONTEXTCLASS" VARCHAR(128), "PYPURPOSE" VARCHAR(64) ) in PEGAECE.PGTS0341 VOLATILE DB2 LUW (tomcat db2) statement create table ECERULES.pr4_rule_declare_expression ( "PZINSKEY" VARCHAR(256) NOT NULL, "PXOBJCLASS" VARCHAR(96), ………………………….. "PXHOSTID" VARCHAR(32), "PYCONTEXTBEHAVIOR" VARCHAR(128), "PYMODE" VARCHAR(255), "PYPAGECONTEXTCLASS" VARCHAR(128), "PYPURPOSE" VARCHAR(64) ) Tomcat udb (LUW) is using the same connect string for LUW and ZOS database: jdbc:db2://host_name:Service_port/database However, ../database in the LUW environment means database, while in the ZOS means location (Node) • If the connection is to a DB2 for z/OS server, database is the DB2 location name that is defined during installation • If the connection is to a DB2 for Linux, UNIX, and Windows server, database is the database name that is defined during installation Does db2j4cc.jar have additional; parameters to use Pega database in the database connections URL? Is there any additional attribute we need to use to run Tomcat with zos? Example: Also, gebnerateddl.sh is throwing the error when run from the same unix VM: "Failure in loading native library db2jcct2" Do we have to add additional attribut to the connection URL to prevent error?

***Moderator Edit-Vidyaranjan: Updated SR details***

 

***Edited by Moderator: Pooja Gadige to add platform capability tag***
Pega Platform System Administration Installation and Deployment Support Case Exists
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.