Journal DB Operations

A permanent license key is required in order to use this option.

To work with file operations, select 15. Collect READs by DB Triggers from the Applications, BizAlerts-Definitions screen (STRJR > 11). The Work with File Operations screen appears.

​                          ​ Work with File Operations​                                                                                                              ​ Type options, press Enter.               ​   ​ Position to . . .​           ​         ​ 1=Modify​   ​ 4=Remove​  ​ 6=Activate​ ​ 7=Temporary disable​  ​ 8=Deactivate​                                   ​ Journal  ​                                             ​ Opt​ File   ​   ​ Library​   ​ R D I U​                                               ​ ​  ​ ​ DEMOPF50  ​ VICTOR    ​ A​  ​  ​ A​                                                ​  ​ ​ DEMOPF    ​ VICTOR    ​ A​ B​ B​ B​                                                ​  ​ ​ DEMOPFY   ​ SMZ1DTA   ​  ​  ​  ​ B​                                                ​  ​ ​ DEMOPF13  ​ VICTOR    ​ A​ B​  ​  ​                                                ​  ​ ​ DEMOPF50  ​ VICTOR    ​ A​ B​ B​ B​                                                ​  ​ ​ DEMOPF50  ​ VICTOR    ​ A​  ​  ​  ​                                                ​  ​ ​ DEMOPF50  ​ VICTOR    ​ A​  ​  ​  ​                                                                                                                                                                                                                                                                                                                                                                    ​       Bottom​  ​ This option is based on DB Triggers. You are recommended to use the Filter   ​   ​ option that the product enables, to minimize any possible performance impact.​                                                                                    ​ R=Read, I=Insert, D=Delete, U=Update. A=After, B=Before.​  ​ =Enabled​  ​ =Disabled ​ F3=Exit    F6=Add New    F12=Cancel                                ​             ​                                                                                                                                                                  ​

The activation status of file operations is indicated by the color of the journal definitions on the screen:

• White text on a black background: File operations are activated.

• Black text on a white background: File operations are not activated.

• Pink text: File operations are temporarily disabled.

To add a new file or to modify an existing one, press F6 or type 1 in the Opt field as appropriate. The Add File Operations / Modify File Operation screen appears.

​                          ​ Modify File Operations​                                                                                                                 ​ Type choices, press Enter.                                                    ​                                                                                   ​ File  .  . . . . . . . . .​ ​ DEMOPF50  ​  ​ Name          ​                         ​   Library  . . . . . . . .​ ​ VICTOR    ​  ​ Name             ​                      ​ Description  . . . . . . .​ ​ test triger encryption                            ​  ​ Time to write to journal​   ​ Journal name is the *CURRENT/*LAST journal used.  ​  ​ for READ . . . . . . . . .​ ​ A​                      ​ A=After​                     ​ for DELETE . . . . . . . .​ ​ B​                      ​ B=Before​                    ​ for INSERT . . . . . . . .​ ​ B​                      ​ B=Before, A=After​           ​ for UPDATE . . . . . . . .​ ​ B​                      ​ B=Before, A=After​           ​ If file is journaled, use READ only, or you will have duplicate entries.​        ​ Operation        ​                                                               ​ Write images to journal  .​ ​ B​                      ​ B=*BOTH, A=*AFTER, N=*NONE​  ​ Add Pgm info . . . . . . .​ ​ N​                      ​ Y=Yes, N=No​                 ​ Use filter . . . . . . . .​ ​ N​                      ​ Y=Yes, N=No​                 ​ User decision program  . .​ ​ *NONE     ​             ​ Name, *NONE          ​       ​   Library  . . . . . . . .​ ​           ​             ​ Name                 ​       ​ This is a user alert and filter program. See SMZJ/JRSOURCE JRTRGFLR.       ​                                                                                      ​ F3=Exit​                ​ F5=Display journal name  ​   ​ F12=Cancel​                 ​                                                                                                                                                                  ​

File/Library

Define the file and library that you want to add/modify.

Description

You can add a meaningful description for this file.

Time to write to journal

For each of the options, you can write A = After Image or B = Before image.

Operation

Write images to journal. The benefit of the READ feature is that most companies want to know when records have been accessed (read), as that too is a security breach. Supporting READ uses "trigger" technology, not IBM journal receivers, which makes this product unique. AP-Journal keeps the information about READs in IBM's journal receivers together with the regular information stored there, so the processing from that point on is the same. Filter can be based upon READs as well. B =*BOTH A =*AFTER N =*NONE

Add Pgm info. Pgm Info is written to the journal

Use filter. Specify Y = Yes if you want to add filters or N= No. In case you select Y, the Filter Conditions screen appears.

User decision program. You can add a program and library for additional calculations.

Type choices and press Enter.