Dynamically changing the values of the LOGSPILL MUF start-up option

Products

• Datacom/AD
• Datacom
• Datacom/DB
• DATACOM - AD

Issue/Introduction

Is there any way to change the percent full values set in the LOGSPILL MUF start-up option, without recycling the MUF region?

Environment

Release : 15.1

Product: Datacom

Resolution

As it can be read on the "LOGSPILL" section of the Datacom documentation, it is possible:

Use the LOGSPILL_x console commands to change the values of this MUF startup option, where x can be A, B, C, D, or E.

Additional Information

If, for example, if you want to change the LXX percent full value at which Datacom/DB starts issuing console messages stating that the Log Area is becoming full (i.e. the first value of the LOGSPILL Startup Option) to 50, you can use the command "LOGSPILL_A 50".

This command can be issued via a MVS MODIFY command: /F mufjobname,LOGSPILL_A 50

Or you can use a DBUTLTY job with the following card:

//SYSIN     DD  *
  COMM OPTION=CONSOLE,OPTION2='LOGSPILL_A 50'
/*  

In both the cases, you can find confirmation messages on the MUF JESMSGLG.

After a MVS MODIFY command:

DB01311I - LOGSPILL_A 50                  
DB01325I - CONSOLE COMPLETE, LOGSPILL_A 50

After a DBUTLTY OPTION=CONSOLE job:

DB00608I - DBUTLTY COMM CONSOLE COMPLETE - LOGSPILL_A 50 job-name run-unit job-ID-step-number user-id 

 

You can run an SQL query via DBSQLPR to confirm that the value has been correctly changed:

//STEP1    EXEC PGM=DBSQLPR,REGION=0K,PARM='OPTFILE=OPTFILE'
//STEPLIB  DD ... (copy the libraries names from the MUF JCL)
//STDOUT   DD  SYSOUT=*                                        
//STDERR   DD  SYSOUT=*                                        
//SYSPRINT DD  SYSOUT=*                                        
//SYSUDUMP DD  SYSOUT=*                                        
//OPTFILE  DD  *                                               
AUTHID=SYSADM                                                  
ROWLIMIT=999999                                                
MSG=NN                                                         
NOTYPE                                                         
//SYSIN    DD  *                                               
SELECT LOGSPILL_A                                              
       FROM MUF_OPTIONS;                                       
/*                                                             

which should return:

INPUT STATEMENT:           
SELECT LOGSPILL_A          
       FROM MUF_OPTIONS;   
                           
LOGSPILL_A                 
__________                 
        50                 
___ 1 row returned ___      

Please remember that if you want to permanently change the percent value, then the LOGSPILL MUF startup card must be changed too, as the console command remains in effect only till the next MUF recycle.