You are viewing limited content. For full access, please sign in.

Question

Question

administration console volume columns

Administration
Updated October 24, 2016
asked on October 18, 2016

Hi

I have about 500 rollover volumes in a 9.2 repository.

When I try to add the column to see the oldest document the admin console crashes every time.

Also this date is not in the vol table. How can I add the column or which sql query do I need to do to see it?
 

Thanks

Gian

0 0

Answer

SELECTED ANSWER
replied on October 18, 2016

Does the admin console actually crash, or is it just freezing up while it retrieves the information? Try giving it a few minutes. 

The direct sql for this is:

select top 1 tocid, name, created from toc where etype=-2 and (vol_id=<VOLID> or vol_id in (select vol_id from vol where sourcevol=<VOLID>)) order by toc.created

Replace <VOLID> with the integer id of the volume.

0 0
View 1 previous reply
replied on October 19, 2016

Thanks I can use that query.

Indeed it hangs but I let it run all night and is still is "not responding".

I think it may be because it needs to run the query for each volume.
Running that query took about 15 seconds for one volume.

I guess the admin console is trying to do the same for 500 volumes and is not able to.

 

Gian

0 0
replied on October 21, 2016

Hi Robert,

I am trying to do the same for the column Current Size.

Do you know the query to get this info?

Thanks

Gian

0 0
replied on October 21, 2016

Sorry I actually saw that the cursize column in the dbo.vol table already has this.

By any chance do you know if the size in that column is in bytes?

 

Thanks

Gian

0 0
replied on October 24, 2016

Yes, that column is the size in bytes.

1 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...