Hi,

I am trying to update the stroage pool but not able to reach to right syntax. actually in my case old tape which is now offsite/not availble in the library still it is showing under storage pool which looks really messy. I would like to know is there a way to update that so that only those which is available in the library and assigned to that specific pool that only visible.

Let me share the snapshot for better understanding.

tsm: ITSM01>q v stg=sqldbpool

Volume Name               Storage      Device      Estimated    Pct   Volume
                          Pool Name    Class Name   Capacity   Util   Status
------------------------  -----------  ----------  ---------  -----  --------
CI2982L4                  SQLDBPOOL    LTO_CLASS       3.2 T    0.1    Full
CI2998L4                  SQLDBPOOL    LTO_CLASS     843.2 G   36.5    Full
KG1646L4                  SQLDBPOOL    LTO_CLASS       4.3 T    6.9    Full
KG1650L4                  SQLDBPOOL    LTO_CLASS       1.6 T    7.5  Filling
KG1651L4                  SQLDBPOOL    LTO_CLASS       3.6 T   14.4    Full
KG3852L4                  SQLDBPOOL    LTO_CLASS       4.3 T    1.7    Full
KG5041L4                  SQLDBPOOL    LTO_CLASS       1.6 T    0.1  Filling
KG5061L4                  SQLDBPOOL    LTO_CLASS       0.0 M    0.0   Empty
KG5063L4                  SQLDBPOOL    LTO_CLASS       0.0 M    0.0   Empty
KG5064L4                  SQLDBPOOL    LTO_CLASS       3.6 T   12.6    Full
KG5065L4                  SQLDBPOOL    LTO_CLASS       2.6 T   15.9  Filling
KG5066L4                  SQLDBPOOL    LTO_CLASS       3.9 T   12.2    Full
KG5067L4                  SQLDBPOOL    LTO_CLASS       0.0 M    0.0   Empty
KG5068L4                  SQLDBPOOL    LTO_CLASS       3.0 T   20.8  Filling
MY5194L4                  SQLDBPOOL    LTO_CLASS       0.0 M    0.0   Empty
MY5198L4                  SQLDBPOOL    LTO_CLASS       2.6 T    9.9    Full
MY5200L4                  SQLDBPOOL    LTO_CLASS     816.9 G    2.3    Full

Assigned tape currently to that pool which is available in the library.

tsm: ITSM01>q v stg=sqldbpool access=readwrite

Volume Name               Storage      Device      Estimated    Pct   Volume
                          Pool Name    Class Name   Capacity   Util   Status
------------------------  -----------  ----------  ---------  -----  --------
KG1646L4                  SQLDBPOOL    LTO_CLASS       4.3 T    6.9    Full
KG1650L4                  SQLDBPOOL    LTO_CLASS       1.6 T    7.5  Filling
KG5041L4                  SQLDBPOOL    LTO_CLASS       1.6 T    0.1  Filling

Please tell me the way out if any applicable.

 

Regards

Prem

 

 

 

 

Hi Guys,

Waiting for your response.

 

Prem

Empty tapes, you can delete. The others you have to collect from offsite storage to get control of.

 

Rgd.

Espen

Hi Espen,

I can't put it back from offsite due to company compliance requirement other option you suggested  to delete it,  I doubt in case near future i need that will it recognize because we are deleting volume information. according to my undérstanding it will not read after deleting volume information. pls advice accordingly will follow instruction.

 

Regards

Prem

For the volumes you are sure will never be available, you should run this (data will be lost!, unless you have a copypool with the data available?):

update volume <volume_name> access=destroyed

...now you can restore volume from copypool if available. If not:

delete volume <volume_name> discarddata=yes

 

 

Rgd.

Espen

Hello Prem,

If I understand you well.... there is no way to set the option to only show the volumes who are onsite by default.  But you can use the     q vol stg=stgpool access=readwrite,readonly

You can put this command in a script if you want
def scr q.vol "q vol stg=$1 access=readwrite,readonly"

run q.vol stgpoolname

Or use a select to combine volumes and libvolumes table, to show only the volumes who are in the library.

 

Regards,

Maurice

Hi Maurice,

Thanks for the response, I supply the command q vol stg=stgpool access=readwrite but still i can see few tapes after that command also which is offsite.

 

Thanks

Prem

That should not be the case..... can you check those tapes with
q volume [volumename] f=d
and see if they are indeed marked as offsite?

I assume that the status is readwrite, even if the volume is not in the library.

Regards,

Maurice

Hi Maurice,

That's correct but not completly few are readw but few are showing unavailable that is also showing over there.

 

Regards

Prem

hi,

if i uderstatnd better SQLDBPOOL  is a primary stg pool? in this case u need to implement a copy storage pool and take copy off site ( by the book).

if you dont have resource for ...i can disscuse latter for option.

Hi Bogdan,

Yes you are right, that is a primary storage pool for SQLDB backup and I don't have resource to create copy storagepool for the same.

 

Regards

Prem

i will straith answer at your Q

-is not posible to hide volume from stgpool u can only change status a volume,

ex:  update volume HMR000L4 access=offsite

also u can see tape from library.

I am late into this discussion. It sounds like you have tapes marked as offsite but they really are not copy tapes.
Are you manually marking these tapes off-site and/or unavailable?
Do you have a script running that puts them in this state at some point?
Are you actually checking them out of the library and keeping them on-site?
Is your end goal to keep the tapes with data for retention issues and not necessarily show up when you do a query on the storagepool?

In order to give you the right resolution, I need more information. If you are keeping them in the library, you will eventually run out of space of tapes you don’t actively need.

Do you run expiration and/or reclamation to consolidate these tapes?

Brenda

Hi Brenda,

Thank you very much for the response, Let me answer all your query one by one.

1.are you manually marking these tapes off-site and/or unavailable? - No I am not , I am just performing a checkout command.

2. Do you have a script running that puts them in this state at some point?- No scripts as such.

3. Are you actually checking them out of the library and keeping them on-site?- Yes

4. Is your end goal to keep the tapes with data for retention issues and not necessarily show up when you do a query on the storagepool?- My goal is according to auditor we have to take checkout the tapes from library and put it on vault for safer side.(If any mishappening happened in DC)

5. In order to give you the right resolution, I need more information.  If you are keeping them in the library, you will eventually run out of space of tapes you don’t actively need.  - I am not keeping then in Library.

6. Do you run expiration and/or reclamation to consolidate these tapes?- No

 

Please let me know if i missed something to update. I will wait for your further input.

 

Regards

Prem

you make backup on internal TSM database on tape? if not in case of lost your tsm instance you cannot restore data from off site tape.!!!

Ps: if you only check out tape from library and not update status of volume in storage pool is correct to view all tape in storage pool white status = R/W

Hi Bodgan,

Thank you for your continuous response I am not able to understand below point.

1. you make backup on internal TSM database on tape? if not in case of lost your tsm instance you cannot restore data from off site tape.!!!- you are pointing to tsm db backup which right now I am taking only on local drive, you are suggesting to move on tape also, this is what you are suggesting. and what do you mean by that lost your tsm instance you cannot restore data from off site tape.

2. if you only check out tape from library and not update status of volume in storage pool is correct to view all tape in storage pool white status = R/W- you mean after checking out i should update the volume to offsite. please correct me if i am wrong.

 

Regards

Prem

In Reply to Prem Singh:

Hi Bodgan,

Thank you for your continuous response I am not able to understand below point.

1. you make backup on internal TSM database on tape? if not in case of lost your tsm instance you cannot restore data from off site tape.!!!- you are pointing to tsm db backup which right now I am taking only on local drive, you are suggesting to move on tape also, this is what you are suggesting = YES. and what do you mean by that lost your tsm instance you cannot restore data from off site tape. = OFF SITE tape do no contain table of contents , in this case when you lose db2 database and storage disk failure can happend how you restore TSM server instance DB?

2. if you only check out tape from library and not update status of volume in storage pool is correct to view all tape in storage pool white status = R/W- you mean after checking out i should update the volume to offsite. please correct me if i am wrong.  yes need update manually.

 

Regards

Prem

 

Hi,

Thanks for the prompt response.

1. DB backup for last 7 days it is automated and moving into different location/server also. But I will adopt this suggestion also to move the db backup into tape also, technically sounds good and I feel i missed a important part.

2. As you said updating the v manually what you suggest and what is the best practice to update as a volume access=offsite/unavailable or something else.

upd v volumename access=offsite( This is correct syntax which i should follow)

 

Regards

Prem

In Reply to Prem Singh:

 

Hi,

Thanks for the prompt response.

1. DB backup for last 7 days it is automated and moving into different location/server also. But I will adopt this suggestion also to move the db backup into tape also, technically sounds good and I feel i missed a important part.

2. As you said updating the v manually what you suggest and what is the best practice to update as a volume access=offsite/unavailable or something else.

upd v volumename access=offsite( This is correct syntax which i should follow)  yes it is the correct syntax

 

Regards

Prem

Hi Bogdan,

I tried today to checkout the tape first then run below command but getting some error. This is pointing I don't have copy storage pool or it doesn't belong to any device class.

tsm: ITSM01>upd v kg5070l4 access=offsite
ANR2117E UPDATE VOLUME: Access mode for volume KG5070L4 cannot be changed to
"offsite" - volume either does not belong to a copy storage pool or from a
device class of DEVTYPE=SERVER.
ANR2212I UPDATE VOLUME: No volumes updated.

 

Regards

Prem

In Reply to Prem Singh:

Hi Bogdan,

I tried today to checkout the tape first then run below command but getting some error. This is pointing I don't have copy storage pool or it doesn't belong to any device class.

tsm: ITSM01>upd v kg5070l4 access=offsite
ANR2117E UPDATE VOLUME: Access mode for volume KG5070L4 cannot be changed to
"offsite" - volume either does not belong to a copy storage pool or from a
device class of DEVTYPE=SERVER.=== WRONG!
ANR2212I UPDATE VOLUME: No volumes updated.

 

Regards

Prem

 

U use a wrong device class. Use the LTO device class when you are using LTO tape devices.

 NR2117E: Command: Access mode for volume volume name cannot be changed to "offsite" - volume either does not belong to a copy storage pool or from a device class of DEVTYPE=SERVER.
Explanation

The access mode for the indicated volume cannot be changed to offsite because the volume either does not belong to a copy storage pool or is of a device class with a DEVTYPE of SERVER.
System action

The access mode for this volume is not changed.
User response

None.

You cannot mark a primary tape volume to be ‘access=offsite’. The option are to use the ‘move media’ command or update volume as this:

Update v kg50714 acc=unav loc=offsite

If you are only checking out full tapes, you could do this:

Update v kg50714 acc=unav loc=offsite wherestatus=full



From: Bogdan Ene [mailto:storage-ti@lists.imwuc.org]
Sent: Tuesday, November 01, 2016 3:21 AM
To: storage-ti@lists.imwuc.org
Subject: [storage-ti] - RE: Process to update the storagepool



In Reply to Prem Singh:

Hi Bogdan,

I tried today to checkout the tape first then run below command but getting some error. This is pointing I don't have copy storage pool or it doesn't belong to any device class.

tsm: ITSM01>upd v kg5070l4 access=offsite
ANR2117E UPDATE VOLUME: Access mode for volume KG5070L4 cannot be changed to
"offsite" - volume either does not belong to a copy storage pool or from a
device class of DEVTYPE=SERVER.=== WRONG!
ANR2212I UPDATE VOLUME: No volumes updated.



Regards

Prem



U use a wrong device class. Use the LTO device class when you are using LTO tape devices.

-----End Original Message-----
[CONFIDENTIALITY AND PRIVACY NOTICE] Information transmitted by this email is proprietary to Medtronic and is intended for use only by the individual or entity to which it is addressed, and may contain information that is private, privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please delete this mail from your records. To view this notice in other languages you can either select the following link or manually copy and paste the link into the address bar of a web browser: http://emaildisclaimer.medtronic.com

In Reply to Brenda Collins:

You cannot mark a primary tape volume to be ‘access=offsite’. The option are to use the ‘move media’ command or update volume as this:
YES, is true  when i wright this i have in mind offsite = copy stg  pool :)
Update v kg50714 acc=unav loc=offsite

If you are only checking out full tapes, you could do this:

Update v kg50714 acc=unav loc=offsite wherestatus=full



From: Bogdan Ene [mailto:storage-ti@lists.imwuc.org]
Sent: Tuesday, November 01, 2016 3:21 AM
To: storage-ti@lists.imwuc.org
Subject: [storage-ti] - RE: Process to update the storagepool



In Reply to Prem Singh:

Hi Bogdan,

I tried today to checkout the tape first then run below command but getting some error. This is pointing I don't have copy storage pool or it doesn't belong to any device class.

tsm: ITSM01>upd v kg5070l4 access=offsite
ANR2117E UPDATE VOLUME: Access mode for volume KG5070L4 cannot be changed to
"offsite" - volume either does not belong to a copy storage pool or from a
device class of DEVTYPE=SERVER.=== WRONG!
ANR2212I UPDATE VOLUME: No volumes updated.



Regards

Prem



U use a wrong device class. Use the LTO device class when you are using LTO tape devices.

-----End Original Message-----
[CONFIDENTIALITY AND PRIVACY NOTICE] Information transmitted by this email is proprietary to Medtronic and is intended for use only by the individual or entity to which it is addressed, and may contain information that is private, privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please delete this mail from your records. To view this notice in other languages you can either select the following link or manually copy and paste the link into the address bar of a web browser: http://emaildisclaimer.medtronic.com

Prem,

If you are saving everything, why are you doing it this way? If the auditor is looking to have tapes for disaster recovery purposes, they are looking at this wrong. If you are doing all of these processes manually, you are creating a nightmare for yourself to manage.


· In doing this, you will have your tapes sitting in a vault when something might be required for a restore, causing delays for any immediate system recovery that may need to be done. You may not know all the tapes required for the restore so that will delay the process even longer. (This is not an easy task!)

· You also can never use reclamation to make better utilization of your tapes. As a result, as data expires, your tapes may only have a small utilization but will always stay off-site because there is no automated process to know when to bring the tapes back. This will lead to increased tape costs.

· None of the tapes will do you any good if you do not also have a copy of the TSM database backup. This would need to be kept up daily as well.

I am attaching a document that gives you a couple options to consider if you are forced to do this but I think you need to reconsider what you are doing.

The simplest way to protect your environment is to implement the Disaster Recovery options for TSM. This will create copies of your data on a daily basis, check the tapes out of the library, run a database backup and check them out of the library as well. Then you can schedule a daily pickup of your tapes to send to a vault for protection. You can create a tape list to be generated daily on what tapes need to go off-site vs. what needs to be brought back.

This will still allow you to run reclamation as well to make better use of your tapes. Only having one copy of the tape is risky and very hard to manage if you need long term retention.

If you need more information from me, please let me know. You can review the commands I sent by looking them up in the TSM Admin Reference Guide.

Brenda

Brenda,

I thank you very much for the detailed response, I am glad. I am attaching few snapshot and the new update is from yesterday onwards db, volhistory and devconfig backup i started moving into tape also. My retention period is 30 days as per company norms. additionally I can see  reclamition is running but i can't see the percentage configure for reclamation . you can see reclamation worked earlier.

tsm: ITSM01>q stg vmpool f=d

 

               Storage Pool Name: VMPOOL

               Storage Pool Type: Primary

               Device Class Name: LTO_CLASS_1

              Estimated Capacity: 40,147 G

              Space Trigger Util:

                        Pct Util: 13.6

                        Pct Migr: 54.5

                     Pct Logical: 99.8

                    High Mig Pct: 90

                     Low Mig Pct: 70

                 Migration Delay: 0

              Migration Continue: Yes

             Migration Processes: 1

           Reclamation Processes: 1

               Next Storage Pool:

            Reclaim Storage Pool:

          Maximum Size Threshold: No Limit

                          Access: Read/Write

                     Description: Vmware Image Level backup

               Overflow Location:

           Cache Migrated Files?:

                      Collocate?: Group

           Reclamation Threshold: 60

       Offsite Reclamation Limit:

 Maximum Scratch Volumes Allowed: 9

  Number of Scratch Volumes Used: 2

   Delay Period for Volume Reuse: 0 Day(s)

          Migration in Progress?: No

            Amount Migrated (MB): 0.00

Elapsed Migration Time (seconds): 0

        Reclamation in Progress?: No

  Last Update by (administrator): ADMIN

           Last Update Date/Time: 08/03/2016 15:22:10

        Storage Pool Data Format: Native

            Copy Storage Pool(s):

             Active Data Pool(s):

         Continue Copy on Error?: Yes

                        CRC Data: No

                Reclamation Type: Threshold

     Overwrite Data when Deleted:

more...   (<ENTER> to continue, 'C' to cancel) c

 

Output to screen cancelled.  Please wait for the 'tsm>' prompt.

 

tsm: ITSM01>q stg sqldbpool f=d

 

               Storage Pool Name: SQLDBPOOL

               Storage Pool Type: Primary

               Device Class Name: LTO_CLASS

              Estimated Capacity: 27,865,474 G

              Space Trigger Util:

                        Pct Util: 0.0

                        Pct Migr: 0.1

                     Pct Logical: 100.0

                    High Mig Pct: 90

                     Low Mig Pct: 70

                 Migration Delay: 0

              Migration Continue: Yes

             Migration Processes: 1

           Reclamation Processes: 1

               Next Storage Pool:

            Reclaim Storage Pool:

          Maximum Size Threshold: No Limit

                          Access: Read/Write

                     Description:

               Overflow Location:

           Cache Migrated Files?:

                      Collocate?: Group

           Reclamation Threshold: 60

       Offsite Reclamation Limit:

 Maximum Scratch Volumes Allowed: 9,999

  Number of Scratch Volumes Used: 2

   Delay Period for Volume Reuse: 0 Day(s)

          Migration in Progress?: No

            Amount Migrated (MB): 0.00

Elapsed Migration Time (seconds): 0

        Reclamation in Progress?: No

  Last Update by (administrator): PREM

           Last Update Date/Time: 10/15/2016 09:41:16

        Storage Pool Data Format: Native

            Copy Storage Pool(s):

             Active Data Pool(s):

         Continue Copy on Error?: Yes

                        CRC Data: No

 

Regards

Prem

percentage configure for reclamation is 60.

Brenda and me sugesting you to define a copy storage pool and implement a DR plan for off site. 

please cons. that

Yes, that is the final answer if you want to really be prepared for Disaster Recovery.

Prem,

I am glad the information helped. See below, I highlighted what you should become familiar with for settings.

I am guessing this is a very new or small environment due to the amount of tapes in use. Remember that reclamation uses 2 tape drives for each session running. If you check on-site tapes out of the library, you will run into trouble with reclamation as it may request tapes that cannot be mounted.

FYI - Be aware also that you have collocation turned on, which is default. If you have 50 servers being backed up and collocation is on, you will create a separate tape for each server. It’s a good thing in terms of database backups but could be bad in case of filesystem backups.

Hi Brenda,

Thank you very much for the continuous response, I am really happy i am reached to the final conclusion, A Big Thank you to you and all the other contributors. Yes environment is not big but it is not new we are backing up almost 40 vm's and one SQL database backup, addidtionally we do not have 2 drives on the library it means in my case reclamation will also not work because we have only one drive.

 

Regards

Prem

Prem,

This is somewhat risky and I would recommend you talk to management about at least 1 more tape drive. You can never do a restore when you are doing other processes due to that limitation. Do you have enough disk to keep data permanently on disk? If so, then you could use your on-site copy as to what is on disk and actually make a copy pool with the off-site tapes.

Just my opinion…I think you really need to reconsider the architecture of your TSM environment. It is way too restrictive and forcing a lot of manual processes just to keep it functional.

Brenda

From: Prem Singh [mailto:storage-ti@lists.imwuc.org]
Sent: Monday, October 31, 2016 11:45 PM
To: storage-ti@lists.imwuc.org
Subject: [storage-ti] - RE: Process to update the storagepool


Hi Brenda,

Thank you very much for the continuous response, I am really happy i am reached to the final conclusion, A Big Thank you to you and all the other contributors. Yes environment is not big but it is not new we are backing up almost 40 vm's and one SQL database backup, addidtionally we do not have 2 drives on the library it means in my case reclamation will also not work because we have only one drive.



Regards

Prem

-----End Original Message-----
[CONFIDENTIALITY AND PRIVACY NOTICE] Information transmitted by this email is proprietary to Medtronic and is intended for use only by the individual or entity to which it is addressed, and may contain information that is private, privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please delete this mail from your records. To view this notice in other languages you can either select the following link or manually copy and paste the link into the address bar of a web browser: http://emaildisclaimer.medtronic.com

Brenda,

You are abslouteley right, I have requested many times to the Management and informed what is the benifit and loss of 2 Drives. But they are not ready because of cost. That's killing my time and skills also. no other option i have, i have to bear with it.

Regards

Prem

Well, when something bad happens, they will realize their mistake! ☺

From: Prem Singh [mailto:storage-ti@lists.imwuc.org]
Sent: Wednesday, November 02, 2016 5:47 AM
To: storage-ti@lists.imwuc.org
Subject: [storage-ti] - RE: Process to update the storagepool


Brenda,

You are abslouteley right, I have requested many times to the Management and informed what is the benifit and loss of 2 Drives. But they are not ready because of cost. That's killing my time and skills also. no other option i have, i have to bear with it.

Regards

Prem

-----End Original Message-----
[CONFIDENTIALITY AND PRIVACY NOTICE] Information transmitted by this email is proprietary to Medtronic and is intended for use only by the individual or entity to which it is addressed, and may contain information that is private, privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please delete this mail from your records. To view this notice in other languages you can either select the following link or manually copy and paste the link into the address bar of a web browser: http://emaildisclaimer.medtronic.com

Brenda,

I am not sure about your base location, I don't know you are interacting with Client or not, if yes possibly You are lucky, you have find always good person.

But in India many times you are responsible for everything whether they (client) have purchased/taken the right solution or not.

 

Regards

Prem