Query volume and move data questions
I have a number of LTO3 tape volumes as follows: 812 BKPLTO3POOL LTO3CLASS1,180,167 0.0 Full 823 BKPLTO3POOL LTO3CLASS1,433,743 0.2 Full 801 BKPLTO3POOL LTO3CLASS1,134,86837.3 Full 827 BKPLTO3POOL LTO3CLASS1,369,99249.5 Filling Unfortunately I have no LTO3 scratch volumes available at this time. When I try a move data command on volumes 812, 823 or 801 it fails because it is looking for a scratch tape. If these tapes have a percentage utilized of 0.0%, 0.2%, 37.3% and 49.5% respectively (and one of those tapes has a status of Filling) why is it looking for a scratch tape? Thanks Regards Paul Paul Dudley Senior IT Systems Administrator ANL Container Line Pty Limited Email: pdud...@anl.com.au Web: http://www.anl.com.au ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Details of large file backed up via TSM
I can see that TSM has backed up a file that is 140 Gb in size. However I have been unable to work out which server this file came from. I want to query the TSM database to find out some information about that file (its name, what server it was on, etc) After some research it appears that the following command will query the contents table in the database. select FILE_NAME,FILE_SIZE from contents order by FILE_SIZE DESC (DESC Specifies that the columns are sorted in descending order. - you see the biggest files at first) I know that the file size is 142,499,909,632 bytes and it is probably the largest file. The TSM query I ran over the weekend was: select FILE_NAME,FILE_SIZE from contents where FILE_SIZE 100 order by FILE_SIZE DESC /tmp/file-list The object of this command was to only list files greater than 100 bytes in size. The command ran and finished straight away so I knew it had not worked. The output in file /tmp/file-list was: Output of command redirected to file '100' ANS8001I Return code 3. ANS8002I Highest return code was 3. The output of file 100 was: ANS8000I Server command: 'select FILE_NAME,FILE_SIZE from contents where FILE_SIZE' ANR2909E The SQL statement is incomplete; additional tokens are required. Please note that it was not my intention to have output written to file 100. That number sets the lower limit of what file sizes I want to report on. If anyone could let me know what the problem was with the query above it would be appreciated. Thanks Regards Paul Paul Dudley Senior IT Systems Administrator ANL Container Line Pty Limited Email: pdud...@anl.com.au Web: http://www.anl.com.au ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Re: Details of large file backed up via TSM
I am aware of the potential problem you raise below which is why I scheduled it to start running at 6 am on Saturday morning as activity on the TSM server during the day on Saturday is minimal. I discovered this large file from the output of the q pr command. The file was either being moved as part of a migration or reclaimation process. I have seen it appear on a number of occasions over the past few months in these processes. Thanks Regards Paul Paul Dudley Senior IT Systems Administrator ANL Container Line Pty Limited Email: pdud...@anl.com.au Web: http://www.anl.com.au -Original Message- The greater issue: Performing a Select against the Contents table is basically suicidal: it's the worst table to query, where a query could run for days and cripple your TSM server. I would instead recommend inspecting the accounting log for a session with data of that size, and 1 or few objects. Likewise you could scan the ANE messages in the Activity Log, or have a look at the Summary table, for recent sessions. You don't say how you know about that file having been backed up: that may lead to more concise ways to determine its origin. Richard Sims ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Make empty volume a scratch tape
I have performed a move data command on a tape volume which has worked OK and moved all the data from the tape. The pct util is 0.0, the tape is in read/write access state and the volume state is full. How can I make this a scratch tape as it has no data on it? The delete vol command fails with a return status of 13. Rather than waiting a day can I force it to be a scratch tape now? Thanks Regards Paul Paul Dudley Senior IT Systems Administrator ANL Container Line Pty Limited Email: pdud...@anl.com.au Web: http://www.anl.com.au ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Re: TSM admin processes
On Jan 26, 2009, at 10:35 PM, Paul Dudley wrote: ... If there are thousands of files backed up via TSM which will stay on the backup tapes in the library for a number of years probably without being required for a restore, is there a way of moving these files to tapes which can then be checked out of the library, thereby freeing up slots in the library for more scratch tapes? You could employ a two-level storage pool hierarch and MIGDelay in the upper level in conjunction with periodic migration, which would migrate old files (actually, Aggregates) which had not been recently used in restorals. Thereafter you would use the principle described in Admin Guide topic Managing a Full Library to externalize the lower level volumes. But: getting operators to respond to mount messages to return tapes to the library is problematic. Richard Sims http://people.bu.edu/rbs/ Fortunately I have the use of a second IBM Tape Library for TSM which uses LTO2 tapes. If I understand you correctly this is what I could set up: Currently my BKPPOOL is on disk and the Next Storage Pool for that is BKPLTO3POOL (LTO3 tapes). I create a new storage pool called BKPLTO2POOL on the second LTO2 tape library and make that the Next Storage Pool for BKPLTO3POOL. I then set the MIGDelay parameter for BKPLTO3POOL to 180 so that any file that has not been written or read in the past 180 days gets migrated to BKPLTO2POOL. Is that feasible? Thanks Regards Paul Paul Dudley Senior IT Systems Administrator ANL Container Line Pty Limited Email: pdud...@anl.com.au Web: http://www.anl.com.au ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Remove backed up files no longer needed from TSM
If we have a server that is backed up via TSM, and that server has a lot of files on it in a particular directory which have already been backed up but we will never need, is it possible to delete these backed up copies of the files from TSM to free up resources within TSM? Thanks Regards Paul Paul Dudley Senior IT Systems Administrator ANL Container Line Pty Limited Email: pdud...@anl.com.au Web: http://www.anl.com.au ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
TSM admin processes
I would like to make sure that I have all the relevant TSM admin processes running as I am concerned about running out of space on the tapes in the tape library. Currently we have the following admin processes running on a daily basis: Delete volhist Expire inventory Reclaimation Migration Is there anything we are missing? If there are thousands of files backed up via TSM which will stay on the backup tapes in the library for a number of years probably without being required for a restore, is there a way of moving these files to tapes which can then be checked out of the library, thereby freeing up slots in the library for more scratch tapes? Thanks Regards Paul Paul Dudley Senior IT Systems Administrator ANL Container Line Pty Limited Email: pdud...@anl.com.au ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Re: TDP Sql question about log growing
Can that log backup be run within TDP Sql or does it have to be run using MSSQL? Thanks Regards Paul Paul Dudley Senior IT Systems Administrator ANL Container Line Pty Limited -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Del Hoobler Sent: Friday, 23 January 2009 1:38 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TDP Sql question about log growing Robert, You need to run a LOG backup in order to truncate the logs. BTW, truncating the transaction log does not reduce the size of a physical log file; it reduces only the size of the logical log file. To reduce the size of a physical log file, it is necessary to shrink the file, using, for example, the DBCC SHRINKFILE command. Here is an IBM Technote that discusses it: http://www-01.ibm.com/support/docview.wss?uid=swg21199294 If you want real deep details, look here: http://msdn.microsoft.com/en-us/library/ms190440.aspx Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/22/2009 03:31:10 AM: TDP Sql question about log growing Robert Ouzen Ouzen to: ADSM-L 01/22/2009 03:32 AM Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU Please respond to ADSM: Dist Stor Manager Hi to all In a sever Windows 2003 with SQL database I saw that a log increase very much ( to +26 GB) , it was programmed with the option Recovery Model: Full I run every day a full backup (not any log backup) with the command: tdpsqlc backup * full /tsmoptfile=%sql_dir%\dsm.opt /logfile=% sql_dir%\sqlfull.log %sql_dir%\sqlsched.log I add those lines in my dsm.opt: INCLUDE \...\meta\...\* mgwhighlearnf INCLUDE \...\data\...\* mgwhighlearnf If I understand correctly the full backup truncate the log after it finish ??? In my case running just full backup I can turn it to just Recovery Model: simple But just for knowledge why the full backup did not clear the log ? I first turn the Recovery Model to: simple to run a shrinking procedure (turn the log to 10MB). By the way what the difference if instead of the lines of the INCLUDE I wrote previous I will write: INCLUDE \...\meta\...\full* mgwhighlearnf INCLUDE \...\data\...\full* mgwhighlearnf And let my recovery model to: Full Did now it will truncate the log after each full backup ??? or I need to add a truncate option somewhere My TDP for SQL version is 5.2.1.0 Regards, Robert Ouzen ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
IO Port on IBM 3852 library
I have an IBM 3852 tape library which has not been configured to use the IO port when checking in or checking out tapes. Our TSM server is a Windows 2003 server. I would like it to use the IO Port when checking in or checking out tapes. Is this something that is configured via TSM or via the device manager in Windows? Regards Paul Paul Dudley Senior IT Systems Administrator ANL Container Line Pty Limited Email: [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Updating spacetrigger db full percentage
When I run q spacetrigger db f=d I see DB Full Percentage: 80 DB Space Expansion Percentage: 100 I have worked out how to change DB Space Expansion Percentage but how would I change DB Full Percentage from 80 to 90? Regards Paul Paul Dudley Senior IT Systems Administrator ANL Container Line Pty Limited Email: [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Improving TSM performance - memory related setting
If I recall correctly there is a TSM system setting that relates to the memory available on the server, and you can check and adjust this setting to improve performance of your TSM server. Can anyone remind me which setting it is? Regards Paul Dudley Senior IT Systems Administrator ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Re: Improving TSM performance - memory related setting
Currently the BUFPOOLSIZE is set to: BufPoolSize: 122,880 K The server has 3 Gb of memory. Is this something I can increase? Regards Paul Dudley Senior IT Systems Administrator ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] 03-9257-0603 http://www.anl.com.au -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Skylar Thompson Sent: Friday, 4 April 2008 1:05 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Improving TSM performance - memory related setting Paul Dudley wrote: If I recall correctly there is a TSM system setting that relates to the memory available on the server, and you can check and adjust this setting to improve performance of your TSM server. Can anyone remind me which setting it is? Are you thinking of BUFPOOLSIZE and LOGPOOLSIZE? The former controls the size of the database buffer pool (bounded only by the physical memory of the machine), and the latter the size of the temporary transaction space in the recovery log (up to 8192 pages IIRC). -- -- Skylar Thompson ([EMAIL PROTECTED]) -- Genome Sciences Department, System Administrator -- Foege Building S048, (206)-685-7354 -- University of Washington School of Medicine ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
What tells Q DRM?
What process is it that tells Q DRM which tapes are in vault retrieve status? Is it Expiration or Space Reclamation? The reason I am asking is that we have not had any tapes in vault retrieve status for a few days. Regards Paul Dudley Senior IT Systems Administrator ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] 03-9257-0603 http://www.anl.com.au ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Re: TDP for SQL question
OK - I have done this and it is working as far as backing up the SQL database goes. Now what do I do if I need to restore from this new node name back onto the client? Do I need to do anything with the dsm.opt and dsmarch.opt files before starting the restore? Regards Paul Dudley Senior IT Systems Administrator ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] 03-9257-0603 http://www.anl.com.au -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: Saturday, 4 August 2007 2:37 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TDP for SQL question Paul, Typically... I see that people will name their node the same as their primary SQL node with an extension. Something like: Primary: SQLSRV23_SQL Archive: SQLSRV23_SQL_ARCH And they will have a separate DSM.OPT file, something like DSMARCH.OPT that has the archive nodename. Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 08/03/2007 12:53:23 AM: I have been told that if I want to create an archive backup of an SQL database via TDP for SQL, then I should create a separate node name in TSM (such as SQL_Archive) and then backup using that node name once a month (for example) and make sure to bind those backups to a management class that has the long term settings that meet our requirements. What else is involved in setting this up? On the client do I have to create another dsm.opt file with the new node name to match what I set up on the TSM server? Regards Paul Dudley ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Setting up TDP for SQL archive db backup
I am trying to set up a secondary TDP for SQL db backup command on a client to use as an archive backup. I have set up a second client node on the TSM server. I have created a second dsm.opt file called dsmarch.opt which has the second client node name in it. I have set up a scheduled job on the client which has the tdpsqlc backup dbmane full command with the /tsmoptfile= parameter set to the new opt file which is called dsmarch.opt. When it runs the following messages are written to the log file: Starting SQL database backup... ACO5091E PASSWORDACCESS is Generate. Either the stored password is incorrect or there is no stored password. If you do not have a stored password, use the -TSMPassword=xxx option to set and store your password. Total SQL backups selected: 1 Total SQL backups attempted: 0 Total SQL backups completed: 0 Total SQL backups excluded: 0 Total SQL backups inactivated:0 Throughput rate: 0.00 Kb/Sec Total bytes transferred: 0 Elapsed processing time: 0.00 Secs ANS1025E (RC137) Session rejected: Authentication failure Any idea what my next step should be? If I run a tdpsqlc query tsm command with the /TSMPassword=password option to try and set the password how do I tell it that I am doing this for the second client I have set up? Regards Paul Dudley Senior IT Systems Administrator ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
TSM Daily report - html stopped working
I have the daily TSM Operational Report e-mailed to me each morning with the stats, etc in an attached HTML format. For some reason over the past few days, the report has still been running OK but when I receive the e-mail all I get is the text e-mail without the html attachment. If I manually run the report from the TSM server and manually send it via e-mail to me I receive it, it is just the scheduled report that has stopped having the html attachment. I changed the format yesterday from html to text and I have received the report in text format OK this morning. Has anyone encountered the same problem? Regards Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] 03-9257-0603 http://www.anl.com.au ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
TDP for SQL advice
We currently perform MS SQL database backups using TDP (using the tdpsqlc backup * full command) We then use Enterprise Manager to run a log backup (using the BACKUP LOG command) followed by a log shrink job (using the DBCC SHRINKFILE command) Is there a way to do all of these within TDP for SQL? Regards Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
TDP for SQL question
I have been told that if I want to create an archive backup of an SQL database via TDP for SQL, then I should create a separate node name in TSM (such as SQL_Archive) and then backup using that node name once a month (for example) and make sure to bind those backups to a management class that has the long term settings that meet our requirements. What else is involved in setting this up? On the client do I have to create another dsm.opt file with the new node name to match what I set up on the TSM server? Regards Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
dsmcad process on linux clients
We are running TSM 5.2 If I perform a TSM restore, archive, backup or retrieve using the GUI on a linux client the agent process stays behind on the server after I close the GUI and eventually both it and the dsmcad process dies. With the dsmcad process gone scheduled backups won't work. My workaround is to kill the agent process and then start dsmcad again. Is this a known bug with 5.2 and is there a fix? Regards Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] http://www.anl.com.au ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
TDP for SQL advice
We currently perform SQL database backups using TDP (using the tdpsqlc backup * full command) We then use Enterprise Manager to run a log backup (using the BACKUP LOG command) followed by a log shrink job (using the DBCC SHRINKFILE command) Is there a way to do all of these within TDP for SQL? Regards Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] 03-9257-0603 http://www.anl.com.au ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
TDP for SQL restore question
I am currently trying to restore a database from our production server onto the E drive of a test server. I have previously been able to restore a database from our production server onto the D drive of the test server. The database is 40 Gb in size. When I have tried this previously the session has timed out after 5 minutes. I have increased the idle time out to 120 minutes. It is currently trying to restore and the output from the q sess command shows that 3.2 Mb of bytes have been sent. This amount of bytes was sent in the first minute of the restore session after the tape was mounted. Since then it has stayed at 3.2 Mb for the past 35 minutes. The session state according to q sess is SendW. The load on the client server is quite low - between 1% and 5%. There is more than enough disk space to restore the database. I have checked Enterprise Manager and there is not much activity on the server. There are no other processes running on the TSM server. If this session times out and the restore fails after 120 minutes how can I work out why this has happened? Is there anything I can do to make it work? As stated above I have been able to restore the same sized database onto the D drive of the same client server. Thanks Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Re: TDP for SQL restore question
Thanks for that clear and concise explanation. It appears that is exactly what is happening. After 40 - 45 minutes the actual restore part of it started and it has now restored 3 Gb of the database. Paul Dudley ANL IT Operations Dept. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David Longo Sent: Thursday, 28 June 2007 11:49 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TDP for SQL restore question Maybe DB was smaller when you restored to D drive, or D is faster disk than E. For this size you need bigger timeout, I have COMMTIMEOUT on TSM server set to 15,000 seconds (250 minutes) What is happening is that SQL (not TSM) is building the DB for the data to be restored to. If it was only say 5GB, you would barely notice. When DB is built, then the restore starts flying! David Longo Paul Dudley [EMAIL PROTECTED] 6/27/2007 9:41 PM I am currently trying to restore a database from our production server onto the E drive of a test server. I have previously been able to restore a database from our production server onto the D drive of the test server. The database is 40 Gb in size. When I have tried this previously the session has timed out after 5 minutes. I have increased the idle time out to 120 minutes. It is currently trying to restore and the output from the q sess command shows that 3.2 Mb of bytes have been sent. This amount of bytes was sent in the first minute of the restore session after the tape was mounted. Since then it has stayed at 3.2 Mb for the past 35 minutes. The session state according to q sess is SendW. The load on the client server is quite low - between 1% and 5%. There is more than enough disk space to restore the database. I have checked Enterprise Manager and there is not much activity on the server. There are no other processes running on the TSM server. If this session times out and the restore fails after 120 minutes how can I work out why this has happened? Is there anything I can do to make it work? As stated above I have been able to restore the same sized database onto the D drive of the same client server. Thanks Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person. ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Extend db question
This morning we received a TSM alert: The database utilization is too high. Condition (85.1 85) Recommendation: Consider a database space trigger or increase the size of the database. Going back through my daily TSM reports I have seen that the database utilization has increased from 60% to 85% over the past few months. This is to be expected as we are performing more backups than previously. Is it correct that I should use the extend db command to do this? The q db command shows that the database is 32 Gb in size. On the server I have 24 Gb of free space so I have room to extend the size of the database. The one thing that confuses me is this statement in the help extend db command: Attention: You cannot change the size of an allocated database volume after it has been defined to Tivoli Storage Manager. If you do, Tivoli Storage Manager may not initialize correctly and data could be lost. Can someone clarify this statement for me and confirm that using the extend db command is the correct way to do this. Thanks Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Re: Extend db question
OK - when I run a q db the available space in MB is 32,768, the assigned capacity in MB is 32,768 and the maximum extension in MB is 0. I assume that this means that I have to run def dbvol to create another database volume file before I can run extend db? Regards Paul -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David Longo Sent: Thursday, 14 June 2007 10:56 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Extend db question That note in manual means the size of an individual DB Volume, not the DB as a whole. There are more automatic extensions of disks, filesystems, etc. these days - and more to come. After you have formatted a DB volume with TSM, you shouldn't monkey with it at the OS level. Extend DB is what you want. Generally use size of DB volumes. As say you have (6) 4 GB dbvols defined, to use one you would enter: extend db 4000. The value is in MB. This is if you have already use def dbvol to create the vol of course. David Longo Paul Dudley [EMAIL PROTECTED] 6/13/2007 7:55 PM This morning we received a TSM alert: The database utilization is too high. Condition (85.1 85) Recommendation: Consider a database space trigger or increase the size of the database. Going back through my daily TSM reports I have seen that the database utilization has increased from 60% to 85% over the past few months. This is to be expected as we are performing more backups than previously. Is it correct that I should use the extend db command to do this? The q db command shows that the database is 32 Gb in size. On the server I have 24 Gb of free space so I have room to extend the size of the database. The one thing that confuses me is this statement in the help extend db command: Attention: You cannot change the size of an allocated database volume after it has been defined to Tivoli Storage Manager. If you do, Tivoli Storage Manager may not initialize correctly and data could be lost. Can someone clarify this statement for me and confirm that using the extend db command is the correct way to do this. Thanks Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person. ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
X in folder icon when restoring
I have noticed that when I am performing a point in time restore using the TSM GUI that some folders have a small X in the folder icon next to the folder name. What does the X signify? Thanks Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Re: Point in time restore problem
Well, I will give it a go, but this just confirms my belief that TSM is the most user-unfriendly, frustrating, annoying, unwieldy IT system I have encountered in 22 years of IT work. Regards Paul -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of William Boyer Sent: Sunday, 27 May 2007 1:08 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Point in time restore problem Instead of doing a SELECTIVE backup on a periodic basis, which won't update the last backup date/time of the filespace, use the MODE=ABSOLUTE of the backup copygroup. In your domain, make a copy of the active policy set and change all the management class backup copygroups to MODE=ABSOLUTE instead of the default of MODIFIED. Then on your occasional timeframe, run an admin schedule to activate this policy set, do your backups which are incremental and then the next day run another admin schedule to activate your MODE=MODIFIED policyset. This way your schedules don't change and as far as the client is concerned you just ran a unqualified INCREMENTAL backup and the filespaces are updated. Since the active policyset will have ABSOLUTS, you'll get a copy of every file whether it's changed or not. I've been doing TSM not for over 8-years and this is the first time I've ever thought of a way to use multiple policyset definitions in a domain. Bill Boyer Backup my harddrive? How do I put it in reverse? - ?? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Paul Dudley Sent: Saturday, May 26, 2007 8:59 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Point in time restore problem From what I read the standard incremental backup is restricted in that it only backs up new or changed files since the last incremental backup. However I have been told that we need to run absolute incremental backups on a periodic basis - these incremental backups backup all files whether they have changed or not, so that the Last Incr Date is updated, so that Point in time restores don't have to traverse through a huge transaction log and spend long periods of time restoring files that were later deleted. I quote from the dsmc help option for incremental backups: Mode: Permits you to back up only files that changed since the last backup (modified). Also permits you to back up the files whether they changed or not (absolute). What I want to know is if you can run an absolute backup from the command line on the client server. The end result I want to achieve from all of this, is to run full backups on a periodic basis so that when I have to perform a Point in time restore it does it quickly and does not have to traverse a huge transaction log and restore files that were later deleted. Regards Paul ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Re: Point in time restore problem
OK - can I perform an absolute/unqualified incremental backup from the command line using the dsmc command? If so then how? I cannot see the correct option to use under dsmc incr. Regards Paul -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: Friday, 25 May 2007 9:07 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Point in time restore problem On May 25, 2007, at 12:39 AM, Paul Dudley wrote: Does a selective backup count as an absolute/unqualified Incremental backup? No; the two are rather different animals in their intent and operation. The major manifestation of this is the Last Incr Date report from Query Filespace being updated only when an unqualified Incremental backup runs to completion. Richard Sims ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Re: Point in time restore problem
From what I read the standard incremental backup is restricted in that it only backs up new or changed files since the last incremental backup. However I have been told that we need to run absolute incremental backups on a periodic basis - these incremental backups backup all files whether they have changed or not, so that the Last Incr Date is updated, so that Point in time restores don't have to traverse through a huge transaction log and spend long periods of time restoring files that were later deleted. I quote from the dsmc help option for incremental backups: Mode: Permits you to back up only files that changed since the last backup (modified). Also permits you to back up the files whether they changed or not (absolute). What I want to know is if you can run an absolute backup from the command line on the client server. The end result I want to achieve from all of this, is to run full backups on a periodic basis so that when I have to perform a Point in time restore it does it quickly and does not have to traverse a huge transaction log and restore files that were later deleted. Regards Paul -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: Saturday, 26 May 2007 11:57 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Point in time restore problem On May 26, 2007, at 9:34 AM, Paul Dudley wrote: OK - can I perform an absolute/unqualified incremental backup from the command line using the dsmc command? If so then how? I cannot see the correct option to use under dsmc incr. There is no option... That's the whole point - it's unqualified: you are in no way restricting the incremental backup, which proceeds on the basis of inventory comparison with prior backups. This is the most basic TSM backup, as described in the client manual: Full and partial incremental backup If you select entire file systems, you are performing a full incremental backup. If you select a directory tree or individual files, you are performing a partial incremental backup. Read through the Backing up your data section of the client manual. The TSM Concepts redbook also helps explain the differences. Richard Sims ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Re: Point in time restore problem
Does a selective backup count as an absolute/unqualified Incremental backup? Regards Paul -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: Wednesday, 23 May 2007 11:22 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Point in time restore problem On May 22, 2007, at 10:24 PM, Paul Dudley wrote: We perform incremental backups each night and occasional archive backups on our mail server (which is linux OS) I am currently performing a point in time restore via the GUI for an account on that mail server. The point in time is last Friday morning. However the restore seems to be restoring everything that was ever backed up in that account. At the time the account was 500 Mb in size - I am restoring this account to another location on the server and so far it has restored 1.8 Gb of data. Why is this happening? Why is it restoring files that were deleted or moved months ago? Paul - That manifestation is documented in the Admin Guide, under How IBM Tivoli Storage Manager Selects Files for Policy Operations: Incremental Backup, where that can happen if an unqualified Incremental backup is not done often enough for a file system. Point-in-time restorals can be interesting. Richard Sims ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Point in time restore problem
We perform incremental backups each night and occasional archive backups on our mail server (which is linux OS) I am currently performing a point in time restore via the GUI for an account on that mail server. The point in time is last Friday morning. However the restore seems to be restoring everything that was ever backed up in that account. At the time the account was 500 Mb in size - I am restoring this account to another location on the server and so far it has restored 1.8 Gb of data. Why is this happening? Why is it restoring files that were deleted or moved months ago? Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Archive option for TDP for SQL in future
Is anyone aware of Archiving being made an option for TDP for SQL in the near future? It's a real pain in the you know what not having an equivalent option to the TSM archive option. Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
backup storage question
I am currently making a copy of our archive storage pool tapes to send offsite using the command: backup stg ARCTAPEPOOL ARCCPYPOOL wait=yes My question is - if I have to cancel this process part way through, when I restart it will it pick up from where it left off or will it start from the beginning again? Regards Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Archive list query
I would like to run a query that will give me a list of all the archives we have done. I don't want a list of every file archived, just the general list of the archive backups on each server. I have found this command: select distinct description from archives But when I ran it TSM replied with a warning that this command may create a very large table and take a long time to complete. I would rather do this from the TSM server and not have to go to each individual client to get this information. Am I on the right track with the above command or is there another one I should be running? Regards Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Client node will not talk to TSM server
I have a linux TSM node called ANL2 that has stopped communicating with the TSM server since Friday December 1st. We have not been able to perform any backups on this server since that time. The error in the activity log is: 12/05/2006 15:09:53 ANR0406I Session 12863 started for node ANL2 (Linux86) (Tcp/Ip ANL2(59771)). (SESSION: 12863) 12/05/2006 15:09:53 ANR0423W Session 12863 for administrator LH$ ( ) refused - administrator name not registered. (SESSION: 12863) 12/05/2006 15:09:53 ANR0403I Session 12863 ended for node ANL2 (Linux86). (SESSION: 12863) This same error appeared on Friday night when the ANL2 server stopped talking to our TSM server. I also appears each time I kill and restart dsmcad on the ANL2 server. I have used the update node command to update the password for the client and have used the update admin command to update the admin account for ANL2 which is called ANL2. I have also updated the client node using the TSM administration GUI. When I start the Backup-Restore GUI using Internet Explorer on node ANL2, I can start it but when I click on the Backup option (or any option) I get the error ANS2604S: The web client agent was unable to authenticate with the server. When I look at the processes running on client node ANL2 I see these processes: root 16887 0.0 0.1 39140 2440 ?S15:37 0:00 dsmcad root 16896 0.2 0.1 21732 3020 ?S15:38 0:00 /usr/bin/dsmc schedule /tmp/fileo78pFb -optfile=/opt/tivoli/tsm/client/ba/bin/dsm.opt The dsm.opt file has not been changed (neither has the dsm.sys file). The output from the query node command for ANL2 is: Node Name Platform Policy Domain Days Since Days Since Locked? Name Last Password AccessSet - -- -- -- --- ANL2 Linux86 STANDARD 1 1 No The output for the query admin command relating to ANL2 is: Administrator Days SinceDays Since Locked?Privilege Classes Name Last Access Password Set -- -- --- ADMIN 1 173 No System ANL2 11 No Client Owner Can anyone offer some advice on how to fix this problem and get the client node ANL2 talking to the TSM server again. Thanks Paul Paul Dudley ANL IT Operations Dept. ANL Container Line mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Archive Policy Group question
If I perform an archive backup, and after that archive completes change the number of days retention in the archive policy (for example change it from 120 days to 365 days) , will the archive backup I have just performed retain the old policy retention of 120 days or will it be updated along with the policy change and be kept for 365 days? Regards Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
TDP for SQL - archive normal backup?
If I have run a normal TDP for SQL database backup onto my TSM tape library, is there any way to grab that backup and archive it? Regards Paul Paul Dudley ANL IT Operations Dept. ANL Container Line mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Checking in new tapes on new TSM tape library
I am trying to check in a new LTO3 tape in our new IBM 3582 TSM tape library that was installed a month ago. However it keeps failing. I would like to know if I am doing it correctly before logging a fault call with IBM. I am placing the new tape with the barcode label on it, in the IO slot on the right side of the unit. The command I execute is: tsm: ANLTSMlabel libvol lb1.1.0.3 818ACFL2 checkin=scratch ANS8003I Process number 593 started. tsm: ANLTSMq pr Process Process DescriptionStatus Number - 593 LABEL LIBVOLUMEANR8804I Labelling volume 818ACFL2 in library LB1.1.0.3. tsm: ANLTSMq req ANR8352I Requests outstanding: ANR8306I 153: Insert LTO volume 818ACFL2 R/W into the slot with element number 4112 of library LB1.1.0.3 within 60 minutes; issue 'REPLY' along with the request ID when ready. The error that appears in the log when it fails is: 11/08/2006 13:28:10 ANR8300E I/O error on library LB1.1.0.3 (OP=8401C058, CC=314, KEY=FF, ASC=FF, ASCQ=FF, SENSE=**NONE**, Description=The source slot or drive was empty in an attempt to move a volume). Refer to Appendix D in the 'Messages' manual for recommended action. (SESSION: 7292, PROCESS: 593) 11/08/2006 13:28:10 ANR8942E Could not move volume 818ACFL2 from slot-element 4112 to slot-element 257. (SESSION: 7292, PROCESS: 593) 11/08/2006 13:28:10 ANR8802E LABEL LIBVOLUME process 593 for library LB1.1.0.3 failed. (SESSION: 7292, PROCESS: 593) Regards Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Re: Checking in new tapes on new TSM tape library
OK - I tried the command label libvol lb1.1.0.3 checkin=scratch search=bulk labels=barcode and got the errors: 11/08/2006 13:54:24 ANR0984I Process 594 for LABEL LIBVOLUME started in the BACKGROUND at 13:54:24. (SESSION: 7295, PROCESS: 594) 11/08/2006 13:54:24 ANR8799I LABEL LIBVOLUME: Operation for library LB1.1.0.3 started as process 594. (SESSION: 7295, PROCESS: 594) 11/08/2006 13:54:24 ANR8826E No Entry/Exit found on library LB1.1.0.3. (SESSION: 7295, PROCESS: 594) 11/08/2006 13:54:24 ANR0985I Process 594 for LABEL LIBVOLUME running in the BACKGROUND completed with completion state FAILURE at 13:54:24. (SESSION: 7295, PROCESS: 594) Does this mean that there is a problem with the IO slot and I have to place the tape in the cartridges? Regards Paul -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lepre, James Sent: Wednesday, 8 November 2006 1:43 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Checking in new tapes on new TSM tape library Try the checkin command with search=bulk I think that is it - Original Message - From: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To: ADSM-L@VM.MARIST.EDU ADSM-L@VM.MARIST.EDU Sent: Tue Nov 07 21:39:34 2006 Subject: [ADSM-L] Checking in new tapes on new TSM tape library I am trying to check in a new LTO3 tape in our new IBM 3582 TSM tape library that was installed a month ago. However it keeps failing. I would like to know if I am doing it correctly before logging a fault call with IBM. I am placing the new tape with the barcode label on it, in the IO slot on the right side of the unit. The command I execute is: tsm: ANLTSMlabel libvol lb1.1.0.3 818ACFL2 checkin=scratch ANS8003I Process number 593 started. tsm: ANLTSMq pr Process Process DescriptionStatus Number - 593 LABEL LIBVOLUMEANR8804I Labelling volume 818ACFL2 in library LB1.1.0.3. tsm: ANLTSMq req ANR8352I Requests outstanding: ANR8306I 153: Insert LTO volume 818ACFL2 R/W into the slot with element number 4112 of library LB1.1.0.3 within 60 minutes; issue 'REPLY' along with the request ID when ready. The error that appears in the log when it fails is: 11/08/2006 13:28:10 ANR8300E I/O error on library LB1.1.0.3 (OP=8401C058, CC=314, KEY=FF, ASC=FF, ASCQ=FF, SENSE=**NONE**, Description=The source slot or drive was empty in an attempt to move a volume). Refer to Appendix D in the 'Messages' manual for recommended action. (SESSION: 7292, PROCESS: 593) 11/08/2006 13:28:10 ANR8942E Could not move volume 818ACFL2 from slot-element 4112 to slot-element 257. (SESSION: 7292, PROCESS: 593) 11/08/2006 13:28:10 ANR8802E LABEL LIBVOLUME process 593 for library LB1.1.0.3 failed. (SESSION: 7292, PROCESS: 593) Regards Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person. --- Confidentiality Notice: The information in this e-mail and any attachments thereto is intended for the named recipient(s) only. This e-mail, including any attachments, may contain information that is privileged and confidential and subject to legal restrictions and penalties regarding its unauthorized disclosure or other use. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action or inaction in reliance on the contents of this e-mail and any of its attachments is STRICTLY PROHIBITED. If you have received this e-mail in error, please immediately notify the sender via return e-mail; delete this e-mail and all attachments from your e-mail system and your computer system and network; and destroy any paper copies you may have in your possession. Thank you for your cooperation. ANL - CELEBRATING 50
Re: Checking in new tapes on new TSM tape library
It may not be a silly question as this is the first time I have tried to load a new tape in the new 3582 unit. We have an older 3582 unit that uses LTO2 tapes. For that unit I check in tapes using the IO slot on the right side of the unit, loading the tape with the barcode facing out (towards the front of the unit) so I am doing the same for the new 3582 unit that uses LTO3 tapes. The tapes have barcodes on them and I have tried 3 or 4 different tapes. Regards Paul -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David Longo Sent: Wednesday, 8 November 2006 2:06 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Checking in new tapes on new TSM tape library Maybe this is a silly question, but have you placed the tape in the I/O slot correctly? With the barcode facing in? David Longo Paul Dudley [EMAIL PROTECTED] 11/07/06 9:59 PM OK - I tried the command label libvol lb1.1.0.3 checkin=scratch search=bulk labels=barcode and got the errors: 11/08/2006 13:54:24 ANR0984I Process 594 for LABEL LIBVOLUME started in the BACKGROUND at 13:54:24. (SESSION: 7295, PROCESS: 594) 11/08/2006 13:54:24 ANR8799I LABEL LIBVOLUME: Operation for library LB1.1.0.3 started as process 594. (SESSION: 7295, PROCESS: 594) 11/08/2006 13:54:24 ANR8826E No Entry/Exit found on library LB1.1.0.3. (SESSION: 7295, PROCESS: 594) 11/08/2006 13:54:24 ANR0985I Process 594 for LABEL LIBVOLUME running in the BACKGROUND completed with completion state FAILURE at 13:54:24. (SESSION: 7295, PROCESS: 594) Does this mean that there is a problem with the IO slot and I have to place the tape in the cartridges? Regards Paul -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lepre, James Sent: Wednesday, 8 November 2006 1:43 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Checking in new tapes on new TSM tape library Try the checkin command with search=bulk I think that is it - Original Message - From: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To: ADSM-L@VM.MARIST.EDU ADSM-L@VM.MARIST.EDU Sent: Tue Nov 07 21:39:34 2006 Subject: [ADSM-L] Checking in new tapes on new TSM tape library I am trying to check in a new LTO3 tape in our new IBM 3582 TSM tape library that was installed a month ago. However it keeps failing. I would like to know if I am doing it correctly before logging a fault call with IBM. I am placing the new tape with the barcode label on it, in the IO slot on the right side of the unit. The command I execute is: tsm: ANLTSMlabel libvol lb1.1.0.3 818ACFL2 checkin=scratch ANS8003I Process number 593 started. tsm: ANLTSMq pr Process Process DescriptionStatus Number - 593 LABEL LIBVOLUMEANR8804I Labelling volume 818ACFL2 in library LB1.1.0.3. tsm: ANLTSMq req ANR8352I Requests outstanding: ANR8306I 153: Insert LTO volume 818ACFL2 R/W into the slot with element number 4112 of library LB1.1.0.3 within 60 minutes; issue 'REPLY' along with the request ID when ready. The error that appears in the log when it fails is: 11/08/2006 13:28:10 ANR8300E I/O error on library LB1.1.0.3 (OP=8401C058, CC=314, KEY=FF, ASC=FF, ASCQ=FF, SENSE=**NONE**, Description=The source slot or drive was empty in an attempt to move a volume). Refer to Appendix D in the 'Messages' manual for recommended action. (SESSION: 7292, PROCESS: 593) 11/08/2006 13:28:10 ANR8942E Could not move volume 818ACFL2 from slot-element 4112 to slot-element 257. (SESSION: 7292, PROCESS: 593) 11/08/2006 13:28:10 ANR8802E LABEL LIBVOLUME process 593 for library LB1.1.0.3 failed. (SESSION: 7292, PROCESS: 593) Regards Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do
Re: Checking in new tapes on new TSM tape library
Taking a different approach and avoiding the IO slot I have put 5 new tapes into the left cartridge. I then ran the command: label libvol lb1.1.0.3 search=bulk labels=barcode checkin=scratch The same error appeared in the activity log: 11/08/2006 16:06:38 ANR0984I Process 596 for LABEL LIBVOLUME started in the BACKGROUND at 16:06:38. (SESSION: 7295, PROCESS: 596) 11/08/2006 16:06:38 ANR8799I LABEL LIBVOLUME: Operation for library LB1.1.0.3 started as process 596. (SESSION: 7295, PROCESS: 596) 11/08/2006 16:06:38 ANR8826E No Entry/Exit found on library LB1.1.0.3. (SESSION: 7295, PROCESS: 596) 11/08/2006 16:06:38 ANR8802E LABEL LIBVOLUME process 596 for library LB1.1.0.3 failed. (SESSION: 7295, PROCESS: 596) 11/08/2006 16:06:38 ANR0985I Process 596 for LABEL LIBVOLUME running in the BACKGROUND completed with completion state FAILURE at 16:06:38. (SESSION: 7295, PROCESS: 596) Is this the correct command for what I am trying to do? Regards Paul -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David Longo Sent: Wednesday, 8 November 2006 2:06 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Checking in new tapes on new TSM tape library Maybe this is a silly question, but have you placed the tape in the I/O slot correctly? With the barcode facing in? David Longo Paul Dudley [EMAIL PROTECTED] 11/07/06 9:59 PM OK - I tried the command label libvol lb1.1.0.3 checkin=scratch search=bulk labels=barcode and got the errors: 11/08/2006 13:54:24 ANR0984I Process 594 for LABEL LIBVOLUME started in the BACKGROUND at 13:54:24. (SESSION: 7295, PROCESS: 594) 11/08/2006 13:54:24 ANR8799I LABEL LIBVOLUME: Operation for library LB1.1.0.3 started as process 594. (SESSION: 7295, PROCESS: 594) 11/08/2006 13:54:24 ANR8826E No Entry/Exit found on library LB1.1.0.3. (SESSION: 7295, PROCESS: 594) 11/08/2006 13:54:24 ANR0985I Process 594 for LABEL LIBVOLUME running in the BACKGROUND completed with completion state FAILURE at 13:54:24. (SESSION: 7295, PROCESS: 594) Does this mean that there is a problem with the IO slot and I have to place the tape in the cartridges? Regards Paul -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lepre, James Sent: Wednesday, 8 November 2006 1:43 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Checking in new tapes on new TSM tape library Try the checkin command with search=bulk I think that is it - Original Message - From: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To: ADSM-L@VM.MARIST.EDU ADSM-L@VM.MARIST.EDU Sent: Tue Nov 07 21:39:34 2006 Subject: [ADSM-L] Checking in new tapes on new TSM tape library I am trying to check in a new LTO3 tape in our new IBM 3582 TSM tape library that was installed a month ago. However it keeps failing. I would like to know if I am doing it correctly before logging a fault call with IBM. I am placing the new tape with the barcode label on it, in the IO slot on the right side of the unit. The command I execute is: tsm: ANLTSMlabel libvol lb1.1.0.3 818ACFL2 checkin=scratch ANS8003I Process number 593 started. tsm: ANLTSMq pr Process Process DescriptionStatus Number - 593 LABEL LIBVOLUMEANR8804I Labelling volume 818ACFL2 in library LB1.1.0.3. tsm: ANLTSMq req ANR8352I Requests outstanding: ANR8306I 153: Insert LTO volume 818ACFL2 R/W into the slot with element number 4112 of library LB1.1.0.3 within 60 minutes; issue 'REPLY' along with the request ID when ready. The error that appears in the log when it fails is: 11/08/2006 13:28:10 ANR8300E I/O error on library LB1.1.0.3 (OP=8401C058, CC=314, KEY=FF, ASC=FF, ASCQ=FF, SENSE=**NONE**, Description=The source slot or drive was empty in an attempt to move a volume). Refer to Appendix D in the 'Messages' manual for recommended action. (SESSION: 7292, PROCESS: 593) 11/08/2006 13:28:10 ANR8942E Could not move volume 818ACFL2 from slot-element 4112 to slot-element 257. (SESSION: 7292, PROCESS: 593) 11/08/2006 13:28:10
Does TDP for SQL Archive exist?
In TDP for SQL, is there an equivalent backup type to the Archive backup in TSM? Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Re: Weekly, Monthly, Yearly Selectives
Can you explain what you mean by: Also, as others have mentioned before, there's no need to make these monthly/yearly backups a selective(full). You can just make a 12 version 5 version management policy for the monthly yearly backups, respectively. All the backups can be incremental this way, and you save bookoo tapes DB entries (not to mention faster backups). As I have a similar issue. Thanks Paul Dudley -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Troy Frank Sent: Wednesday, 13 September 2006 8:06 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Weekly, Monthly, Yearly Selectives This sounds like a classic request from management that doesn't understand TSM works differently from typical backup software, and they're trying to shoehorn it into behaving as they're used to. If you make your normal retention policy 30 versions or more, you can at least get rid of the weekly/monthly full backups. In our case, we do 60 versions held for 60 days. So if/when we do longer term archives, it would have to be at most bi-monthly. Also, as others have mentioned before, there's no need to make these monthly/yearly backups a selective(full). You can just make a 12 version 5 version management policy for the monthly yearly backups, respectively. All the backups can be incremental this way, and you save bookoo tapes DB entries (not to mention faster backups). [EMAIL PROTECTED] 9/12/2006 4:12 PM Fellow TSM'rs, I have been tasked to provide a backup schedule to provide weekly, monthly, and yearly full backups for a 5 year duration. The weekly would be retained for a month, monthly for a year, and yearly for 5 years. I've created separate policies, nodenames, etc. to keep the policy retentions separate. The problem I have is the actual TSM client schedule on the server. How do I keep the weekly selective backup from running at the end of the month when the monthly selective is supposed to kickoff? Same thing for the monthly at the end of the year when the yearly selective will kickoff? I'm running TSM server 5.3.3.0 and BA 5.3.4 and I see the Enhanced Schedule capability to provide DAYOFWEEK and WEEKOFMONTH to which I can set Saturday as DAYOFWEEK and First,Second,Third as WEEKOFMONTH but some months have 4 weeks while others have 5. Also, I can't set the weekly to be every Saturday BUT the last Saturday of the month and the montly to be every last Saturday BUT the last Saturday of the year. Any suggestions? Regards, Brian Brian Scott EDS Global Client Engineering-GM MS 3234 4594 W Nancy Dr. Kankakee, IL 60901 ( Phone:+1-815-939-2684) + mailto:[EMAIL PROTECTED] Confidentiality Notice follows: The information in this message (and the documents attached to it, if any) is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken, or omitted to be taken in reliance on it is prohibited and may be unlawful. If you have received this message in error, please delete all electronic copies of this message (and the documents attached to it, if any), destroy any hard copies you may have created and notify me immediately by replying to this email. Thank you. ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Restoring TDP for SQL backup onto another server
I have a Windows SQL server which has a large database on it which is being backed up via TDP for SQL (version 5.3). Unfortunately the database is too large to restore back onto a different location on the same server so I have to restore it onto another server. I have another Windows SQL server on which I have installed TSM and TDP for SQL. I am having a lot of problems trying to work out how to restore this database onto the other server using the tdpsqlc restore command. Is there an FAQ or cheat sheet that deals with this subject? Regards Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Restoring TDP for SQL backup onto another server
Hi all, I have a Windows SQL server which has a large database on it which is being backed up via TDP for SQL (version 5.3). Unfortunately the database is too large to restore back onto a different location on the same server so I have to restore it onto another server. I have another Windows SQL server on which I have installed TSM and TDP for SQL. I am having a lot of problems trying to work out how to restore this database onto the other server using the tdpsqlc restore command. Is there an FAQ or cheat sheet that deals with this subject? Regards Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Missing tape volumes
Hi, I have a couple of tape volumes which do not show up via the q vol command but I cannot check them in as scratch tapes (see below). Any ideas? tsm: ANLTSMq vol 915ACFL2 ANR2034E QUERY VOLUME: No match found using this criteria. ANS8001I Return code 11. tsm: ANLTSMcheckin libvol lb1.1.0.2 915ACFL2 status=scratch ANR8443E CHECKIN LIBVOLUME: Volume 915ACFL2 in library LB1.1.0.2 cannot be assigned a status of SCRATCH. ANS8001I Return code 12. tsm: ANLTSMq vol 943ACFL2 ANR2034E QUERY VOLUME: No match found using this criteria. ANS8001I Return code 11. tsm: ANLTSMcheckin libvol lb1.1.0.2 943ACFL2 status=scratch ANR8443E CHECKIN LIBVOLUME: Volume 943ACFL2 in library LB1.1.0.2 cannot be assigned a status of SCRATCH. ANS8001I Return code 12. Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Re: Missing tape volumes
Yes it is a DB backup. Thanks Paul -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Len Boyle Sent: Wednesday, 9 August 2006 10:01 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Missing tape volumes Hello Paul, Check out the query volhist command, or look at the volhist file, and see if the tape is listed as one of the special use tapes. That is it was used as a database backup tape, or export tape, or len -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Paul Dudley Sent: Tuesday, August 08, 2006 7:51 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Missing tape volumes Hi, I have a couple of tape volumes which do not show up via the q vol command but I cannot check them in as scratch tapes (see below). Any ideas? tsm: ANLTSMq vol 915ACFL2 ANR2034E QUERY VOLUME: No match found using this criteria. ANS8001I Return code 11. tsm: ANLTSMcheckin libvol lb1.1.0.2 915ACFL2 status=scratch ANR8443E CHECKIN LIBVOLUME: Volume 915ACFL2 in library LB1.1.0.2 cannot be assigned a status of SCRATCH. ANS8001I Return code 12. tsm: ANLTSMq vol 943ACFL2 ANR2034E QUERY VOLUME: No match found using this criteria. ANS8001I Return code 11. tsm: ANLTSMcheckin libvol lb1.1.0.2 943ACFL2 status=scratch ANR8443E CHECKIN LIBVOLUME: Volume 943ACFL2 in library LB1.1.0.2 cannot be assigned a status of SCRATCH. ANS8001I Return code 12. Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person. ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
SQL Meta copy storage pool
We currently have our primary and copy storage pools for SQL backups as follows: Primary Copy SQLDB_DISKPOOL SQLDB_COPYPOOL SQLDB_TAPEPOOL SQLDB_COPYPOOL SQLMETA_DISKPOOLSQLMETA_COPYPOOL Is there any problem if I change the SQLMETA_DISKPOOL so that it's copy storage pool is also SQLDB_COPYPOOL? Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
TSM server crash
I wonder if anyone else has had a similar issue... We have a TSM server (5.2) running on a Windows 2000 server. This runs on an IBM x346 hardware. This server also has IBM Storage Management software on it which has been happily running on there for around a year. Today I also installed IBM Director on this server. To complete the installation we have to reboot the server. Upon reboot the server now crashes just as it finishes starting up Windows with unexpected_kernel_mode_trap on the blue screen of death... If we boot up the server in safe mode it boots up OK however we cannot get any TSM services to run, and it won't let me un-install IBM Director. We took all the hard disks out of this x346 and put them in another x346 to boot up but the same error occurred. As we can see the TSM data storage disks (the D and the E drive) when we boot up in safe mode we would rather not blow everything away by re-installing Windows and having to recreate TSM from scratch and restore all the data from the tapes. I realise that this is mainly a Windows issue now, but if anyone else was in a similar situation with their TSM server I would like to know if you were able to get around it. Thanks Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Paramter missing in tdpsqlc restore command
I am running the following tdpsqlc command and get a parameter missing error - possibly after /relocate - can anyone point me in the right direction as to what I may be missing? I am trying to restore a database from another server to a different location on this server tdpsqlc restore Sales2000 full /fromsqlserver=nt_sales2_database /relocate /to=n:\Database\MSSQL\Data\Sales2000_Data.mdf Regards Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
TDP for SQL - restoring to different server
We have just started using TDP for SQL (version 5.2.1) I need to restore an SQL database backup from 7 days ago to another Windows server. I have a few questions regarding this. If I install TSM and TDP for SQL on another Windows server, does the server I restore it too have to have SQL installed on it? All I want to do initially is get the db file onto a server so that we can then move it to wherever we want. How do I specify the 7 day old database backup in the tdpsqlc command? I have run a tdpsqlc query on the original SQL server and I know what the database object name is of the database backup from 7 days ago. Regards Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
TDP for SQL error
We have TSM server 5.2 and have installed TDP for SQL on a client. We can run manual full and differential SQL backups OK using the GUI, however we cannot get scheduled backups working. We have registered the license using the command: Reg lic file(mssql.lic) Number=4 The output of the q lic command includes the entries: Number of TDP for MS SQL Server in use: 1 Number of TDP for MS SQL Server licensed: 4 The error from the TSM activity log is as follows: 06/22/2006 23:33:23 ANR2579E Schedule SQL_FULL_BACKUPS in domain STANDARD for node DEVSQL_DATABASE failed (return code 1900). Any suggestions? Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
TSM for SQL
We are about to purchase TSM licenses so that we can backup or SQL server databases on our Windows server clients direct to TSM. Is there an FAQ or guide available on how to do this? Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
q vol and q libvol
Rather than going back and forth between the output of the q vol and q libvol commands is there a command that would give me the output from the q vol command but only for those tape volumes that show up in the q libvol command? Regards Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Re: Deleting archives
Sorry if I was not clear - I mean where the client is a linux server. Using the GUI via IE is a bit flaky - I can delete one archive then when I try to do a second it locks up and I have to kill dsmcad and restart it on the client then try again. Regards Paul On Fri, 2 Jun 2006 07:12:25 -0400 Richard Sims [EMAIL PROTECTED] wrote: On Jun 1, 2006, at 7:19 PM, Paul Dudley wrote: I know that I can delete archives via the Backup-Archive GUI using the Delete Archives option. Is it possible on a linux server to also delete these at a command line level? It's not clear what you're asking, as linux server is ambiguous... If you mean that the archiving client is accessing a TSM server which runs on Linux, and you seek to issue some kind of TSM server command to delete some Archive files, then no, there is no capability for that (because it would violate ownership and control conventions). You can perform client actions from a node different from the one which stored the files in TSM, via the means summarized in the client manual (Set Access and Virtualnodename, and maybe Proxy Node), presuming that the clients are the same OS type. Richard Sims http://people.bu.edu/rbs Paul Dudley ANL IT Operations [EMAIL PROTECTED] 61-3-9257-0603 ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Deleting archives
I know that I can delete archives via the Backup-Archive GUI using the Delete Archives option. Is it possible on a linux server to also delete these at a command line level? Regards Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Expire archive question
By mistake I have run some client archive backups which are not required. There was no expiration date set in the client schedule for these archive backups. Is there any way to expire or delete these archive backups? Thanks in advance. Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
reclaimation question
I have a question regarding the reclaimation process (hopefully not a stupid one). Does the reclaimation process work logically or physically? Ie: If I have a private tape that is marked as being Offsite, will the reclaimation happen at a logical database level or will I have to update the tape from being Offsite to access Read/Write and check the tape in to the tape library for the reclaimation process to work on that tape? Regards Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Migration questions
We have TSM 5.2 I would like some advice as to what can automatically trigger a migration process and what settings to look for. We have scheduled migration processes every weekday afternoon however I have two migration processes that have started this morning for some reason. Thanks Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Resend - Policy and DRP question
I sent this query a week ago but have not received a reply back. I am resending in the hope that someone can offer some advice. We have TSM version 5.2 I have changed the standard policy so that we now keep the 10 latest versions of each file rather than 7. I have also changed our del volhist to tod=today-10 where it was previously 7. I have been told that previously we had to keep the 7 latest copy tapes and db tapes offsite for DRP to ensure that we could recover complete servers. With the changes that I have made does this mean that we have to now keep the 10 latest tapes offsite for complete DRP? Paul Dudley ANL IT Operations Dept. [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Sending of object failed
One of the windows servers we back up via TSM has been showing the errors below in the log for the past couple of days. 04/06/2006 19:50:04 ANS1228E Sending of object '\\qmaster\c$\adsm.sys\EVENTLOG' failed 04/06/2006 19:50:04 ANS1228E Sending of object '\\qmaster\c$\adsm.sys\WMI' failed 04/06/2006 19:50:04 ANS1228E Sending of object '\\qmaster\c$\adsm.sys\xml.state' failed These seem to be TSM related files. Any idea why it would start failing on these files all of a sudden? Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Policy and DRP question
We have TSM version 5.2 I have changed the standard policy so that we now keep the 10 latest versions of each file rather than 7. I have also changed our del volhist to tod=today-10 where it was previously 7. I have been told that previously we had to keep the 7 latest copy tapes and db tapes offsite for DRP to ensure that we could recover complete servers. With the changes that I have made does this mean that we have to now keep the 10 latest tapes offsite for complete DRP? Paul Dudley ANL IT Operations Dept. [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Re: dsmcad stops on linux servers
It seems that when I finish using the Backup-Archive GUI via Internet Explorer and then close IE this http process at the linux level hangs around for a while then dies, and takes the dsmcad process with it. Regards Paul -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Remco Post Sent: Thursday, 30 March 2006 5:33 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] dsmcad stops on linux servers Paul Dudley wrote: We have TSM Server and clients 5.2 On our Red Hat linux AS 3.0 clients I find that after I use the Backup-Archive GUI via Internet Explorer to perform backups or restores, the dsmcad process on that linux server dies within an hour or so. Is there any way to stop this from happening? I've never seen this happening. So I guess your plan is: 1- upgrade to the latest greatest client level 2- reproduce the problem (might be fixed?) 3- if it isn't fixed, call IBM (or, of course just use the cli, but then again, that's only a work-around, and you might not want to) Thanks Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] -- Met vriendelijke groeten, Remco Post SARA - Reken- en Netwerkdiensten http://www.sara.nl High Performance Computing Tel. +31 20 592 3000Fax. +31 20 668 3167 PGP Key fingerprint = 6367 DFE9 5CBC 0737 7D16 B3F6 048A 02BF DC93 94EC I really didn't foresee the Internet. But then, neither did the computer industry. Not that that tells us very much of course - the computer industry didn't even foresee that the century was going to end. -- Douglas Adams ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
dsmcad stops on linux servers
We have TSM Server and clients 5.2 On our Red Hat linux AS 3.0 clients I find that after I use the Backup-Archive GUI via Internet Explorer to perform backups or restores, the dsmcad process on that linux server dies within an hour or so. Is there any way to stop this from happening? Thanks Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Reclaimation process keeps starting
We use TSM 5.2. I have a reclaimation process which is an automated scheduled job. It started today and I needed to cancel it, so I did using the can process command. I have also changed the status of this process from Active=Yes to Active=No. However this process keeps starting again after an hour or so, despite me having cancelled it and the schedule being updated to Active=No. WHY Regards Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Re: Full backup direct from client server
I know how to define a schedule against a node - how do I define another node client in the same TSM client? Regards Paul -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Francisco Molero Sent: Sunday, 5 February 2006 9:55 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Full backup direct from client server Hi Paul, you can define another node client in your TSM client and define a copygroup with backup mode absolute. Then you need to define a scheduler against this node. So, you have a full backup. --- Paul Dudley [EMAIL PROTECTED] escribió: Is it possible to schedule a full client server backup onto tape where the data comes direct from the client server? From my understanding of the gen backupset command it appears that it grabs the server data from existing backups already on tape. I would prefer to get the data direct from the client server as I have had a lot of problems with the gen backupset command. Thanks in advance Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person. __ LLama Gratis a cualquier PC del Mundo. Llamadas a fijos y móviles desde 1 céntimo por minuto. http://es.voice.yahoo.com ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
TSM licensing question
I have been told that TSM licensing is done by number of CPU's not number of servers. If we have a number of virtual servers on VM Ware systems, is the TSM licensing calculated by the number of physical CPU's or the number of virtual CPU's? Regards Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Can .net and TSM co-exist?
We have TSM version 5.2 installed on a Windows 2000 server. We would like to install Microsoft .NET framework on the same server. Has anyone encountered any problems with this or know of any reason why we should not do this? Thanks Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Full backup direct from client server
Is it possible to schedule a full client server backup onto tape where the data comes direct from the client server? From my understanding of the gen backupset command it appears that it grabs the server data from existing backups already on tape. I would prefer to get the data direct from the client server as I have had a lot of problems with the gen backupset command. Thanks in advance Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Re: Full backup direct from client server
If I understand you correctly you are suggesting creating an extra node client on the TSM server. We are already at the limit of client licenses so this is not possible at the moment. Regards Paul -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Francisco Molero Sent: Sunday, 5 February 2006 9:55 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Full backup direct from client server Hi Paul, you can define another node client in your TSM client and define a copygroup with backup mode absolute. Then you need to define a scheduler against this node. So, you have a full backup. --- Paul Dudley [EMAIL PROTECTED] escribió: Is it possible to schedule a full client server backup onto tape where the data comes direct from the client server? From my understanding of the gen backupset command it appears that it grabs the server data from existing backups already on tape. I would prefer to get the data direct from the client server as I have had a lot of problems with the gen backupset command. Thanks in advance Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person. __ LLama Gratis a cualquier PC del Mundo. Llamadas a fijos y móviles desde 1 céntimo por minuto. http://es.voice.yahoo.com ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Backupset question
We have TSM server and clients version 5.2 We have generated some backupsets of clients onto tape. The retention was set to 120 days. Not all the backupsets that we wanted created were created. Is it possible to delete these backupsets so that the tapes can be re-used? I would like to try and work out why the rest of the backupsets were not created and re-do them all. Regards Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Backup larger than data on server
We have TSM version 5.2. The client server I am referring to here is Redhat linux. In the /var/log/tsm/dsmsched.log it lists Total number of bytes transferred:79.18 GB However there is only around 60 Gb of data on the server (see df below) FilesystemSize Used Avail Use% Mounted on /dev/sda1 9.7G 2.1G 7.1G 23% / /dev/sdb2 104G 57G 43G 58% /opt Can someone explain why the number of bytes transferred exceeds the amount of data on the server? Thanks Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
gen backupset question
In the gen backupset command there is an option to nominate the volumes that will contain this backupset. If I enter a couple of tape names here (ie: tape01, tape02) and both those tapes are filled, what happens to the generation of the backupset? Does it fail or does it go and find a scratch tape to write to? Regards Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
List of compatible unix OS for TSM 5.2
Our TSM server is version 5.2. My manager wants to know if we can use TSM to backup an old Digital AS4100 server running Digital unix 4.0D. Where can I find a list of compatible unix OS for TSM? Regards Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
TSM service on linux client
I have installed TSM 5.2 on a RH linux AS 3.0 server. To install it I performed the following steps: Used rpm -i to install the two rpm packages. rpm -i TIVsm-API.i386.rpm rpm -i TIVsm-BA.i386.rpm Created the dsm.sys and dsm.opt files. Created the environment variables by adding these to a .profile file. export DSM_CONFIG=/opt/tivoli/tsm/client/ba/bin/dsm.opt export DSM_DIR=/opt/tivoli/tsm/client/ba/bin I run the command dsmcad to start the tsm service however it does not start the TSM service (when I run the command service tsm status I get the error Unrecognised service.) Is there a step I am missing either on the linux client or on the TSM server? There is a schedule created for this client on the TSM service as well as a client node. I have other clients (both Windows and linux) being backed up successfully via the TSM server. I am able to run a manual incremental backup from the linux client by running the command dsmc incr Regards Paul Paul Dudley ANL IT Operations Dept. [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Missing tape in TSM 5.2
Subject: Missing tape in TSM 5.2 Running TSM 5.2, I have a tape that is not defined in a storage pool yet I cannot check it in with a status of scratch. If I check it in with a status of private I then cannot do anything with it. When I run the q volhist type=all command it shows up as a volume type STGDELETE. How can I get it back to a useful state? Regards Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Re: Missing tape in TSM 5.2
It shows the following: tsm: ANLTSMq drm Volume Name State Last Update Automated Date/Time LibName - --- 084ACFL2 Vault retrieve09/30/2005 06:51:31 905ACFL2 Vault 09/26/2005 07:22:03 913ACFL2 Mountable 10/03/2005 09:00:38 LB1.1.0.2 914ACFL2 Vault 08/19/2005 21:03:23 909ACFL2 Mountable 10/03/2005 09:00:37 LB1.1.0.2 092ACFL2 Mountable 10/03/2005 07:15:39 LB1.1.0.2 900ACFL2 Mountable 09/30/2005 09:00:36 LB1.1.0.2 910ACFL2 Mountable 09/30/2005 07:15:25 906ACFL2 Mountable 09/29/2005 09:00:37 LB1.1.0.2 083ACFL2 Mountable 09/28/2005 09:00:36 LB1.1.0.2 916ACFL2 Mountable 09/28/2005 07:15:11 The tape in question is the bottom one - 916ACFL2. Regards Paul -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Meadows, Andrew Sent: Monday, 3 October 2005 2:36 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Missing tape in TSM 5.2 If you do a q drm does it show there? -Original Message- From: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To: ADSM-L@VM.MARIST.EDU ADSM-L@VM.MARIST.EDU Sent: Sun Oct 02 23:22:48 2005 Subject: Missing tape in TSM 5.2 Subject: Missing tape in TSM 5.2 Running TSM 5.2, I have a tape that is not defined in a storage pool yet I cannot check it in with a status of scratch. If I check it in with a status of private I then cannot do anything with it. When I run the q volhist type=all command it shows up as a volume type STGDELETE. How can I get it back to a useful state? Regards Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person. This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
IBM 3582 and cleaning tapes
We have TSM 5.2 with an IBM 3582 LTO2 tape library. I followed the instructions in the IBM 3582 manual to configure a cleaning slot and then configure autoclean for this unit. I then tried to checkin a cleaning tape using the command: checkin libvol lb1.1.0.2 CLNU31L1 status=Cleaner Cleanings=50 Upon which I received the following errors: ANRD mmsscsi.c(8417): ThreadId36 Element address mismatch; slotInfo.elem = 4118, slotInv.addr = 0 Callchain: 10500D79 outTextf()+1529 - 1036B851 tsmInitializeServer()+364031 - (SESSION: 1262, PROCESS: 45) ANR8310E An I/O error occurred while accessing library LB1.1.0.2. (SESSION: 1262, PROCESS: 45) ANR8426E CHECKIN LIBVOLUME for volume CLNU31L1 in library LB1.1.0.2 failed. (SESSION: 1262, PROCESS: 45) Any idea what may have caused this? I am I going about this the right way? What I want to do is checkin or insert a cleaning tape and set up auto cleaning for this tape unit. Thanks Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.