ca.portal.admin

CAS Question Temporary Solution

Discussion created by ca.portal.admin on Jun 6, 2006
Hello All:

We were unable to figure out how to do this so we used DMLO and Stored a
new occurrence of the CAS Application record with the new DBNAME and it
is working fine for now.

The real question here is how do you add a new CAS Application record,
we could not find any screen to do this, we found MODAPPL and SUMAPPL
but no ADDAPPL?

Bill Allen

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








Normal

Normal
Re: Broken pointer utility - HSL DBRepair
"Lutz- I concure with Wayne
I found that DBRepair from HSL is quick, easy & has a report-only capability.
Fortunately have not used the fix in years.
However have used the report, for ""perceived"" 0361's,
seen by local batch retrieval report-only runs against ""live"" db files.
Have a Good day,

Don

Don Locke
SimplexGrinnell
Phone: (978) 731-8678
Email: dlocke@tycoint.com


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








Normal

Normal
Upgrading from 12.01 to 16.x
"Hello Listers,

We are a small shop that is woefully behind on our IDMS maintenance due to conflicting priorities and the fact that we have only one DBA (that's me). We run 3 CVs; only one in production. We want to upgrade, sometime after July of this year, from release 12.01 to release 16, latest service pack. That brings me to the two questions I have for this esteemed body of experts.

First, can I upgrade directly to 16 from 12.01? Or, do I have to first go to 14.1 or 15?

Second, do you all know of consultants who can come into our shop and handle the upgrade for us? We're looking at upgrading our ""DBA"" CV all the way to 16.x; testing that from the standpoint that everything is there and that major components work; then, promoting the upgrade to our ""test"" CV for our development staff to give a more thorough test including running all production dialogs, jobs, and the like. Then, once we're satisfied with the results in test, promote the upgrade to production.

I would greatly appreciate whatever insight and suggestions you all can provide.

Thanks,

Roger C. Lawrence
Database Administrator
Seminole Electric Cooperative, Inc.
Tampa, Fl.
813.739.1518

"
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] Broken pointer utility
"We had an incident where a production local batch job aborted and the
developer ran the UNLOCK utility and this corrupted the database, but it did
not show right away. We used DB-AUDIT and it identified that the pointers
were corrupted for 3 owners. We have since locked-down the UNLOCK utility
from the developers.



Susan Reggio
USDA/NFC/IRMD/DBMB
P.O. Box 60,000
New Orleans, LA 70160
Susan.Reggio@USDA.GOV
504-426-2025
cell 1-504-247-5939
IDMS-L@LISTSERV.IUASSN.COM@inter2 6/7/2006 8:06:24 AM >>>
Some of our users do their own backups, so
they can restore after running a batch job that went awry. This works
fine, as long as they keep their backup and restore JCL current. We
have had a few cases where someone forgot to update their JCL after
adding a new file to the database.


not offering advice here, but just based on my own experiences ... NEVER
let developers put in jobs in production to backup production database
data. (especially the one you do not know about) Since 12.0, the idea is
that developers do not need to know the dataset layout. Since they do not
have DDs in their jobs anymore to see what files are used (or even in the
CV startup) - its an unnecessary burden to change ""application"" production
(backup) jobs when database files are added (missed backup) or dropped
(abended jobs)

i suppose if they backup using generics, you might get away with it, but
when a pre- or post- local mode update job backup is desired, the
DBA-authored DBA group backup job for that application is run.

now on the other hand, if the dev team (and not the DBA) is responsible
for data integrity and d/r, then let them handle the backups - but i have
not found this to be true in most places I have worked.


the bottom line is .. if they database is corrupted due to a bad appl
backup, the appl folks will fix it, right? NAAAAAAAAAAAAAAAAAAAA


just my thoughts ...

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: Upgrading from 12.01 to 16.x
"I found myself in a similar situation... I was the lone DBA among many other Management duties and needed to desperately upgrade to keep up with latest releases of CICS, MVS, etc... and to gain the performance improvements of the newer IDMS. We were also in the process of converting all Administrative Systems from IBM platform to SUN/UNIX platform, and I just did not have time to attempt the upgrade of IDMS myself...

You can upgrade from 12.01 directly to the latest version of IDMS, without all the in-between releases.

I contracted with Bill Allen, ARCH CONSULTING to do the complete install for East Carolina University. I have used Arch Consulting in the past and found them to be extremely knowledgeable and thorough, and swift. Bill was able to accomplish in less than a week, what it would have taken me months of preparation, planning and testing to accomplish, especially with all my other duties.

We only had one issue during our upgrade with a third-party PRINTER queuing software. Bill worked thru the entire problem working with our internal Systems Staff, with CA, and with the third-party vendor. The resolution was discovered within a few hours, with a patch from CA. I have found Bill's many years of experience and his connections with CA Technical Support to be a great plus for his company.

Bill was on-site for the initial upgrade to our TEST environment, then once we were satisfied with our thorough testing, Bill was able to upgrade our PRODUCTION environment remotely... it was that simple with the techniques used by Arch Consulting. Also, during our first week after upgrade, Bill was available for consultation but we had no problems.

I highly recommend anyone to consider Arch Consulting services if you are tired, over-worked, and woefully under-staffed.
__________________
Donnie W. Tenney
Associate Director, ITCS Software Development Services
& IDMS Database Administrator
East Carolina University
209 Cotanche Street, Room #106
Greenville, NC 27858
tenneyd@ecu.edu <mailTo:tenneyd@ecu.edu>
p: 252.328.9225 f: 252.328.4258



"
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] Upgrading from 12.01 to 16.x
"one thing that I ran across (and was pointed out by others) - is that you
MUST read the features guide of each release you are skipping - it has
been determine that certain install steps are mentioned there and nowhere
else (install steps that 16 assumes you did when you went from 12->14->15,
etc)

i think the features guide for all releases since 12.0 are included in the
CD, but you best read them




Chris Hoelscher
IDMS & DB2 Database Administrator
Humana Inc
502-710-3038
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: Parallel Unload/Reload
"To all,

I appreciate all your replies. It's been very informative. We have a lot
to examine and consider.

We have obtained a PDF document about R16 SP4 (beta). It's available on
CA's web site. It briefly describes new features and how unload and reload
utililties have been improved. In the end that may be the our solution.

Let's hope SP4 is available soon. Surely, we would like to take it for a
test drive.

Thank you all,

Claude F..../



----- Original Message -----
From: ""Jon R. Gocher"" <jgocher@FRONTIERNET.NET>
To: <IDMS-L@LISTSERV.IUASSN.COM>
Sent: Friday, June 09, 2006 10:56 PM
Subject: Re: [IDMS-L] Parallel Unload/Reload

Claude -

You didn't mention the record type that is connected to the index.
If it is VIA or DIRECT, I think maybe you can map multiple files to the
area
such that the first block in each file is a Space Management Page.
Then, for the reload piece, you could ready each file as if it were it's
own
area and run multiple reloads that way.

If the record is CALC, then you probably need an IDMSCLCX exit for this
record type with an algorithm that can target to the correct file.
I never did this, but I suppose you could get it to work.

Then you could run MAINTAIN INDEX to build the index, after the reload,
going against the entire area.

Good Luck.
Jon Gocher

----- Original Message -----
From: ""JEC"" <jectec@WORLDNET.ATT.NET>
To: <IDMS-L@LISTSERV.IUASSN.COM>
Sent: Wednesday, June 07, 2006 9:18 AM
Subject: Parallel Unload/Reload

Hello all,

A few years ago, I saw messages on this list about using parallel jobs
for
unloads and reloads.

For a new project, we are facing a situation where we may have to unload
and
reload an area with 150,000,000 records connected to a system owned
index
(MA set).

We have FAST ACCESS and it's good but not that good.

Can somebody provide feedback on the methodology for parallel unloads
and
reloads discussed here a few years ago ?

TIA,

Claude Ferland
Contractor
NYC

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








Normal

Normal
Re: Parallel Unload/Reload
"Claude -

You didn't mention the record type that is connected to the index.
If it is VIA or DIRECT, I think maybe you can map multiple files to the area
such that the first block in each file is a Space Management Page.
Then, for the reload piece, you could ready each file as if it were it's own
area and run multiple reloads that way.

If the record is CALC, then you probably need an IDMSCLCX exit for this
record type with an algorithm that can target to the correct file.
I never did this, but I suppose you could get it to work.

Then you could run MAINTAIN INDEX to build the index, after the reload,
going against the entire area.

Good Luck.
Jon Gocher

----- Original Message -----
From: ""JEC"" <jectec@WORLDNET.ATT.NET>
To: <IDMS-L@LISTSERV.IUASSN.COM>
Sent: Wednesday, June 07, 2006 9:18 AM
Subject: Parallel Unload/Reload

Hello all,

A few years ago, I saw messages on this list about using parallel jobs for
unloads and reloads.

For a new project, we are facing a situation where we may have to unload
and
reload an area with 150,000,000 records connected to a system owned index
(MA set).

We have FAST ACCESS and it's good but not that good.

Can somebody provide feedback on the methodology for parallel unloads and
reloads discussed here a few years ago ?

TIA,

Claude Ferland
Contractor
NYC

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








Normal

Normal
Going SOS in Pool 255
"Hi,



Yesterday and today we have exhausted Pool 255 allocation with large
Batch CV jobs. This pool is defined as type SY. We have a cushion
defined and can see no other storage pool went SOS though pool 0 high
water mark was higher than normal. The IDMS system handled everything
well and once it abended the problem program, the CV settled down.



An effect that I was surprised was that we had a SYSTEM MODULE PROGRAM
CHECKED NEAR RHDCSTGP AT OFFSET 328 when the pool went SOS with an SOS
CONDITION 1 the first time.



We are on 16.0 SP1 plus many apars. Is this the way that the system is
expected to work?



We are putting a stop on running the large Batch CV job during the day
and increasing both the primary allocation and cushion in that pool.



I just thought that this was a strange method to handle the situation
and had not seen it before.



Thanks



Chris Wood

Alberta Department of Energy

CANADA

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








Normal

Normal
Re: Going SOS in Pool 255
"Chris,

We've had an issue with pool 255 when batch programs were not taking enough
commits. The problem is lock overflow. You might want to check your
SYSLOCKS value in the sysgen and make sure it's at least 100,000. If you
are consistently exceeding the defined size, it should probably be larger.
SYSLOCKS is allocated out of the region (OS storage) and when that fills up
starts using pool 255, then pool 0. This is normal for now. I think a
future release is supposed to address lock overflow and disallow usage of
pool 0. Making pool 255 larger is an option, but if locks are using up the
pool, increasing SYSLOCKS might be better.

You mention that you have a cushion defined on pool 255. How'd you do that?

We're on SP2 and we haven't gotten the abend you mention, but have had other
interesting experiences, like runaway tasks when we're SOS.

HTH

Linda Campbell
Informatix, Inc.

Outcomes