how can I know an archive finished

2010-03-31 Thread William ZHANG
Hi All,



My colleague is archiving some data by gui interface - dsmj ,

how can I know the finish of this archive if I can not see the gui interface
and he does not close gui.





Thanks and regards,



William


Re: how can I know an archive finished

2010-03-31 Thread Richard Sims
On Mar 31, 2010, at 9:25 AM, William ZHANG wrote:

 Hi All,
 
 My colleague is archiving some data by gui interface - dsmj ,
 
 how can I know the finish of this archive if I can not see the gui interface
 and he does not close gui.

The action constitutes transactions and a session, so standard evidence:
- dsmaccnt records created.
- ANE records in Activity Log.
- Summary table entry.


Re: how can I know an archive finished

2010-03-31 Thread Grigori Solonovitch
Try q act or=client node=node name begint=X

Grigori G. Solonovitch

Senior Technical Architect

Information Technology  Bank of Kuwait and Middle East  http://www.bkme.com

Phone: (+965) 2231-2274  Mobile: (+965) 99798073  E-Mail: g.solonovi...@bkme.com

Please consider the environment before printing this Email


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of 
William ZHANG
Sent: Wednesday, March 31, 2010 4:26 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] how can I know an archive finished

Hi All,



My colleague is archiving some data by gui interface - dsmj ,

how can I know the finish of this archive if I can not see the gui interface
and he does not close gui.





Thanks and regards,



William

Please consider the environment before printing this Email.

CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail 
message and any attachments hereto may be legally privileged and confidential. 
The information is intended only for the recipient(s) named in this message. If 
you are not the intended recipient you are notified that any use, disclosure, 
copying or distribution is prohibited. If you have received this in error 
please contact the sender and delete this message and any attachments from your 
computer system. We do not guarantee that this message or any attachment to it 
is secure or free from errors, computer viruses or other conditions that may 
damage or interfere with data, hardware or software.


Re: how can I know an archive finished

2010-03-31 Thread Patel, Ankur
Try this:

select date(start_time) as start_date, time(start_time) as start_time, 
date(end_time) as end_date, time(end_time)  as end_time,  SUBSTR (CAST(entity AS
char(17)),1,17) as Node_Name, cast((Bytes/1024) as decimal(15,2)) as 
KB_Archived, affected, (end_time-start_time)minutes as Mins  from summary where
activity='ARCHIVE' order by start_date

result looks like:
START_DATE START_TIME   END_DATE END_TIME NODE_NAME 
  KB_ARCHIVED AFFECTED   MINS
-- -- --  - 
-  --
2010-03-01   11:50:37 2010-03-01 16:44:35 AUCFDW01_FS   
 376022498.94  120293


 
Regards,
 
Ankur Patel
Snr Enterprise Mgmt Administrator
Sydney.




-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of 
William ZHANG
Sent: Thursday, 1 April 2010 12:26 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] how can I know an archive finished

Hi All,



My colleague is archiving some data by gui interface - dsmj ,

how can I know the finish of this archive if I can not see the gui interface
and he does not close gui.





Thanks and regards,



William

DISCLAIMER

Confidential Communication: This email and any attachments are intended for the 
addressee(s)
only and are confidential. They may contain legally privileged or copyright 
material. If you
are not the intended recipient, please contact the sender immediately by reply 
email and 
delete this email and any attachments. You must not read, copy, use, distribute 
or disclose 
the contents of this email without consent and Harvey Norman Holdings Limited 
ACN 003 237 545
(and its related subsidiaries) (“Harvey Norman”) does not accept responsibility 
for any
unauthorised use or reliance on the contents of this email.

Harvey Norman does not represent or warrant that the integrity of this email 
has been maintained
or that it is free from errors, viruses, interceptions or interference. Any 
views expressed by
the sender do not necessarily represent the views of Harvey Norman.

This notice should not be removed from this email.



Re: how can I know an archive finished

2010-03-31 Thread William ZHANG
That's great!  I have tested and got the infor about archived status.

Thank you very much!

Best Regards,
william

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Patel, Ankur
Sent: Thursday, April 01, 2010 10:55 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] how can I know an archive finished

Try this:

select date(start_time) as start_date, time(start_time) as start_time,
date(end_time) as end_date, time(end_time)  as end_time,  SUBSTR
(CAST(entity AS
char(17)),1,17) as Node_Name, cast((Bytes/1024) as decimal(15,2)) as
KB_Archived, affected, (end_time-start_time)minutes as Mins  from summary
where
activity='ARCHIVE' order by start_date

result looks like:
START_DATE START_TIME   END_DATE END_TIME NODE_NAME
KB_ARCHIVED AFFECTED   MINS
-- -- --  -
-  --
2010-03-01   11:50:37 2010-03-01 16:44:35 AUCFDW01_FS
376022498.94  120293


 
Regards,
 
Ankur Patel
Snr Enterprise Mgmt Administrator
Sydney.




-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
William ZHANG
Sent: Thursday, 1 April 2010 12:26 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] how can I know an archive finished

Hi All,



My colleague is archiving some data by gui interface - dsmj ,

how can I know the finish of this archive if I can not see the gui interface
and he does not close gui.





Thanks and regards,



William


DISCLAIMER

Confidential Communication: This email and any attachments are intended for
the addressee(s)
only and are confidential. They may contain legally privileged or copyright
material. If you
are not the intended recipient, please contact the sender immediately by
reply email and 
delete this email and any attachments. You must not read, copy, use,
distribute or disclose 
the contents of this email without consent and Harvey Norman Holdings
Limited ACN 003 237 545
(and its related subsidiaries) (Harvey Norman) does not accept
responsibility for any
unauthorised use or reliance on the contents of this email.

Harvey Norman does not represent or warrant that the integrity of this email
has been maintained
or that it is free from errors, viruses, interceptions or interference. Any
views expressed by
the sender do not necessarily represent the views of Harvey Norman.

This notice should not be removed from this email.