Datacom History Database SPILLOPT
Article ID: 49477
Updated On:
Products
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
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
Attachments
Feedback
