SQL Diagnostics

Setting environment variable PJS_SQL_DEBUG=1 causes the SQL API to output diagnostic information to standard output. PJS_SQL_DEBUG can be set either when starting the service or by using code in a Profound.js program.

When Starting from an Interactive Terminal

# SQL diagnostic information will display in the terminal window.
cd /profoundjs
PJS_SQL_DEBUG=1 node start.js

Enabling Diagnostics Using Code in a Profound.js Program

// Run this before calling any SQL API.
process.env["PJS_SQL_DEBUG"] = "1";

When starting Profound.js as a service on IBM i, the diagnostic information will be written to the instance standard output log in directory /profoundjs-base/INSTANCE_NAME/logs.