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.
 
Back
Top