ca.portal.admin

Re: 2 PDE copies in memory

Discussion created by ca.portal.admin on Aug 30, 2007
So, how did the resident flag get there? Not that I saw it, but a good
source said the pde had the resident flag on.

Lutz Petzold





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: Avoiding long outages with large databases
"We currently don't use any vendor products to handle reorgs or restructures. I'd be most interested in hearing from those who do though, as to how well they like them...
Richard C Borman <rborman@CSC.COM> 8/8/2007 11:37 AM >>>
Do you use DB-EZREORG to handle reorgs, unloads etc on this database? It
is the one way to handle situations such as yours.

Dick

Richard C Borman/GIS/CSC
CSC/GIS Idms System Support
9305 Lightwave Ave
San Diego, Ca 92193-9011
home 760-787-1075
cell 858-245-4761
rborman@csc.com



--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit written
agreement or government initiative expressly permitting the use of e-mail
for such purpose.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------





Joan Hutchinson
<JHUTCHIN@IPSCO.C
OM> To
Sent by: IDMS IDMS-L@LISTSERV.IUASSN.COM
Public Discussion cc
Forum
<IDMS-L@LISTSERV. Subject
IUASSN.COM> Avoiding long outages with large
databases

08/08/2007 10:15
AM


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






I have a question regarding large databases. In the last few years for
various business reasons, we have drastically increased the number of
occurrences of 3 specific record types (two are via the third) that reside
in the same area. The numbers will continue to increase. Our DBA has
increased the size of the area several times to accommodate this. However,
she has advised us that the area cannot be made much larger, as it will
mean long outages when database maintenance/changes need to be done
involving that area (restructures, etc.). Our business runs 24/7, and so
long outages are a major issue for our users. One of the records in
question is 464 characters, and we have almost 2 million occurrences of it.
It is used frequently by our applications. The second is 168 characters,
and we have 1.5 million occurrences, and the third is 52 characters, and we
have 1.5 million occurrences. The area currently has over 1 million pages.
We do archive/delete old data, but not enough is considered 'old' by our
users' requirements to alleviate enough of the problem. No doubt there are
larger databases out there than ours with more data...what
strategies/products/etc. do you use to avoid long outages when you must
make changes to the records/indexes in an area? Any feedback would be most
appreciated.

We are a VM/VSE shop with IDMS Release 15.0.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Changing password in different dictionaries
"We use an MVS CLIST that submits a batch job that takes care of all the
CVs, OCF and dictionaries. Handles adds and deletes with DROP, SDEL and
subsequent drop. Could use the same process for password propagation.
Paul Wood
IBM Global Services
Mainframe Database, Modeling, Repository Tech. Lead
AmerisourceBergen Account
Home Office: (714) 876-0497
pawood@us.ibm.com



javier sotela <jsotela@HOTMAIL.COM>
Sent by: IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM>
08/31/2007 09:35 AM
Please respond to
IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM>


To
IDMS-L@LISTSERV.IUASSN.COM
cc

Subject
Changing password in differnt dictionaries






Hi Everybody:

We have a programmers requirenmet to change the password on user signon
and try to replicate the new password to the different dictionaries that
the programmer have. I know that the user can change the ddlsec password
using the signon, but how to give an option to the programmers to sync
this main password with all the passwords in the different dictionaries
that that they have access. Any ideas ???

Thanks.

J. Sotela
_________________________________________________________________
Connect to the next generation of MSN Messenger
http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmailtagline
"
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] Changing password in differnt dictionaries
"depending upon your shop, dictionary passwords may not be needed: from the
dusty corner of my memory - if you sign on to a CV - and then attempt an
IDD signon to a dictionary WITH THE SAME USERID with which you signed onto
the CV, the dictionary password is ignored if specified (whether or not it
matches the value on the USER-045 record in the dictionary)


Chris Hoelscher
Senior 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: 2 PDE copies in memory
"I guess the point is Ed, that there are situations when IDMS picks the
wrong PDE and a dcmt v d pro or dcmt v pro disable does not target the
wanted PDE. That's why some dba's were between a rock and a hard place
and varied the bad pde's memory so it's out of the picture. I dont
remember the exact details, but I have seen a situation like that years
ago, with CA on the phone, we couldn't shake a bad PDE either. Then,
there was no fallout. But that was so long ago, I dont remember the
IDMS release, could have been 10.0 or 12.0.

Lutz Petzold




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: 2 PDE copies in memory
"Don,
You can issue a delete on a dynamically created program.

DCMT V DYN PRO x DELETE .




Dan Hall
GE
Capital Solutions
Danbury, CT

T 513.217.5060
E dan.hall@ge.com
http://www.ge.com/capitalsolutions/

Outcomes