Question

2
Replies
48
Views
DarkoL35 Member since 2016 2 posts
Infosys
Posted: 8 months ago
Last activity: 7 months 3 weeks ago

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***

Pega Platform SR Exists
Share this page LinkedIn