ca.portal.admin

Re:Re: Multiple DBL4 jobs

Discussion created by ca.portal.admin on Jun 20, 2007
Mike,

No, you won't see that multiple executions of DBL4 are possible because
nobody ever thought to write it down. But if you read what DBL4 does
(possibly release 5 or 10 documentation) you will find that all it does
is read a file sorted in DBKEY sequence and put values into the pointer
prefixes.

You will find in rel 15 documentation the note that, if DBL4 abends, all
one does is rerun it from DBL4 as long as the input file has been saved.
That is because DBL4 is a simple read/write program. It doesn't know
what it is reading, it just takes the pointer information and puts it
where it is told to. So if one uses the G00V00 option on the DD
statement and restricts the step execution to a single specific reel of
tape, then one can run as many executions of DBL4 simultaneously as one
has reels.

This was not my idea, it was developed by a very skilled senior DBA at
GE who was part of this list the last that I knew. I would share his
name but would rather let him acknowledge it if he wants to. I just
know that it worked the last time that I tried it using rel 15 and can't
think of how it could stop working given the architecture of U/R that I
first used back in 77. I think that it was probably release 3).

One additional comment, 4 years ago I came across a 16 file area nearly
full that couldn't be expanded because some pages were already logically
full but when I analyzed how it was growing, it was nearly sequential in
growth and all I had to do was extend it.

John Wheeler

--- Mike Baker <mikebaker345@HOTMAIL.COM> wrote:
John & Laura,

We are still on R15 SP5, so no luck there. As for multiple DBL4 steps,
this would save some time. However I cannot see any mention in the
manuals that this is even possible (in R15).

NB: Our big Area is in six files, and no more Expand Pages are
possible, so we need to Unload/Reload sometime, increase the number of
files, and reduce the Page size.

Thanks for your feedback; its appreciated. Cheers
________________________________________________________________________
____________
Don't get soaked. Take a quick peak at the forecast with the Yahoo!
Search weather shortcut.
http://tools.search.yahoo.com/shortcuts/#loc_weather
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Cleanup question
"Hi Kay:

From the Utilities Guide:

Logically deleted records: You must remove any logically deleted records
from
the areas being unloaded before executing the REORG utility. To determine if
an area

has logically deleted records, use PRINT SPACE with the FULL option. If
logically

deleted records exist, use the CLEANUP utility to remove them from the area.

Regards,

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








Normal

Normal
Re: Area/Record security.
"Jim,

Turning on journal retrieval just creates BGIN and ENDJ checkpoints on
the journal for retrieval rununits. There are no journal images for
record access. However, for update rununits, your Journal Reporter is
absolutely great!

The most widely used solution for this type of request is really, as
Chris pointed out, using a dbproc tied to all access commands on a
record. The dbproc writes a journal record identifying the type of access.

Laura Rochon
Ajilon Consulting


Jim Phillips wrote:
We can supply a program, at sensible cost, to provide a formatted report of=
changes to the record using the journals. I suppose we could also report o=
n retrieval access to it but turning on retrieval journaling just for this =
is a bit tail-wagging-dog.=20
=20
=20



Date: Thu, 21 Jun 2007 22:23:39 -0400> From: pierra@SPRYNET.COM> Subject:=
Area/Record security.> To: IDMS-L@LISTSERV.IUASSN.COM> > greetings from th=
e perplexed.> > I've got a situation where we need to track access to 1 (an=
d only 1)> record/area (we're a 1 record to 1 area (mainly) shop.)> > We ne=
ed to see all who read/modify/update/store or erase. Batch and online.> > W=
e're a IDMS 16.0 SP1 (No DC and minimal UCF) / CICS shop with DMLO (too> mu=
ch), OLQ, Culprit and a home-grown> data unloader.> > OLQ security is turne=
d on, but Culprit security is not. The sensitive> information in the given =
record is secured by> encryption and de-encryption is handled in a ""special=
"" schema/subschema> combination.> > Any ideas?> > Dick Pierce> Mass Registr=
y of Motor Vehicles> 617-973-8911> > 3 million transactions a day and we ju=
st keep growing.> > While I approve of this message, I'm not running for an=
ything.
_________________________________________________________________
Connect to the next generation of MSN Messenger=A0
http://imagine-msn.com/messenger/launch80/default.aspx?locale=3Den-us&sourc=
e=3Dwlmailtagline=

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








Normal

Normal
Re: Area/Record security.
"We can supply a program, at sensible cost, to provide a formatted report of changes to the record using the journals. I suppose we could also report on retrieval access to it but turning on retrieval journaling just for this is a bit tail-wagging-dog.




Date: Thu, 21 Jun 2007 22:23:39 -0400> From: pierra@SPRYNET.COM> Subject: Area/Record security.> To: IDMS-L@LISTSERV.IUASSN.COM> > greetings from the perplexed.> > I've got a situation where we need to track access to 1 (and only 1)> record/area (we're a 1 record to 1 area (mainly) shop.)> > We need to see all who read/modify/update/store or erase. Batch and online.> > We're a IDMS 16.0 SP1 (No DC and minimal UCF) / CICS shop with DMLO (too> much), OLQ, Culprit and a home-grown> data unloader.> > OLQ security is turned on, but Culprit security is not. The sensitive> information in the given record is secured by> encryption and de-encryption is handled in a ""special"" schema/subschema> combination.> > Any ideas?> > Dick Pierce> Mass Registry of Motor Vehicles> 617-973-8911> > 3 million transactions a day and we just keep growing.> > While I approve of this message, I'm not running for anything.
_________________________________________________________________
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: Logically deleted records
"Hey, Bill!

Don't ya' know beach sand and computers don't mix?? And, if you're really
on vacation, then just why the **** are you even thinking about computers,
much less reading / answering e-mail??!!??

Alan




Jim Criscuolo <JCriscuolo@US.IMSHEALTH.COM>
Sent by: IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM>
06/22/2007 10:06 AM
Please respond to
IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM>


To
IDMS-L@LISTSERV.IUASSN.COM
cc

Subject
Re: [IDMS-L] Logically deleted records





Bill,

You don't have to rub it in that you are on vacation while the rest of
us a stuck in work!!!

Jim

Outcomes