How can I be out of space???? URGENT PLS HELP ME!!!!!!

[newtsm]

Hello TSM Folks:

I am new to TSM and have this problem:

In the past two weeks my db2 full backup had failed with anr0522 and rc=2025

this is the error from the client side:



Starting db2 archive for db2arch : Sat Sep 20 04:00:01 EDT 2003

Backing up the DB2 ARCHIVE database online

Backing up the DB2 ARCHIVE database at 09/20/03 04:00:02

Unable to backup database ARCHIVE. err=-2025

arsdb: Unable to backup DB2 ARCHIVE database to ADSM. rc=-2025

** ERROR: db2 archive failed Sat Sep 20 06:18:03 EDT 2003 for db2arch



from the actlog:



09/13/03 04:20:06 ANR0522W Transaction failed for session 24 for node

db2arch (DB2/6000) - no space available in storage pool

DBCMD1 and all successor pools.

09/20/03 06:17:55 ANR0522W Transaction failed for session 25 for node

db2arch (DB2/6000) - no space available in storage pool

DBCMD1 and all successor pools.



q stg:



Storage Pool Name: DBCMD1

Storage Pool Type: Primary

Device Class Name: 3575CLASS

Estimated Capacity (MB): 1,779,789.8

Pct Util: 14.1

Pct Migr: 15.0

Pct Logical: 100.0

High Mig Pct: 90

Low Mig Pct: 70

Migration Delay: 0

Migration Continue: Yes

Migration Processes:

Next Storage Pool:

Reclaim Storage Pool:

Maximum Size Threshold: No Limit

Access: Read/Write

Description: Backup stgpool for CMD DB2 Database

Overflow Location:

Cache Migrated Files?:

Collocate?: Yes

Reclamation Threshold: 60

Maximum Scratch Volumes Allowed: 120

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

Volume Being Migrated/Reclaimed:

Last Update by (administrator): DB2ADMIN

Last Update Date/Time: 01/31/02 15:50:09



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

--------- -------- --------- --------- ------- --------- --------- ----- -----

396 380 16 372 4,096 97,280 1,428 1.5 1.5





tsmsvr1 q vol * stg=dbcmd1



Volume Name Storage Device Estimated Pct Volume

Pool Name Class Name Capacity Util Status

(MB)

------------------------ ----------- ---------- --------- ----- --------

00D8F4 DBCMD1 3575CLASS 13,366.2 100.0 Full

00D915 DBCMD1 3575CLASS 15,276.8 93.5 Full

00E37E DBCMD1 3575CLASS 15,225.1 100.0 Full

00E38B DBCMD1 3575CLASS 13,573.7 77.8 Full

00E38D DBCMD1 3575CLASS 17,238.5 99.5 Full

00E38E DBCMD1 3575CLASS 13,381.0 100.0 Full

00EF73 DBCMD1 3575CLASS 14,166.4 100.0 Full

00F715 DBCMD1 3575CLASS 11,919.4 100.0 Filling

00F71D DBCMD1 3575CLASS 14,496.9 54.4 Full

00F891 DBCMD1 3575CLASS 17,343.4 97.8 Full

00FE73 DBCMD1 3575CLASS 15,417.9 90.6 Full

010CDB DBCMD1 3575CLASS 15,252.6 100.0 Full

010CDD DBCMD1 3575CLASS 13,281.3 74.4 Full

010CF3 DBCMD1 3575CLASS 16,554.5 100.0 Full

010CF6 DBCMD1 3575CLASS 16,239.5 100.0 Full

010CFC DBCMD1 3575CLASS 13,475.2 100.0 Full

010D14 DBCMD1 3575CLASS 13,403.3 100.0 Full

010D32 DBCMD1 3575CLASS 17,356.7 100.0 Full



tsmsvr1 select count(*) from libvolumes where status='Scratch'



Unnamed[1]

-----------

5



Do I need to increase the maxscr to the stg pool (DBCMD1)?

There are 17 private vols defined to dbcmd1 stg.. and the stg maxscr=120



Any hints to help me solve this problem, it is greatly appreciated it!!!!

null

 

[nezih]

Do I need to increase the maxscr to the stg pool (DBCMD1)?

There are 17 private vols defined to dbcmd1 stg.. and the stg maxscr=120



No... you don't need to define additional scratch vols to stg's maxscr... but you'll be sure there will be scratch volumes in library... you'll see scratch status on some cartridges with q libvol command

 

[schwarme]

If you see below, he did in fact show that he has 5 scratch volumes via his SQL query.



newtsm, are any of your storage pools specifying a reclaimation storage pool? Also, I noticed that you are collocated. I am curious how many processes you are using to back up your db and if that node would call for more than 5 tapes at a time.



Hope this helps,



Michael



<TABLE BORDER=0 ALIGN=CENTER WIDTH=85%><TR><TD><font class="pn-sub">Quote:</font><HR></TD></TR><TR><TD><FONT class="pn-sub"><BLOCKQUOTE>Do I need to increase the maxscr to the stg pool (DBCMD1)?

There are 17 private vols defined to dbcmd1 stg.. and the stg maxscr=120



No... you don't need to define additional scratch vols to stg's maxscr... but you'll be sure there will be scratch volumes in library... you'll see scratch status on some cartridges with q libvol command</BLOCKQUOTE></FONT></TD></TR><TR><TD><HR></TD></TR></TABLE>