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 |