CA UIM: Reset Identity Value in S_QOS_DEFINITION

Article Id: 34937
Status: Published
Updated On: 14-02-2018 07:40
Legacy Id: TEC000003723
Products:
CA Unified Infrastructure Management On-Premise (Nimsoft / UIM) , NIMSOFT PROBES
Issue/Introduction:

Introduction:

S_QOS_DEFINITION has an identity field qos_def_id which increments sequentially. When this table is truncated, the next value inserted will be last-max-value+1 - e.g , if last max value of qos_def_id is 129, then after truncating, qos_def_id will start from 130. You can check the current number by issuing the following command in SQL Studio:

DBCC CHECKIDENT (s_qos_definition, NORESEED)

Background:
You can use this process to reset qos_def_id if needed.

Environment:
CA UIM QoS

Instructions:

To reset the number so that qos_def_id starts from 1, issue following command:
DBCC CHECKIDENT (s_qos_definition,RESEED,0)

Environment:

Release:
Component: CAUIM