Viewing SQL Queries Against AS400

Viewing SQL queries against an AS400 iSeries:

  1. Open iSeries Navigator
  2. Expand the System (i.e. 10.0.0.1 or PROD400)
  3. 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")
  4. Expand the System Name (i.e. S10bABC)
  5. Right click on SQL Plan Cache Snapshots
  6. Click SQL Plan Cache
  7. It is strongly recommended to set up some filters to limit the results. (i.e. Set date/time, User, etc)
  8. You should be able to read the SQL Queries in the result window.  Click it to view the entire statement.


Comments

Post a Comment

Popular posts from this blog

Dell Zino HD Remote Standard

Image
Took me hours and multiple calls to Dell Technical Support to find this information out. The Dell Zino HD uses the following IR standard for the Remote Sensor on the front: UPD6124A Here is the PDF specification:  http://www.datasheetcatalog.org/datasheet/nec/UPD6600A.pdf The support representative said most universal remotes use one of these two standards: RC5, RECS80 Unfortunately, this causes issues when trying to use a universal remote (example: XBOX 360 Universal Remote) with the Dell Zino HD.  A USB External IR sensor is needed to work with most universal remotes.  This is very confusing, as both devices list as a standard "Microsoft eHome Infrared Tranciever". What this means is that no remote -- other than the one that shipped with your device -- will work with your Dell Zino HD!  Scroll down to see my work-around. Since the Dell Zino HD only comes with 4 usb ports, the external sensor may have to be plugged in to the front of the device, which is partic
Read more

iPod Touch iPhone 3G Ubuntu 9.10 in 5 minutes

Image
"Lucid (Ubuntu 10.04) has 'out of the box', zero-configuration support in Rhythmbox for the iPod touch running firmware 3.12/3.13. It does not require jailbreaking, though I have personally discovered it will work with both a "stock" and a jailbroken iPod touch." - Raffisson Studio Changes (skip this) : Mar 28, 2010: Added link to French tutorial in step 1. Mar 16, 2010: Added Amarok 2.3 notes pe r Gary Feb 23, 2010: Removed "-dev" packages and made some small changes per farfouille64 feedback. Feb 19, 2010: Bifster found a similar tutorial. Worth trying if you have issues. Here's the link: easy way to sync your iphone Feb 19, 2010: Step 11 added DFB 's RythmBox plugin suggestion. Confirmation working with firmware 3.1.3! Thanks DFB! Feb 15, 2010: Step 11 added AJ's unicode work-around. Thanks AJ! Feb 11, 2010: Step 10 modified to automatically add user to group "fuse". Thanks for the
Read more

Pidgin - Microsoft Office Communicator

Image
Update: 11/15/10 - Added ICONV.DLL, LIBXML2.DLL work-around for Windows. Update: 05/01/10 - SIPE 1.10 is out. Tutorial updated. Update: 01/27/10 - SIPE 1.7.1 is out. Download it here . Update: 08/20/09 - SIPE 1.6.0 seems to be available, so I've updated this article with some 1.6.0 comments in red below. Steps: Downloading and installing the latest Pidgin for your platform. - Windows: For first time users, the installer will require GTK to be installed. - Windows: Recommended: Install automatic spell-check (Aspell) for your language, which needs to be selected during install. (Requires a connection to the internet). Download and install the latest SIPE ( SI mple P rotocol E xchange) for your platform. - Windows: The plugin will come bundled as a zip file with a MSI installer. Run the MSI installer. This will install the plugin to "Program Files\Pidgin" - Linux: If a precompiled version (usually ".DEB" or ".RPM" is not ava
Read more