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.