E-DB2 Execution of SET CURRENT PRECISION = “D31,6” (Doc ID 2126581.1)

Last updated on APRIL 19, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.53 to 8.53 [Release 8.4]
Information in this document applies to any platform.

Goal

PeopleTools 8.53 Installation for DB2 for z/OS

 

Please refer to the PeopleTools 8.53 Installation Guide for Db2 Zos platform.

This can be found on the PeopleSoft PeopleTools 8.53 Installation Home Page (Doc ID 1523278.1)

See Task 1-8-2: Defining Decimal Arithmetic under chapter "Understanding DB2 Configuration Requirements"

which says

PeopleSoft code executes the statement SET CURRENT PRECISION = “D31,6” for each connection into
the database, which will have the effect of running the application in a DB2 subsystem with zparm settings
of DECARTH=31 and MINDVSCL=6, overriding what the actual zparm settings may be. DECDIV3 is overridden by MINDVSCL so whether DECDIV3 is YES or NO has no impact on the PeopleSoft application.

 

Question:  where is the setting for the PeopleSoft code to execute the statement SET CURRENT PRECISION = “D31,6” ?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms