How can I enable and collect trace for DB2 through WebSphere? -



How can I enable and collect trace for DB2 through WebSphere? -

i enable trace db2 i'm accessing via datasource in websphere application server version 8.

in server's bootstrap.properties file after variable com.ibm.ws.logging.trace.specification= add together next code:

for version 6 or later:

*=info:was.j2c=all:rra=all:was.database=all:transaction=all

for version 5:

rra=all=enabled:was.database=all=enabled:j2c=all=enabled

more info can found on ibm website: https://www-304.ibm.com/support/docview.wss?rs=71&uid=swg21196160#wasconnection

in datasource need specify tracelevel property well. example:

<datasource id="db2" jndiname="jdbc/db2" jdbcdriverref="db2driver" > <properties.db2.jcc databasename="mydb" tracelevel="-1"/> </datasource>

db2 websphere ibm trace websphere-8

Comments

Popular posts from this blog

formatting - SAS SQL Datepart function returning odd values -

c++ - Apple Mach-O Linker Error(Duplicate Symbols For Architecture armv7) -

php - Yii 2: Unable to find a class into the extension 'yii2-admin' -