ca.portal.admin

SQL batch performance with called programs

Discussion created by ca.portal.admin on Oct 24, 2006
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

-----Original Message-----
From: Linda J. Casey [mailTo:lindajcasey@COMCAST.NET]
Sent: Wednesday, October 25, 2006 09:46 AM
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: 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
IDMS/DC and MQ Series
"My apologies for putting this question to the list. I know that I've seen
references to this in the past but I cannot get into the IUA website to
search the archives for them.

Be that as it may, I have a customer who currently has an IDMS application
runnng in CICS that reads and writes messages to a transient data queue.
That queue is mirrored back and forth between a second CICS application
running at another site using some piece of third-party software. The
customer would like to eliminate CICS from both sites (since this is the
only app running there now). We can move the CICS app to IDMS/DC here but
the big question is the message communication between the sites. The other
site already has MQ Series installed so they would prefer it be used at
this site. This site will need to contract for MQ Series and alter the app
here to use it for message handling; however, I assume that we wil need to
use another piece of software in the IDMS/DC region to interface with MQ
Series. Unless someone has rolled their own and would share the code, I
also assume such software will need to be purchased. The client is
looking to save some money since the MQ Series licence at this site is
cheaper then the CICS licence. However, the difference will need to pay
for the effort in moving the app from CICS to IDMS/DC plus the MQ Series
interface software.

Anyone who would care to fill me in on how this might be accomplished is
welcome to send me a note directly.

Dave Embury,
IBM Global Services
01/UCY/410/WLOO
410 Albert St., Waterloo. ON N2L 3V3
Internal IBM email: Dave Embury/Ontario/IBM@IBMCA
External (Internet) email: emburyd@ca.ibm.com
Voice: (519) 880-2946 {5-2946}
Fax: (519) 746-4803

Adult: A being who has stopped growing on both ends and is growing in the
middle.

This transmission may contain information that is privileged, confidential
and/or exempt from disclosure under applicable law. If you are not the
intended recipient, you are hereby notified that any disclosure, copying,
distribution, or use of the information contained herein (including any
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission
in error, please immediately contact the sender and destroy the material in
its entirety, whether in electronic or hard copy format.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Security reports (the auditors are coming!)
"Dear listers --

As we all know <ahem>, the catalog carries resource categories which list
groups of tasks and users (or groups of users) are granted execute
privileges on the categories. The question where is all this stuff
stored. I've been traipsing through the dictionary and catalog and coming
up empty. Anybody got any ideas???

Alan Fields
VF Corporation
Greensboro, NC

336-424-4773
Alan_Fields@vfc.com

This email is intended solely for the use of the individual(s) to whom it is addressed and may contain information that is privileged, confidential or otherwise required to be protected from disclosure. If the reader of this email is not the intended recipient, you are hereby notified that any dissemination, distribution, copying or other use of this communication or its attachments is strictly prohibited. If you have received this communication in error, please delete it as well as all copies or backups of it entirely from your email system and notify me that you received this email in error. Thank you.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Security reports (the auditors are coming!)
"CA-IDMS Security Administration Appendix B tells you where you can find
everything - even includes the Table Definitions.

HTH - cheers - Gary

Outcomes