DB2归档日志没有被TSM备份
a3inr2fb@b03cxnp46026:/db/a3inr2fb/db2backup# db2adutl query full
Query for database R2FAPP
Retrieving FULL DATABASE BACKUP information.
No FULL DATABASE BACKUP images found for R2FAPP
Retrieving INCREMENTAL DATABASE BACKUP information.
No INCREMENTAL DATABASE BACKUP images found for R2FAPP
Retrieving DELTA DATABASE BACKUP information.
No DELTA DATABASE BACKUP images found for R2FAPP
在db2diag.log中有以下错误
2011-09-02-07.44.23.114538+000 E859182A347 LEVEL: Error
PID : 13500666 TID : 1 PROC : db2vend
INSTANCE: a3inr2fb NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, database utilities, sqluvint, probe:374
DATA #1 : TSM RC, PD_DB2_TYPE_TSM_RC, 4 bytes
TSM RC=0x0000006A=106 -- see TSM API Reference for meaning.
查了一下information center
http://publib.boulder.ibm.com/infocenter/tsminfo/v6r2/index.jsp?topic=%2Fcom.ibm.itsm.srv.install.doc%2Ft_srv_prep_dbmgr.html
define DSM_RC_ACCESS_DENIED 106 /* denied due to improper permission */
#
说是权限问题,但是确认过DSMI_LOG等路径下的权限已经足够大
看到有如下链接
https://www-304.ibm.com/support/docview.wss?uid=swg21399011
引用
The API return code 106 means DSM_RC_ACCESS_DENIED and is referring to the error log file in the DSMI_LOG environment variable.
DSMI_LOG下的error log文件权限足够,不过是空的
a3inr2fb@b03cxnp46026:/db/a3inr2fb/db2backup/apilogs# ls -atrl
total 8
drwxr-xr-x 4 a3inr2fb dbadmin 4096 Sep 1 08:24 ..
-rwxrwxrwx 1 a3inr2fb dbadmin 0 Sep 1 08:27 dsierror.log
drwxrwxr-x 2 a3inr2fb dbadmin 256 Sep 1 08:27 .
再看看dsm.sys文件下面的设置
a3inr2fb@b03cxnp46026:/db/a3inr2fb/db2diag# grep ERROR /usr/tivoli/tsm/client/api/bin64/dsm.sys
没有设置ERRORLOGNAME,尝试手动设置
ERRORLOGName /usr/tivoli/tsm/client/ba/bin/dsmerror.log
ERRORLOGRetention 2 D
备份就恢复正常了
看来这是因为TSM客户端无法写错误日志,所以无法进行备份
a3inr2fb@b03cxnp46026:/db/a3inr2fb/arclog_bpedb# db2adutl query db BPEPPDB
Query for database BPEPPDB
Retrieving FULL DATABASE BACKUP information.
No FULL DATABASE BACKUP images found for BPEPPDB
Retrieving INCREMENTAL DATABASE BACKUP information.
No INCREMENTAL DATABASE BACKUP images found for BPEPPDB
Retrieving DELTA DATABASE BACKUP information.
No DELTA DATABASE BACKUP images found for BPEPPDB
Retrieving TABLESPACE BACKUP information.
No TABLESPACE BACKUP images found for BPEPPDB
Retrieving INCREMENTAL TABLESPACE BACKUP information.
No INCREMENTAL TABLESPACE BACKUP images found for BPEPPDB
Retrieving DELTA TABLESPACE BACKUP information.
No DELTA TABLESPACE BACKUP images found for BPEPPDB
Retrieving LOAD COPY information.
No LOAD COPY images found for BPEPPDB
Retrieving LOG ARCHIVE information.
Log file: S0009508.LOG, Chain Num: 1, DB Partition Number: 0, Taken at: 2011-09-02-03.44.45
Log file: S0009509.LOG, Chain Num: 1, DB Partition Number: 0, Taken at: 2011-09-02-03.45.07
Log file: S0009510.LOG, Chain Num: 1, DB Partition Number: 0, Taken at: 2011-09-02-03.45.28
Log file: S0009511.LOG, Chain Num: 1, DB Partition Number: 0, Taken at: 2011-09-02-03.45.48
Log file: S0009512.LOG, Chain Num: 1, DB Partition Number: 0, Taken at: 2011-09-02-03.46.09
Log file: S0009513.LOG, Chain Num: 1, DB Partition Number: 0, Taken at: 2011-09-02-03.46.30
Log file: S0009514.LOG, Chain Num: 1, DB Partition Number: 0, Taken at: 2011-09-02-03.46.51
Log file: S0009515.LOG, Chain Num: 1, DB Partition Number: 0, Taken at: 2011-09-02-03.47.12
Log file: S0009516.LOG, Chain Num: 1, DB Partition Number: 0, Taken at: 2011-09-02-03.47.34
Log file: S0009517.LOG, Chain Num: 1, DB Partition Number: 0, Taken at: 2011-09-02-03.47.55
Log file: S0009518.LOG, Chain Num: 1, DB Partition Number: 0, Taken at: 2011-09-02-03.48.16
分享到:
相关推荐
韩国触摸芯片TSM12/TSM16驱动程序
详细的介绍了TSM,详细的介绍了TSM,详细的介绍了TSM,详细的介绍了TSM.
TSM备份相关文档集合,包含以下文档: linux下安装TSM7.1.doc TSM-7.1.6部署工艺手册.pdf TSM培训课件.ppt TSM操作指南.docx TSM日常维护手册.doc TSM的监控和维护.pdf TSM系统备份介绍.doc tsm维护.doc ...
tsm常用命令tsm常用命令tsm常用命令tsm常用命令tsm常用命令
TSM SAN Agent for ORACLE RAC 实验
TSM在AIX环境上的维护文档 3 §1.1 TSM服务器hztsmserver1在AIX环境上的维护文档 3 §1.1.1 TSM服务器的启动 3 §1.1.2 ISC服务器的启动与关闭 3 §1.1.3 TSM服务器的管理中心界面的进入 4 §1.1.4 TSM管理客户机的...
tsm安装文档 修改drive path
韩国ADS的,常用触摸按键芯片TSM12方案,主要用在市面上常用的12键的门锁
tsm5.5安装指南 tsm5.5安装指南 tsm5.5安装指南
TSM12M手册和驱动程序
IBM TSM TSM 学习 资料 安装 介绍
IBM tsm日常维护,讲述了平时对tsm的一些操作
TSM(Tivoli Storage Manager) 软件是 IBM 存储管理经验的结晶。 TSM 是为解决企业级数据及系统安全而设计的备份全面解决方案,为石油、金融、电信等许多大型企业,解决困扰信息技术部门的备份管理问题。它在节省成本...
华为TSM终端安全管理系统身份认证功能 (2).pdf华为TSM终端安全管理系统身份认证功能 (2).pdf华为TSM终端安全管理系统身份认证功能 (2).pdf华为TSM终端安全管理系统身份认证功能 (2).pdf华为TSM终端安全管理系统身份...
TSM实施文档TSM实施文档TSM实施文档TSM实施文档TSM实施文档TSM实施文档TSM实施文档TSM实施文档TSM实施文档TSM实施文档TSM实施文档TSM实施文档TSM实施文档TSM实施文档TSM实施文档TSM实施文档TSM实施文档TSM实施文档...
TSM培训的PPT 商业机构关于tsm培训的ppt,可以当做入门的介绍看看
有浅入深,分析TSM让你更快的掌握TSM
很好的TSM控制台管理手册 很好的TSM控制台管理手册 很好的TSM控制台管理手册
tsm installation guide