Re: ACP Journalling of a non-keyed PF

//--- forwarded letter -------------------------------------------------------
> X-Mailer: Forte Agent 1.5/32.451
> Date: Wed, 11 Feb 98 15:28:41 -0500
> From: ghutchinson@tntoverland.com
> To: MIDRANGE-L@midrange.com
> Reply-To: MIDRANGE-L@midrange.com
> Subject: ACP Journalling of a non-keyed PF

> 
> Is it not redundant to journal the access path of a non-keyed
> (journaled) physical file?
> 
> What might the recovery ramifications be of not journalling such an
> access path.
> 
> Gord
> 
> -- 
> Gord Hutchinson
> TST Overland Express
> ghutchinson@tntoverland.com

Hello Gord,

The Backup and Recovery Guide answers your question.  

quote"
   If you choose to journal an access path, remember the following:

      You can journal an access path for a physical file only if the
       physical file has a keyed access path or an index created by a
       referential constraint.
"endquote

I'd say IBM thought it was redundant too!

Regards,
Simon Coulter.

//----------------------------------------------------------
// FlyByNight Software         AS/400 Technical Specialists
// Phone: +61 3 9419 0175      Mobile: +61 3 0411 091 400
// Fax:   +61 3 9419 0175      E-mail: shc@flybynight.com.au
// 
// Windoze should not be open at Warp speed.
 

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---