Db2 Tools for zOS

 View Only
  • 1.  Studio Timeouts

    Posted Wed December 15, 2021 05:47 PM
    When doing various activities in the studio one often sees timeouts.   Our development systems get hammered so DVM response can be, er, unpredictable.

    What knobs exist in the studio or DVM parms to lengthen AVZ2700 timeout periods?

    Is there information on what the various timeout settings are for the studio?

    I know when we have data limits there are things such as SQLFAILCPUTIME?

    Please advise...

    Kevin Flanagan


  • 2.  RE: Studio Timeouts

    Posted Wed December 15, 2021 07:19 PM

    Hi Kevin,

    These are great questions, I'll get some of the engineering team plugged in on this one. Curious about the types of app dev activities going on during the slowdowns or timeouts. Our engineers will chime in here, but I know that the Studio is not meant for performance testing. We recommend using tools like JMETER for that where you can have some control over timeouts. But if there are other server-side settings that need to be assessed it may be more involved. We also have Command Line Tester (CLT) for this purpose. Both of these are documented in the latest Redbook in section 8.8.


    Look for some additional responses soon and thanks for the question!


    Doug Dailey
    Product Manager
    IBM Data and AI on Z, Data Virtualization Manager for z/OS

    Test Drive Data Virtualization Manager for z/OS! ibm.biz/dte-live

  • 3.  RE: Studio Timeouts

    Posted Thu December 16, 2021 03:40 PM
    these are simple reads with a where clause, which i know can be an issue due to dvm having to read the entire file to find the matching entries...

    thanks for the hints regarding JMETER and command line tester...

    Kevin Flanagan

  • 4.  RE: Studio Timeouts

    Posted Wed December 15, 2021 11:47 PM
    Edited by System Fri January 20, 2023 04:45 PM

    If you have access to https://ssw-ui.mybluemix.net, you can search the error code by replacing the first character with "x" and third character with "y". So if you search "xVy2700E" you will see this:
    xVy2700E Error 06-001 (No space in return area)

    For other timeouts, you can search at this site, there are handful of different timeouts discussion/technotes. If you have any specific timeouts that you are getting that you can't find a solution, please let me know. You can also open a case from IBM support page.

    Please let me know if that helps.


    Dale Voon

  • 5.  RE: Studio Timeouts

    Posted Fri December 17, 2021 12:43 PM
    Thanks, Dale, good information!

    Kevin Flanagan