1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

Database backup - How to ?

Discussion in 'TSM Server' started by vaisim, Mar 26, 2008.

  1. vaisim

    vaisim New Member

    Joined:
    Feb 5, 2008
    Messages:
    9
    Likes Received:
    0
    Hi everyone!

    Anybody can tell me how can I backup my database, step by step, beceause in the IBM Tivoli Storage Manager Implementation Guide, it's not really clear. In fact, I've got this error msg: ANR4571E insufficient number of mount point .

    Also, when I try to update my stgpool diskpool, I've got the error to:


    03/26/2008 13:30:23 ANR2017I Administrator ADMIN issued command: UPDATE
    STGPOOL diskpool hi=0 lo=0 (SESSION: 75)
    03/26/2008 13:30:23 ANR2202I Storage pool DISKPOOL updated. (SESSION: 75)
    03/26/2008 13:30:23 ANR0984I Process 49 for MIGRATION started in the
    BACKGROUND at 13:30:23. (PROCESS: 49)
    03/26/2008 13:30:23 ANR1000I Migration process 49 started for storage pool
    DISKPOOL automatically, highMig=0, lowMig=0, duration=No.
    (PROCESS: 49)
    03/26/2008 13:30:23 ANR1134E Migration is ended for storage pool DISKPOOL.
    There is an insufficient number of mount points available
    for removable media. (PROCESS: 49)
    03/26/2008 13:30:23 ANR0985I Process 49 for MIGRATION running in the
    BACKGROUND completed with completion state FAILURE at
    13:30:23. (PROCESS: 49)


    Here is the information about my installation:

    tsm: SERVER1>q devc f=d
    Device Class Name: 8MM_CLASS_1
    Device Access Strategy: Sequential
    Storage Pool Count: 2
    Device Type: 8MM
    Format: DRIVE
    Est/Max Capacity (MB):
    Mount Limit: DRIVES
    Mount Wait (min): 60
    Mount Retention (min): 60
    Label Prefix: ADSM
    Drive Letter:
    Library: SONY150C
    Directory:
    Server Name:
    Retry Period:
    Retry Interval:
    Twosided:
    Shared:
    High-level Address:
    Minimum Capacity:
    WORM: No
    Drive Encryption:
    Scaled Capacity:
    Last Update by (administrator): ADMIN
    Last Update Date/Time: 02/25/2008 14:55:52
    Device Class Name: DISK
    Device Access Strategy: Random
    Storage Pool Count: 1
    Device Type:
    Format:
    Est/Max Capacity (MB):
    Mount Limit:
    Mount Wait (min):
    Mount Retention (min):
    Label Prefix:
    Drive Letter:
    Library:
    Directory:
    Server Name:
    Retry Period:
    Retry Interval:
    Twosided:
    Shared:
    High-level Address:
    Minimum Capacity:
    WORM: No
    Drive Encryption:
    Scaled Capacity:
    Last Update by (administrator):
    Last Update Date/Time: 02/08/2008 11:29:48

    **********************************************************
    tsm: SERVER1>q stg f=d
    Storage Pool Name: DISKPOOL
    Storage Pool Type: Primary
    Device Class Name: DISK
    Estimated Capacity: 256 G
    Space Trigger Util: 31.9
    Pct Util: 31.9
    Pct Migr: 31.9
    Pct Logical: 100.0
    High Mig Pct: 90
    Low Mig Pct: 70
    Migration Delay: 1
    Migration Continue: Yes
    Migration Processes: 1
    Reclamation Processes:
    Next Storage Pool: TAPEPOOL
    Reclaim Storage Pool:
    Maximum Size Threshold: No Limit
    Access: Read/Write
    Description:
    Overflow Location:
    Cache Migrated Files?: No
    Collocate?:
    Reclamation Threshold:
    Offsite Reclamation Limit:
    Maximum Scratch Volumes Allowed:
    Number of Scratch Volumes Used:
    Delay Period for Volume Reuse:
    Migration in Progress?: No
    Amount Migrated (MB): 0.00
    Elapsed Migration Time (seconds): 0
    Reclamation in Progress?:
    Last Update by (administrator): ADMIN
    Last Update Date/Time: 02/28/2008 14:20:16
    Storage Pool Data Format: Native
    Copy Storage Pool(s):
    Active Data Pool(s):
    Continue Copy on Error?: Yes
    CRC Data: No
    Reclamation Type:
    Overwrite Data when Deleted:
    Storage Pool Name: TAPEPOOL
    Storage Pool Type: Primary
    Device Class Name: 8MM_CLASS_1
    Estimated Capacity: 0.0 M
    Space Trigger Util:
    Pct Util: 0.0
    Pct Migr: 0.0
    Pct Logical: 0.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: Tape SONY
    Overflow Location:
    Cache Migrated Files?:
    Collocate?: Group
    Reclamation Threshold: 60
    Offsite Reclamation Limit:
    Maximum Scratch Volumes Allowed: 50
    Number of Scratch Volumes Used: 0
    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: 02/28/2008 14:20:16
    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:

    *******************************************
    tsm: SERVER1>q path
    Source Name Source Type Destination Destination On-Line
    Name Type
    ----------- ----------- ----------- ----------- -------
    SERVER1 SERVER 1 DRIVE Yes
    ********************************************
    tsm: SERVER1>q drive
    Library Name Drive Name Device Type On-Line
    ------------ ------------ ----------- -------------------
    SONY150C 1 GENERICTAPE Yes

    ********************************************
    tsm: SERVER1>q libr
    Library Name: SONY150C
    Library Type: MANUAL
    ACS Id:
    Private Category:
    Scratch Category:
    WORM Scratch Category:
    External Manager:
    RSM Media Type:
    Shared: No
    LanFree:
    ObeyMountRetention:
    *********************************************
    tsm: SERVER1>q db f=d
    Available Space (MB): 1,024
    Assigned Capacity (MB): 1,024
    Maximum Extension (MB): 0
    Maximum Reduction (MB): 716
    Page Size (bytes): 4,096
    Total Usable Pages: 262,144
    Used Pages: 78,125
    Pct Util: 29.8
    Max. Pct Util: 29.8
    Physical Volumes: 1
    Buffer Pool Pages: 8,192
    Total Buffer Requests: 84,045
    Cache Hit Pct.: 97.33
    Cache Wait Pct.: 0.00
    Backup in Progress?: No
    Type of Backup In Progress:
    Incrementals Since Last Full: 0
    Changed Since Last Backup (MB): 305.18
    Percentage Changed: 100.00
    Last Complete Backup Date/Time:
    Estimate of Recoverable Space (MB):
    Last Estimate of Recoverable Space (MB):
    *********************************************

    So, can you please tell me where I can found the "Backup your TSM Database for Dummies" !!!

    Thank's a lot,

    Simon
     
    Last edited: Mar 26, 2008
  2.  
  3. heada

    heada Moderator

    Joined:
    Sep 23, 2002
    Messages:
    2,560
    Likes Received:
    168
    Occupation:
    Storage Administrator
    Location:
    Indiana
    What is the command you're using and what other processes are going on at the same time?

    -Aaron
     
  4. vaisim

    vaisim New Member

    Joined:
    Feb 5, 2008
    Messages:
    9
    Likes Received:
    0
    I'm not shure if the command are ok:

    BACKUP DB type=full devclass=8MM_CLASS_1 scratch=yes

    Here is more information:

    tsm: SERVER1>q db
    Available Assigned Maximum Maximum Page Total Used Pct Max.
    Space Capacity Extension Reduction Size Usable Pages Util Pct
    (MB) (MB) (MB) (MB) (bytes) Pages Util
    --------- -------- --------- --------- ------- --------- --------- ----- -----
    1,024 1,024 0 716 4,096 262,144 78,132 29.8 29.8

    tsm: SERVER1>q stg
    Storage Device Estimated Pct Pct High Low Next Stora-
    Pool Name Class Name Capacity Util Migr Mig Mig ge Pool
    Pct Pct
    ----------- ---------- ---------- ----- ----- ---- --- -----------
    DISKPOOL DISK 256 G 31.9 31.9 0 0 TAPEPOOL
    TAPEPOOL 8MM_CLASS- 0.0 M 0.0 0.0 90 70
    _1
    tsm: SERVER1>update stgpool diskpool hi=0 lo=0
    ANR2202I Storage pool DISKPOOL updated.
    03/26/2008 14:54:03 ANR0984I Process 10 for MIGRATION started in the
    BACKGROUND at 14:54:03. (PROCESS: 10)
    03/26/2008 14:54:03 ANR1000I Migration process 10 started for storage pool
    DISKPOOL automatically, highMig=0, lowMig=0, duration=No.
    (PROCESS: 10)
    03/26/2008 14:54:03 ANR1134E Migration is ended for storage pool DISKPOOL.
    There is an insufficient number of mount points available
    for removable media. (PROCESS: 10)
    03/26/2008 14:54:03 ANR0985I Process 10 for MIGRATION running in the
    BACKGROUND completed with completion state FAILURE at
    14:54:03. (PROCESS: 10)
    03/26/2008 14:54:03 ANR1002I Migration for storage pool DISKPOOL will be
    retried in 60 seconds.
     
  5. cwilloug

    cwilloug Senior Member

    Joined:
    Sep 13, 2006
    Messages:
    387
    Likes Received:
    11
    Occupation:
    Storage / Backup / VMware / HyperV admin
    Location:
    North Dakota
    03/26/2008 14:54:03 ANR1134E Migration is ended for storage pool DISKPOOL.
    There is an insufficient number of mount points available
    for removable media. (PROCESS: 10)


    How many mount points do you have available? and how many mount points do you have defined to use for a backup?

    command syntax looks correct.......

    Syntax

    >>-BAckup DB--DEVclass--=--device_class_name-------------------->

    .-Type--=--Incremental-----.
    >--+--------------------------+--------------------------------->
    '-Type--=--+-Incremental-+-'
    +-Full--------+
    '-DBSnapshot--'

    >--+-------------------------------------+---------------------->
    | .-,-----------. |
    | V | |
    '-VOLumenames--=--+---volume_name-+-+-'
    '-FILE: file_name-'

    .-Scratch--=--Yes-----. .-Wait--=--No------.
    >--+---------------------+--+------------------+---------------><
    '-Scratch--=--+-Yes-+-' '-Wait--=--+-No--+-'
    '-No--' '-Yes-'
     
  6. BBB

    BBB Moderator

    Joined:
    Feb 13, 2007
    Messages:
    2,076
    Likes Received:
    20
    Location:
    Brisbane, Australia
    Maybe your environment is different but normally I would expect to see a path defined to the *library*, as well as to the drive. This is so TSM knows how to talk to the library (which device file).

    What is the output from "q libv" do you have any scratch tapes listed?

    Also update your 8mm device class and put a estimated capacity on it and show the output from q stg f=d again.
     
  7. heada

    heada Moderator

    Joined:
    Sep 23, 2002
    Messages:
    2,560
    Likes Received:
    168
    Occupation:
    Storage Administrator
    Location:
    Indiana
    Do you need a path to a manual library? if so, what is the "device" used?
     
  8. djchopps0013

    djchopps0013 Senior Member

    Joined:
    Jun 29, 2007
    Messages:
    286
    Likes Received:
    5
    Occupation:
    Storage Administrator
    Location:
    St Louis
    You do need a path to the drive, not library, you would still define a library though. Device would be whatever your device is i.e. LTO3 would be devt=lto.
     
  9. vaisim

    vaisim New Member

    Joined:
    Feb 5, 2008
    Messages:
    9
    Likes Received:
    0
    I don't have a library. I have a single external 8mm. I can label tape with no problem. How can I mount a tape after a label?

    Here is the information about my configuration:

    *************************************************************************
    tsm: SERVER1>q path f=d
    Source Name: SERVER1
    Source Type: SERVER
    Destination Name: 1
    Destination Type: DRIVE
    Library: SONY150C
    Node Name:
    Device: \\.\Tape0
    External Manager:
    LUN:
    Initiator: 0
    Directory:
    On-Line: Yes
    Last Update by (administrator): ADMIN
    Last Update Date/Time: 02/25/2008 15:37:05
    *************************************************************************
    tsm: SERVER1>q drive f=d
    Library Name: SONY150C
    Drive Name: 1
    Device Type: GENERICTAPE
    On-Line: Yes
    Read Formats:
    Write Formats:
    Element:
    Drive State: EMPTY
    Volume Name:
    Allocated to:
    WWN:
    Serial Number:
    Last Update by (administrator): ADMIN
    Last Update Date/Time: 03/27/2008 13:52:52
    Cleaning Frequency (Gigabytes/ASNEEDED/NONE): NONE
    *************************************************************************
    tsm: SERVER1>q devc f=d
    Device Class Name: 8MM_CLASS_1
    Device Access Strategy: Sequential
    Storage Pool Count: 1
    Device Type: 8MM
    Format: DRIVE
    Est/Max Capacity (MB):
    Mount Limit: DRIVES
    Mount Wait (min): 60
    Mount Retention (min): 60
    Label Prefix: ADSM
    Drive Letter:
    Library: SONY150C
    Directory:
    Server Name:
    Retry Period:
    Retry Interval:
    Twosided:
    Shared:
    High-level Address:
    Minimum Capacity:
    WORM: No
    Drive Encryption:
    Scaled Capacity:
    Last Update by (administrator): ADMIN
    Last Update Date/Time: 02/25/2008 14:55:52
    Device Class Name: DISK
    Device Access Strategy: Random
    Storage Pool Count: 1
    Device Type:
    Format:
    Est/Max Capacity (MB):
    Mount Limit:
    Mount Wait (min):
    Mount Retention (min):
    Label Prefix:
    Drive Letter:
    Library:
    Directory:
    Server Name:
    Retry Period:
    Retry Interval:
    Twosided:
    Shared:
    High-level Address:
    Minimum Capacity:
    WORM: No
    Drive Encryption:
    Scaled Capacity:
    Last Update by (administrator):
    Last Update Date/Time: 02/08/2008 11:29:48

    *************************************************************************
    tsm: SERVER1>q libr f=d
    Library Name: SONY150C
    Library Type: MANUAL
    ACS Id:
    Private Category:
    Scratch Category:
    WORM Scratch Category:
    External Manager:
    RSM Media Type:
    Shared: No
    LanFree:
    ObeyMountRetention:
    Primary Library Manager:
    WWN:
    Serial Number:
    AutoLabel: No
    Reset Drives: No
    Last Update by (administrator): ADMIN
    Last Update Date/Time: 02/25/2008 14:55:52
    *************************************************************************

    tsm: SERVER1>q stg f=d
    Storage Pool Name: DISKPOOL
    Storage Pool Type: Primary
    Device Class Name: DISK
    Estimated Capacity: 256 G
    Space Trigger Util: 31.9
    Pct Util: 31.9
    Pct Migr: 31.9
    Pct Logical: 100.0
    High Mig Pct: 0
    Low Mig Pct: 0
    Migration Delay: 1
    Migration Continue: Yes
    Migration Processes: 1
    Reclamation Processes:
    Next Storage Pool: TAPEPOOL
    Reclaim Storage Pool:
    Maximum Size Threshold: No Limit
    Access: Read/Write
    Description:
    Overflow Location:
    Cache Migrated Files?: No
    Collocate?:
    Reclamation Threshold:
    Offsite Reclamation Limit:
    Maximum Scratch Volumes Allowed:
    Number of Scratch Volumes Used:
    Delay Period for Volume Reuse:
    Migration in Progress?: No
    Amount Migrated (MB): 0.00
    Elapsed Migration Time (seconds): 0
    Reclamation in Progress?:
    Last Update by (administrator): ADMIN
    Last Update Date/Time: 03/27/2008 14:21:57
    Storage Pool Data Format: Native
    Copy Storage Pool(s):
    Active Data Pool(s):
    Continue Copy on Error?: Yes
    CRC Data: No
    Reclamation Type:
    Overwrite Data when Deleted:

    Storage Pool Name: TAPEPOOL
    Storage Pool Type: Primary
    Device Class Name: 8MM_CLASS_1
    Estimated Capacity: 0.0 M
    Space Trigger Util:
    Pct Util: 0.0
    Pct Migr: 0.0
    Pct Logical: 0.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: Tape SONY
    Overflow Location:
    Cache Migrated Files?:
    Collocate?: Group
    Reclamation Threshold: 60
    Offsite Reclamation Limit:
    Maximum Scratch Volumes Allowed: 50
    Number of Scratch Volumes Used: 0
    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: 03/26/2008 12:02:19
    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:

    tsm: SERVER1>q libr f=d
    Library Name: SONY150C
    Library Type: MANUAL
    ACS Id:
    Private Category:
    Scratch Category:
    WORM Scratch Category:
    External Manager:
    RSM Media Type:
    Shared: No
    LanFree:
    ObeyMountRetention:
    Primary Library Manager:
    WWN:
    Serial Number:
    AutoLabel: No
    Reset Drives: No
    Last Update by (administrator): ADMIN
    Last Update Date/Time: 02/25/2008 14:55:52
     
    Last edited: Mar 27, 2008

Share This Page