• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Logging SQL commands with STRDBMON problem

dburt16

Member
I want to log SQL commands using STRDBMON for:

- Older versions SQL SCRIPT (iNavigator Fat Client)
- Newer versions SQL SCRIPT (iNavigator Browser)
- STRSQL interactive SQL

CANNOT get anything from older Fat client SQL Script iNavigator.

***DOES NOT WORK FOR OLDER CLIENT ACCESS SCRIPT***
Example 14: Starting Public Monitoring and Filtering SQL Statements
Run From iNav Run SQL Scripts

STRDBMON OUTFILE(MYLIB/DBMONFILE) JOB(*ALL)
TYPE(*BASIC)

FTRCLTPGM(cwbunnav.exe)
OSTVAR(*CONDENSED)


***WORKS FOR LATEST ACS SCRIPTS***
Example 13: Starting Public Monitoring and Filtering SQL Statements
Run From iNav Run SQL Scripts

STRDBMON OUTFILE(MYLIB/DBMONFILE) JOB(*ALL)
TYPE(*BASIC)

FTRCLTAPP(System i Navigator - Run SQL Scripts)
HOSTVAR(*CONDENSED)

***WORKS FOR INTERACTIVE STRSQL***
STRDBMON OUTFILE(MYLIB/DBMONSTRS) JOB(*ALL)

TYPE(*BASIC) FTRCLTPGM(STRSQL)
HOSTVAR(*CONDENSED)

Thanks in advance for any help.
 
Top