Re: Quiescing the system prior to Save While Active? -- MIDRANGE-L

Quite possibly....

But if you ever need to recover, good luck!

*SYSDFN means every object reaches a checkpoint individually. Thus,
you will probably have saved transactions in progress. Which means if
you want to recover, you'd better have your files journalled and the
receivers saved. Plus you'll need a recovery plan in place that
examines the restored journal receivers to to find the in-progress
transactions and does a APLJRNCHG as needed to bring your files into a
consistent state.

Al Barsa used to call *SYSDFN "the hard way"

*SYNCLIB is the preferred method, the "easy way" as Al called it.. If
you're lucky, the activity level of the system combined with the use
of commitment control on the system will allow you to use *SYNCLIB
without stopping your applications. Otherwise, you'll need to quiesce
the system for a few minutes and allow the save to reach a checkpoint
before restarting the applications. Once the checkpoint has been
reached, only a few operations are prohibited against the objects
being saved, same examples are the CHGPF command or the SQL ALTER
TABLE statement.

Sounds like you probably need the quiesce period. If you can't afford
the 15min downtime the *SYNCLIB method could need, instead of looking
at *SYSDFN, consider a HA solution.

HTH,
Charles

On Tue, Aug 24, 2010 at 10:39 AM, <JDHorn@xxxxxxxxxxxxxx> wrote:

I have never had any luck trying to use SAVACT. Always seems to lock something up or cause programs to crash. Will SAVACT(*sysdfn) solve this?

Jim Horn

message: 5
date: Mon, 23 Aug 2010 16:44:50 -0400
from: "Musselman, Paul" <pmusselman@xxxxxxxxxxxxxxxx>
subject: RE: Quiescing the system prior to Save While Active?

If it doesn't matter if all the files are at a known point, then
quiescing the system isn't necessary-- a SAVLIB SAVACT(*SYSDFN) saves
"Objects in a library... while they are in use by another job. Objects
in a library may reach checkpoints at different times and may not be in
a consistent state in relationship to each other." All objects are
saved, but you may end up with half an order in the order file-- header
records without detail records, for example.

Otherwise, you'll have to examine your system activity and determine
when a 'quiet time' for your application occurs. You can tell all
interactive users to get off the system, and not run any batch jobs
against the library(ies) used by your application, and then do your
save.

If you have PC or Web users, then you need to explore HTTP and WebSphere
and other such applications.

Ending TCP is not a good idea these days-- your system console is most
likely running via TCP (or do you still have Twinax consoles), and
ending TCP may lock yourself out of the system!

Paul E Musselman
IT Technical Support
General Cable Corporation
(859) 572-8030 phone
(859) 760-8030 cell

Jim Horn

____________________________________________________
This email is intended only for the person or entity
to which it is addressed and may contain information
that is privileged, confidential or otherwise protected
from disclosure. If you are not the named addressee
or an employee or agent responsible for delivering
this message to the named addressee, you are not
authorized to read, print, retain copy, and disseminate
this message or any part of it. If you have received this
message in error please notify us immediately by email,
discard any paper copies and delete all electronic files
of this message.
--
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.