ca.portal.admin

Support Connect

Discussion created by ca.portal.admin on Mar 28, 2007
Latest reply on Mar 30, 2007 by ca.portal.admin
Actually it's an SAP conversion that has thrown the monkey wrench into
everything IIRC... My prioity 2 issue from 11/24 is still open and I
haven't heard a peep from anyone since 2/12, despite repeated requests
for status updates. It's pretty clear to me from this that the Support
Connect folks really don't care whether the clients think the product is
a POS.
-----Original Message-----
From: IDMS Public Discussion Forum
Date: Tue, 27 Mar 2007 13:56:02 -0400
From: ""Govan, Hal (LNG-DAY)"" <Harold.Govan@LEXISNEXIS.COM>
Subject: Re: check your ca-support connect product repository .....

I guess the repository must be a DATACOM system Chris... :-)
Cleveland Clinic is ranked one of the top 3 hospitals in
America by U.S.News & World Report. Visit us online at
http://www.clevelandclinic.org for a complete listing of
our services, staff and locations.


Confidentiality Note: This message is intended for use
only by the individual or entity to which it is addressed
and may contain information that is privileged,
confidential, and exempt from disclosure under applicable
law. If the reader of this message is not the intended
recipient or the employee or agent responsible for
delivering the message to the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited. If
you have received this communication in error, please
contact the sender immediately and destroy the material in
its entirety, whether electronic or hard copy. 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
Support Connect
"Actually it's an SAP conversion that has thrown the monkey wrench into everything IIRC... My prioity 2 issue from 11/24 is still open and I haven't heard a peep from anyone since 2/12, despite repeated requests for status updates. It's pretty clear to me from this that the Support Connect folks really don't care whether the clients think the product is a POS.
-----Original Message-----
From: IDMS Public Discussion Forum
Date: Tue, 27 Mar 2007 13:56:02 -0400
From: ""Govan, Hal (LNG-DAY)"" <Harold.Govan@LEXISNEXIS.COM>
Subject: Re: check your ca-support connect product repository .....

I guess the repository must be a DATACOM system Chris... :-)
Cleveland Clinic is ranked one of the top 3 hospitals in
America by U.S.News & World Report. Visit us online at
http://www.clevelandclinic.org for a complete listing of
our services, staff and locations.


Confidentiality Note: This message is intended for use
only by the individual or entity to which it is addressed
and may contain information that is privileged,
confidential, and exempt from disclosure under applicable
law. If the reader of this message is not the intended
recipient or the employee or agent responsible for
delivering the message to the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited. If
you have received this communication in error, please
contact the sender immediately and destroy the material in
its entirety, whether electronic or hard copy. 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
XML question
"When using the new (with R16) XML commands, is there any to do a ""SELECT
* "" type of query, or must the columns always be specified?

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
Drawing for free CA WORLD 2007 registration
"Greetings all,

I received the following email (below) from CA in regards to their
giving away a free CA World registration.
CA is giving away 2 free registrations, one to an IUA member
in North America and one to a European IUA member. I will be handling
the North American
givaway and Jan Rabaut will be handling the European giveaway.

If you are already registered for CA World or are definitely going to CA
World, please send an email to
terry.schwartz@ps.net by April 4 and I will enter you in the drawing
for the North American free registration.


Thanks,
Terry Schwartz
IUA Chair






Dear PLC IDMS (IUA/EIUA) members,



For those of you who are planning on attending CA WORLD this
April, we will be giving away two free CA WORLD 2007 registrations
(valued at $1295.00 USD) to two members of this user community.

The random drawing will take place on April 4, 2007.

At CA WORLD, we invite you to join the face to face PLC meetings
for your user community This is the chance for customers from around
the globe to meet in person and engage in peer networking and mutual
support. These sessions will be primarily guided by the members- topics
may include introductions to CA Development teams, quarterly call
topics, Enhancement Requests and Product Requirements, and many other
agenda items.



The IDMS users meeting at CA WORLD will be held on April 23
from 12-1 pm. Details are available thru the CA World site conference
sessions at http://www.caworld.com/ <http://www.caworld.com/> .



Also, remember to send to us any specific topics you wish to
have addressed at this meeting to ensure that we have the right CA
resources and subject matter experts available to join you at this
meeting.


"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Debugging database procedures
"Pete, I understood your execellent suggestion. I just tried to
recommend a way where it would have no impact on any other developers
and you dont have to be the only one calling the procedure.
We're cool.

Best regards

Lutz

This e-mail may contain confidential or privileged information. If
you think you have received this e-mail in error, please advise the
sender by reply e-mail and then delete this e-mail immediately.
Thank you. Aetna
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Debugging database procedures
"I would suggest debugging the procedure outside the schema.

Make a small program that reads the expected data from a file, have the
procedure manipulate it, then optionally write the result to another file.
You can add the necessary debugging information to the procedure, or use
available debugging tools.

Tommy Petersen




peter.g.charles@B
T.COM
Sent by: IDMS To
Public Discussion IDMS-L@LISTSERV.IUASSN.COM
Forum cc
<IDMS-L@LISTSERV.
IUASSN.COM> Subject
Re: Debugging database procedures

03/30/2007 04:33
AM


Please respond to
IDMS Public
Discussion Forum
<IDMS-L@LISTSERV.
IUASSN.COM>






Lutz,

I did say ' This of course is only works if only you are calling the
procedure.'

May be I should have made it clear that this was ONLY for
testing/debugging when you have a single user you is invoking the
procedure and that when running 'for real' .

I do not wish to get into a long discussion on this but I must add the
following.

Defining an ISA and STORAGE PROTECT for a database procedure has no
effect.

These options are checked/actioned by IDMSDC program management
(RHDCPCTL) which is not involved when IDMSDBMS calls a database
procedure.

What IDMSDBMS does when it needs to call a db procedure is check the
variable portion of the PC70 VPCENTR to see if it already has the entry
point for the procedure. If not it issues a #LOAD and populates VPCENTR.
It then issues a #CALL to the entry point.

What #CALL does a stack check and then a branch to CSAMPMOD.

CSAMPOD checks to see if a call to mode manger is required and if not it
just braches to the procedure. In mode manger is required it does the MP
stuff and then branch to the procedure. In either case no RHDCPCTL

If you are running MP all DB procedures should have mode of DB if not it
can seriously impact performance I know because I got it wrong once.

Before I get the response saying that ISA and storage protect do apply
to DB procedures I did a little test.

I have procedure define with storage protected on, ISA 256 and
reentrant.
System has protect on.
The procedure on entry stores R11 (should be ISA) into an area with
itself which if storage protect was on would cause a S0C4.
My procedure does not abend but runs as expected.
Displaying memory I can see that R11 on entry was 0 so no ISA.

Last point is the Times called count displayed when you do a DCMT D PR
for a db procedure this is in fact the number of time that a #LOAD was
issued for it and not the times the IDMSDBMS has called it.

I do have a procedure that counts internally the times it is called. I
run my test program to drive the database procedure and DCMT count for
it is incremented by 1 where as the internal count is incremented by
1,831.

If you are running MP mode and updating non re-entrant storage as I am
then be sure to us the Compare and Swap instruction to ensure single
thearding of the update to the storage.

Pete

Outcomes