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