Modify the Showcase.cfg file to Turn on JDBC Tracing for Showcase Logging [Video]

 

Follow the steps below to modify the Showcase.cfg file to turn on JDBC tracing for Showcase logging.

Setting Showcase Logging for your Showcase Server

Note: Extra leading or trailing  blank spaces or an incorrect spelling of server name can prevent the Showcase server from starting.

1. Edit the showcase.cfg file located in the Showcase server library.

   1. On iSeries command line, type the following command: (replace <sc_svr_lib_name> with the Showcase Server library name)

      EDTF '/<sc_svr_lib_name>/proddata/config/showcase.cfg'

2. If the lines for Showcase debugging Information ARE NOT listed in the beginning of the showcase.cfg file, you will need to enter them as shown in the example below.
3. If the lines for Showcase debugging logging ARE listed in the beginning of the showcase.cfg file (see example below), do the following.
   1. Change Debug=0 to Debug=1
   2. Then DELETE the double slashes (//) at the beginning of the six lines starting with: showcasecorp.traceService=ALL to scserver.os400.stdout=file:///SUPPORT94/SUPPORT94_stdout.log

Turning on JDBC Trace Logging

1. Add the following three entries for the JDBC Trace logging. See the example below on where to place these lines. (replace <sc_svr_lib_name> with the Showcase Server library name)

   // Showcase JDBC Trace logging

   // scserver.db2.jdbc.trace.level=4

   scserver.db2.jdbc.trace.config=file:///<sc_svr_lib_name>/db2Jdbc.log

2. Once ALL the lines have been added or modified, Press F3 to Save/Exit the file.

After the above steps have been completed, issue the following command to start the Showcase server:

SCSERVER/strscsvr (where SCSERVER is the name of your Showcase server name)

 

EXAMPLE: Entries to turn on Showcase logging and JDBC trace

************Beginning of data**************

///////////////////////////////////////////////////

// ShowCase Server Properties                    //

///////////////////////////////////////////////////

 

///////////////////////////////////////////////////

// Supplemental Group Support                    //

///////////////////////////////////////////////////

showcasecorp.supplementalGroupSupport=FALSE

 

///////////////////////////////////////////////////

// Showcase Debugging Information                //

///////////////////////////////////////////////////

DEBUG=1

 

showcasecorp.traceService=ALL

showcasecorp.traceLevel=ALL

showcasecorp.traceUser=ALL

showcasecorp.traceLog=/SCSERVER/SCSERVER.log

 

scserver.os400.stderr=file:///SCSERVER/stderr.log

scserver.os400.stdout=file:///SCSERVER/stdout.log

 

// Showcase JDBC Trace logging  //

scserver.db2.jdbc.trace.level=4

scserver.db2.jdbc.trace.config=file:///SCSERVER/db2Jdbc.log

 

// Properties must be added before the below stanza

 

[ControlTables]

hsql.cached.table=false

 

************End of Data********************

Once the error has been generated stop the Showcase server with the command: SCSERVER/ENDSCSVR (where SCSERVER is the name of your Showcase server name).

$ logs should appear in the IFS under SCSERVER.

1. SCSERVER.log
2. STDERR.log
3. SRDOUT.log
4. DB2JDBC.log.

Once logs have been downloaded you can turn off Showcase logging. Note you can changed the DEBUG=1 to DEBUG=0 and comment out the 8 logging lines as shown below.

EXAMPLE: Entries to turn off Showcase logging and JDBC trace

************Beginning of data**************

///////////////////////////////////////////////////

// ShowCase Server Properties                    //

///////////////////////////////////////////////////

 

///////////////////////////////////////////////////

// Supplemental Group Support                    //

///////////////////////////////////////////////////

showcasecorp.supplementalGroupSupport=FALSE

 

///////////////////////////////////////////////////

// Showcase Debugging Information                //

///////////////////////////////////////////////////

DEBUG=0

 

//showcasecorp.traceService=ALL

//showcasecorp.traceLevel=ALL

//showcasecorp.traceUser=ALL

//showcasecorp.traceLog=/SCSERVER/SCSERVER.log

 

//scserver.os400.stderr=file:///SCSERVER/stderr.log

//scserver.os400.stdout=file:///SCSERVER/stdout.log

 

// Showcase JDBC Trace logging  //

//scserver.db2.jdbc.trace.level=4

//scserver.db2.jdbc.trace.config=file:///SCSERVER/db2Jdbc.log

 

// Properties must be added before the below stanza

 

[ControlTables]

hsql.cached.table=false

 

************End of Data********************

Video:

IBM Ref#: 1494000

Still have questions? We can help. Submit a case to technical support

Last Modified On: