RE: DSPJRN very, very slow

John,

My other posts give some size information.

But yes, there are millions of entries in the receiver. (production system has 2.7 million in a
receiver attached about midnight)

I guess I didn't expect that DSPJRN with selection criteria specified would require the journal
equivalent of a "full table scan".

I'm just wondering if there are any tips to searching large journals.

Thanks,

Charles

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of John Earl
Sent: Wednesday, August 15, 2007 11:24 AM
To: Midrange Systems Technical Discussion
Subject: RE: DSPJRN very, very slow

Charles -

Take a look at the *CURRENT journal receiver and see how many
entries are in it. When you do the search you specified, you
are searching the entire journal. It could have millions of
entries (records), so it wouldn't surprise me that it takes a
long time.

jte

--
John Earl, VP and Chief Technology Officer
PowerTech: 253-872-7788
Direct: 253-479-1408
Mobile: 206-669-3336
John.Earl@xxxxxxxxxxxxx




Email is an excellent way to communicate material that is not
time sensitive. If your communication is of a more urgent
nature, please call.

===========================
This email message and any attachments are intended only for
the use of the intended recipient named above and may contain
information that is privileged and confidential. If you are
not the intended recipient, any dissemination, distribution,
or copying is strictly prohibited. If you received this email
message in error, please immediately notify the sender by
replying to this email message or by telephone and delete the
message from your email system. Thank you.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
bounces@xxxxxxxxxxxx] On Behalf Of Wilt, Charles
Sent: Wednesday, August 15, 2007 7:53 AM
To: Midrange Systems Technical Discussion
Subject: DSPJRN very, very slow

All,

In my past life, DSPJRN and Prodata's DBUJRN commands have

been a huge

help on smaller, less busy systems.

Now however, I'm on a bigger, busier system and DSPJRN takes forever

to

return even a "no entries
converted" message when looking for entries in the *CURRENT

receiver,
for

a specific file, from a
specific job.
DSPJRN JRN(HLTHJRN) FILE((FCSTEQP))

JOB(027859/PPFALCON/CVT0000133)

Is this normal?

Is there anything that could be done to speed up the DSPJRN command?

Thanks!

Charles Wilt

Software Engineer

CINTAS Corporation - IT 92B

513.701.1307

wiltc@xxxxxxxxxx <mailto:wiltc@xxxxxxxxxx>



This e-mail transmission contains information that is

intended to be

confidential and privileged. If you receive this e-mail and you are

not a

named addressee you are hereby notified that you are not

authorized to

read, print, retain, copy or disseminate this communication without

the

consent of the sender and that doing so is prohibited and may be

unlawful.

Please reply to the message immediately by informing the sender that

the

message was misdirected. After replying, please delete and

otherwise

erase it and any attachments from your computer system. Your

assistance

in correcting this error is appreciated.
--
This is the Midrange Systems Technical Discussion

(MIDRANGE-L) mailing

list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting,

please take

a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion
(MIDRANGE-L) mailing list To post a message email:
MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting,
please take a moment to review the archives at
http://archive.midrange.com/midrange-l.

This e-mail transmission contains information that is intended to be confidential and privileged. If you receive this e-mail and you are not a named addressee you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this communication without the consent of the sender and that doing so is prohibited and may be unlawful. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please delete and otherwise erase it and any attachments from your computer system. Your assistance in correcting this error is appreciated.