Joni,
See "SET TOCLOADRETENTION" default is 2 hours

Use the QUERY STATUS command to see the table of contents load retention
time.
Cheers,
Neil

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Wilkinson, Brent
Sent: Friday, September 14, 2007 2:10 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Help! TOC will not load

How many pages free do you have on your TSM DB?

Remember that the TOC loads into the TSM DB and will stay loaded for the
amount specified in your TOC Retention setting. When you load multiple
TOC's they all load to the DB and do not release until the time
specified.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Joni Moyer
Sent: Friday, September 14, 2007 12:05 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Help! TOC will not load

Hello everyone,

Since approximately 10:00 AM today, I had sporadic issues loading the
table of contents (TOC) to do file / folder restores. This appears to be
universal in that it is not just server_2, server_3, or server_22,
server_23. This problem went away on its own after an hour or so of
waiting regardless of what backups are running but after I select a file
system to restore I get the same error again.

To recreate this problem I loaded the TOC for HMCH1015_F and got the
same ANS1852E error message. We checked the log and found:

q act begint=now-00:05

09/14/07   11:18:37      ANR4837I The loading for the table of contents
for node
                          NAS_SERVER_2, file space
/root_vdm_4/HMCH1015_F started.
                          (SESSION: 1229426)
09/14/07   11:18:37      ANR4949E The server is unable to write to table
                          Backup.Objects(TEMP) because there is not
enough
                          temporary space in the database.  Table of
contents
                          operation for node NAS_SERVER_2, file space
                          /root_vdm_4/HMCH1015_F fails. (SESSION:
1229426)
09/14/07   11:18:37      ANR4839E The loading for the table of contents
for node
                          NAS_SERVER_2, file space
/root_vdm_4/HMCH1015_F failed.
                          See previous messages. (SESSION: 1229426)

Has anyone ever had this issue?  Thanks in advance for any help!

********************************
Joni Moyer
Highmark
Storage Systems, Storage Mngt Analyst III Phone Number: (717)302-9966
Fax: (717) 302-9826
joni.moyer AT highmark DOT com
********************************

IMPORTANT:  E-mail sent through the Internet is not secure. Legg Mason 
therefore recommends that you do not send any confidential or sensitive 
information to us via electronic mail, including social security numbers, 
account numbers, or personal identification numbers. Delivery, and or timely 
delivery of Internet mail is not guaranteed. Legg Mason therefore recommends 
that you do not send time sensitive 
or action-oriented messages to us via electronic mail.

This message is intended for the addressee only and may contain privileged or 
confidential information. Unless you are the intended recipient, you may not 
use, copy or disclose to anyone any information contained in this message. If 
you have received this message in error, please notify the author by replying 
to this message and then kindly delete the message. Thank you.