Db2 Sqlcode - 2048 Error
Contents |
DB2 sqlcode -2048 error ANR2971E 2048 TSM DB BACKUP Technote (troubleshooting) Problem(Abstract) TSM server database backup failed and the following message logged in the server's activity log: ANR2971E db2 sql error sqlcode Database backup/restore/rollforward terminated - DB2 sqlcode -2048 error Symptom A backup of
Db2 Sql Error Sqlcode List
the the Tivoli Storage Manager (TSM) server database can't be performed Cause Corrupted volume history file Diagnosing the problem db2 sql error sqlcode 305 In the TSM server Activity Log, the following event is logged: ANR2971E Database backup/restore/rollforward terminated - DB2 sqlcode -2048 error. (SESSION: 23, PROCESS: 2) In the DB2 db2diag.log, the following events db2 sql error sqlcode 440 sqlstate 42884 stored procedure are logged: 2010-02-03-09.06.01.203000-300 E38260402H953 LEVEL: Error PID : 3252 TID : 3556 PROC : db2syscs.exe INSTANCE: SERVER1 NODE : 000 DB : TSMDB1 APPHDL : 0-111 APPID: *LOCAL.SERVER1.100203140729 AUTHID : SYSTEM EDUID : 3556 EDUNAME: db2agent (TSMDB1) FUNCTION: DB2 UDB, database utilities, sqluhReadEntry, probe:802 MESSAGE : SQL2161N A damaged recovery history file could not be fixed. The specified action failed. DATA #1 :
Db2 Sql Error Sqlcode 804
String, 60 bytes Error parsing history entry: invalid number of fields found. DATA #2 : String, 23 bytes Number of fields read: DATA #3 : signed integer, 4 bytes -1 DATA #4 : String, 32 bytes Expected number of fields read: DATA #5 : signed integer, 4 bytes 24 DATA #6 : Dumped object of size 514 bytes at offset 0, 76 bytes C:\DOCUME~1\ALLUSE~1\APPLIC~1\IBM\DB2\DB2TSM1\SERVER1\3252.3556.000.dump.bin . . 2010-02-03-10.27.52.594000-300 E38388701H965 LEVEL: Severe PID : 3252 TID : 368 PROC : db2syscs.exe INSTANCE: SERVER1 NODE : 000 DB : TSMDB1 APPHDL : 0-864 APPID: *LOCAL.SERVER1.100203152738 AUTHID : SYSTEM EDUID : 368 EDUNAME: db2bm.3712.0 (TSMDB1) FUNCTION: DB2 UDB, database utilities, sqlubProcessHistoryFile, probe:484 MESSAGE : SQL2048N An error occurred while accessing object "". Reason code: "". DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2048 sqlerrml: 14 sqlerrmc: db2rhist.asc 4 sqlerrp : sqlubPro 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: . . 2010-02-03-10.28.38.326000-300 E38390227H437 LEVEL: Severe PID : 3252 TID : 3712 PROC : db2syscs.
is corrupted. SQL2048N; Backup ; recovery history file Technote (troubleshooting) Problem(Abstract) DB2 Backup fails with SQL2048N RC 4 when the recovery history file is corrupted Symptom Following errors will be noticed in the db2diag.log about DB2 Backup failure due to damaged history file: 2014-06-21-00.32.19.304000-420 I85598107H614 LEVEL: Error PID : 2580 TID : 6948 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : SAMPLE APPHDL : 0-6998 APPID: XXXX db2 sql error sqlcode 204 sqlstate 42704 AUTHID : TEST db2 sql error sqlcode 803 EDUID : 6948 EDUNAME: db2bm.4380.0 (SAMPLE) FUNCTION: DB2 UDB, database utilities, sqluhVerifyHistoryFiles, probe:254
Db2 Sql Error Sqlcode 104 Sqlstate 42601
MESSAGE : SQL2161N A damaged recovery history file could not be fixed. The http://www-01.ibm.com/support/docview.wss?uid=swg21420318 specified action failed. DATA #1 : String, 48 bytes Error encountered in verifying the history file. 2014-06-21-00.32.19.304000-420 E85598723H640 LEVEL: Severe PID : 2580 TID : 6948 PROC : http://www-01.ibm.com/support/docview.wss?uid=swg21677560 db2syscs.exe INSTANCE: DB2 NODE : 000 DB : SAMPLE APPHDL : 0-6998 APPID: XXXX AUTHID : TEST EDUID : 6948 EDUNAME: db2bm.4380.0 (SAMPLE) FUNCTION: DB2 UDB, database utilities, sqlubProcessHistoryFile, probe:484 DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes -2048 DATA #2 : Hexdump, 21 bytes 0x39611714 : 00F8 FFFF 6462 3272 6869 7374 2E61 7363 ....db2rhist.asc 0x39611724 : 0004 0000 00 ..... 2014-06-21-00.32.19.304000-420 E85599365H961 LEVEL: Severe PID : 2580 TID : 6948 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : SAMPLE APPHDL : 0-6998 APPID: XXXX AUTHID : TEST EDUID : 6948 EDUNAME: db2bm.4380
Print view FAQ Register Login * * New Chat Feature http://www.tsmdesk.com/forum/database-backup-terminated-with-anr2971e-db2-sqlcode-2048-t1947.html Added * * Database backup terminated with ANR2971E DB2 sqlcode https://adsm.org/forum/index.php?threads/backup-db-failing.19264/ 2048. Includes the issues and suggestions related to TSM Server Database and Recovery Log Post a reply 1 post • Page 1 of 1 Database backup terminated with ANR2971E DB2 sqlcode 2048. by samineni » Fri Jan 22, db2 sql 2016 9:49 pm Technote (troubleshooting)Problem(Abstract)ANR2971E Database backup/restore/rollforward terminated - DB2 sqlcode -2048 error and failure for the Tivoli Storage Manager database backup. Below is the error which is seen during the Tivoli Storage Manager database backup operations.SymptomThe DB2 SQL2048, points to the object being corrupt or the db2 sql error object being accessed is a tablespace and either the tablespace is in such a state that the operation is not allowed or one or more containers of the tablespace is not available. (LIST TABLESPACES will list the current tablespace state.) Examples of such states are quiesced offline.The db2diag.log file records the equivalent message as below.2010-01-14-08.30.01.767586-480 I155257A1679 LEVEL: Error (OS)PID : 409754 TID : 19022 PROC : db2sysc 0INSTANCE: tsminst1 NODE : 000APPHDL : 0-529 APPID: *LOCAL.tsminst1.100114163005AUTHID : TSMINST1EDUID : 19022 EDUNAME: db2agent (instance) 0FUNCTION: DB2 Common, OSSe, ossGetDiskInfo, probe:90MESSAGE : ECF=0x9000001A=-1879048166=ECF_FILE_DOESNT_EXISTFile doesn't existCALLED : OS, -, statvfsOSERR : ENOENT (2) "No such file or directory"DATA #1 : String, 51 bytes/tsm/tsminst1/db3/tsminst1/NODE0000/TSMDB1/T0000009DATA #2 : unsigned integer, 8 bytes 140Resolving the problemWhile trying to access the a directory (for example): '/tsm/tsminst1/db3/tsminst1/NODE0000/TSMDB1/T0000009' this is not available on the system as seen below.user@tsm02prd$ ls -la /tsm/tsminst1/db3/t
Knowledge. If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link above 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 notice will disappear after you have made at least 3 posts. Please Give Thanks to Those Sharing Their Knowledge Forum Rules (PLEASE READ BEFORE POSTING) backup db failing. Discussion in 'TSM Server' started by LED888, Oct 9, 2009. LED888 ADSM.ORG Moderator Joined: Oct 15, 2002 Messages: 789 Likes Received: 56 TSM Server 6.1.2.0 running on a Windows 2003 sp2. When I run either - backup db devclass=primary_lto t=f w=y or backup db devclass=primary_local_file t=f w=y I get the following messages - ANR0984I Process 54 for DATABASE BACKUP started in the FOREGROUND at 08:59:00. ANR2280I Full database backup started as process 54. ANR2971E Database backup/restore/rollforward terminated - DB2 sqlcode -2048 error. ANR0985I Process 54 for DATABASE BACKUP running in the FOREGROUND completed with completion state FAILURE at 08:59:20. ANS8001I Return code 54. Anyone encounter this before? -Sias LED888, Oct 9, 2009 #1 ADSM.ORG Sponsor wim ADSM.ORG Senior Member Joined: Aug 14, 2007 Messages: 208 Likes Received: 2 Never have seen this error before. Seems a problem with the DB2 database. I would suggest to contact IBM support if possible wim, Oct 11, 2009 #2 Jacob_6 ADSM.ORG Senior Member Joined: Jul 22, 2008 Messages: 207 Likes Received: 5 Occupation: TSM Admin, Netbackup Admin Location: Dallas, Texas Tivoli Storage Manager, V6.1 intends to set up the DB2 configuration parameter NUM_DB_BACKUPS to 1. Currently, it is temporarily set to 2 to avoid a DB2 code problem. DB2 will have the code fix later this year. Tivoli Storage Manager will set the DB2 configuration parameter NUM_DB_BACKUPS to 1 when the DB2 code