CA IDMS IUA EIUA

SQL batch performance with called programs

  • 1.  SQL batch performance with called programs

    Posted 10-24-2006 01:16 PM
    I have a user who has a non-SQL COBOL batch program (program A) that
    calls a second COBOL program (program B) which issues SQL. This
    combination is performing poorly - long run time, lots of CPU.

    When program B's processing is incorporated into program A, thus
    removing the call, it performs much better. I suspect the problem is
    caused by program B setting up a new SQL session and transaction every
    time it is called.

    Is there any way to eliminate this additional overhead by getting
    program B to reuse a single session/transaction across multiple calls?
    I have looked at ""transaction sharing"" and ""global cursors"", but neither
    seems to be what we are looking for.

    Kay Rozeboom
    State of Iowa
    Information Technology Enterprise
    Department of Administrative Services
    Telephone: 515.281.6139 Fax: 515.281.6137
    Email: Kay.Rozeboom@Iowa.Gov
    "
    IDMS Public Discussion Forum
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP
    IDMS-L@LISTSERV.IUASSN.COM
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP








    Normal

    Normal
    "Re: Anyone have IDMS SMF COBOL, ASSEMBLER or SAS DSECT/Program?"
    "Hi Martin.

    Your points are well taken. End user has MXG and was approached with that
    solution.

    Customer desires to write their own. What can I say?

    I told customer I would toss out to IDMS-L and see if anyone had something
    to share....

    Thanks

    Rob Klan/Cincinnati/IBM
    Phone: 1-877-205-4871 (T/L: 349-2446)
    ITN: 23492446
    Email: rklan@us.ibm.com



    Martin Wieland <martin.wieland@NECKNET.COM>
    Sent by: IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM>
    10/25/2006 09:22 AM
    Please respond to
    IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM>


    To
    IDMS-L@LISTSERV.IUASSN.COM
    cc

    Subject
    Re: Anyone have IDMS SMF COBOL, ASSEMBLER or SAS DSECT/Program?






    Robert,

    The answer to this is not as simple as the question suggests and
    involves quite a lot of work. The IDMS Performance Monitor System
    Administration manual documents a lot. Eg. you could use PMARPT90 to
    produce a machine readable report and build your own report. Another way
    (the way we do it) is to use available off the shelf software to produce
    the reports you want. We use MXG (www.mxg.com) the create a SAS database
    out of our SMF extraction data and then it's just a matter of building
    some SAS report programs. If I am right SAS has a similar product of its
    own. Don't forget that you have to enable SMF loggin in the first
    place...

    Regards,
    Martin Wieland
    Neckermann.com







    -----Oorspronkelijk bericht-----
    Van: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM]
    Namens Robert Klan
    Verzonden: Wednesday, October 25, 2006 13:23 PM
    Aan: IDMS-L@LISTSERV.IUASSN.COM
    Onderwerp: Anyone have IDMS SMF COBOL, ASSEMBLER or SAS DSECT/Program?


    Anyone have an IDMS SMF layout or extraction program they are willing to
    share?

    I have end user who desires to write their own IDMS SMF report using
    PMAM, PMIM Type 1/2 records instead of using available options.

    I have pointed customer to the Culprit layouts (i.e. PMSMFEX ) but they
    were not satisfied with that information.

    Thanks in advance.


    Rob Klan/Cincinnati/IBM
    Phone: 1-877-205-4871 (T/L: 349-2446)
    ITN: 23492446
    Email: rklan@us.ibm.com
    "
    IDMS Public Discussion Forum
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP
    IDMS-L@LISTSERV.IUASSN.COM
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP








    Normal

    Normal
    "Re: Anyone have IDMS SMF COBOL, ASSEMBLER or SAS DSECT/Program?"
    "Robert,

    The answer to this is not as simple as the question suggests and
    involves quite a lot of work. The IDMS Performance Monitor System
    Administration manual documents a lot. Eg. you could use PMARPT90 to
    produce a machine readable report and build your own report. Another way
    (the way we do it) is to use available off the shelf software to produce
    the reports you want. We use MXG (www.mxg.com) the create a SAS database
    out of our SMF extraction data and then it's just a matter of building
    some SAS report programs. If I am right SAS has a similar product of its
    own. Don't forget that you have to enable SMF loggin in the first
    place...

    Regards,
    Martin Wieland
    Neckermann.com







    -----Oorspronkelijk bericht-----
    Van: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM]
    Namens Robert Klan
    Verzonden: Wednesday, October 25, 2006 13:23 PM
    Aan: IDMS-L@LISTSERV.IUASSN.COM
    Onderwerp: Anyone have IDMS SMF COBOL, ASSEMBLER or SAS DSECT/Program?


    Anyone have an IDMS SMF layout or extraction program they are willing to
    share?

    I have end user who desires to write their own IDMS SMF report using
    PMAM, PMIM Type 1/2 records instead of using available options.

    I have pointed customer to the Culprit layouts (i.e. PMSMFEX ) but they
    were not satisfied with that information.

    Thanks in advance.


    Rob Klan/Cincinnati/IBM
    Phone: 1-877-205-4871 (T/L: 349-2446)
    ITN: 23492446
    Email: rklan@us.ibm.com
    "
    IDMS Public Discussion Forum
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP
    IDMS-L@LISTSERV.IUASSN.COM
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP








    Normal

    Normal
    "Anyone have IDMS SMF COBOL, ASSEMBLER or SAS DSECT/Program?"
    "Anyone have an IDMS SMF layout or extraction program they are willing to
    share?

    I have end user who desires to write their own IDMS SMF report using PMAM,
    PMIM Type 1/2 records instead of using available options.

    I have pointed customer to the Culprit layouts (i.e. PMSMFEX ) but they
    were not satisfied with that information.

    Thanks in advance.


    Rob Klan/Cincinnati/IBM
    Phone: 1-877-205-4871 (T/L: 349-2446)
    ITN: 23492446
    Email: rklan@us.ibm.com
    "
    IDMS Public Discussion Forum
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP
    IDMS-L@LISTSERV.IUASSN.COM
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP








    Normal

    Normal
    DBKEYs and table & call procedures
    "Has anyone passed a DBKEY from a table procedure to a .net/java front end
    and then back again to either a table procedure or call procedure? Any
    known problems doing this? I would think not but then again you never know.



    Linda J. Casey

    Managing Member

    Run Right, LLC
    "
    IDMS Public Discussion Forum
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP
    IDMS-L@LISTSERV.IUASSN.COM
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP








    Normal

    Normal
    "Re: Anyone have IDMS SMF COBOL, ASSEMBLER or SAS DSECT/Program?"
    "The PMDC logging component, an alternative to the Perfmon one, comes with
    the appropriate MXG code as well as numerous SAS reports.


    From: Robert Klan <rklan@US.IBM.COM>
    Reply-To: IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM>
    To: IDMSVENDOR-L@LISTSERV.IUASSN.COM
    Subject: Re: Anyone have IDMS SMF COBOL, ASSEMBLER or SAS DSECT/Program?
    Date: Wed, 25 Oct 2006 09:38:37 -0400

    Hi Martin.

    Your points are well taken. End user has MXG and was approached with that
    solution.

    Customer desires to write their own. What can I say?

    I told customer I would toss out to IDMS-L and see if anyone had something
    to share....

    Thanks

    Rob Klan/Cincinnati/IBM
    Phone: 1-877-205-4871 (T/L: 349-2446)
    ITN: 23492446
    Email: rklan@us.ibm.com



    Martin Wieland <martin.wieland@NECKNET.COM>
    Sent by: IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM>
    10/25/2006 09:22 AM
    Please respond to
    IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM>


    To
    IDMS-L@LISTSERV.IUASSN.COM
    cc

    Subject
    Re: Anyone have IDMS SMF COBOL, ASSEMBLER or SAS DSECT/Program?






    Robert,

    The answer to this is not as simple as the question suggests and
    involves quite a lot of work. The IDMS Performance Monitor System
    Administration manual documents a lot. Eg. you could use PMARPT90 to
    produce a machine readable report and build your own report. Another way
    (the way we do it) is to use available off the shelf software to produce
    the reports you want. We use MXG (www.mxg.com) the create a SAS database
    out of our SMF extraction data and then it's just a matter of building
    some SAS report programs. If I am right SAS has a similar product of its
    own. Don't forget that you have to enable SMF loggin in the first
    place...

    Regards,
    Martin Wieland
    Neckermann.com







    -----Oorspronkelijk bericht-----
    Van: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM]
    Namens Robert Klan
    Verzonden: Wednesday, October 25, 2006 13:23 PM
    Aan: IDMS-L@LISTSERV.IUASSN.COM
    Onderwerp: Anyone have IDMS SMF COBOL, ASSEMBLER or SAS DSECT/Program?


    Anyone have an IDMS SMF layout or extraction program they are willing to
    share?

    I have end user who desires to write their own IDMS SMF report using
    PMAM, PMIM Type 1/2 records instead of using available options.

    I have pointed customer to the Culprit layouts (i.e. PMSMFEX ) but they
    were not satisfied with that information.

    Thanks in advance.


    Rob Klan/Cincinnati/IBM
    Phone: 1-877-205-4871 (T/L: 349-2446)
    ITN: 23492446
    Email: rklan@us.ibm.com
    _________________________________________________________________
    Ready for the world's first international mobile film festival celebrating
    the creative potential of today's youth? Check out Mobile Jam Fest for your
    a chance to WIN $10,000! www.mobilejamfest.com
    "
    IDMS Public Discussion Forum
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP
    IDMS-L@LISTSERV.IUASSN.COM
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP








    Normal

    Normal
    "Re: Anyone have IDMS SMF COBOL, ASSEMBLER or SAS DSECT/Program?"
    "Thank You Jim, Your information is valuable in that the end user is a PMDC
    customer.


    Rob Klan/Cincinnati/IBM
    Phone: 1-877-205-4871 (T/L: 349-2446)
    ITN: 23492446
    Email: rklan@us.ibm.com



    Jim Phillips <jimphillips44@HOTMAIL.COM>
    Sent by: IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM>
    10/26/2006 09:13 AM
    Please respond to
    IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM>


    To
    IDMS-L@LISTSERV.IUASSN.COM
    cc

    Subject
    Re: Anyone have IDMS SMF COBOL, ASSEMBLER or SAS DSECT/Program?






    The PMDC logging component, an alternative to the Perfmon one, comes with
    the appropriate MXG code as well as numerous SAS reports.


    From: Robert Klan <rklan@US.IBM.COM>
    Reply-To: IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM>
    To: IDMSVENDOR-L@LISTSERV.IUASSN.COM
    Subject: Re: Anyone have IDMS SMF COBOL, ASSEMBLER or SAS DSECT/Program?
    Date: Wed, 25 Oct 2006 09:38:37 -0400

    Hi Martin.

    Your points are well taken. End user has MXG and was approached with that
    solution.

    Customer desires to write their own. What can I say?

    I told customer I would toss out to IDMS-L and see if anyone had
    something
    to share....

    Thanks

    Rob Klan/Cincinnati/IBM
    Phone: 1-877-205-4871 (T/L: 349-2446)
    ITN: 23492446
    Email: rklan@us.ibm.com



    Martin Wieland <martin.wieland@NECKNET.COM>
    Sent by: IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM>
    10/25/2006 09:22 AM
    Please respond to
    IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM>


    To
    IDMS-L@LISTSERV.IUASSN.COM
    cc

    Subject
    Re: Anyone have IDMS SMF COBOL, ASSEMBLER or SAS DSECT/Program?






    Robert,

    The answer to this is not as simple as the question suggests and
    involves quite a lot of work. The IDMS Performance Monitor System
    Administration manual documents a lot. Eg. you could use PMARPT90 to
    produce a machine readable report and build your own report. Another way
    (the way we do it) is to use available off the shelf software to produce
    the reports you want. We use MXG (www.mxg.com) the create a SAS database
    out of our SMF extraction data and then it's just a matter of building
    some SAS report programs. If I am right SAS has a similar product of its
    own. Don't forget that you have to enable SMF loggin in the first
    place...

    Regards,
    Martin Wieland
    Neckermann.com







    -----Oorspronkelijk bericht-----
    Van: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM]
    Namens Robert Klan
    Verzonden: Wednesday, October 25, 2006 13:23 PM
    Aan: IDMS-L@LISTSERV.IUASSN.COM
    Onderwerp: Anyone have IDMS SMF COBOL, ASSEMBLER or SAS DSECT/Program?


    Anyone have an IDMS SMF layout or extraction program they are willing to
    share?

    I have end user who desires to write their own IDMS SMF report using
    PMAM, PMIM Type 1/2 records instead of using available options.

    I have pointed customer to the Culprit layouts (i.e. PMSMFEX ) but they
    were not satisfied with that information.

    Thanks in advance.


    Rob Klan/Cincinnati/IBM
    Phone: 1-877-205-4871 (T/L: 349-2446)
    ITN: 23492446
    Email: rklan@us.ibm.com
    _________________________________________________________________
    Ready for the world's first international mobile film festival celebrating
    the creative potential of today's youth? Check out Mobile Jam Fest for
    your
    a chance to WIN $10,000! www.mobilejamfest.com
    "
    IDMS Public Discussion Forum
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP
    IDMS-L@LISTSERV.IUASSN.COM
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP








    Normal

    Normal
    Re: DBKEYs and table & call procedures
    "Hi Linda,
    Yes, I have done this. You define your db-key in the table procedure definition as Integer. Let me know if you need any addtional info and I'll try to find you an example.
    Margaret