Results 1 to 8 of 8
  1. #1
    Newcomer
    Join Date
    Feb 2008
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exclamation Database backup - How to ?

    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 by vaisim; 03-26-2008 at 01:38 PM.

  2. #2
    Moderator
    Join Date
    Sep 2002
    Location
    Indiana
    Posts
    2,560
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Default

    What is the command you're using and what other processes are going on at the same time?

    -Aaron
    Three things are certain:
    Death, taxes, and lost data.
    Guess which has occurred.

  3. #3
    Newcomer
    Join Date
    Feb 2008
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    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.

  4. #4
    Senior Member cwilloug's Avatar
    Join Date
    Sep 2006
    Location
    North Dakota
    Posts
    384
    Thanks
    1
    Thanked 5 Times in 5 Posts

    Default

    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-'

  5. #5
    Moderator BBB's Avatar
    Join Date
    Feb 2007
    Location
    Brisbane, Australia
    Posts
    2,075
    Thanks
    0
    Thanked 5 Times in 5 Posts

    Default

    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.

  6. #6
    Moderator
    Join Date
    Sep 2002
    Location
    Indiana
    Posts
    2,560
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Default

    Do you need a path to a manual library? if so, what is the "device" used?

  7. #7
    Senior Member
    Join Date
    Jun 2007
    Location
    St Louis
    Posts
    286
    Thanks
    0
    Thanked 1 Time in 1 Post

    Default

    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.

  8. #8
    Newcomer
    Join Date
    Feb 2008
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    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 by vaisim; 03-27-2008 at 03:36 PM.

Similar Threads

  1. Database Backup
    By OKTSMGURU21 in forum Backup / Archive Discussion
    Replies: 3
    Last Post: 05-24-2007, 02:54 AM
  2. Database Backup
    By scott.robertson in forum Backup / Archive Discussion
    Replies: 7
    Last Post: 03-06-2007, 12:42 PM
  3. Replies: 6
    Last Post: 06-21-2005, 07:43 AM
  4. Database backup
    By markroe in forum Scripting
    Replies: 4
    Last Post: 10-22-2004, 09:00 AM
  5. backup Tivoli database
    By edward.shevtsov in forum Backup / Archive Discussion
    Replies: 4
    Last Post: 09-21-2004, 09:30 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •