TSM check in/out issue

I'm completely new to TSM backup. For the last several days, TSM Manager doesn't require any tapes to be checked in and all backup jobs failed to start. How do I find out what's causing the issue? I've read several posts but can't seem to find the answer. Here's what I've tried so far:


Select count(*) from volumes where stgpool_name='ONSITEPOOL'
 Unnamed[1]
-----------
          0
 
Select count(*) from volumes where stgpool_name='OFFSITEPOOL'
 Unnamed[1]
-----------
          0
 
LVL 1
ithawaiiAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

woolmilkporcCommented:
Hi,

what do you get with

Q VOL *
Q LIBVOL * *
Q STGPOOL

Q DRMEDIA

?
0
ithawaiiAuthor Commented:
Attached is the results of commands you provided.
TSM-qDrMedia.txt
TSM-qStgPool.txt
TSM-qLibVol.txt
TSM-qVol.txt
0
woolmilkporcCommented:
As far as I can see you neither have a storage pool "ONSITEPOOL" nor do you have a storage pool "OFFSITEPOOL", so it's no wonder that your queries wouldn't yield any results.

To investigate your issue further I'll need the error message generated when "... all backup jobs failed to start ...".

Additionally please post the output of

Q NODE

and the output of the following query:

select DOMAIN_NAME, CLASS_NAME, DESTINATION from BU_COPYGROUPS

wmp
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

ithawaiiAuthor Commented:
q node
Node Name                 Platform Policy Domain  Days Since Days Since Locked?
                                   Name           Last Acce-   Password
                                                          ss        Set
------------------------- -------- -------------- ---------- ---------- -------
SERVER1                   WinNT    SERVERS                 1      1,112   No  
SERVER2                   WinNT    CRIT_SRVRS          1,662      1,682   No  
SERVER3                   WinNT    STANDARD               <1      1,676   No  
SERVER4                   WinNT    SERVERS                 2      1,690   No  
SERVER5                   WinNT    CRIT_SRVRS             <1      1,671   No  
SERVER6                   WinNT    CRIT_SRVRS              4      1,300   No  
SERVER7                   WinNT    CRIT_SRVRS              2         97   No  
SERVER8                   WinNT    SERVERS                 4      1,690   No  
SERVER9                   WinNT    SERVERS                 2      1,690   No  
SERVER10                  WinNT    SERVERS                 4        108   No  
SERVER11                  WinNT    SERVERS               791      1,686   No  
SERVER12                  WinNT    SERVERS                 1      1,690   No  
SERVER13                  WinNT    SERVERS                36      1,028   No  
 
select DOMAIN_NAME, CLASS_NAME, DESTINATION from BU_COPYGROUPS
DOMAIN_NAME            CLASS_NAME             DESTINATION      
------------------     ------------------     ------------------
CRIT_SRVRS             CRIT_MC                CRIT_BACKPOOL    
CRIT_SRVRS             CRIT_NOLIMIT           CRIT_BACKPOOL    
CRIT_SRVRS             CRIT_MC                CRIT_BACKPOOL    
CRIT_SRVRS             CRIT_NOLIMIT           CRIT_BACKPOOL    
SERVERS                MCLASS1                LTOPOOL          
SERVERS                MCLASS1                LTOPOOL          
STANDARD               STANDARD               BACKUPPOOL        
STANDARD               STANDARD               BACKUPPOOL        
 
0
ithawaiiAuthor Commented:
Sorry, the output doesn't look good. So, here's the file.
TSM-qNode.txt
0
woolmilkporcCommented:
It's not so easy to understand your setup!

1) The backups of the servers in the "SERVERS" domain (SERVER1,4,8-13) are problematic, because their backup data go into the "LTOPOOL" which indeed has 7 "Filling" tapes, i.e. tapes still having room for more data, but only 3 of these tapes are in the library (22L3,33L3,67L3)

2) The backups of the servers in the "CRIT_SRVRS" domain (SERVER2,5-7) are critical  as well. Their backup data should go to "CRIT_BACKPOOL", then to "CRIT_DSKP" (both diskpools) then to  "CRIT_LTOPOOL" which has 5 "filling" tapes, but only 2 are in the library (40L3,56L3).

3) "SERVER3" in the "STANDARD" domain cannot be backed up. Its data should go to "BACKUPPOOL", a diskpool which has no volumes defined.

The "Filling" tapes which are not in the library are not in "VAULT" either! Where could they be?
I think you should try to find them to then check them into the library.
It might well be that you often get "Server out of Data Storage Space" because of too few free tapes!

I'm still waiting for the error messages you get during backup!

wmp
0
woolmilkporcCommented:
All this looks quite as if someone ran a MOVE DRMEDIA to ONSITERETRIEVE and forgot to perform the final CHECKIN LIBVOLUME.

This concerns all tapes which show up with QUERY VOLUME but neither with Q LIBVOLUME  * nor with Q DRMEDIA.

Note the names of these volumes, try to find them then insert them into your library and run a CHECKIN LIBVOL as SCRATCH or PRIVATE, see below.

Finally, depending on your STGPOOL settings (use of scratch tapes allowed or not) leave them as scratch for free use or define them to the critical stgpools. In the former case check them in as SCRATCH, in the latter case use PRIVATE.

wmp

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ithawaiiAuthor Commented:
I know it's not an easy thing to fix. I'll follow your instructions and give it a shot. Thanks for helping me. I'll let you know the result shortly.
0
ithawaiiAuthor Commented:
I end up having TSM professional to fix it for me. Thanks for all your help.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Storage Software

From novice to tech pro — start learning today.