OK I see my mistake I know what the Unamed[1] and Unamed[2] are reporting now just an over sight. Thanks Justin ---------------------- Forwarded by Justin Case/OIT/Univ/Duke on 07/16/2004 04:05 PM ---------------------------
Justin Case 07/16/2004 03:54 PM To: [EMAIL PROTECTED] cc: Subject: total mb of data on tapepool I have ran a select command and I not sure of the meaning of the out put listed below could someone inlighten me ? What is the Unamed[1] and Unamed[2] ? Thanks tsm: DUKETSM1>select sum(num_files),sum(physical_mb) from occupancy where stgpool_name='TAPEPOOLH' ANR2963W This SQL query may produce a very large result table, or may require a significant amount of time to compute. Do you wish to proceed? (Yes (Y)/No (N)) y Unnamed[1] Unnamed[2] ----------- --------------------------------- 112866529 39587397.10 Justin