Deleting old active Backtrack db's

[steve_mcelligott]

I am trying to figure out how to delete old active backtrack DB's , that have been left over from old versions of Backtrack, and Backtrack is unable to delete them. I know its an api delete command i have to use, but i don't know how to do it. here is the command i use to show old active versions. When i run this script i put the node name ie : scrpitname nodename. this will give the list of instances But i wwant to know how to delete them



select distinct cast( node_name as varchar(10) ) Node_Name, cast(hl_name as varchar(10)) Hl_Name, -

cast ( backup_date as date)Backup_Date, state, cast (deactivate_date as date)Deac_Date, class_name -

from backups where node_name=upper ('$1') and filespace_name='/BACKTRACKracatalog' -

and backup_date < '2002-01-01' order by node_name, Hl_Name, Backup_Date

 

[romeyer]

<TABLE BORDER=0 ALIGN=CENTER WIDTH=85%><TR><TD><font class="pn-sub">Quote:</font><HR></TD></TR><TR><TD><FONT class="pn-sub"><BLOCKQUOTE>I am trying to figure out how to delete old active backtrack DB's , that have been left over from old versions of Backtrack, and Backtrack is unable to delete them. </BLOCKQUOTE></FONT></TD></TR><TR><TD><HR></TD></TR></TABLE>



Same problem to me, but I've written a small Perl script (adapted from some other tsm users) with following functions:

q filespace for SQL-BT nodename

q backup for the filespaces found

give the result to a unix find/grep to look for the backup object name in ../oracatalog/..dumps files

save all backup objects, which aren't found in oracatalog

reformat backup objects names to app. format described in SQLBT-obsi.adsm manual into a file

start adsmdel program from BMC with the infos in above mentioned file.