Unused Policy Sets
Loon, E.J. van - SPLXM
I would like to get rid of a few old policy domains. Before I delete them I
would like to be sure that there is no data bound to them anymore.
Does anybody know a way to retrieve this information from ADSM?
Kindest regards,
Eric van Loon
Gary Ison
You can't delete domains with nodes defined in them. If you do the
delete and it doesn't' complain, you're OK. If it complains, you could do
"q n do=domain-name" to determine the nodes. You could then "q fi
node-name" to determine the filespaces. You could then do other
investigative commands (hl_name, ll_name, backup dates, etc.) to determine
the validity of the data.
Loon, E.J. van - SPLXM
What if the client is now assigned to a different domain? It's still
possible that previously backed up data is bound to the old policy set. In
that case there are 0 nodes associated with a domain, but there is still
data stored in this domain. That is what I would like to determine.
Kindest regards,
Eric van Loon
Gary Ison
this format, some or all of this message may not be legible.
------_=_NextPart_000_01BF928B.EE4A62A8
Content-Type: text/plain;
charset="iso-8859-1"
Hi Eric,
The same applies to nodes - you can't delete them if data is still
present. The data should have been re-bound to the new domain classes when
they moved. You can construct a select on the backups table and see the
contents of the class_name the data is bound to.
A select similar to the following may help provide the answers you
are looking for.
<<detail-filex.mac>>
Gary L. Ison
Governor's Office for Technology
101 Cold Harbor Drive
Frankfort, Ky. 40601
Phone: (502) 564-8724
Fax: (502) 564-6856
E-mail: Gary...@mail.state.ky.us <mailto:Gary...@mail.state.ky.us>
Eric,
------_=_NextPart_000_01BF928B.EE4A62A8
Content-Type: application/octet-stream;
name="detail-filex.mac"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="detail-filex.mac"
del script detail-filex
def script detail-filex desc=3D"File information for all copies of file =
x (3 of 3)"
upd script detail-filex '/* =
-------------------------------------------------*/'
upd script detail-filex '/* Script Name: detail-filex =
*/'
upd script detail-filex "/* Description: Display file information for =
a */"
upd script detail-filex '/* specified file. =
*/'
upd script detail-filex '/* Parameter: Node-name hl_name ll_name =
*/'
upd script detail-filex '/* (node-name directory file) =
*/'
upd script detail-filex '/* Example: run detail-filex node hl_name =
ll_name */'
upd script detail-filex '/* =
*/'
upd script detail-filex '/* This is the lowest level for listing all =
the */'
upd script detail-filex "/* details of a clients' backup file =
strcuture. */"
upd script detail-filex '/* =
*/'
upd script detail-filex '/* This produces detailed info for the =
specfied file */'=20
upd script detail-filex '/* for all the iterations (copies) of the =
file. The */'
upd script detail-filex '/* exact syntax from the two preceding =
scripts, */'
upd script detail-filex '/* "detail-dir" and "detail-file" must be =
used. The */'
upd script detail-filex '/* directory name should be enclosed in =
quotes. */'
upd script detail-filex '/* =
*/'
upd script detail-filex '/* SAMPLE OUTPUT =
*/'
upd script detail-filex '/* =
*/'
upd script detail-filex '/* gison Filespace: \\disch_gison\d$ =
*/'
upd script detail-filex '/* File Name: ACC-DAYS.MAC =
*/'
upd script detail-filex '/* Type: FILE =
*/'
upd script detail-filex '/* A/I: ACTIVE_VERSION =
*/'
upd script detail-filex '/* Backed Up: 2000-01-12 =
14:51:41.000000 */'
upd script detail-filex '/* Owner: =
*/'
upd script detail-filex '/* Mgt. Class: DEFAULT =
*/'
upd script detail-filex '/* =
*/'
upd script detail-filex '/* =
*/'
upd script detail-filex '/* DUE TO THE RESOURCE REQUIREMENTS AND LONG =
RUN TIME, */'
upd script detail-filex '/* THIS SCRIPT IS RESTRICTED TO SYSTEM ADMINS =
ONLY!!!! */'
upd script detail-filex '/* =
*/'
upd script detail-filex '/* =
-----------------------------------------------------*/'
upd script detail-filex 'select admin_name from admins -'
upd script detail-filex " where admin_name=3Dcurrent_user and =
system_priv=3D'Yes'"
upd script detail-filex 'if (ERROR, WARNING) goto err'
upd script detail-filex 'select filespace_name as "$1 Filespace", -'
upd script detail-filex ' ll_name as "File Name", -'
upd script detail-filex ' type as "Type", -'
upd script detail-filex ' state as "A/I", -'
upd script detail-filex ' backup_date as "Backed Up", -'
upd script detail-filex ' owner as "Owner", -'
upd script detail-filex ' class_name as " Mgt. Class" -'
upd script detail-filex ' from backups -'
upd script detail-filex " where node_name =3D upper('$1') -"
upd script detail-filex " and hl_name =3D ('$2') -"
upd script detail-filex " or hl_name =3D upper('$2') -"
upd script detail-filex " and ll_name =3D ('$3') -"
upd script detail-filex " or ll_name =3D upper('$3')"
upd script detail-filex 'goto end'
upd script detail-filex 'err:'
upd script detail-filex 'select admin_name -'
upd script detail-filex 'as " You are not authorized to execute this =
procedure." -'
upd script detail-filex ' from admins -'
upd script detail-filex ' where admin_name=3Dcurrent_user'
upd script detail-filex 'end:'
------_=_NextPart_000_01BF928B.EE4A62A8--