DBUTLTY DATASCAN vs RETIX KEYNAME=*SETR for CA Datacom
Article ID: 215434
Updated On:
Products
Issue/Introduction
Datacom version 15.1 provides several enhancements, including a new DBUTLTY function called DATASCAN.
One of the DATASCAN options is
DATASCAN OPTION=COUNT_SET_RECORDS
This option is an alternative to RETIX KEYNAME=*SETR. However, note that options currently documented continue to be supported.
Environment
Release : 15.1
Component : CA Datacom/AD
Component : CA Datacom/DB
Resolution
If you previously used the DBUTLTY function
RETIX KEYNAME=*SETR,DBID=dbid,...,
you can now use the new feature available in Version 15.1:
DATASCAN OPTION=COUNT_SET_RECORDS,DBID=dbid,...
This function is described in the documentation:
Any MUF abend can result in lost of current data row counts if MUF fails without clean error handling such as a System failure requiring an IPL.
The count of records in a table, as known to the CXX, can become wrong if the MUF is restarted after a MUF outage occurs. This function is used to recount the records and set the new value in MUF.
When running this function, the output is very simple. Here is an example using DBID 252:
Date: 5/19/2021 ******************************************************************************** Page: 8
* CA Datacom/DB *
Time: 11.38.32 * General Utility * Version: 15.1
* COPYRIGHT (C) 1990-2015 CA. ALL RIGHTS RESERVED. *
******************************************************************************** Directory: MY15MUF
CONTROL CARD(S)
.........1.........2.........3.........4.........5.........6.........7.........8
DATASCAN DBID=252,OPTION=COUNT_SET_RECORDS
FUNCTION=DATASCAN
DBID=00252
OPTION=COUNT_SET_RECORDS
Date: 5/19/2021 ******************************************************************************** Page: 9
* CA Datacom/DB *
Time: 11.38.33 * General Utility * Version: 15.1
* COPYRIGHT (C) 1990-2015 CA. ALL RIGHTS RESERVED. *
******************************************************************************** Directory: MY15MUF
* DBID 252 AREA FCA REQUEST COMPLETE
BLOCKS READ 2,698 TABLE ROWS 205,000 DELETED ROWS 0 OTHER ROWS 0
Additional Information
For further information about this function, please refer to CA Datacom Core - 15.1 documentation for "DATASCAN OPTION=COUNT_SET_RECORDS."
As always, please contact Broadcom support for CA Datacom if you have further questions.
Feedback
