Configuring DB2-400 Query Length
-
- Last UpdatedMar 14, 2025
- 2 minute read
Starting with SecureSphere v13.1, you can configure the length of the query statement as either short (256 characters) or long (4000 characters). The long query length enables the parsing of firewall events from the v13.1 Agent (and later).
Note: If you configure the DB2-400 Agent for the long query statement, you may experience a performance degradation due to the increase in parsed data. |
The default setting is for the short query statement.
To configure the DB2-400 agent query length:
- Disable the log collector. For more information, see Configuring Log Collector.
- Access the AS400 Agent. The Login window appears.
- Type values for the User and the Password and hit Enter. The Main Screen appears.
- Type the STRISA command on the command line. The main menu appears.
- Type
81
and hit Enter. The System Configuration window appears. - Verify that the Release ID is 2.10 or later.
- Type
1
and hit Enter. The General Definitions window appears. - The default value of SQL Reporting attributes is 1 (standard length). To set it to long length, select the number 1, type
2
, and hit Enter. - Hit F3 or Enter to return to the main window.
- Hit Enter again to save the changes.
- Re-enable the log collector.