-zr iqsrv15 Server Option

Enables request-level logging of operations.

Syntax

-zr level

Remarks

Specify maximum size of file for server request logging.

  • All—logs all SQL statements and other requests to the server.

  • None—turns off SQL statement logging. This is the default.

  • SQL—logs the following types of requests only:

    • CONTROL_START_DATABASE

    • CONTROL_STOP_ENGINE

    • CONTROL_STOP_DATABASE

    • STMT_PREPARE

    • STMT_EXECUTE

    • STMT_EXECUTE_IMM

    • STMT_EXECUTE_ANY_IMM

    • SQL_OPTION_SET

    • BACKUP

    • DELETE_FILE

    • COMMIT

    • ROLLBACK

    • PREPARE_TO_COMMIT

    • CONNECT

    • DISCONNECT

    • BEGIN_TRANSACTION

    • STMT_DROP

    • CURSOR_OPEN

    • CURSOR_EXPLAIN

    • CURSOR_CLOSE

    • CURSOR_RESUME

    • Errors

-zr also prevents request-level logging from appearing in the console. See System Administration Guide: Volume 1 > Troubleshooting Hints > Diagnostic Tools> Logging Server Requests.

For information about reading the -zr log output, see System Administration Guide: Volume 1 > Troubleshooting Hints > Diagnostic Tools > Logging Server Requests > Request Log File Analysis.

See also SQL Anywhere Server - SQL Usage > Monitoring and Improving Database Performance > Improving database performance > Other diagnostic tools and techniques > Request logging.
Note: This reference points to SQL Anywhere documentation.

See also -zo file and -zs { integer | integerG | integerK | integerM } … command-line switches.

Parent topic: start_iq Server Options