Clear Table and reset Identity Column
TRUNCATE TABLE mytable RESTART IDENTITY;
See
IBM Knowledge Center
ibm
,
devel
,
sql