Viewing SQL Queries Against AS400
Viewing SQL queries against an AS400 iSeries:
- Open iSeries Navigator
- Expand the System (i.e. 10.0.0.1 or PROD400)
- Expand "Databases" (*Note: If Databases does not exist, run a Selective Reinstall of iSeries Access for Windows and Select "iSeries Navigator", "Databases". On a side note, you may also want to install everything under iSeries Navigator as well as "Data Access", "ODBC" and "Data Transfer", "Base" as well as "Excel Add-In")
- Expand the System Name (i.e. S10bABC)
- Right click on SQL Plan Cache Snapshots
- Click SQL Plan Cache
- It is strongly recommended to set up some filters to limit the results. (i.e. Set date/time, User, etc)
- You should be able to read the SQL Queries in the result window. Click it to view the entire statement.
No comments:
Post a Comment