RE: journalling question

["McCallion, Martin" <MccalliM@xxxxxxxxxxxxxxxx>]

> I have created a file using DDS.
> By default  the DSPFFD of that file say s  'journelled as NO'
> I want to make the journelled 'YES'
> How?

You need to start journalling using the start journal physical file
command: STRJRNPF.  Before doing that, though, you'll have to create a
journal receiver (CRTJRNRCV) and a journal (CRTJRN) -- in that order;
the receiver needs to exist for you to create the journal.

I think SQL handles all this for you under the covers.

You should also have  a journal receiver management strategy in place
before you start doing this, for which I would refer you to the manuals:
Backup and Recovery (SC41-5304-02); DB2 for AS/400 programming
(SC41-5701-02) and probably others.  Those are V4R3 book numbers.

Oh yes: you'll probably also want to think about using commitment
control in you application.

Regards,

Martin.
--                                                                     
Martin McCallion                 
Midas-Kapiti International
Work:  mccallim@midas-kapiti.com
Home: martin.mccallion@ukonline.co.uk

Company policy says:
This email message is intended for the named recipient only.  It may be
privileged and/or confidential.  If you are not the intended named
recipient of this email then you should not copy it or use it for any
purpose, nor disclose its contents to any other person.  You should
contact Midas-Kapiti International as shown below so that we can take
appropriate action at no cost to yourself.

Midas-Kapiti International Ltd, 1 St George's Road, Wimbledon, London,
SW19 4DR, UK
Email: Postmaster@midas-kapiti.com Tel: +44 (0)208 879 1188 Fax: +44
(0)208 947 3373
Midas-Kapiti International Ltd is registered in England and Wales under
company no. 971479

.:. 
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@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
+---