OpenAPI Writing of DBMS Trace Messages to File
OpenAPI can redirect trace messages returned from the DBMS to a disk file.
The II_API_SET environment variable can be set to a value of PRINTTRACE to enable writing of GCA_TRACE messages to the default output file iiprttrc.log. Output can be directed to a specific file by adding the TRACEFILE argument.
Here are examples in the UNIX environment:
1. Enable OpenAPI tracing of GCA_TRACE messages to default output file iiprttrc.c:
setenv II_API_SET printtrace
2. Enable OpenAPI tracing of GCA_TRACE messages to output file tracing.log:
setenv II_API_SET "printtrace; tracefile tracing.log"
Setting II_API_SET does not affect passing of trace information to the application by OpenAPI.