Troubleshooting error message ANR2971E using the SQL code

Edit online

Error message ANR2971E might show when you are restoring or backing up a database operation, and the process stops. Use the SQL code attached to the error to help you resolve this problem.

Before you begin

If you are restoring a database because the server stopped during normal operation, review the db2diag.log file before backing up or restoring the database.

The following message can be issued when you are restoring or backing up data:
ANR2971E Database bàckup/restore/rollforward terminated - DB2 sqlcode -2581 error
In the following scenario, the DSMSERV RESTORE DB process failed with a Db2 SQL 2581 code. This following scenario does not pertain to problems with the DSMI environment variables.

Procedure

  1. Issue the following command from the Db2 command-line interface: 
    ? SQL2581
    An explanation is generated about the SQL code. 
    SQL2581N  Restore is unable to extract log files or restore a log
directory from the backup image to the specified path. Reason code 2581
  2. Review the db2diag.log file where you can find status and error messages. A portion of the db2diag.log file is displayed in the following example: 
    2009-02-10-09.49.00.660000-300 E8120712F500       LEVEL: Info
PID     : 4608                 TID  : 3956        PROC : db2syscs.exe
INSTANCE: SERVER1              NODE : 000         DB   : TSMDB1
APPHDL  : 0-7                  APPID: *LOCAL.SERVER1.090210144859
AUTHID  : B1JRPM01
EDUID   : 3956                 EDUNAME: db2agent (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqludPrintStartingMsg, probe:1292
DATA #1 : <preformatted>
Starting a full database restore. 
Agent EDU ID: 3956  

2009-02-10-09.50.21.051000-300 E8123213F483       LEVEL: Severe
PID     : 4608                 TID  : 5080        PROC : db2syscs.exe
INSTANCE: SERVER1              NODE : 000 
EDUID   : 5080                 EDUNAME: db2bm.3956.1 (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqluWriteLogFile, probe:1498 
MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
            DIA8312C Disk was full. 
DATA #1 : String, 46 bytes
F:\tivoli\tsm\Beta\sarch\RstDbLog\S0000262.LOG  

2009-02-10-09.50.21.051000-300 E8124165F912       LEVEL: Severe 
PID     : 4608                 TID  : 5080        PROC : db2syscs.exe 
INSTANCE: SERVER1              NODE : 000
EDUID   : 5080                 EDUNAME: db2bm.3956.1 (TSMDB1) 
FUNCTION: DB2 UDB, database utilities, sqluWriteLogFile, probe:1500
MESSAGE : SQL2581N  Restore is unable to extract log files or restore a log
          directory from the backup image to the specified path. Reason code "". 
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -2581   sqlerrml: 1
sqlerrmc: 4
sqlerrp : sqluWrit
sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 0x00000000
          (4) 0x00000000      (5) 0x00000000      (6) 0x00000000  
sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
          (7)      (8)      (9)      (10)        (11)  
sqlstate:
    The preceding example shows from the Disk Full message that there was not enough disk space to place the needed log files from the backup operation.
  3. Add disk space and run the operation again.