IBM WebSphere Enterprise Application Server Fixpack Installation?

Ahsen1982

Ahsen1982

Active Member
Hi list;

Trying to install IBM WebSphere Enterprise Application Server Fixpack.
Basically I am trying to install JAS Application Server in PeopleSoft E1 8.10. Well this is my 1st experience to install PSFT JAS
Server in my life becuase I am new in this CNC Feild. Well I followed the Installation guide and complete my installation.
Well every thing ok so far, But When I am trying to log in from http://was:81/jde/owhtml I cannot!!!.
So I checked the versions of IBM , ok Currently I am using IBM Websphere Enterprise Application Server V5.0.2, Then I dowloaded
Fixes & Fix Pack from IBM WebSite, I And I installed , but facing same problem, Cannot log in the server. Well any body have any cue about this issue.
Well Please go through with the JAS.ini & Jdbj.ini file, And do let me know the steps to install FIXPACK of Websphere may be I am following the wrong issue.
So please do help me out.

Bye

Ahsen

======================================JAS.INI=====================================
# Please refer to the JAS Installation Guide for detailed information on
# this file.
#
#

[SECURITY]
DataSource=System - 810
SecurityServer=ente810
UseLogonCookie=FALSE
CookieLifeTime=7
SSOEnabled=FALSE
SSOUserIDOnly=FALSE
# set password only if SSOUserIDOnly is set to TRUE
Password=

[OWWEB]
PathCodes=('PD810','PY810')
MO QUEUE=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\moqueue
ProxyPoolSize=50
F0005Prefix=DR
F0004Prefix=DT
#ProxyHost=
#ProxyPort=
MAXUser=200
FtpPort=21
FtpUsr=anonymous
FtpPwd=anonymous
UseMOWinNTShare=TRUE
PrintImmediate=FALSE
KeepUBE=TRUE
UBEQueue=QBATCH
SystemDateFormat=MDE
SystemDateSeparator=/
VirtualClientTimeOut=300000
InYourFaceError=TRUE

# The HelpPath key determines where JAS looks for help files.
# Syntax: "http://[machine]/[path]/".
# Note, if you specify "/jde/owhelp/", this machine is assumed.
HelpPath=/jde/owhelp/


[CACHE]
# These intervals are in milliseconds. For example, 60000ms = 1 minute
UserSession=2400000
UserProfile=1200000
CacheCheck=60000
Menu=3600000



[SERVER COMPONENTS]
#
# Do not modify this section
#
com.jdedwards.jas.UserManager
com.jdedwards.jas.JDBCProxy
com.jdedwards.jas.JDEORB
com.jdedwards.jas.DDValidation
com.jdedwards.jas.security.SecurityBroker
com.jdedwards.jas.UDCJDBC
com.jdedwards.jas.JDEUDCText
com.jdedwards.jas.JDEUpdates
com.jdedwards.jas.JDEQueries
com.jdedwards.jas.JDEOWDirect
com.jdedwards.jas.ServerQuery
com.jdedwards.jas.JDESignon
com.jdedwards.runtime.virtual.MAFComponentLoader

[JDENET]
# Enterprise Server JDENET port
serviceNameConnect=6012

# JAS Server JDENET Listening port
serviceNameListen=6012

# Maximum number of dedicated kernel types
maxKernelRanges=1

# Time out value for requests sent to the Enterprise Server
enterpriseServerTimeout=90000

# JDENET socket connection pool size
maxPoolSize=50

# Directory for JDENET temporary file
tempFileDir=C:\DOCUME~1\arizwan\LOCALS~1\Temp

# Clustered logical datasource retry interval
ClusterRetryInterval=60000

# Dedicated Kernel Definitions
[JDENET_KERNEL_DEF1]
krnlName=XAPI Kernel
processClassName=com.jdedwards.runtime.virtual.xapi.PublishedMessageProcessor
startMessageRange=15001
endMessageRange=15250
maxNumberOfThread=3


[SERVER]
# Enterprise Server and port providing Glossary Text information
glossaryTextServer=ENTE810:6012

# Encoding scheme
# 1252- English and Western European
# 932- Japanese
# 950- Traditional Chinese
# 936- Simplified Chinese
# 949- Korean
codePage=1252

[LOGS]
Debug=TRUE
logs=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\logs\JAS.LOG
Debudlog=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\logs\JASDEBUG.LOG
# JDBC Trace (in stdout)

rtdebugTrace=TRUE
rtlog=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\logs\rt.log
rtdebug=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\logs\rtdebug.log
rtlogType=All
#or =BSFN|TableIO|SYSFUNC|MISC|ER|EVENT|THREAD (any combination).


# The STDERR and STDOUT keys must point to the same directory that was supplied for the
# STDERR and STDOUT fields when defining the WebSphere Application Server.
# This is usually the INTERNET directory under B7333.
#
stderr=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\logs\stderr.txt
stdout=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\logs\stdout.txt

[JAS INSTANCE]
# This is for JAS redirector only
# RoundRobin will be used as default if ther is no entry in [JAS WEIGHT].
# If redirect based on JAS instance weight, then each instance's weight must specified,
# otherwise, weight 0 will be assumed, which means the server will not get
# any redirected request
# example: JAS1=http://127.0.0.1/jde
# Note: in this example, "JAS1" is the key, if weight will be given,
# this key must be used in [JAS WEIGHT] section to match this JAS instance

[JAS WEIGHT]
# The key must match the key in [JAS INSTANCE] section
# example: JAS1=2
# The weight is ratio based, for example:
# JAS1=2
# JAS2=1
# That means JAS1 will take as twice load as JAS2


[REDIRECTOR]
# interval unit is milliseconds
Interval=5000
# This is the location that Redirector will redirect to, if no server is available.
# If it is empty, redirect will display a simple page tells user that no server is available
# example: NoServerAvailableURL=http://servername/path/noserver.html
NoServerAvailableURL=

[TRANSACTIONS]
# Configuration settings to customize transaction processing within JAS.

# ReapInterval : Interval in minutes of how often the TransactionReaper
# should check for abandoned transactions.
# Valid values: Integer from 1 to n
# Default: 5 minutes
# MaxAge : Maximum age in minutes of a transaction. Transactions
# older than this will be rolled back by the
# TransactionReaper.
# Valid values: Integer from 1 to n
# Default: 10 minutes
#

ReapInterval=5
MaxAge=10

[ERPINTERACTIVITY]
#interactivity level. valid values are: LOW, MEDIUM, and HIGH
InteractivityLevel=HIGH
# whether multiple browsers fetch is enabled
MultipleBrowserEnabled=TRUE
# the maximum number of open browsers for each user
MaxOpenBrowsers=5
# the number of records fetched for each database fetch before getting a system warning
DBFetchLimitBeforeWarning=2000


====================================== JDbj.INI======================================================

#=======================================================================
# jdbj.ini - JDBj configuration
#
# This file contains configuration information for JDBj, which provides
# general database access capabilities on behalf of J.D. Edwards Java
# solutions.
#
# IMPORTANT: All keys in this file are case sensitive.
#=======================================================================

#=======================================================================
# ERP specific information
#
# These sections apply only when accessing ERP data. These sections are
# ignored for standalone database access.
#=======================================================================

#-----------------------------------------------------------------------
# Bootstrap session
#
# The user, password, role information is optional. It is used by the
# the JDBJ Unit tests and JDBExplorer only if these parameters are not
# specified on the command line. The environment is required field otherwise
# JAS cannot signon to the HTML client.
#
# NOTES: * This information in this section corresponds to the information
# specified in the [DB SYSTEM SETTINGS] section of this installation's
# JDE.INI file.
#-----------------------------------------------------------------------

[JDBj-BOOTSTRAP SESSION]
user=PSFT
password=PSFT
environment=JPY810
role=*ALL

#-----------------------------------------------------------------------
# Bootstrap physical data source
#
# This defines the data source where the OCM and some other system
# tables reside. JDBj uses this at bootstrap time and later to look up
# OCM entries on demand. If it is not valid, then no ERP database
# access is possible.
#
# Here is a description of each field in this section:
#
# ---------------- --------------------------------------- -----------
# Field Description Applies to
# ---------------- --------------------------------------- -----------
# name The data source name. This is not that All
# important for bootstrap connections,
# but it does show up in error messages
# and the log.
# ---------------- --------------------------------------- -----------
# databaseType The database type. One of the All
# following:
#
# I = AS/400
# O = Oracle
# S = SQL Server
# W = UDB
# M = MSDE
# ---------------- --------------------------------------- -----------
# server The server (i.e. the host), or AS/400,
# "localhost". SQL Server
# MSDE
# ---------------- --------------------------------------- -----------
# database The database. Oracle,UDB
# ---------------- --------------------------------------- -----------
# serverPort The server port. SQL Server
# ---------------- --------------------------------------- -----------
# physicalDatabase The physical database (used as library AS/400,
# qualifier for AS/400). SQL Server,
# MSDE
# ---------------- --------------------------------------- -----------
# owner The owner. Oracle,
# SQL Server,
# UDB,
# MSDE
# ---------------- --------------------------------------- -----------
# lob Supports lobs. Oracle,
#
# AS/400
# ---------------- --------------------------------------- -----------
# unicode Performs unicode conversion. SQL Server
# MSDE
# ---------------- --------------------------------------- -----------
# databaseInstance The instance name of server. (JDELocal) MSDE
# ---------------- --------------------------------------- -----------
# translateOn AS400 translate on (default is FASLE) AS400
# ---------------- --------------------------------------- -----------
#-----------------------------------------------------------------------
#
# NOTES: * This information in this section should match the
# corresponding information specified in the
# [DB SYSTEM SETTINGS] section of this installation's JDE.INI
# file.
#-----------------------------------------------------------------------

[JDBj-BOOTSTRAP DATA SOURCE]
name=System - 810
databaseType=S
server=ente810
serverPort=1433
database=
physicalDatabase=PS810
owner=SY810
lob=false
unicode=false
databaseInstance=
translateOn=

#-----------------------------------------------------------------------
# Bootstrap spec data source (Optional)
#
# This defines the data source where the serialized spec tables reside.
# JDBj uses this at bootstrap time and after to look up serialized spec
# objects on demand. JDBj first looks for the name specified in this
# section in the Data Source Master table (F98611). If it finds a data
# source there, it uses it to read the serialized spec tables. If it
# does not find the data source in the Data Source Master table, then
# it initializes a new data source based on the rest of the fields in
# this section.
#
# If this section is not specified, then JDBj uses the OCM to find the
# serialized spec tables. If it is not valid, then no ERP database
# access is possible.
#
# See the description for "Bootstrap physical data source" above for
# information about which fields must be filled in for a given database
# platform.
#-----------------------------------------------------------------------

[JDBj-SPEC DATA SOURCE]
name=system - 810
databaseType=S
server=ente810
serverPort=1433
database=
physicalDatabase=PS810
owner=SY810
lob=false
unicode=false
user=PFST
password=PSFT

#=======================================================================
# END - ERP specific information
#
# The rest of the sections apply when accessing ERP and standalone data.
#=======================================================================

#-----------------------------------------------------------------------
# JDBC drivers
#
# This defines JDBC drivers and JDBC specific settings.
#-----------------------------------------------------------------------

[JDBj-JDBC DRIVERS]
ORACLE=oracle.jdbc.driver.OracleDriver
AS400=com.ibm.as400.access.AS400JDBCDriver
SQLSERVER=com.microsoft.jdbc.sqlserver.SQLServerDriver
UDB=COM.ibm.db2.jdbc.app.DB2Driver

[JDBj-ORACLE]
tns=

[JDBj-LOGS]
jdbcTrace=true

[JDBj-SERVER]
dbcsConversionTolerant=true

#-----------------------------------------------------------------------
# Connection pool settings
#-----------------------------------------------------------------------

[JDBj-CONNECTION POOL]

; The minimum number of connections to a data source. When closing old connections,
; the value set by this parameter will remain in the pool regardless of use.
;
; Valid values: 0 or greater
; Default value: 5

minConnection=5

; The maximum number of connections to a data source for all users. Additional
; database connection requests beyond this value will be queued for the next available
; connection.
;
; Valid values: 1 or greater (must be equal to or greater than "minConnection")
; Default value: 50

maxConnection=50

; The number of connections to initialize upon pool creation.
;
; Valid values: a value equal to or greater than "minConnection" AND equal to or
; less than "maxConnection"
; Default value: 5

initialConnection=5

; The increment of connections the system will create when a request for a connection
; cannot be satisfied with the current allocation as long as the maxConnection value
; has not been reached.
;
; Valid values: The rule of thumb is (poolGrowth >= maxConnection/10)
; Default value: 5

poolGrowth=5

; Amount of time in milliseconds that a connection remains idle before it is flagged
; to be cleaned up. Keeping this value high may or may not add to performance. Reducing
; the value may reduce memory consumption.
;
; Valid values: 0 or greater
; Default value: 1800000 (30 minutes)

connectionTimeout=1800000

; Amount of time in milliseconds that the pool cleaner is set to clean data sources
; that have a validation string. When cleaning occurs, any connections which have been
; flagged as idle will be cleaned up. The amount of time between a connection
; becoming idle and being cleaned up can be as long as the connectionTimeout value plus
; the cleanPoolInterval value.
;
; Valid values: 0 or greater
; Default value: 600000 (10 minutes)

cleanPoolInterval=600000

; The maximum number of JDBC prepared statements cached on each JDBC connection.
;
; Valid values: 0 or greater
; Default value: 50

maxSize=50

; The number of JDBC statements purged from a JDBC connection if the maxSize limit is
; reached. The statements purged will be the statements in the cache which have not
; been used for the longest amount of time.
;
; Valid values: The rule of thumb is (cachePurgeSize >= maxSize/10 + 2)
; Default value: 5

cachePurgeSize=5

#-----------------------------------------------------------------------
# JDBj Runtime properties
#
# These are all optional. They correspond to system runtime properties
# applicable to JDBj logical connections.
#
# NOTES: * In each case, the values listed are the defaults. The
# template default entries are commented out. Make sure
# and remove the pound sign (#) when changing these values.
#-----------------------------------------------------------------------

[JDBj-RUNTIME PROPERTIES]

; AS400 Database ASP property. Use this setting if you are running your iSeries
; server with multiple user databases or IASP (Independent Auxiliary Storage Pool)
; and have your EnterpriseOne tables located on the IASP. The IASP name can be found
; by using the command WRKRDBDIRE. This entry is not needed if you only have *LOCAL
; configured on your system in the WRKRDBDIRE Remote Location name.
;
; Valid values: Any valid string

# AS400DatabaseASP=null

; AS400 package name property. Overrides the default sql package
; name on the AS400 with the specified name.
;
; Valid values: Any valid string

# as400Package=JDBj

; AS400 package library name property. Overrides the default sql package
; library name on the AS400 with the specified name.
;
; Valid values: Any valid string

# as400PackageLibrary=JDBj-Library

; AS400 extended dynamic property. Overrides the default extended dynamic
; setting with the specified setting. If specified to a false, AS400 database
; will not use packages. This will have a negative impact on performance.
;
; Valid values: true, false

# as400ExtendedDynamic=true

; Data cache entry size threshold property. Sets the maximum
; size (in rows) for a single entry in the data cache. If a
; potential entry exceeds this threshold, then it will not be
; cached. -1 indicates that all eligible entries should be
; cached.
;
; Valid values: -1 or greater

# dataCacheEntrySizeThreshold=500

; Data cache entry threshold property. Sets the maximum size (in
; entries) for the data cache. If the data cache exceeds this
; size, then the least recently used entries are removed to
; make room for the new entry. -1 indicates that there is no
; maximum.
;
; Valid values: -1 or greater

# dataCacheEntryThreshold=100

; Data varification property. Enable or disable the data ve
 
Asjen,

To start with verify that you have all the WebSphere MTR as given on the site. To sum up make sure you have done the following. Do follow the order mentioned

Install WebSphere Application Server 5.0 (v5.0)
Install WebSphere Enterprise Server 5.0 (v5.0)
Apply fixpack 2 to WebSphere Application Server (v5.0.2)
Apply fixpack 2 to WebSphere Enterprise Server (v5.0.2)
Apply the application server cumulative fix 2 to the WebSphere Application Server (v5.0.2.2)
Apply the enterprise server cumulative fix 2 to the WebSphere Enterprise Server (v5.0.2.2)
Apply the application server cumulative fix 3 to the WebSphere Application Server (v5.0.2.3)

When you say you cannot login, is it that you do not get the login page, or after you enter the User ID and Password and try to sign in it fails..?

If you are not getting the login page, then it could be a port problem. Do you get any page on port 81. i.e What page do get when you access the following URL

http://was:81

Which Web Server are you using IBM or IIS. Check that the virtual host settings are proper.
 
Hi

Thanks for your reply.Well Yes I can Access the LOGIN Page , But I Am failed to login when press Submit Button, The browser keep searching
for sometime and then next Page open that "CANNOT ACCESS THE PAGE".

Well I am trying to install Fixpack but I hope that I am not using the correct way to install.So please go through with the attached file for Version INFO
And do let me know the correct way to install PME FIXPACK Step by step .

Waiting for your reply

Thanks

Ahsen
 

Attachments

  • 90368-VERSIONINFO.JPG
    90368-VERSIONINFO.JPG
    74.3 KB · Views: 261
Ahsen,

From your screen dump I see that your WAS Enterprise Server is only at 5.0.2. The MTR requires you to be at 5.0.2.2

But since you are already at 5.0.2.3 for you WAS Application Server, the WAS Enterprise cum fix 2 will not install properly.

You need to apply the fixes in the order mentioned in my last post.

Hope it helps
 
Thanks for your humble guidance regarding Fix pack Installation. Well fix packs are installed well in the system , But Still I cannot sign in the system , Same Logging problem. So I am attaching some files for your convenience please review it and please do help me out because I want this JAS server got to be running in this week. So please help me out. Waiting for reply.

Regards;

Ahsen Rizwan Siddiqui


===================================================JAS.INI=====================================================

# Please refer to the JAS Installation Guide for detailed information on
# this file.
#
#

[SECURITY]
DataSource=System - 810
SecurityServer=ENTE810
UseLogonCookie=FALSE
CookieLifeTime=7
SSOEnabled=FALSE
SSOUserIDOnly=FALSE
# set password only if SSOUserIDOnly is set to TRUE
Password=

[OWWEB]
PathCodes=('PD810','PY810')
MO QUEUE=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\moqueue
ProxyPoolSize=50
F0005Prefix=DR
F0004Prefix=DT
#ProxyHost=
#ProxyPort=
MAXUser=200
FtpPort=21
FtpUsr=anonymous
FtpPwd=anonymous
UseMOWinNTShare=TRUE
PrintImmediate=FALSE
KeepUBE=TRUE
UBEQueue=QBATCH
SystemDateFormat=MDE
SystemDateSeparator=/
VirtualClientTimeOut=300000
InYourFaceError=TRUE

# The HelpPath key determines where JAS looks for help files.
# Syntax: "http://[machine]/[path]/".
# Note, if you specify "/jde/owhelp/", this machine is assumed.
HelpPath=/jde/owhelp/


[CACHE]
# These intervals are in milliseconds. For example, 60000ms = 1 minute
UserSession=2400000
UserProfile=1200000
CacheCheck=60000
Menu=3600000



[SERVER COMPONENTS]
#
# Do not modify this section
#
com.jdedwards.jas.UserManager
com.jdedwards.jas.JDBCProxy
com.jdedwards.jas.JDEORB
com.jdedwards.jas.DDValidation
com.jdedwards.jas.security.SecurityBroker
com.jdedwards.jas.UDCJDBC
com.jdedwards.jas.JDEUDCText
com.jdedwards.jas.JDEUpdates
com.jdedwards.jas.JDEQueries
com.jdedwards.jas.JDEOWDirect
com.jdedwards.jas.ServerQuery
com.jdedwards.jas.JDESignon
com.jdedwards.runtime.virtual.MAFComponentLoader

[JDENET]
# Enterprise Server JDENET port
serviceNameConnect=6012

# JAS Server JDENET Listening port
serviceNameListen=6012

# Maximum number of dedicated kernel types
maxKernelRanges=1

# Time out value for requests sent to the Enterprise Server
enterpriseServerTimeout=90000

# JDENET socket connection pool size
maxPoolSize=50

# Directory for JDENET temporary file
tempFileDir=C:\DOCUME~1\arizwan\LOCALS~1\Temp

# Clustered logical datasource retry interval
ClusterRetryInterval=60000

# Dedicated Kernel Definitions
[JDENET_KERNEL_DEF1]
krnlName=XAPI Kernel
processClassName=com.jdedwards.runtime.virtual.xapi.PublishedMessageProcessor
startMessageRange=15001
endMessageRange=15250
maxNumberOfThread=3


[SERVER]
# Enterprise Server and port providing Glossary Text information
glossaryTextServer=ENTE810:6012

# Encoding scheme
# 1252- English and Western European
# 932- Japanese
# 950- Traditional Chinese
# 936- Simplified Chinese
# 949- Korean
codePage=1252

[LOGS]
Debug=TRUE
logs=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\logs\JAS.LOG
Debudlog=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\logs\JASDEBUG.LOG
# JDBC Trace (in stdout)

rtdebugTrace=TRUE
rtlog=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\logs\rt.log
rtdebug=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\logs\rtdebug.log
rtlogType=All
#or =BSFN|TableIO|SYSFUNC|MISC|ER|EVENT|THREAD (any combination).


# The STDERR and STDOUT keys must point to the same directory that was supplied for the
# STDERR and STDOUT fields when defining the WebSphere Application Server.
# This is usually the INTERNET directory under B7333.
#
stderr=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\logs\stderr.txt
stdout=C:\Program Files\WebSphere\AppServer\installedApps\was\EA_JS_81_was.ear\webclient.war\logs\stdout.txt

[JAS INSTANCE]
# This is for JAS redirector only
# RoundRobin will be used as default if ther is no entry in [JAS WEIGHT].
# If redirect based on JAS instance weight, then each instance's weight must specified,
# otherwise, weight 0 will be assumed, which means the server will not get
# any redirected request
# example: JAS1=http://127.0.0.1/jde
# Note: in this example, "JAS1" is the key, if weight will be given,
# this key must be used in [JAS WEIGHT] section to match this JAS instance

[JAS WEIGHT]
# The key must match the key in [JAS INSTANCE] section
# example: JAS1=2
# The weight is ratio based, for example:
# JAS1=2
# JAS2=1
# That means JAS1 will take as twice load as JAS2


[REDIRECTOR]
# interval unit is milliseconds
Interval=5000
# This is the location that Redirector will redirect to, if no server is available.
# If it is empty, redirect will display a simple page tells user that no server is available
# example: NoServerAvailableURL=http://servername/path/noserver.html
NoServerAvailableURL=

[TRANSACTIONS]
# Configuration settings to customize transaction processing within JAS.

# ReapInterval : Interval in minutes of how often the TransactionReaper
# should check for abandoned transactions.
# Valid values: Integer from 1 to n
# Default: 5 minutes
# MaxAge : Maximum age in minutes of a transaction. Transactions
# older than this will be rolled back by the
# TransactionReaper.
# Valid values: Integer from 1 to n
# Default: 10 minutes
#

ReapInterval=5
MaxAge=10

[ERPINTERACTIVITY]
#interactivity level. valid values are: LOW, MEDIUM, and HIGH
InteractivityLevel=HIGH
# whether multiple browsers fetch is enabled
MultipleBrowserEnabled=TRUE
# the maximum number of open browsers for each user
MaxOpenBrowsers=5
# the number of records fetched for each database fetch before getting a system warning
DBFetchLimitBeforeWarning=2000


========================================================================================================================

=============================================JDBJ.INI====================================================================

#=======================================================================
# jdbj.ini - JDBj configuration
#
# This file contains configuration information for JDBj, which provides
# general database access capabilities on behalf of J.D. Edwards Java
# solutions.
#
# IMPORTANT: All keys in this file are case sensitive.
#=======================================================================

#=======================================================================
# ERP specific information
#
# These sections apply only when accessing ERP data. These sections are
# ignored for standalone database access.
#=======================================================================

#-----------------------------------------------------------------------
# Bootstrap session
#
# The user, password, role information is optional. It is used by the
# the JDBJ Unit tests and JDBExplorer only if these parameters are not
# specified on the command line. The environment is required field otherwise
# JAS cannot signon to the HTML client.
#
# NOTES: * This information in this section corresponds to the information
# specified in the [DB SYSTEM SETTINGS] section of this installation's
# JDE.INI file.
#-----------------------------------------------------------------------

[JDBj-BOOTSTRAP SESSION]
user=PSFT
password=PSFT
environment=JPY810
role=*ALL

#-----------------------------------------------------------------------
# Bootstrap physical data source
#
# This defines the data source where the OCM and some other system
# tables reside. JDBj uses this at bootstrap time and later to look up
# OCM entries on demand. If it is not valid, then no ERP database
# access is possible.
#
# Here is a description of each field in this section:
#
# ---------------- --------------------------------------- -----------
# Field Description Applies to
# ---------------- --------------------------------------- -----------
# name The data source name. This is not that All
# important for bootstrap connections,
# but it does show up in error messages
# and the log.
# ---------------- --------------------------------------- -----------
# databaseType The database type. One of the All
# following:
#
# I = AS/400
# O = Oracle
# S = SQL Server
# W = UDB
# M = MSDE
# ---------------- --------------------------------------- -----------
# server The server (i.e. the host), or AS/400,
# "localhost". SQL Server
# MSDE
# ---------------- --------------------------------------- -----------
# database The database. Oracle,UDB
# ---------------- --------------------------------------- -----------
# serverPort The server port. SQL Server
# ---------------- --------------------------------------- -----------
# physicalDatabase The physical database (used as library AS/400,
# qualifier for AS/400). SQL Server,
# MSDE
# ---------------- --------------------------------------- -----------
# owner The owner. Oracle,
# SQL Server,
# UDB,
# MSDE
# ---------------- --------------------------------------- -----------
# lob Supports lobs. Oracle,
#
# AS/400
# ---------------- --------------------------------------- -----------
# unicode Performs unicode conversion. SQL Server
# MSDE
# ---------------- --------------------------------------- -----------
# databaseInstance The instance name of server. (JDELocal) MSDE
# ---------------- --------------------------------------- -----------
# translateOn AS400 translate on (default is FASLE) AS400
# ---------------- --------------------------------------- -----------
#-----------------------------------------------------------------------
#
# NOTES: * This information in this section should match the
# corresponding information specified in the
# [DB SYSTEM SETTINGS] section of this installation's JDE.INI
# file.
#-----------------------------------------------------------------------

[JDBj-BOOTSTRAP DATA SOURCE]
name=System - 810
databaseType=S
server=ENTE810
serverPort=1433
database=
physicalDatabase=PS810
owner=SY810
lob=false
unicode=false
databaseInstance=
translateOn=

#-----------------------------------------------------------------------
# Bootstrap spec data source (Optional)
#
# This defines the data source where the serialized spec tables reside.
# JDBj uses this at bootstrap time and after to look up serialized spec
# objects on demand. JDBj first looks for the name specified in this
# section in the Data Source Master table (F98611). If it finds a data
# source there, it uses it to read the serialized spec tables. If it
# does not find the data source in the Data Source Master table, then
# it initializes a new data source based on the rest of the fields in
# this section.
#
# If this section is not specified, then JDBj uses the OCM to find the
# serialized spec tables. If it is not valid, then no ERP database
# access is possible.
#
# See the description for "Bootstrap physical data source" above for
# information about which fields must be filled in for a given database
# platform.
#-----------------------------------------------------------------------

[JDBj-SPEC DATA SOURCE]
name=system - 810
databaseType=S
server=ENTE810
serverPort=1433
database=
physicalDatabase=PS810
owner=SY810
lob=false
unicode=false
user=PFST
password=PSFT

#=======================================================================
# END - ERP specific information
#
# The rest of the sections apply when accessing ERP and standalone data.
#=======================================================================

#-----------------------------------------------------------------------
# JDBC drivers
#
# This defines JDBC drivers and JDBC specific settings.
#-----------------------------------------------------------------------

[JDBj-JDBC DRIVERS]
ORACLE=oracle.jdbc.driver.OracleDriver
AS400=com.ibm.as400.access.AS400JDBCDriver
SQLSERVER=com.microsoft.jdbc.sqlserver.SQLServerDriver
UDB=COM.ibm.db2.jdbc.app.DB2Driver

[JDBj-ORACLE]
tns=

[JDBj-LOGS]
jdbcTrace=true

[JDBj-SERVER]
dbcsConversionTolerant=true

#-----------------------------------------------------------------------
# Connection pool settings
#-----------------------------------------------------------------------

[JDBj-CONNECTION POOL]

; The minimum number of connections to a data source. When closing old connections,
; the value set by this parameter will remain in the pool regardless of use.
;
; Valid values: 0 or greater
; Default value: 5

minConnection=5

; The maximum number of connections to a data source for all users. Additional
; database connection requests beyond this value will be queued for the next available
; connection.
;
; Valid values: 1 or greater (must be equal to or greater than "minConnection")
; Default value: 50

maxConnection=50

; The number of connections to initialize upon pool creation.
;
; Valid values: a value equal to or greater than "minConnection" AND equal to or
; less than "maxConnection"
; Default value: 5

initialConnection=5

; The increment of connections the system will create when a request for a connection
; cannot be satisfied with the current allocation as long as the maxConnection value
; has not been reached.
;
; Valid values: The rule of thumb is (poolGrowth >= maxConnection/10)
; Default value: 5

poolGrowth=5

; Amount of time in milliseconds that a connection remains idle before it is flagged
; to be cleaned up. Keeping this value high may or may not add to performance. Reducing
; the value may reduce memory consumption.
;
; Valid values: 0 or greater
; Default value: 1800000 (30 minutes)

connectionTimeout=1800000

; Amount of time in milliseconds that the pool cleaner is set to clean data sources
; that have a validation string. When cleaning occurs, any connections which have been
; flagged as idle will be cleaned up. The amount of time between a connection
; becoming idle and being cleaned up can be as long as the connectionTimeout value plus
; the cleanPoolInterval value.
;
; Valid values: 0 or greater
; Default value: 600000 (10 minutes)

cleanPoolInterval=600000

; The maximum number of JDBC prepared statements cached on each JDBC connection.
;
; Valid values: 0 or greater
; Default value: 50

maxSize=50

; The number of JDBC statements purged from a JDBC connection if the maxSize limit is
; reached. The statements purged will be the statements in the cache which have not
; been used for the longest amount of time.
;
; Valid values: The rule of thumb is (cachePurgeSize >= maxSize/10 + 2)
; Default value: 5

cachePurgeSize=5

#-----------------------------------------------------------------------
# JDBj Runtime properties
#
# These are all optional. They correspond to system runtime properties
# applicable to JDBj logical connections.
#
# NOTES: * In each case, the values listed are the defaults. The
# template default entries are commented out. Make sure
# and remove the pound sign (#) when changing these values.
#-----------------------------------------------------------------------

[JDBj-RUNTIME PROPERTIES]

; AS400 Database ASP property. Use this setting if you are running your iSeries
; server with multiple user databases or IASP (Independent Auxiliary Storage Pool)
; and have your EnterpriseOne tables located on the IASP. The IASP name can be found
; by using the command WRKRDBDIRE. This entry is not needed if you only have *LOCAL
; configured on your system in the WRKRDBDIRE Remote Location name.
;
; Valid values: Any valid string

# AS400DatabaseASP=null

; AS400 package name property. Overrides the default sql package
; name on the AS400 with the specified name.
;
; Valid values: Any valid string

# as400Package=JDBj

; AS400 package library name property. Overrides the default sql package
; library name on the AS400 with the specified name.
;
; Valid values: Any valid string

# as400PackageLibrary=JDBj-Library

; AS400 extended dynamic property. Overrides the default extended dynamic
; setting with the specified setting. If specified to a false, AS400 database
; will not use packages. This will have a negative impact on performance.
;
; Valid values: true, false

# as400ExtendedDynamic=true

; Data cache entry size threshold property. Sets the maximum
; size (in rows) for a single entry in the data cache. If a
; potential entry exceeds this threshold, then it will not be
; cached. -1 indicates that all eligible entries should be
; cached.
;
; Valid values: -1 or greater

# dataCacheEntrySizeThreshold=500

; Data cache entry threshold property. Sets the maximum size (in
; entries) for the data cache. If the data cache exceeds this
; size, then the least recently used entries are removed to
; make room for the new entry. -1 indicates that there is no
; maximum.
;
; Valid values: -1 or greater

# dataCacheEntryThreshold=100

; Data varification property. Enable or disable the data verification
; between actual data and EnterpriseOne specification for insert and
; update operations.
; The verification is performed on the following types:
; - EVDT_CHAR
; - EVDT_STRING
; - EVDT_NID
; - EVDT_TEXT
; - EVDT_VARSTRING
; - EVDT_VARCHAR
; - EVDT_MATH_NUMERIC
;
; This property will have a negative impact on performance.
;
; Valid values: true or false

# dataVerification=false

; Oracle NCHAR Trimming property. Indicates if the Oracle NCHAR
; Trimming logic is turned or off. True means the returned NCHAR
; data is intact. False means always right trim the returned
; NCHAR data.
;
; Valid values: true or false

# disableOracleNcharTrimming=false

; Force single data source property. Indicates whether JDBj
; should force operations involving multiple database objects to
; run against a single data source. If this is true, JDBj will
; only resolve the physical data source for the first database
; object involved in a given operation. Otherwise, JDBj will
; resolve physical data sources for all database objects and
; throw an exception if a single operation spans multiple data
; sources.
;
; Valid values: true, false

# forceSingleDataSource=false

; Result set timeout property. Sets the the number of
; milliseconds for the result set timeout. A result set will
; timeout if it has not had any operations for a period of time.
; -1 means that result sets will not timeout.
;
; Valid values: -1 or greater

# resultSetTimeout=60000

; Retry interval property. Sets the interval (in milliseconds)
; to wait before retrying idempotent database operations. -1
; means not to retry, 0 means retry immediately.
;
; Valid values: -1 or greater

# retryInterval=0

; Retry maximum property. Sets the number of times to retry
; idempotent database operations. -1 means to retry
; indefinitely.
;
; Valid values: -1 or greater

# retryMaximum=5

; OCM cache purge property. Sets the number of
; milliseconds after which inactive OCM cache entries are
; purged. 0 means to never purge OCM cache entries.
;
; Valid values: 0 or greater

# ocmCachePurge=3600000

; Personal Spec Versions property. Indicates if user's personal
; version can be read. This is only enforced during a read and not
; during a spec generation. If it set to a true, the personal version
; will be returned if it exists, otherwise the public version will be
; returned. If the property is set to a false, then the personal
; version will not even be read and we will default to the public
; version
;
; Valid values: true , false

# personalSpecVersions=false

; Service cache purge property. Sets the number of
; milliseconds after which inactive service cache entries are
; purged. 0 means to never purge service cache entries.
;
; Valid values: 0 or greater

# securityCachePurge=3600000


; Service cache purge property. Sets the number of
; milliseconds after which inactive service cache entries are
; purged. 0 means to never purge service cache entries.
;
; Valid values: 0 or greater

# serviceCachePurge=3600000

; Spec cache purge property. Sets the number of
; milliseconds after which inactive spec cache entries are
; purged. 0 means to never purge spec cache entries.
;
; Valid values: 0 or greater

# specCachePurge=3600000

; Spec consistency check property. Sets the level of spec
; consistency checking. Set this property to a higher level to
; improve exception messages relating to spec inconsistency
; problems. Set this to a lower level when it is not needed
; since it may degrade performance.
;
; Valid values: full, minimal, none

# specConsistencyCheck=minimal

; Spec generate on demand property. Indicates whether JDBj
; should generate specs on demand if it can not find them
; in the persistent cache.
;
; Valid values: true, false

# specGenerateOnDemand=false

; Transaction isolation property. Sets the isolation level to be
; used for transactions.
;
; Valid values: default, none, read uncommitted, read committed,
; repeatable read, serializable

# transactionIsolation=default

; Transaction timeout property. Sets the number of milliseconds
; for the transaction timeout. A transaction will timeout if it
; has not had any operations for a period of time. If this
; timeout is set to a -1 then the transaction timeout feature
; will be disabled. (This currently only happens when JDBj is
; run as part of a JAS transaction.)
;
; Valid values: -1 or greater

# transactionTimeout=120000

; Trigger auto fetch property. Indicates whether JDBj should
; automatically fetch rows to be changed in order to pass them
; to ERP triggers. This is needed for certain triggers to
; work properly.
;
; Valid values: none, single, all

# triggerAutoFetch=none

; Updatable result set timeout property. Sets the the number of
; milliseconds for the updatable result set timeout. An
; updatable result set will timeout if it has not had any
; operations for a period of time. -1 indicates that updatable
; result sets should have the same value as RESULT_SET_TIMEOUT.
;
; Valid values: -1 or greater

# updatableResultSetTimeout=-1

; Usage execution threshold property. Sets the expected maximum
; time (in milliseconds) for a single database operation to
; execute. If a single database operation takes longer than this
; threshold, then the statement and time will be logged as part
; of usage tracking.
;
; Valid values: 0 or greater

# usageExecutionThreshold=20000

; Usage fetch size threshold property. Sets the expected maximum
; fetch size (in rows) for a single fetch to return. If a single
; fetch returns more than than this threshold, then the actual
; fetch size will be logged as part of usage tracking. -1
; indicates that any fetch size is valid.
;
; Valid values: -1 or greater

# usageFetchSizeThreshold=500

; Usage result set open threshold property. Sets the expected
; maximum time (in milliseconds) for a result set to remain
; open. If a result set is left open longer than this threshold,
; then the result set and time will be logged as part of usage
; tracking. This does not automatically close the result set. A
; usage result set open threshold value of -1 indicates that no
; such usage tracking will occur.
;
; Valid values: -1 or greater

# usageResultSetOpenThreshold=60000

; Usage tracking property. Enables or disables usage tracking.
; This provides additional tracking and logging to use during
; testing. Usage tracking does incur a performance penalty so it
; should be disabled for production code.
;
; Valid values: true, false

# usageTracking=false

; Usage tracking output property. Specifies the destination of
; usage tracking output.
;
; Valid values: log, exception

# usageTrackingOutput=log

; Usage transaction active threshold property. Sets the expected
; maximum time (in milliseconds) for a transaction to remain
; active. If a transaction is left active longer than this
; threshold, then the transaction and time will be logged as
; part of usage tracking. This does not automatically rollback
; the transaction. A usage transaction active threshold value of
; -1 indicates that no such usage tracking will occur.
;
; Valid values: -1 or greater

# usageTransactionActiveThreshold=120000

#=======================================================================
# END OF FILE
#=======================================================================
 

Attachments

  • 90444-jaslog.txt
    23.6 KB · Views: 131
Hi, Ahsen1982!

I can recommend comment out all unused JDBC drivers in jdbj.ini [JDBj-JDBC DRIVERS] section like this:

#ORACLE=oracle.jdbc.driver.OracleDriver
#AS400=com.ibm.as400.access.AS400JDBCDriver
SQLSERVER=com.microsoft.jdbc.sqlserver.SQLServerDriver
#UDB=COM.ibm.db2.jdbc.app.DB2Driver

In addition you should revise [JDBj-SPEC DATA SOURCE] section.

Regards,
Vladimir
-------
Currently EOne 8.11 on Windows/Oracle with 8.94_F1.
WebSphere 5.0.2 (base - 5.0.2.9, ent - 5.0.2.6, jdk - 1.3.1-08)
 
Back
Top