Database backup - How to ?

[vaisim]

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

[heada]

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

-Aaron

[vaisim]

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.

[cwilloug]

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

[BBB]

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.

[heada]

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

[djchopps0013]

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.

[vaisim]

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