CA UIM: Reset Identity Value in S_QOS_DEFINITION

book

Article ID: 34937

calendar_today

Updated On:

Products

DX Infrastructure Management 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