Do you know if the temp space is used when NDMP backups are running? I would think that it probably does. I also had expiration running as well. I'm beginning to wonder if too many things are using the temp space in the database at the same time and it can't get the proper amount of space that it needs...
Any thoughts? Thanks again! ******************************** Joni Moyer Highmark Storage Systems, Storage Mngt Analyst III Phone Number: (717)302-9966 Fax: (717) 302-9826 [EMAIL PROTECTED] ******************************** "Wilkinson, Brent" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[email protected]> 09/14/2007 02:40 PM Please respond to "ADSM: Dist Stor Manager" <[email protected]> To [email protected] cc Subject Re: Help! TOC will not load I do not have the space required per an object but my TOC is about the same size of yours and each one takes about 2.5gb ( roughly ). I *believe* that TSM uses the temp space for other operations as well so I would not assume that you have the space to load 8-9 TOC's at once. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: Friday, September 14, 2007 12:33 PM To: [email protected] Subject: Re: [ADSM-L] Help! TOC will not load Hi Brent, Right now I have about 20% free space on my database. The TOC for this file system could potentially be very large as it is a 1.3 TB NAS file system. Is there a way to calculate how much free db space is needed to load a TOC? Thanks again! ******************************** Joni Moyer Highmark Storage Systems, Storage Mngt Analyst III Phone Number: (717)302-9966 Fax: (717) 302-9826 [EMAIL PROTECTED] ******************************** "Wilkinson, Brent" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[email protected]> 09/14/2007 02:27 PM Please respond to "ADSM: Dist Stor Manager" <[email protected]> To [email protected] cc Subject Re: Help! TOC will not load You said you were loading multiple TOC's. One in itself may not be bad but when you have multiples you can exhaust your TEMP DB space. To give you an idea I run at about 40-50% free on my TSM DB 52gb/92gb. My TOC loads will eat up around 3% of my free space for each one ( they are big in my environment ). -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: Friday, September 14, 2007 12:20 PM To: [email protected] Subject: Re: [ADSM-L] Help! TOC will not load Hi Neil, Yes, the TOC Load time is 120 min. How might this give me the error I see below? And what does everyone usually have this set to? Thanks! ******************************** Joni Moyer Highmark Storage Systems, Storage Mngt Analyst III Phone Number: (717)302-9966 Fax: (717) 302-9826 [EMAIL PROTECTED] ******************************** "Strand, Neil B." <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[email protected]> 09/14/2007 02:18 PM Please respond to "ADSM: Dist Stor Manager" <[email protected]> To [email protected] cc Subject Re: Help! TOC will not load 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:[EMAIL PROTECTED] On Behalf Of Wilkinson, Brent Sent: Friday, September 14, 2007 2:10 PM To: [email protected] 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:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: Friday, September 14, 2007 12:05 PM To: [email protected] 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 [EMAIL PROTECTED] ******************************** 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.
