lilei1
1 Nickel

DB2备份报错

不知道哪位大哥碰到过这种问题,一发起备份,DB2数据库服务就停了:

networker版本7.4.4,DB2备份模块(for windows)4.0,数据库服务版本2003SP2,DB2版本10

配置如下:

存储集极度高兴的表情B2:/SAMPLE/NODE0000
备份命令:nsrdb2sv -f c:\progra~1\Legato\nsr\bin\nmdb2.cfg

控制台组里面报错信息如下:已重试 1 次。
Writing debug messages to c:\progra~1\Legato\nsr\applogs\nmdb2\nsrdb2sv.log
Unable to backup SAMPLE database due to backup request failure, SQLCODE : -1224, SQL1224N  The database manager is not able to accept new requests, has
terminated all requests in progress, or has terminated the specified request
because of an error or a forced interrupt.  SQLSTATE=00000
SQLSTATE 00000: Execution of the operation was successful and did not result in
any type of warning or exception condition.

nmdb2.cfg:

DB2_ALIAS=SAMPLE
DB2INSTANCE=DB2
DB2_NODE_NAME=DB2
DB2_USR=db2admin
#DB2_OPTIONS=DB2BACKUP_FULL
#DB2_TBS_LIST=TBSP1
DB2_VENDOR_LIB_PATH=c:\progra~1\Legato\nsr\bin\libnsrdb2.dll
DB2PATH=C:\PROGRA~1\IBM\SQLLIB
DB2_SESSIONS=1
NSR_DEBUG_LEVEL=9
NSR_LIBNSRDB2_DEBUG_LEVEL=9
NSR_DEBUG_FILE=c:\progra~1\Legato\nsr\applogs\nmdb2\nsrdb2xbsa.log
NSR_LIBNSRDB2_DEBUG_FILE=c:\progra~1\Legato\nsr\applogs\nmdb2\nsrdb2.log
NSR_DB2SV_DEBUG_FILE=c:\progra~1\Legato\nsr\applogs\nmdb2\nsrdb2sv.log
NSR_DB2SV_DEBUG_LEVEL=9
DB2_PSWD=lc5gcdkf

标签 (1)
标记 (1)
0 项奖励
13 条回复13
liulei_it
4 Germanium

Re: DB2备份报错

帮你顶一下,这个备份是用了networker 的组建集成备份的还是用文件系统方式备份的?备份软件的日志有吗?

好像是未知的错误?

0 项奖励
lilei1
1 Nickel

Re: DB2备份报错

用的是db2的备份模块4.0

diaglog:

E9608H513            LEVEL: Event
PID     : 3792                 TID : 668            PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000           DB   : SAMPLE
APPHDL  : 0-9                  APPID: *LOCAL.DB2.121217102248
AUTHID  : DB2ADMIN            
EDUID   : 668                  EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1000
START   : DATABASE: SAMPLE   : ACTIVATED: NO

E10123H536           LEVEL: Info
PID     : 3792                 TID : 668            PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000           DB   : SAMPLE
APPHDL  : 0-9                  APPID: *LOCAL.DB2.121217102248
AUTHID  : DB2ADMIN            
EDUID   : 668                  EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqluxGetDegreeParallelism, probe:542
DATA #1 : <preformatted>
Autonomic backup/restore - using parallelism = 5.

E10661H560           LEVEL: Info
PID     : 3792                 TID : 668            PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000           DB   : SAMPLE
APPHDL  : 0-9                  APPID: *LOCAL.DB2.121217102248
AUTHID  : DB2ADMIN            
EDUID   : 668                  EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqluxGetAvailableHeapPages, probe:648
DATA #1 : <preformatted>
Autonomic BAR - heap consumption.
Targetting (90%) - 3988 of 4432 pages.

E11223H549           LEVEL: Info
PID     : 3792                 TID : 668            PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000           DB   : SAMPLE
APPHDL  : 0-9                  APPID: *LOCAL.DB2.121217102248
AUTHID  : DB2ADMIN            
EDUID   : 668                  EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqlubTuneBuffers, probe:903
DATA #1 : <preformatted>
Autonomic backup - tuning enabled.
Using buffer size = 769, number = 5.

E11774H498           LEVEL: Info
PID     : 3792                 TID : 668            PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000           DB   : SAMPLE
APPHDL  : 0-9                  APPID: *LOCAL.DB2.121217102248
AUTHID  : DB2ADMIN            
EDUID   : 668                  EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, probe:1687
MESSAGE : Starting an offline db backup.

LEVEL: Error (OS)
PID     : 3792                 TID : 3164           PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000           DB   : SAMPLE
APPHDL  : 0-9                  APPID: *LOCAL.DB2.121217102248
AUTHID  : DB2ADMIN            
EDUID   : 3164                 EDUNAME: db2med.668.0 (SAMPLE) 0
FUNCTION: DB2 UDB, oper system services, sqloloadmodule, probe:43
MESSAGE : ZRC=0x830003E9=-2097150999

CALLED  : OS, -, unspecified_system_function
OSERR   : 1001 "????;?????"

LEVEL: Error
PID     : 3792                 TID : 3164           PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000           DB   : SAMPLE
APPHDL  : 0-9                  APPID: *LOCAL.DB2.121217102248
AUTHID  : DB2ADMIN            
EDUID   : 3164                 EDUNAME: db2med.668.0 (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqluFencedVendorProcessCB::loadLibrary, probe:103
MESSAGE : ZRC=0x830003E9=-2097150999

DATA #1 : String, 33 bytes
C:\WINDOWS\system32\libnsrdb2.dll

LEVEL: Error
PID     : 3792                 TID : 3164           PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000           DB   : SAMPLE
APPHDL  : 0-9                  APPID: *LOCAL.DB2.121217102248
AUTHID  : DB2ADMIN            
EDUID   : 3164                 EDUNAME: db2med.668.0 (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqluFencedVendorProcessInit, probe:113
MESSAGE : SQL2071N  An error occurred while accessing the shared library
"C:\WINDOWS\system32\libnsrdb2.dll". Reason code: "2".
DATA #1 : ZRC, PD_TYPE_ZRC, 4 bytes
0x830003E9

0 项奖励
TimQuan
3 Zinc

Re: DB2备份报错

楼主考虑升级到NetWorker 8.0NetWorker Module for Databases and Applications (NMDA)吧,NetWorker 7.4NetWorker Module for DB2早就淘汰了,EMC早就不支持了。

lilei1
1 Nickel

Re: DB2备份报错

主要客户是7.6版本,那如果用networker 7.6版本和db2 4.0的模块来备份db2V10,可以嘛?

0 项奖励
TimQuan
3 Zinc

Re: DB2备份报错

升级到NMDA module吧。NetWorker Module for DB2 2008EMC就不再官方支持了。

liulei_it
4 Germanium

Re: DB2备份报错

能不能考虑对DB2不用模块备份使用原始方法备份行吗?

0 项奖励

Re: DB2备份报错

什么是原始方法?

0 项奖励
liulei_it
4 Germanium

Re: DB2备份报错

例如对于Oracle可以先把其置为备份模式的alter database begin backup,然后开始备份结束以后就alter database end backup.就OK啦。就想普通的文件系统备份一样。 不知道DB2有没有这个方式备份的。

0 项奖励

Re: DB2备份报错

据我了解是没有的,不过你可以问问IBM。

0 项奖励