Copyright © Cloud Software Group, Inc. All Rights Reserved

S6BBRIAL (Move ACCESSLOG)

S6BBRIAL moves the ACCESSLOG table, which stores the security audit log, from the MetaStor (segment 0) to another segment. The ACCESSLOG table is located in segment 0 when distributed with TIBCO Object Service Broker. If this utility is used, it should be run immediately after archiving or purging all current data, and successfully shutting down the Data Object Broker.

Prerequisites

Before invoking S6BBRIAL, ensure that the following prerequisites are met:

•	Since this utility directly modifies both segment 0 and a target segment, the user invoking it must have write authority to both segments.

•	The JCL execution parameter SEGMENT= indicates a valid Pagestore segment number.

•	A valid ACCESSLOG occurrence exists on segment 0, including an entry in TABLES where TABLES.SEG is not NULL and an RTIX entry where primary path = a segment 0 page number.

•	There is no ACCESSLOG entry on the target segment.

•	There must be no more than one D page of data in the ACCESSLOG table. This data is not retained in the move to the new segment.

•	The ACCESSLOG table is archived or purged.

•	The Data Object Broker is shut down normally.

Invocation

The JCL required to run S6BBRIAL is as follows (where ## is the target segment):

---

 

//MOVLOG EXEC PGM=S6BBRIAL,PARM=’SEGMENT=##’

//DBDLIB DD DISP=SHR,DSN=dbdlib_data_set_name

//AUDIT DD SYSOUT=*

//SYSUDUMP DD SYSOUT=*

---

 

Considerations

Note the following when using S6BBRIAL:

•	The S6BBRIAL utility moves the ACCESSLOG table from segment 0 to a non-zero segment only. ACCESSLOG can be moved only once and after it is moved off segment 0 it cannot be moved again. If possible, move it to its own segment where it can be kept separate from other data.

•	Since this utility updates the segment offline and does not normally perform journaling, you must back up any changes you make to the target segment.

Sample Audit Log

The following illustrates a sample audit log for the S6BBRIAL utility. The audit log must be checked after the run; the message: S6BBC915I ACCESSLOG INSTALLATION COMPLETE indicates success:

---

 

S6BBRIAL INSTALL ACCESSLOG DATE 2009 APR 09 TIME 07:41 V520E049

INSTALLING ACCESSLOG ON SEGMENT #: 99

S6BBC910I SEARCH METASTOR FOR ACCESSLOG

S6BBC911I CHECKING METASTOR POINTERS

S6BBC912I INSTALLATION COMMENCED - TARGET SEGMENT

S6BBC913I INSTALLATION COMPLETED - TARGET SEGMENT

S6BBC914I MODIFYING METASTOR POINTERS

S6BBC915I ACCESSLOG INSTALLATION COMPLETE

---

 

See Also

TIBCO Object Service Broker for z/OS Installing and Operating for information about setting up the ACCESSLOG table.

TIBCO Object Service Broker Managing Security about purging the ACCESSLOG (audit log) table.

TIBCO Object Service Broker for z/OS Managing Backup and Recovery for information about backing up a segment.

Copyright © Cloud Software Group, Inc. All Rights Reserved