An Admin Subscription is a set of specifications to be applied to the auditing of administrative data. These include (but are not limited to):
The “Admin Subscriptions” are two predefined entries, using the reserved name/id of ADMIN/SUBSYS1 and DDL/SUBSYS2. These are used for monitoring administrative changes and Adabas structural changes made by SYSAOS.
The user must complete the entries, defining destinations and files to each of the entries. The user cannot delete these subscriptions, copy these subscriptions, or add new subscriptions to this ‘Admin Subscriptions’ list.
Admin Subscription definitions identify subscription file definitions that should be used. At least one subscription file definition is required.
This section describes the following topics:
To use the Adabas Auditing Configuration to list the predefined
Admin Subscription definitions stored in the Auditing system file, complete the
following step:
Select option T from the Adabas Auditing Configuration Main Menu.
The Available Admin Subscriptions screen appears showing all Admin Subscription definitions in the Adabas Auditing Configuration.
16:44:04 ***** A D A B A S AUDITING CONFIGURATION ***** 2021-08-03
Available Admin Subscriptions M-RP1600
Incomplete Sel NAME ID Description
-------------- --- -------------------------------- -------- --------------
_ ADMIN SUBSYS1 ADMINISTRATION
-----> C _ DDL SUBSYS2 STRUCTUAL CHAN
Command ==>
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Repos Exit ID - + Menu
The following tables describe the options on this menu.
| Sel | Allows you to: |
|---|---|
| M/E/S | Modify an Admin Subscription definition |
| PF1 | Get screen help |
| PF2 | Reposition to a specific Admin Subscription definition in the list |
| PF3 | Exit this screen and return to the previous screen |
| PF6 | Toggle between the sorting of Admin Subscriptions by ID or Name |
| PF12 | Exit this screen and return to the main menu |
To use the Adabas Auditing Configuration to complete an Admin Subscription definition to the Auditing system file, complete the following steps:
Step 1. Access the Admin Subscription Definition Area of the Adabas Auditing Configuration
Step 2. Add Destination(s) to the Admin Subscription Definition
Step 3. Add Source Files and related parameters to the Admin Subscription Definition
To access the Admin Subscription Definition area of the Adabas
Auditing Configuration, complete the following step:
Select T from the Adabas Auditing Configuration main menu to list the Admin Subscription definitions, as described above in Listing Admin Subscription Definitions . Refer to that section to see the map that is displayed. Select one of the two predefined Admin Subscriptions for modifications.
The Admin Subscription Definition screen appears.
15:18:43 ***** A D A B A S AUDITING CONFIGURATION ***** 2021-08-04
Admin Subscription Definition M-RP1610
Subscription ID ............... ADMIN___________________________
Subscription Name ............. SUBSYS1_ Current
Description ................... ADMINISTRATION__________________
Destination Name List ......... _ +
File-related Parameters ....... _ +
Subscription Active ........... Y
Command ==>
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Exit Save Menu
To add one or more Destinations to the Admin Subscription
definition:
On the Admin Subscription Definition screen for the Admin Subscription being added mark the Destination ID List field with any character (e.g. “S”).
The Destination List screen appears with the Admin Subscription ID listed at the top of the screen.
15:52:48 ***** A D A B A S AUDITING CONFIGURATION ***** 2021-08-04
Destination List M-RP1640
Current
Admin Subscr ID .... SUBSYS1 Description ... ADMINISTRATION
Admin Subscr Name .. ADMIN
ID ID ID ID ID
-------- -------- -------- -------- --------
AUDIT1__ ________ ________ ________ ________
________ ________ ________ ________ ________
________ ________ ________ ________ ________
________ ________ ________ ________ ________
________ ________ ________ ________ ________
________ ________ ________ ________ ________
________ ________ ________ ________ ________
________ ________ ________ ________ ________
________ ________ ________ ________ ________
________ ________ ________ ________ ________
Command ==>
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Exit Save Sel Menu
Type the required Destination ID (if you know it) into the list, and press PF5 to save.
Alternatively, you can press PF6 which will display the following pop-up screen which lists all the available Destinations:
18:12:22 ***** A D A B A S AUDITING CONFIGURATION ***** 2021-01-12
Available Destinations M-RP1201
Sel ID Typ Sel ID Typ Sel ID Typ Sel ID Typ
----------------- ----------------- ----------------- ----------------
_ AUDIT1 AUD
_ AUDIT2 AUD
_ DESTXYZ AUD
_ INPL1 NUL
_ INPL2 AUD
_ NULL1 NUL
_ NULL2 NUL
_ TESTDAY1 AUD
_ TESTNUL2 NUL
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11—PF12
Exit Accpt - +
Choose the required Destination by selecting it with an “S” and press PF5 to accept it.
The selected Destination is added to the Admin Subscription definition.
For the ADMIN/SUBSYS1 Admin Subscriptions Definition, the parameters to be added or modified are related only to a specified DBID.
For the DDL/SUBSYS2 Admin Subscriptions Definition, the parameters to be added or modified are related to a specified DBID AND a specified FILE
To add/modify the parameters of the ADMIN/SUBSYS1 Admin
Subscription Definition
On the Admin Subscription Definition screen of ADMIN/SUBSYS1, mark the DBID-related Parameters field with any character (e.g. “S”).
The 'List of Subscription DBIDs' screen appears with the Subscription ID listed at the top of the screen.
19:12:47 ***** A D A B A S AUDITING CONFIGURATION ***** 2021-09-14
List of Admin Subscription DBIDs M-RP1615
Subscription ID SUBSYS1 Current
Subscription Name ADMIN
send Data send Client
Sel DBID Admin Admin
-----------------------------------------------------------------------------
_ 1958 Y Y
Command ==>
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--
Help Exit Add - + Menu
Press PF4 to add a new Admin Subscription DBID entry.
The DBID-Related Parameters screen appears, either by pressing PF4 (when adding an entry) or by selecting an entry (when modifying an existing entry).
19:13:01 ***** A D A B A S AUDITING CONFIGURATION ***** 2021-09-14
Admin DBid-Related Parameters M-RP1620
Subscription Name ..... ADMIN
Subscription ID ....... SUBSYS1 Current
Description ........... ADMINISTRATION
DBID .................. _1958
Buffers Data Client
Admin cmds ... Y Y
Command ==>
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Exit Save Sel Menu
Press PF5 to save the parameters to the Admin Subscription definition.
To add/modify parameters of the DDL/SUBSYS2 Admin Subscription
Definition
On the Admin Subscription Definition screen of DDL/SUBSYS2, mark the File-related Parameters field with any character (e.g. “S”).
The List of Subscription SFILEs screen appears with the Subscription ID listed at the top of the screen.
19:13:26 ***** A D A B A S AUDITING CONFIGURATION ***** 2021-09-14
List of Admin Subscription SFILEs M-RP1616
Subscription ID SUBSYS2 Current
Subscription Name DDL
send Data send Client
Sel DBID File DDL DDL
-----------------------------------------------------------------------------
_ 1958 1 Y Y
Command ==>
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Exit Add - + Menu
Press PF4 to add a new Admin Subscription SFILE entry.
The File-Related Parameters screen appears, either by pressing PF4 (when adding an entry) or by selecting an entry (when modifying an existing entry).
19:13:40 ***** A D A B A S AUDITING CONFIGURATION ***** 2021-09-14
Admin File-Related Parameters M-RP1621
Subscription Name ..... DDL
Subscription ID ....... SUBSYS2 Current
Description ........... STRUCTURAL CHANGES TO DATABASE
DBID / File Number .... _1958 ___1
Buffers Data Client
DDL cmd ...... Y Y
Command ==>
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Exit Save Sel Menu
Press PF5 to save the parameters to the Admin Subscription definition.
The File- and DBID-related parameter field names are described in the following table:
| Field Name | Description | Default |
|---|---|---|
| Subscription Name | The previously entered name of the current Admin Subscription. | None |
| Subscription ID | The previously entered ID of the current Admin Subscription. | None |
| Description | The previously entered description of the current Admin Subscription. | none |
| DBID | Specify the DBid and the file number for which you want to have Auditing information extracted. | none |
| File Number | Specify the file number for which you want to have Auditing information extracted. | none |
| Data Buffer | Set indicators of “Y”, or “N” if you desire the buffer to be sent for Select, Insert, Update, or Delete commands. | Y |
| Client Buffer (Clnt) | For this release, not available for choice. | Y |
Notes:
To save the Admin Subscription definition:
Press PF5 to save the Admin Subscription definition in the Auditing system file.