ca.portal.admin

USERID in Journal records

Discussion created by ca.portal.admin on Oct 31, 2005
Latest reply on Nov 4, 2005 by ca.portal.admin
Hello,

Does anyone have a work-around to get user id info off of the journals?
See below:

To accommodate Sarbanes-Oxley requirements, client would like to see the

userid associated with the run unit written out to the journals so they

can later use those journals to report on process performed by userid.
Currently there is no way to report on this information because the
journals to not contain userid associated with the run unit.

TIA.

Navid


The electronic mail message you have received and any files transmitted
with it are confidential and solely for the intended addressee(s)'s
attention. Do not divulge, copy, forward, or use the contents,
attachments, or information without permission of Fannie Mae.
Information contained in this message is provided solely for the purpose
stated in the message or its attachment(s) and must not be disclosed to
any third party or used for any other purpose without consent of Fannie
Mae. If you have received this message and/or any files transmitted
with it in error, please delete them from your system, destroy any hard
copies of them, and contact the sender.



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








Normal

Normal
Re: USERID in Journal records
"Hi Navid,

We provide an EXIT for one of our products to create a ""USER"" record
in the Journal so that you have
such information. We could provide a free copy of the source if you
like. It is code for EXIT 14. We
have an eyecatch in it for our own use but you could change.

Drop me a note offline, and I will send the source and some instructions.

John

At 02:25 PM 10/31/2005, Ahrarian, Navid wrote:
Hello,
=20
Does anyone have a work-around to get user id info off of the journals?
See below:
=20
To accommodate Sarbanes-Oxley requirements, client would like to see the

userid associated with the run unit written out to the journals so they

can later use those journals to report on process performed by userid.=20
Currently there is no way to report on this information because the=20
journals to not contain userid associated with the run unit.
=20
TIA.
=20
Navid
=20

The electronic mail message you have received and any files transmitted
separate run-unit, that did an OBTAIN KEEP EXCLUSIVE, >with it are confidential and solely for the intended addressee(s)'s
attention. Do not divulge, copy, forward, or use the contents,
attachments, or information without permission of Fannie Mae.
Information contained in this message is provided solely for the purpose
stated in the message or its attachment(s) and must not be disclosed to
any third party or used for any other purpose without consent of Fannie
Mae. If you have received this message and/or any files transmitted
with it in error, please delete them from your system, destroy any hard
copies of them, and contact the sender. =20

=20
John Abell
International Software Products

This email may contain confidential and privileged material for the
sole use of the intended recipient(s). Any review, use, retention,
distribution or disclosure by others is strictly prohibited. If you
are not the intended recipient (or authorized to receive on behalf of
the named recipient), please contact the sender by reply email and
delete all copies of this message. Also, email is susceptible to data
corruption, interception, tampering, unauthorized amendment and
viruses. We only send and receive emails on the basis that we are not
liable for any such corruption, interception, tampering, amendment or
viruses or any consequence thereof.

"
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] USERID in Journal records
"many many 3rd-party software vendors market this kind of product - at
least one markets their product as a ""sarbanes-oxley"" solution for IDMS

or you might do some kind of task /transaction # match on the journal and
log fiels to apply user ids from the log to transactions from the journal

chris hoelscher

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
USERID in Journal records
"Hello,

Does anyone have a work-around to get user id info off of the journals?
See below:

To accommodate Sarbanes-Oxley requirements, client would like to see the

userid associated with the run unit written out to the journals so they

can later use those journals to report on process performed by userid.
Currently there is no way to report on this information because the
journals to not contain userid associated with the run unit.

TIA.

Navid


The electronic mail message you have received and any files transmitted
with it are confidential and solely for the intended addressee(s)'s
attention. Do not divulge, copy, forward, or use the contents,
attachments, or information without permission of Fannie Mae.
Information contained in this message is provided solely for the purpose
stated in the message or its attachment(s) and must not be disclosed to
any third party or used for any other purpose without consent of Fannie
Mae. If you have received this message and/or any files transmitted
with it in error, please delete them from your system, destroy any hard
copies of them, and contact the sender.



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








Normal

Normal
Advantage CA-ADS Introductory Overview Webcast
"Computer Associates is offering a free one hour webcast that is an introductory or refresher overview for anyone needing to create or modify applications using the Advantage(tm) CA-ADS for CA-IDMS family of tools.  The live webcast will be on Tuesday, November 8, 2005, at 10:00 AM EST.

To register for the webcast, please access http://www.thevoicethevoice.com/pizza/

This webcast is part of the ""Better Learning Through Pizza Mainframe Update Webcast"" program. CA will award one pizza to the referring party for every two people they recommend who attend the webinar. Guests must enter referral's name when registering and attend the webinar. CA employees and their families are not eligible. Prize is a coupon for a one-topping pizza from a national pizza chain (retail value $8 - $12). Winner will be notified by email.

DBAs, be sure to pass on this information to your application developers.

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








Normal

Normal
Advantage CA-ADS Introductory Overview Webcast
"
Computer Associates is offering a free one hour webcast that is an
introductory or refresher overview for anyone needing to create or modify
applications using the Advantage™ CA-ADS for CA-IDMS family of tools.  The
live webcast will be on Tuesday, November 8, 2005, at 10:00 AM EST.

To register for the webcast, please access
http://www.thevoicethevoice.com/pizza/

This webcast is part of the ""Better Learning Through Pizza Mainframe Update
Webcast"" program. CA will award one pizza to the referring party for every
two people they recommend who attend the webinar. Guests must enter
referral's name when registering and attend the webinar. CA employees and
their families are not eligible. Prize is a coupon for a one-topping pizza
from a national pizza chain (retail value $8 - $12). Winner will be
notified by email.

DBAs, be sure to pass on this information to your application developers.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: IDMS Server question
"Hello Kay:

ARCH just had a client go live last week with 16.0 SP2 and all of a sudden
we were getting all kinds of DDS Snaps in the log for task CASERVER and program
CASERVER stalled waiting on PTERMS.

We resolved this issue by changing the Internal and external time out values
to 300 and the resource timeout to forever from the default sysgen values.

Once the system cycled, the next day we did not see any stalls waiting on
PTERMS or DDS Snaps in the log.

What had happened was that the values that we had established had been
replaced by the default sysgen values for the CASERVER task during the
installation of IDMS 16.0 SP2.

Bill Allen
ARCH Consulting Associates, Ltd.

In a message dated 11/1/2005 3:44:17 P.M. Eastern Standard Time,
KAY.ROZEBOOM@IOWA.GOV writes:

Several times a day, we have IDMS Server tasks for web applications
abend with DC001003 - STALLED WAITING FOR PTERM. I have adjusted all
the timeout values according to CA's recommendations. From comparing
times on the various logs, it appears that the front end and back end
are both waiting for each other, until one or the other times out. This
occurs sporadically on multiple CV's, with multiple applications,
running on multiple web servers. Has anyone else had this problem?

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
IDMS Server question
"Several times a day, we have IDMS Server tasks for web applications
abend with DC001003 - STALLED WAITING FOR PTERM. I have adjusted all
the timeout values according to CA's recommendations. From comparing
times on the various logs, it appears that the front end and back end
are both waiting for each other, until one or the other times out. This
occurs sporadically on multiple CV's, with multiple applications,
running on multiple web servers. Has anyone else had this problem?

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: How to punch all schemas ??????
"We have a library of signon and dictionary control cards. We concatenate
the appropriate member with the output from a previous step to build the
complete set of control cards.

Patricia Rathbone
University of New Mexico

At 11/01/2005 09:06 Tuesday, javier sotela wrote:
Hi Everyone:

We are trying to punch all schemas from a dictionary in two steps. The first
step just send all schemas to suspch verb punch, like this : Punch all
schemas as syn verb punch. The idea is that in the second step the utilitie
IDMSCHEM takes the schemas in syspch and punch to a file with syn. The
problem is that we can do this with modules using IDMSDDL and punching the
user information and the dictionary options across idd modules, using for
example PUNCH MODULE SIGNON-XXXX. The problem is that with IDMSCHEM there is
not valid option to use PUNCH MODULE SIGNON-***, then there is not the
option to send the signon information and the dictionary options to the
second step. Does anybody have a job with different steps to punch all
schemas and solve my problem ????

TIA.

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








Normal

Normal
Re: How to punch all schemas ??????
"What I do is that I punch the information to a temporary dataset.
Then in my second step ""in-line"" the syntax for punching the schemas.

FIRST Step
//SYSPCH DD DSN=&&TEMPDSN.......
//SYSIPT
PUNCH ALL SCHEMA AS SYN VERB PUN.

SECOND Step
//SYSIPT DD *
SIGNON ......
SET OPT DIS AS SYN WITHOUT ELE.
// DD DSN=&&TEMPDSN,DISP=PASS

I hope this helps.

Tommy Petersen




javier sotela
<jsotela@hotmail.
com> To
Sent by: IDMS IDMS-L@LISTSERV.IUASSN.COM
Public Discussion cc
Forum
<IDMS-L@LISTSERV. Subject
IUASSN.COM> How to punch all schemas ??????


11/01/2005 11:06
AM


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






Hi Everyone:

We are trying to punch all schemas from a dictionary in two steps. The
first
step just send all schemas to suspch verb punch, like this : Punch all
schemas as syn verb punch. The idea is that in the second step the utilitie
IDMSCHEM takes the schemas in syspch and punch to a file with syn. The
problem is that we can do this with modules using IDMSDDL and punching the
user information and the dictionary options across idd modules, using for
example PUNCH MODULE SIGNON-XXXX. The problem is that with IDMSCHEM there
is
not valid option to use PUNCH MODULE SIGNON-***, then there is not the
option to send the signon information and the dictionary options to the
second step. Does anybody have a job with different steps to punch all
schemas and solve my problem ????

TIA.

Javier S.

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

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








Normal

Normal
Re: USERID in Journal records
"Hi Everyone!!!!

We open a DAR with this problem to CA some months ago. Althougth there is
some optios ,we are on VSE and there is not a good options to do that. And
on the other side, this is a market requerinment for database software ,if
CA understand one day that they have to put this feature in the base
software. They said that I was the second site that needs that, then we open
a DAR. I suggest to everybody to open a DAR with this requirenment, all
competitive database in the market provide this feature, why not IDMS ???

TIA.

J. Sotela

From: ""Ahrarian, Navid"" <navid_ahrarian@FANNIEMAE.COM>
Reply-To: IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM>
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: USERID in Journal records
Date: Mon, 31 Oct 2005 14:25:10 -0500

Hello,

Does anyone have a work-around to get user id info off of the journals?
See below:

To accommodate Sarbanes-Oxley requirements, client would like to see the

userid associated with the run unit written out to the journals so they

can later use those journals to report on process performed by userid.
Currently there is no way to report on this information because the
journals to not contain userid associated with the run unit.

TIA.

Navid


The electronic mail message you have received and any files transmitted
with it are confidential and solely for the intended addressee(s)'s
attention. Do not divulge, copy, forward, or use the contents,
attachments, or information without permission of Fannie Mae.
Information contained in this message is provided solely for the purpose
stated in the message or its attachment(s) and must not be disclosed to
any third party or used for any other purpose without consent of Fannie
Mae. If you have received this message and/or any files transmitted
with it in error, please delete them from your system, destroy any hard
copies of them, and contact the sender.

_________________________________________________________________
Don't just search. Find. Check out the new MSN Search!
http://search.msn.com/

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








Normal

Normal
How to punch all schemas ??????
"Hi Everyone:

We are trying to punch all schemas from a dictionary in two steps. The first
step just send all schemas to suspch verb punch, like this : Punch all
schemas as syn verb punch. The idea is that in the second step the utilitie
IDMSCHEM takes the schemas in syspch and punch to a file with syn. The
problem is that we can do this with modules using IDMSDDL and punching the
user information and the dictionary options across idd modules, using for
example PUNCH MODULE SIGNON-XXXX. The problem is that with IDMSCHEM there is
not valid option to use PUNCH MODULE SIGNON-***, then there is not the
option to send the signon information and the dictionary options to the
second step. Does anybody have a job with different steps to punch all
schemas and solve my problem ????

TIA.

Javier S.

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

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








Normal

Normal
IDMS16 - Security issue
"Hi all,

We are getting the following message:

+IDMS DB347012 Security violation using subschema IDMSSECU with dbname SYSUSER pgm ZDBAPSH1

1 - The IDMS startup JCL contains USER=XXXXX

2 - The program ZDBAPSH1 is submitted via dialog and it's seems that the message is related to the user.

3 - Such user has SYSADMIN profile and able to access SYSUSER segment

I can't figure out what's going on.

Any clue?

Thanks.

Marcelo Gaspar
Large Systems Database Software, LSDS
*(313)24-84634 * mailTo:mgaspar1@ford.com
* mailTo:8517035@alphapage.airtouch.com
Amagus Consulting at Ford Motor Co.

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








Normal

Normal
Re: DAR voting
"Chris,

I'll post the list later today.

Laura

Chris Wood wrote:
Laura,

For the benefit of non members would it be possible to see the list?

Thanks

Chris Wood
Alberta Department of Energy
CANADA

-----Original Message-----
From: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM]
On Behalf Of Laura Rochon
Sent: November 2, 2005 9:57 AM
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: DAR voting

Hi everyone,

The IUA & Computer Associates need your help. CA is busy working
working on the next release of CA-IDMS, and would like your feedback on
the DARs and Suggestions that were submitted to CA.

The IUA went thru the list, and have posted the 28 highest ranking ones
on our website. We would like you to give us your feedback on these
DARs/Suggestions. Please visit www.iuassn.org. Once you've signed on,
if you're a paid member of the IUA, you can get to the DAR Ballot page
off the MEMBERs ONLY section.

Please vote by November 11th 2005, as the results will be reported back
to CA during CA-World, which is being help in Las Vegas, from November
13th to the 17th 2005.

Thank you,
Laura Rochon
IUA
This communication is intended for the use of the recipient to which it i=
s addressed, and may contain confidential, personal and or privileged inf=
ormation. Please contact us immediately if you are not the intended recip=
ients of this communication, and do not copy, distribute, or take action =
relying on it. Any communication received in error, or subsequent reply, =
should be deleted or destroyed.


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








Normal

Normal
Re: DAR voting
"Laura,

For the benefit of non members would it be possible to see the list?

Thanks

Chris Wood
Alberta Department of Energy
CANADA

Outcomes