× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



One last note,

At 6.1 and higher, the QDFTJRN data area was superseded by the
STRJRNLIB command....

Charles

On Mon, Nov 29, 2010 at 10:26 AM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:
For the archives (in case IBM moves the page :)

1) CL command: SAVLIB SRC ACCPTH(*YES)
Remember the i5/OS container for a schema is a library. The
ACCPTH(*YES) option saves the actual index tree object if any indexes
exist in the schema - that will eliminate indexes having to be rebuilt
on the restore operation.

2) SQL: CREATE SCHEMA TRG
This will create the target schema object with auto-created journal
and system catalog views.
Note: If the journal object was altered away from its default settings
with the CHGJRN CL command or iSeries Navigator. Those customizations
would need to be performed on the journal object in the TRG schema.

3) CL commands:
CRTDTAARA DTAARA(TRG/QDFTJRN) TYPE(*CHAR) LEN(40) VALUE('TRG       QSQJRN    ')
CHGDTAARA DTAARA(TRG/QDFTJRN (21 20)) VALUE('*ALL      *RSTOVRJRN')

The QDFTJRN data area is a special data area that is automatically
processed by the restore command. The restore command consults the
contents of this data area to determine if any special journal
processing has been requested. Without this data area, the restore
command will not perform any journal processing. The result is that
the DB2 objects will no longer be journaled in the new schema since by
default they are still associated with the journal in the original
schema. The *RSTOVRJRN value directs the restore command to journal
the DB2 objects to the specified journal (TRG/QSQJRN) after each
object is restored. Support for the QDFTJRN data area was added in
V5R4 of i5/OS. You can find more details on the QDFTJRN data area in
the iSeries Information Center.

4) CL command: RSTLIB SRC OPTION(*NEW) RSTLIB(TRG)
The *NEW option will only restore the SRC objects that do not already
exist in the TRG schema. This type of restore essentially restores
everything but the objects automatically created by DB2 (journal,
journal receiver, and catalog views). Due to the contents of the
QDFTJRN data area, the DB2 objects are properly journaled after the
restore operation completes.

Note: If logical file or index objects in the schema have been
explicitly journaled by the user, then journaling on those objects
would have to be ended and restarted after the restore with the
ENDJRNAP and STRJRNAP CL commands.

5) Save the newly configured schema to backup media, so that you don't
have to do these configuration steps again!

On Mon, Nov 29, 2010 at 10:04 AM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:
http://www.ibm.com/developerworks/data/library/techarticle/0305milligan/0305milligan.html

HTH,
Charles



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.