ca.portal.admin

CAS ADSO Map weirdness

Discussion created by ca.portal.admin on Oct 19, 2006
EnvironmSent: IDMS 15.0 SP2 as shipped with CAS 3.0 N30100 plus loads of
subsequent PTFs.

CAS/OE ADS Response PRINTSO, dialog COEDUSOP, map COEMUSOP.

There are two fields on this map with the name
MAP-PRINT-ACKNOWLEDGE-FLAG: one is a 1-byte field for the user to key
in an ""action code"" of sorts, the other is 15 bytes or so and is
populated by an unlinked code table using the first field as input.

Had to compile map to resolve date/time stamp mismatch after I
recompiled dialog; made no changes to the map other than to recompile
it. Prior to map recompilation, when the dialog executed the ADS
statement ""IF FIELD MAP-PRINT-ACKNOWLEDGE-FLAG IS NOT CHANGED"" it would
read the MDT on the FIRST of these two fields to determine if the field
had been modified. After map compilation, now it reads the second one.

Have compared dialog, map, etc. with our TEST system that is functioning
as before - cannot find anything different.

Has anyone seen anything like this before? I'm out of ideas.

Thanks,

Mike

PELLERIN MILNOR CORPORATION
Michel J Champagne
Systems Analyst / DBA

Voice: 504-712-7589
FAX: 504-712-3589

Confidentiality Notice: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential and privileged information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all
copies of the original message.

Notice of Confidentiality:
**This E-mail and any of its attachments may contain Lincoln National
Corporation proprietary information, which is privileged, confidential,
or subject to copyright belonging to the Lincoln National Corporation
family of companies. This E-mail is intended solely for the use of the
individual or entity to which it is addressed.
If you are not the intended recipient of this E-mail, you are hereby
notified that any dissemination, distribution, copying, or action taken
in relation to the contents of and attachments to this E-mail is
strictly prohibited and may be unlawful. If you have received this
E-mail in error, please notify the sender immediately and permanently
delete the original and any copy of this E-mail and any printout. 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
SQL batch performance with called programs
"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: [IDMSVENDOR-L] SQL batch performance with called programs
"Kay,
i have no specific knowledge of your situation, but may I please offer the
following?

QO18253 Enhancement for multiple use of LE enclave.

See PDC QI18135 for documentation on the
performance enhancement which can be enabled by
turning on optional bit 232 after these APARs are
applied.

This optional functionality is activated by coding
the following #DEFOPTF in your RHDCOPTF module:

#DEFOPTF OPT00232


also, if LS40957 is on, higher CPU is predicted ...




Chris Hoelscher
IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
choelscher@humana.com




The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: SQL batch performance with called programs
"You may use a host variable with USAGE SQLSESS to obtain and maintain
the SQL session identifier. See SQL Option Programming Guide.

Onni Kukkonen
Vegasoft

Outcomes