IBM Support

How to collect a GSKit Trace in a Db2 Purescale environment?

Technical Blog Post


Abstract

How to collect a GSKit Trace in a Db2 Purescale environment?

Body

I recently came across a scenario where GSKit trace was not getting generated in a Db2 Purescale environment.

 

What works in a regular EE instance doesn't work in Purescale environment, you will need to temporarily add the export to the sqllib/db2profile file.
The reason is that Purescale node (even though logical node) are treated as physical node internally so it does not pick up the environment variable like the EE.
Here is an example:


1. Update the sqllib/db2profile, add the following lines to the end of the file:  (Remove it once you are done with the trace)

     GSK_TRACE_FILE=/tmp/gsktrace.out
     GSK_TRACE_FILE_SIZE=5000000
     export GSK_TRACE_FILE
     export GSK_TRACE_FILE_SIZE

 

2. db2set DB2ENVLIST="GSK_TRACE_FILE GSK_TRACE_FILE_SIZE"


3. db2stop and db2start


4. db2 activate db xxx, db2 connect to xxx -> you will see the /tmp/gsktrace.out file created.

 

Thanks,

Shashank Kharche

IBM DB2 LUW Lab

 

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

UID

ibm13285933