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
Post a Comment