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.

TSM 6 error ANR2971E -970 during restore db

Discussion in 'TSM Database' started by danieleinfn, Nov 27, 2009.

  1. danieleinfn

    danieleinfn New Member

    Nov 8, 2007
    Likes Received:
    OS Linux

    Hi all,
    I try to restore my db in a different directory with:
    [admin@tsm-server-1 ~]$ /opt/tivoli/tsm/server/bin/dsmserv restore db on=/home/admin/DB_Restore/mnt/TSM_DB/DB/admin/NODE0000/TSMDB1/

    I try also with dbdir.file that contains /home/admin/DB_Restore/mnt/TSM_DB/DB/admin/NODE0000/TSMDB1/

    but the error is always the same:
    [admin@tsm-server-1 ~]$ /opt/tivoli/tsm/server/bin/dsmserv restore db on=/home/admin/DB_Restore/mnt/TSM_DB/DB/admin/NODE0000

    ANR7800I DSMSERV generated at 13:35:30 on Oct 29 2009.

    Tivoli Storage Manager for Linux/x86_64
    Version 6, Release 1, Level 2.1

    Licensed Materials - Property of IBM

    (C) Copyright IBM Corporation 1990, 2009.
    All rights reserved.
    U.S. Government Users Restricted Rights - Use, duplication or disclosure
    restricted by GSA ADP Schedule Contract with IBM Corporation.

    ANR7801I Subsystem process ID is 20415.
    ANR0900I Processing options file /home/admin/dsmserv.opt.
    ANR7814I Using instance directory /home/admin.
    ANR4726I The ICC support module has been loaded.
    ANR1636W The server machine GUID changed: old value (), new value (ee.c3.57.f0-
    ANR8200I TCP/IP Version 4 driver ready for connection with clients on port
    ANR4636I Starting roll-forward database restore.
    ANR4620I Database backup series 4 operation 0 device class BACKUP_ON_DISK.
    ANR8340I FILE volume /home/admin/BackupDbOnDisk/59243941.DBV mounted.
    ANR1363I Input volume /home/admin/BackupDbOnDisk/59243941.DBV opened (sequence
    number 1).
    ANR1364I Input volume /home/admin/BackupDbOnDisk/59243941.DBV closed.
    ANR8340I FILE volume /home/admin/BackupDbOnDisk/59243951.DBV mounted.
    ANR1363I Input volume /home/admin/BackupDbOnDisk/59243951.DBV opened (sequence
    number 1).
    ANR1364I Input volume /home/admin/BackupDbOnDisk/59243951.DBV closed.
    ANR4638I Restore of backup series 4 operation 0 in progress.
    ANR0406I Session 1 started for node $$_TSMDBMGR_$$ (DB2/LINUXX8664) (Tcp/Ip
    ANR8340I FILE volume /home/admin/BackupDbOnDisk/59243941.DBV mounted.
    ANR0510I Session 1 opened input volume /home/admin/BackupDbOnDisk/59243941.DBV.ANR1363I Input volume /home/admin/BackupDbOnDisk/59243941.DBV opened (sequence
    number 1).
    ANR8213E Socket 6 aborted due to send error; error 32.
    ANR4912I Database full restore in progress and DB Data bytes transferred
    ANR1364I Input volume /home/admin/BackupDbOnDisk/59243941.DBV closed.
    ANR0514I Session 1 closed volume /home/admin/BackupDbOnDisk/59243941.DBV.
    ANR0480W Session 1 for node $$_TSMDBMGR_$$ (DB2/LINUXX8664) terminated -
    connection with client severed.
    ANR2971E Database backup/restore/rollforward terminated - DB2 sqlcode -970

    This sql error indicate:

    SQL0970N The system attempted to write to a read-only file.


    A file used by the database is marked read-only or does not exist. The
    database requires write access to this file.

    The statement cannot be processed.

    User response:

    Terminate the application on receipt of this message (SQLCODE). Ensure
    that all database files are allowed both read and write access. Check
    for unnecessary blank spaces within the specified filename.

    The user admin can write inside the dir
    [admin@tsm-server-1 ~]$ touch /home/admin/DB_Restore/mnt/TSM_DB/DB/admin/NODE0000/TSMDB1/pippo
    [admin@tsm-server-1 ~]$

    Any Help?


Share This Page