ADSM-L

Re: To big node

2000-03-09 21:54:56
Subject: Re: To big node
From: "Nathan E. King" <nathan.king AT STORSOL DOT COM>
Date: Thu, 9 Mar 2000 20:54:56 -0600
Jeff,

I can give you the following pointers:

Verify that you have the following settings in the backup copy group of the
management class which you are using for SQL Backtrack:  Ver Exists 1  Ver
Deleted 0 Ret Extra 0 Ret Only 0.

Remember that SQL Backtrack controls the versioning and not *SM.

A lot of it is down to your DBA's. Make sure that they run the appropriate
jobs to expire old backups. It's difficult from your side to track exactly
what's going on. As was previously suggested,a periodic query of the
auditocc table in the *SM Database just to see how much that particular node
is growing is a good idea.

select node_name,backup_mb,archive_mb,total_mb from auditocc where
node_name='YOURNODE'

Remember to run an audit licenses command before issuing this select
statement to update the values in the auditocc table.

Good luck,

Nathan



<Prev in Thread] Current Thread [Next in Thread>