#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    2
    Rep Power
    0

    Need a tool to enhance and check the performance of DB2 Native SQL Stored Procedure


    Need a tool to enhance and check the performance of DB2 Native SQL Stored Procedure. Please help.
  2. #2
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2010
    Location
    Katy, Texas
    Posts
    495
    Rep Power
    199
    What platform?
    Do you agree? Disagree? And remember, it's all about the reputation power...
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    2
    Rep Power
    0

    Need a tool to enhance and check the performance of DB2 Native SQL Stored Procedure


    We run the Stored procedures via UI applications where we cannot let it run for more than 2 sec (at max 2 secs) otherwise the UI application will face time out error. we code the Stored procedures in Mainframes and the execute them thru SQLDBX.

    Please help as performance improvement has become one of the most important factor here.
  6. #4
  7. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2010
    Location
    Katy, Texas
    Posts
    495
    Rep Power
    199
    Originally Posted by amit.347
    We run the Stored procedures via UI applications where we cannot let it run for more than 2 sec (at max 2 secs) otherwise the UI application will face time out error. we code the Stored procedures in Mainframes and the execute them thru SQLDBX.

    Please help as performance improvement has become one of the most important factor here.
    I'm not familiar with SQLDBX. On the mainframe, the Resource Limit Facility (RLF) can be used, either predictively or reactively, to limit the CPU used. It's available in all supported releases of DB2 for z/OS.
    Do you agree? Disagree? And remember, it's all about the reputation power...

IMN logo majestic logo threadwatch logo seochat tools logo