Have you got this with anything other than system objects.
If not you need to have a look back at this years www.adsm.org for problem
expiring system objects and action to take,
Lawrie Scott - Persetel Q Vector <[EMAIL PROTECTED]> on 12/20/2002
06:04:40 AM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc: (bcc: John Naylor/HAV/SSE)
Subject:
Hi All
I am trying to expire all my data except the latest active version. My
backup copy group settings are as follows:-
Policy Domain Name WINDOWS
Policy Set Name ACTIVE
Mgmt Class Name WINDOWS
Copy Group Name STANDARD
Versions Data Exists 1
Versions Data Deleted 0
Retain Extra Versions 0
Retain Only Version 0
Copy Mode MODIFIED
Copy Serialization DYNAMIC
Copy Frequency 0
Copy Destination WINDOWS
Last Update Date/Time 2002-12-20 07:52:24.000000
Last Update by (administrator) ADMIN Managing profile -
However when I use a select statement just to look at one file to see its
status this is what I see:-
select * from backups where node_name='ALSBCK' and ll_name='BOOT.INI'
Operation Results
NODE_NAME: ALSBCK
FILESPACE_NAME: SYSTEM OBJECT
FILESPACE_ID: 3
STATE: ACTIVE_VERSION
TYPE: FILE
HL_NAME: \
LL_NAME: BOOT.INI
OBJECT_ID: 28209279
BACKUP_DATE: 2002-12-20 00:10:03.000000
DEACTIVATE_DATE:
OWNER:
CLASS_NAME: DEFAULT
NODE_NAME: ALSBCK
FILESPACE_NAME: SYSTEM OBJECT
FILESPACE_ID: 3
STATE: INACTIVE_VERSION
TYPE: FILE
HL_NAME: \
LL_NAME: BOOT.INI
OBJECT_ID: 21347128
BACKUP_DATE: 2002-10-29 19:41:41.000000
DEACTIVATE_DATE: 2002-11-04 23:57:37.000000
OWNER:
CLASS_NAME: DEFAULT
NODE_NAME: ALSBCK
FILESPACE_NAME: SYSTEM OBJECT
FILESPACE_ID: 3
STATE: INACTIVE_VERSION
TYPE: FILE
HL_NAME: \
LL_NAME: BOOT.INI
OBJECT_ID: 22179567
BACKUP_DATE: 2002-11-04 23:57:37.000000
DEACTIVATE_DATE: 2002-11-05 21:13:14.000000
OWNER:
CLASS_NAME: DEFAULT
NODE_NAME: ALSBCK
FILESPACE_NAME: SYSTEM OBJECT
FILESPACE_ID: 3
STATE: INACTIVE_VERSION
TYPE: FILE
HL_NAME: \
LL_NAME: BOOT.INI
OBJECT_ID: 22618038
BACKUP_DATE: 2002-11-05 21:13:14.000000
DEACTIVATE_DATE: 2002-11-06 19:36:13.000000
OWNER:
CLASS_NAME: DEFAULT
NODE_NAME: ALSBCK
FILESPACE_NAME: SYSTEM OBJECT
FILESPACE_ID: 3
STATE: INACTIVE_VERSION
TYPE: FILE
HL_NAME: \
LL_NAME: BOOT.INI
OBJECT_ID: 22875347
BACKUP_DATE: 2002-11-06 19:36:13.000000
DEACTIVATE_DATE: 2002-11-11 19:41:46.000000
OWNER:
CLASS_NAME: DEFAULT
NODE_NAME: ALSBCK
FILESPACE_NAME: SYSTEM OBJECT
FILESPACE_ID: 3
STATE: INACTIVE_VERSION
TYPE: FILE
HL_NAME: \
LL_NAME: BOOT.INI
OBJECT_ID: 23481388
BACKUP_DATE: 2002-11-11 19:41:46.000000
DEACTIVATE_DATE: 2002-11-19 17:15:50.000000
OWNER:
CLASS_NAME: DEFAULT
NODE_NAME: ALSBCK
FILESPACE_NAME: SYSTEM OBJECT
FILESPACE_ID: 3
STATE: INACTIVE_VERSION
TYPE: FILE
HL_NAME: \
LL_NAME: BOOT.INI
OBJECT_ID: 24304303
BACKUP_DATE: 2002-11-19 17:15:50.000000
DEACTIVATE_DATE: 2002-11-29 09:41:35.000000
OWNER:
CLASS_NAME: DEFAULT
NODE_NAME: ALSBCK
FILESPACE_NAME: SYSTEM OBJECT
FILESPACE_ID: 3
STATE: INACTIVE_VERSION
TYPE: FILE
HL_NAME: \
LL_NAME: BOOT.INI
OBJECT_ID: 25991488
BACKUP_DATE: 2002-11-29 09:41:35.000000
DEACTIVATE_DATE: 2002-11-29 23:46:42.000000
OWNER:
CLASS_NAME: DEFAULT
NODE_NAME: ALSBCK
FILESPACE_NAME: SYSTEM OBJECT
FILESPACE_ID: 3
STATE: INACTIVE_VERSION
TYPE: FILE
HL_NAME: \
LL_NAME: BOOT.INI
OBJECT_ID: 26097958
BACKUP_DATE: 2002-11-29 23:46:42.000000
DEACTIVATE_DATE: 2002-12-01 21:59:49.000000
OWNER:
CLASS_NAME: DEFAULT
NODE_NAME: ALSBCK
FILESPACE_NAME: SYSTEM OBJECT
FILESPACE_ID: 3
STATE: INACTIVE_VERSION
TYPE: FILE
HL_NAME: \
LL_NAME: BOOT.INI
OBJECT_ID: 26259332
BACKUP_DATE: 2002-12-01 21:59:49.000000
DEACTIVATE_DATE: 2002-12-02 23:07:36.000000
OWNER:
CLASS_NAME: DEFAULT
NODE_NAME: ALSBCK
FILESPACE_NAME: SYSTEM OBJECT
FILESPACE_ID: 3
STATE: INACTIVE_VERSION
TYPE: FILE
HL_NAME: \
LL_NAME: BOOT.INI
OBJECT_ID: 26442741
BACKUP_DATE: 2002-12-02 23:07:36.000000
DEACTIVATE_DATE: 2002-12-05 12:05:07.000000
OWNER:
CLASS_NAME: DEFAULT
There is still a whole lot of inactive files available some as far back as a
month. The expire command i'm using is <expi i w=n> and some files where
delete according to the query process however nowhere near enough as can be
seen from the select statement.
Help I need to get this done to restructure our TSM server:-
Kind Regards
LAWRIE SCOTT
**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.
Scottish Hydro-Electric, Southern Electric, SWALEC and S+S
are trading names of the Scottish and Southern Energy Group.
**********************************************************************
