SQL batch performance with called programs

[ca.portal.admin]

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: [phone] Fax: [phone]
Email: [e-mail]
"
IDMS Public Discussion Forum
[e-mail]
SMTP
[e-mail]
[e-mail]
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: [phone] (T/L: 349-2446)
ITN: 23492446
Email: [e-mail]



Martin Wieland <[e-mail]>
Sent by: IDMS Public Discussion Forum <[e-mail]>
10/25/2006 09:22 AM
Please respond to
IDMS Public Discussion Forum <[e-mail]>


To
[e-mail]
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:[e-mail]]
Namens Robert Klan
Verzonden: Wednesday, October 25, 2006 13:23 PM
Aan: [e-mail]
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: [phone] (T/L: 349-2446)
ITN: 23492446
Email: [e-mail]
"
IDMS Public Discussion Forum
[e-mail]
SMTP
[e-mail]
[e-mail]
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:[e-mail]]
Namens Robert Klan
Verzonden: Wednesday, October 25, 2006 13:23 PM
Aan: [e-mail]
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: [phone] (T/L: 349-2446)
ITN: 23492446
Email: [e-mail]
"
IDMS Public Discussion Forum
[e-mail]
SMTP
[e-mail]
[e-mail]
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: [phone] (T/L: 349-2446)
ITN: 23492446
Email: [e-mail]
"
IDMS Public Discussion Forum
[e-mail]
SMTP
[e-mail]
[e-mail]
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
[e-mail]
SMTP
[e-mail]
[e-mail]
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 <[e-mail]>
Reply-To: IDMS Public Discussion Forum <[e-mail]>
To: [e-mail]
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: [phone] (T/L: 349-2446)
ITN: 23492446
Email: [e-mail]



Martin Wieland <[e-mail]>
Sent by: IDMS Public Discussion Forum <[e-mail]>
10/25/2006 09:22 AM
Please respond to
IDMS Public Discussion Forum <[e-mail]>


To
[e-mail]
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:[e-mail]]
Namens Robert Klan
Verzonden: Wednesday, October 25, 2006 13:23 PM
Aan: [e-mail]
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: [phone] (T/L: 349-2446)
ITN: 23492446
Email: [e-mail]

_________________________________________________________________
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
[e-mail]
SMTP
[e-mail]
[e-mail]
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: [phone] (T/L: 349-2446)
ITN: 23492446
Email: [e-mail]



Jim Phillips <[e-mail]>
Sent by: IDMS Public Discussion Forum <[e-mail]>
10/26/2006 09:13 AM
Please respond to
IDMS Public Discussion Forum <[e-mail]>


To
[e-mail]
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 <[e-mail]>
Reply-To: IDMS Public Discussion Forum <[e-mail]>
To: [e-mail]
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: [phone] (T/L: 349-2446)
ITN: 23492446
Email: [e-mail]



Martin Wieland <[e-mail]>
Sent by: IDMS Public Discussion Forum <[e-mail]>
10/25/2006 09:22 AM
Please respond to
IDMS Public Discussion Forum <[e-mail]>


To
[e-mail]
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:[e-mail]]
Namens Robert Klan
Verzonden: Wednesday, October 25, 2006 13:23 PM
Aan: [e-mail]
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: [phone] (T/L: 349-2446)
ITN: 23492446
Email: [e-mail]

_________________________________________________________________
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
[e-mail]
SMTP
[e-mail]
[e-mail]
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