ca.portal.admin

Re:Apars QO71083 (16.0) and QO71174 (14.1)

Discussion created by ca.portal.admin on Aug 12, 2005
Hi,



These apars mention about removing type DB from storage pool 0 if it
is
defined as being in another 24-bit storage pool. I seem to remember
that
we could not do this before when we added a 24-bit pool for type DB.



So does this mean that we could create a new 24-bit pool defined for
type DB and if we have the apar applied it will remove the entry from
pool 0?



Thanks



Chris Wood

Alberta Department of Energy

CANADA

This communication is intended for the use of the recipient to which it
is
addressed, and may contain confidential, personal and or privileged
information. Please contact us immediately if you are not the intended
recipients 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.

This E-Mail has been scanned for viruses.

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








Normal

Normal
Re: Storing VIA records in a separate area
"Kay,

It may not have to do with location mode but, instead, with
ADSO retrieval locking. CA added this ""feature"" in release
12.0 and it can bring an online application to a halt, if
there is heavy traffic. Because they thought they were
fixing a bug, they did not publicize this change and caused
many of us application people much grief. It is set in ADSC
with an indicator like ""Mainline Dialog"", ""COBOL
Moves"", ""Symbol Table Enabled"", etc. The default is set on
so this means when dialogs are readied in update mode, they
lock every record they touch in the event the record maybe
updated subsequently within the application thread. In the
old days you used to be able to do all of your retrieval in
one dialog and then link to a mapless dialog to do your
updates. If currency is passed between these dialogs and
retrieval locking is not on, the dialog will abort. The
best solution is set retrieval locking off for dialogs that
do retrieval only and if they link to update dialogs, do
a ""LINK NOSAVE"" and pass dbkeys to re-establish currency.
You may just have to do it on a few that are high usage and
volume. Anyway, this may not be the problem but check to
see if you are getting deadlocking errors or very wierd
status codes that mean something totally different. For
example, we used to get 0361's (broken chains) in some
instances of deadlockling. Good luck and let me know if you
need any more info on disabling ADSO retrieval locks. I've
had a lot of practice in that area.

Margaret

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








Normal

Normal
Re: Storing VIA records in a separate area
"Thanks to everyone who took the time to reply to this question. The
detailed responses were really educational. I learned a lot, and hope
that others did too.

Isn't this list great?

"
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 question
"IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM> writes:
Hi everyone,

Not being a SQL expert, I need some help. I have a developper who wants
to do an outer-left join on a network set. Let me explain.... We have
record A, and record B, and a set between the twTo: A-B. The developper
needs fields A1 & A2 from A, and B1 from B for all records in the set
A-B. However, he also wants A1 & A2 from A for thoses A that don't have
any members in A-B. All in the same query.

Is there a way to do this?

TIA,
Laura Rochon
Ajilon Consulting
on contract at CAE inc.
Laura,

I had something similar once where record A had a short name and B had a ""full"" name.

My SQL looked something like this:

SELECT A1, A2, B1
FROM A, B
WHERE ""A-B"" PRESERVE A

What I got was <null> for B1 if there was no B record. Hope this helps. The only other way I usually do this is via a table procedure but that is a lot more involved.


Joe S Cates, C.C.P.
Database Analyst
Office of Global Access Technology
Montgomery County Public Schools
Rockville, MD 20850
email: Joe_Cates@fc.mcps.k12.md.us

"
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 question
"You can use the PRESERVE command:

select A1, A2, B1
from A, B
where ""setA-B""
preserve A;

But be careful with this. The optimizer often forces area sweeps when
you use PRESERVE. (This may only be true when you preserve B.)
Also, you will get nulls for field B1 when there are no members.

Outcomes