Appendix A ClearIVS SQL Script

The script below should be executed against the IVS database when preparing for versioning. It will leave current security intact.

DB2 Database

delete from ivsconfigpackagecontents
go
delete from ivsconfigpackage
go
delete from ivsmigrationsetcontents	
go
delete from ivsmigrationset
go
delete from ivsreleasepackage
go
delete from ivsreleasehistory
go
delete from ivsversion
go
delete from ivsversionfield
go
delete from ivsversionhistory
go
SELECT
(SELECT COUNT* FROM IvsConfigPackageContents) AS CPC,
(SELECT COUNT* FROM IvsConfigPackage) AS CP,
(SELECT COUNT* FROM IvsMigrationSetContents) AS MSC,
(SELECT COUNT* FROM IvsMigrationSet) AS MS,
(SELECT COUNT* FROM IvsReleasePackage) AS RP,
(SELECT COUNT* FROM IvsReleaseHistory) AS RH,
(SELECT COUNT* FROM IvsVersion) AS V,
(SELECT COUNT* FROM IvsVersionField) AS VF,
(SELECT COUNT* FROM IvsVersionHistory) AS VH
FROM sysibm.sysdummy1
go

Oracle Database

delete from ivsconfigpackagecontents
go
delete from ivsconfigpackage
go
delete from ivsmigrationsetcontents
go
delete from ivsmigrationset
go
delete from ivsreleasepackage
go
delete from ivsreleasehistory
go
delete from ivsversion
go
delete from ivsversionfield
go
delete from ivsversionhistory
go
SELECT
(SELECT COUNT* FROM IvsConfigPackageContents) AS CPC,
(SELECT COUNT* FROM IvsConfigPackage) AS CP,
(SELECT COUNT* FROM IvsMigrationSetContents) AS MSC,
(SELECT COUNT* FROM IvsMigrationSet) AS MS,
(SELECT COUNT* FROM IvsReleasePackage) AS RP,
(SELECT COUNT* FROM IvsReleaseHistory) AS RH,
(SELECT COUNT* FROM IvsVersion) AS V,
(SELECT COUNT* FROM IvsVersionField) AS VF,
(SELECT COUNT* FROM IvsVersionHistory) AS VH
FROM DUAL
go

 

 

 

 

 

 

 

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. About Oracle Insurance | Contact Us