Skip to Main Content
IBM Power Ideas Portal


This portal is to open public enhancement requests against IBM Power Systems products, including IBM i. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas
  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

Status Delivered
Workspace IBM i
Categories IBM i Access Family
Created by Guest
Created on Jul 26, 2017

ACS Enhancment - Need SQL Details for Jobs... on Schemas window.

In iNav, once connected to an lpar, right clicking on Databases... there is the option for SQL for Jobs... option to bring up a window to show by user, current user, job, job number what jobs are running and we can then double click a job to see the sql running for the job.
I need that option on the ACS SCHEMAS window in ACS. To be able to right click on the Databases at the top of the tree on the left side.
Ideally, I'd love it as a new tab on the ACS SQL Performance Center as well. Both places would be great, but I'll take one of the two at this point.
We are trying to get off iNav.
This is one critical piece we need for system/sql performance duties that we have to using by going back to iNav.


Use Case:

While a user reports a slow running report, they give me the job and user profile the job is running under along with the lpar. I need a fast way to get to the SQLs for a Job...
Today, I have to stop, start up iNav, and go into the SQLs for Jobs... from there.
I am trying to get to no iNav usage.


Idea priority High
  • Guest
    Reply
    |
    Aug 16, 2017

    In the most recent update delivered in July 2017, this option exists when using Run SQL Scripts. From Run SQL Scripts, select:
    View->SQL Details for Job
    In our next update coming out in October 2017, we will also add the option to Schemas by right clicking on the Databases.

  • Guest
    Reply
    |
    Jul 27, 2017

    Now I am even more confused. I found this directory in the application settings directory while debugging something else.

    C:\Users\dolso32\Documents\IBM\iAccessClient\Settings\client.configuration\com.ibm.iaccess.plugins.db.x0044isplayx0053ettings\sqldetailsforjobs
    In that directory is a file prefs.dat

    Contents are:
    #sqldetailsforjobs Last updated on Thu Jul 27 11:19:14 CDT 2017 by process with PID pid_13104_b555a091
    #Thu Jul 27 11:19:14 CDT 2017
    x-loc=518
    height=600
    verticalDivider=0.59
    width=900
    y-loc=200
    horizontalDivider=0.73
    extended-state=0

    The stats are current. However, I can't figure out which window these location stats are for. I moved around and resized windos for the SQL Perf Ctr, Schemas, and Run SQL Scritps and all pop up windows I could find. None of them updated the window location stats in this file.
    So something is there for this requested option already to store the window location/parm.

    I just can't find it on any menu or window.
    Is this maybe an inflight enhancement that I happen to stumble across?

  • Guest
    Reply
    |
    Jul 26, 2017

    Attachment (Description)

  • Guest
    Reply
    |
    Jul 26, 2017

    Attachment (Description)