Datacom History Database SPILLOPT

Products

• Datacom
• Datacom/AD
• Datacom/DB

Issue/Introduction

Why are there no rows in my History Database Table when a DBUTLTY SPILL function is run?

The DBUTLTY function SPILL is not be used in relation to History Table because SPILL does not take any action relating to History.

Instead, the DBUTLTY SPILLOPT function must be used to update the SPILL history table by specifying the keyword HISTORY=.

 

Environment

Release:
Component: DB

Resolution

The DBUTLTY function SPILL is not be used in relation to History Table because SPILL does not take any action relating to History.
Instead, the DBUTLTY SPILLOPT function must be used to update the SPILL history table by specifying the keyword HISTORY=.

DB01311I - STATUS                                                               
DB01327I - MULTI-USER AVAILABLE, TASKS - ATTACHED-----2, AVAILABLE----98       0
                                                                                
DB01328I - TIME   I/O  JOBNAME R-UNIT TASK CMD-DBID-TBL    SEQ STATUS          ID
                                                                                
DB01329I -   1:00      ***HISTR        108 UPDAT1007ADS        WAIT ADD LOG RC  
DB01329I -  11:48    2 OBRDEXT  89012    1 UPDAT   2FLD  40802 WAIT E/C DBSSPL  
                                                                                
DB01329I -    :58      OBRDEXT  89014    2 RDULE   2BAS  41143 WAIT E/C         
DB01331I - JOBNAME R-UNIT TASK OWNR/Y VALUE/RID                                 
DB01332I - OBRDEXT  89014    2    1     1-000044EB-00                           

Additional Information

Refer to CA DATACOM CORE 15.1 section "Update SPILL History Table"
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-mainframe-software/database-management/ca-datacom/15-1/reference/dbutlty-reference/utility-function-summary/spillopt-transfer-data-to-rxx-using-max-min.html