Common 2010 IMG REP/400

Common 2010

IM

G

REP/400

IMG Consulting s r.o.

Michal Kudrna

i5OS Journals Working and

Experience

IM

G

REP/400

Beginnings – that brought us ?

- 2002 – backups in terms LPARs V5R1M0

- 2006 - data replication - version 1 licence program - Own disaster recovery solution

- Primary fully employ system functionality i5OS - Solution fully under our SW control

- Open solution - Easy solution

- Integration reporting changes in user friendly format - Custom expansion – users program

- Moving applications to backup system - Break with original applications

- One pack - clear price

- independence of operating system version - Performance optimisation

IM

G

REP/400

Journals Type – files, DTAQ , DTAARA

- CRTJRNRCV/DLTJRNRCV Create/Delete Journal Receiver

threshold value (min 10 MB)

- CRTJRN/DLTJRN Create/Delete Journal

Manage Receivers(*SYSTEM *USER) Delete Receivers(*YES *NO)

Receiver size option(*RMVINTENT *MINFIXLEN *MAXOPT1 *MAXOPT2 *MAXOPT3) Fixed length data(*PGM *PGMLIB *SYSSEQ *RMTADR *THD *LUW *XID)

- STRJRNPF/ENDJRNAP Start/End Journal Physical File

- STRJRNAP/ENDJRNAP Start/End Journal Access Path

- STRJRNOBJ/ENDJRNOBJ Start Journal Object *DTAARA *DTAQ - STRJRNLIB/ENDJRNLIB Start Journal Library (V6R1)

IM

G

REP/400

Journals Type – Audit

- CRTJRNRCV/DLTJRNRCV Create/Delete Journal Receiver

threshold value (min 10 MB)

- CRTJRN QSYS/QAUDJRN Create Journal

Work With System Values

- QAUDCTL Auditing control (*OBJAUD *AUDLVL *NOQTEMP)

- QAUDENDACN Auditing end action (*NOTIFY *PWRDWNSYS) - QAUDFRCLVL Force auditing data (*SYS 1-100)

- QAUDLVL Security auditing level (*CREATE *DELETE

*OBJMGT *PGMADP *JOBDTA *SECCFG … )

- QAUDLVL2 Security auditing level extension - QCRTOBJAUD Create object auditing

IM

G

REP/400

Journals Type – IFS

- STRJRN/ENDJRN Start/End Journal

Objects type (*STMF *DIR *SYMLNK *DTAARA *DTAQ)

Directory subtree (*ALL *NONE) New objects inherit journaling(*YES *NO)

Images(*AFTER, *BOTH) Omit journal entry(*OPNCLOSYN *NONE)

IM

G

REP/400

Remote Journals

- WRKRDBDIRE Work with Relational Database

Directory Entries

- ADDRMTJRN/RMVRMTJRN Add/Remove Remote Journal

Relational database Source journal/Target journal Remote receiver library Remote journal type (*TYPE1 *TYPE2) Delete receivers (*YES *NO)

- CHGRMTJRN Change Remote Journal

Relational database Source journal/Target journal Journal state (*ACTIVE *INACTIVE) Delivery (*ASYNC *SYNC) Sending task priority (1-99 *SYSDFT )

IM

G

REP/400

Journals Commands

- WRKJRN Work with Journals

- WRKJRNA Work with Journal Attributes - DSPJRN Display Journal

- DSPAUDJRNE Display Audit Journal Entries - SNDJRNE Send Journal Entry

- WRKJRNRCV Work with Journal Receivers - RCVJRNE Receive Journal Entry

- RTVJRNE Retrieve Journal Entry (CLP) - APYJRNCHG Apply Journaled Changes

- APYJRNCHGX Apply Journaled Changes Extend - CHGJRN Change Journal

IM

G

REP/400

Journal Codes

Library Entry Y

User-Generated Entry (QJOSJRNE) API U

Audit Trail Entry T

Distributed Mail Services S

Operation on Specific Record R

Data Queue Operation Q

Performance Tuning Entry P

Network Management Data M

License Management L

Journal or Receiver Operation J

Internal Operation I

Database File Member Operation F

Data Area Operation E

Database File Operation D

Commitment Control Operation C

Integrated File System B

System Accounting Entry A

IM

G

REP/400

Journals API - Service Program QJOURNAL

- QjoAddRemoteJournal Add Remote Journal

- QjoChangeJournalState Change Journal State

- QjoRemoveRemoteJournal Remove Remote Journal

- QjoRetrieveJournalInformation Retrieve Journal

Information

- QjoRtvJrnReceiverInformation Retrieve Journal

Receiver Information

- QjoRetrieveJournalEntries Retrieve Journal Entries

- QjoDeletePointerHandle Delete Pointer Handle

- QjoStartJournal Start Journal

- QjoEndJournal End Journal

- QjoReplayJournalEntry (V6R1) Replay Journal Entry

Create data area E/EE

Formats :

- RJNE0100 Format IMG REP/400 version 1 - RJNE0200 Format (=> V5R2) IMG REP/400 version 2

Pointers can be used only with the V4R4M0 or later versions of the following languages:

- ILE COBOL - ILE RPG

- ILE C if the TERASPACE

Journal code R or F of tables or database files that include any fields of data type BLOB

(binary large object), CLOB (character large

object), or DBCLOB (double-byte character large object)

IM

G

REP/400

Journal Code R

Example Entry Types :

- DL Record deleted in the physical file member - PT Record added to a physical file member

- PX Record added directly by relative record

number

- UB Before-image of a record that is updated in

the physical file member

- UP After-image of a record that is updated in

the physical file member

IM

G

REP/400

- QUSCRTUS Create User Space - QUSDLTUS Delete User Space

- QUSPTRUS Retrieve Pointer to User Space - QUSLRCD List Record Formats

- QUSLMBR List Database File Members - QUSRMBRD Retrieve Member Description - QDBLDBR List Database Relations

- QUSLFLD List Fields

- QDBRTVFD Retrieve Database File Description

FFILE UF A F32766 2000AIDISK ExtFile(QualFile)

F UsrOpn ExtMbr(QualMbr)

IM

G

REP/400

Journal Code E

Example Entry Types :

- EB Update data area, before image - EA Update data area, after image - ED Data area deleted

- EE Create data area (V6R1M0)

- EK Change journaled object attribute - EL Data area restored

- EM Data area moved

- EQ Data area changes applied - ZA Change authority

- ZB Change object attribute - ZO Ownership change

IM

G

REP/400

- QUSLOBJ List Objects

- QusMaterialize Context Materialize Context - QLIRNMO Rename Object

- QUSROBJD Retrieve Object Description - QLICVTTP Convert Type

- QLICOBJD Change Object Description - QGYOLOBJ Open List of Objects

IM

G

REP/400

Journal Code Q

Example Entry Types :

- QA Create data queue (V6R1M0) - QC Data queue cleared, no key - QD Data queue deleted

- QG Data queue attributes changed (V6R1M0) - QH Data queue changes applied

- QJ Data queue cleared, has key - QK Send data queue entry, has key - QL Receive data queue entry, has key - QM Data queue moved

- QN Data queue renamed

- QR Receive data queue entry, no key - QS Send data queue entry, no key - QZ Data queue restored

- ZA Change authority

- ZB Change object attribute

IM

G

REP/400

- QCLRDTAQ Clear Data Queue - QRCVDTAQ Receive Data Queue

- QMHQRDQD Retrieve Data Queue Description - QMHRDQM Retrieve Data Queue Message

- QSNDDTAQ Send Data Queue

IMG REP/400

IM

G

REP/400

Replay Database Operation - QDBRPLAY API

Change Trigger TG D Remove Trigger TD D Add Trigger TC D Revoke File RV D Reorganize Member RM F Rename Member MN F Add Member MC F Grant File GT D Change Owner GO D Change Constraint GC D Rename File FN D Move File FM D Delete File DT D Remove Member DM F Remove Constraint DC D Create File CT D Change File CG D Change Member CB F Add Constraint AC D Description Entry Type Journal Code

Journal Code T

Example Entry Types :

-

CO

Create object

-

CA

Changes to object authority

-

CP

Create, change, restore user profiles

-

DO

All delete operations on the system

-

OM

Object management change

-

OR

Object restored

-

ZC

A change was made to object change

access

IM

G

REP/400

Journal Code B

Example Entry Types : - B1 Create summary

- B2 Link to existing object - B3 Rename, move object

- B4 Remove link (parent directory) - B5 Remove link (link)

- B7 Created object authority information.

- FA Integrated file system object attribute

changed

- FR Integrated file system object restored - OA Change object authority

- OO Change object owner

- RN Rename file identifier - WA Write, after-image

IM

G

REP/400

- QP0LLIB1 - Service Program

- readdir() - Read Directory Entry

- readlink() - Read Value of Symbolic Link

- rewinddir()- Reset Directory Stream to Beginning - symlink() - Make Symbolic Link

- unlink() - Remove Link to File

- Qp0lGetPathFromFileID() -Get Path Name of Object

from Its File ID

- Qp0lRenameKeep() - Rename File or Directory,

Keep "new" If It Exists

- Qp0lRenameUnlink() - Rename File or Directory,

Unlink "new" If It Existsmemset()

- #pragma datamodel (p128) 128bit pointers - memcpy()

- TS_malloc()

IM

G

REP/400

Common 2010

IM

G

REP/400

IMG Consulting s r.o.

Michal Kudrna

Product presentation

IMG REP/400

IM

G

REP/400

Product IMG REP/400

- Hot - backup replication and save

- Build on system remote journaling instruments - Free of DB2 iSeries application

- Change proceed on record level - Replication usage for reporting - 365x7x24 non-stop process

- Backup to remote localities - Actual test environment

- DB reporting of changes in databases - Replication up to 256 localities

- Big monitoring OF exceptions and error handling - Object replication include change description - IFS replication include description

IM

G

REP/400

Scheme DB2 Data and IFS Replication

Primary system HOT BACKUP Data Library Journal Data Library Remote Journal Aplication REP/400 Data Library Data Library Directory Directory Directory Directory Remote journal Journal Remote Journal Application REP/400

IM

G

REP/400

Scheme Audit Object and IFS Replication

Primary system HOT BACKUP Audit Journal Remote Journal Application REP/400 Backup mode Application REP/400 Primary mode Remote journal Distribution QUEUE Data QUEUE REPORTING DB

IM

G

REP/400

Scheme Data, Object and IFS Replication – locally

Libraries from Journal Libraries to Application REP/400 Directories from Directories to Application REP/400 Audit Journal

IM

G

REP/400

Product IMG REP/400

- Performance balance flexibility – process application

out from primary system

- Remove read-only applications from primary system to

backup system

- Online backup (no user access limits on primary

system)

- Hold replication possibility

- Fast access data in case of primary system down, Fast

refresh actual data

- Reporting of changes to Log database with possibility

of user print based on primary system

- Reporting takes CPU from backup system

- Multiple instances proceed parallel

- Usage REP/400 result data as base for any other

applications

- Object replication include change object description

IM

G

REP/400

Product IMG REP/400 - Terms

- TOOL IMG REP/400 – terms

- One program instance replicates data from one or more

data libraries using one journal to second data libraries

- Unique keys for replicated database advantage

- REP/400 generates fully keyed files, if there are no

such keys possible on the system

- Minimum OS/400 V5R2M0

- TCP/IP connection

- Free of DB2 iSeries application software

- Multiple instances for more data library

- Object replication work over audit journal accordance

with enabled objects

- IFS replication work over enabled directory and file

IM

G

REP/400

Product IMG REP/400 - Service

- Software installation

- Maintenance – new versions included

- Disaster recovery, support for primary system with

using backup system

- Training

- Transfer applications to backup system (query, print

layouts…)

- Possibility of build Test environment online from

Production primary system usage replication data

- Locality replication possibility

- Local replication (copy database)

- User changes, upgrades

- Transfer application to 24x365 accessibility

IM

G

REP/400

Produkt IMG REP/400 - Licencování

- Primary and backup systems (iSeries processor

number)

- Licence accordance with maximal primary or

backup system class

- Possibility of multi licence - Maintenance

- Disaster recovery hotline 24 hours system

online after replacement primary HW

- Support during application process

- Base licence for two system primary and backup - Licence include data, object and IFS

replication without restriction on primary and backup systems

IM

G

REP/400

IM

G

REP/400

Product IMG REP/400 – Work with Instances - WRKINST

IM

G

REP/400

Product IMG REP/400 – Work with Instances - WRKINST

IM

G

REP/400

IM

G

REP/400

IM

G

REP/400

IM

G

REP/400

Product IMG REP/400 –

IM

G

REP/400

Product IMG REP/400 – WRKINST

IM

G

REP/400

Product IMG REP/400 – WRKINST Option 7 Display Log

IM

G

REP/400

Product IMG REP/400 – WRKINST

IM

G

REP/400

Product IMG REP/400 –

IM

G

REP/400

Product IMG REP/400 – Display File/Members Option 1

IM

G

REP/400

Product IMG REP/400 – Display Nickfield - Field Join

IM

G

REP/400

Product IMG REP/400 – Subsystem RCVRMTJRN - Jobs

IM

G

REP/400

Product IMG REP/400 – Reporting Command JRNREP