RE: DSPJRN very, very slow

receiver:
Size (K) . . . . . . . : 55275140
Status . . . . . . . . . . . . . . . . . . . . . . : ATTACHED
Number of entries . . . . . . . . . . . . . . . . . : 214563314
Attach date . . . . . : 03/20/07 Attach time . . . . . : 10:35:45

This is on a QA system, so it's not surprising that the receiver has been attached for a while.
I'll see if I can get operations to attached a new receiver.


But even on production, DSPJRN is slower than what I'm used too. That receiver gets changed every
day.

Thanks,
Charles

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

How big is the journal? Is it user or system managed. Some
people set then at user managed then never detach / create
new receivers.

Chris Bipes
Director of Information Services
CrossCheck, Inc.
-----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?

--
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.