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***
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***
Pegasystems Inc.
US
Typically, these are the db urls:
# IBM DB/2 z / OS jdbc:db2://localhost:50000/dbName
# IBM DB/2 jdbc:db2://localhost:50000/dbName:fullyMaterializeLobData=true;fullyMaterializeInputStreams=true;progressiveStreaming=2;useJDBC4ColumnNameAndLabelSemantics=2;
For Failure in loading native library db2jcct2, can you check if your env has similar issue like this:
Infosys
AU
Steps to resolve:
- Install Linux IBM DB2 client v11.1
- Call DB2 client profile from the .profile of the installer
- . . /export/home/db11/sqllib/db2profile