2008-2-19 09:35
feidang
tsm 5.4 备份db2问题
备份服务器:windows2003+ISC+AC
客户端:AIX5.3+DB2 V9.1
从客户端
1. #dsmj,备份测试到带库 没有问题
2. db2 backup database test to /dev/rmt0 也没问题
[color=Red]3、db2 backup database test use tsm,
SQL2033N An error occurred while accessing TSM during the processing of a
database utility. Reason code: "106".[/color]
客户端 tsm for aix client 重新装过了,也是这样,请各位大侠帮忙,还需要我提供什么信息?
[[i] 本帖最后由 feidang 于 2008-2-19 09:38 编辑 [/i]]
2008-2-19 10:10
jiangxh
tsm client的api是否没有配置好啊?
2008-2-19 10:14
feidang
dsm.opt
Servername xhserver1
dsm.sys
SErvername xhserver1
COMMMethod TCPip
TCPPort 1500
TCPServeraddress 10.100.2.237
TCPCLIENTPort 1501
NODename xhnc3
TCPCLIENTAddress 10.100.2.103
PasswordAccess Generate
SCHEDMode Prompted
SCHEDLOGName /home/db2inst1/tsm/dsmsched.log
ERRORLOGName /home/db2inst1/tsm/dsmerror.log
2008-2-19 15:37
jpzhai
查看一下日志
2008-2-19 21:40
darkbug
dsmi 等环境变量
[[i] 本帖最后由 darkbug 于 2008-2-19 21:41 编辑 [/i]]
2008-2-20 20:09
qian1110
106是没权限
2008-2-22 11:09
feidang
106的问题解决了,
把ba和api 的dsm.opt,dsm.sys 内容分开
ba:
dsm.opt
SErvername xhserver1
dsm.sys
SErvername xhserver1
COMMMethod TCPip
TCPPort 1500
TCPServeraddress 10.100.2.237
TCPCLIENTPort 1501
NODename xhnc3
TCPCLIENTAddress 10.100.2.103
PasswordAccess Generate
api:
dsm.opt
SErvername xhnc_db2
dsm.sys
SErvername xhnc_db2
COMMMethod TCPip
TCPPort 1500
TCPServeraddress 10.100.2.237
NODename db2_node
TCPCLIENTAddress 10.100.2.103
TCPCLIENTPort 1501
PASSWORDAccess Generate
2008-2-22 11:12
feidang
db2下 .profile 文件
#export DB2CODEPAGE=1386
DSMI_CONFIG=/usr/tivoli/tsm/client/api/bin64/dsm.opt
DSMI_DIR=/usr/tivoli/tsm/client/api/bin64
DSMI_LOG=/home/db2inst1/tsm
export DSMI_DIR DSMI_CONFIG DSMI_LOG
注意把/home/db2inst1/tsm 下的log文件 读写权限加上
2008-2-22 22:45
darkbug
总结的不错,db2用tsm备份是最简单的
2008-2-27 16:20
jiangxh
servername都要改变吗?不用吧?
2008-3-5 21:20
ibm-lxy
# cat dsm.sys
SErvername tsm
COMMMethod TCPip
TCPPort 1500
TCPServeraddress 172.61.7.219
nodename db219
enablelanfree yes
LANFREECommmethod TCPIP
LANFREETCPPort 1500
Compression OFF
TCPBuffsize 32
TCPWindowsize 24
Passwordaccess generate
ERRORLOGName /home/db2inst1/tsmerrorlog
我的API和bin下的dsm.opt dsm.sys内容是一致的。
su - db2inst1
db2 backup db 数据库名 use tsm
2008-3-5 21:24
ibm-lxy
$ cat .profile
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.
export PATH
if [ -s "$MAIL" ] # This is at Shell startup. In normal
then echo "$MAILMSG" # operation, the Shell checks
fi # periodically.
# The following three lines have been added by UDB DB2.
if [ -f /home/db2inst1/sqllib/db2profile ]; then
. /home/db2inst1/sqllib/db2profile
fi
export DSMI_CONFIG=/usr/tivoli/tsm/client/api/bin64/dsm.opt
export DSMI_DIR=/usr/tivoli/tsm/client/api/bin64
export DSMI_LOG=/usr/tivoli/tsm/log
$ ls -al
total 48
drwxr-xr-x 3 db2inst1 db2iadm1 256 Feb 28 14:45 .
drwxr-xr-x 11 bin bin 4096 Feb 28 09:48 ..
-rwxr----- 1 db2inst1 db2iadm1 610 Feb 28 13:13 .profile:loveliness:
-rw------- 1 db2inst1 db2iadm1 6962 Mar 05 21:39 .sh_history
drwxrwsr-t 18 db2inst1 db2iadm1 4096 Jan 23 17:57 sqllib
-rwxrwxrwx 1 db2inst1 db2iadm1 3454 Mar 05 21:12 tsmerrorlog
2008-3-5 21:29
ibm-lxy
[quote]原帖由 [i]feidang[/i] 于 2008-2-22 11:09 发表 [url=http://www.loveunix.com/redirect.php?goto=findpost&pid=760720&ptid=81377][img]http://www.loveunix.com/images/common/back.gif[/img][/url]
106的问题解决了,
把ba和api 的dsm.opt,dsm.sys 内容分开
ba:
dsm.opt
SErvername xhserver1
dsm.sys
SErvername xhserver1
COMMMethod TCPip
TCPPort 1500
TCPSer ... [/quote]
怎么和API下的TSM SERVER名称不一样??能讲一下吗!
2008-3-6 15:33
haomao1879
[quote]原帖由 [i]ibm-lxy[/i] 于 2008-3-5 21:29 发表 [url=http://bbs.loveunix.net/redirect.php?goto=findpost&pid=763417&ptid=81377][img]http://bbs.loveunix.net/images/common/back.gif[/img][/url]
怎么和API下的TSM SERVER名称不一样??能讲一下吗! [/quote]
api下备份数据库用,ba下备份文件用
2008-3-7 17:13
guoguo5481
root用户需要设置这些环境变量么?root的.profile在哪,/目录下只有.dtprofile
DSMI_CONFIG=/usr/tivoli/tsm/client/api/bin64/dsm.opt
DSMI_DIR=/usr/tivoli/tsm/client/api/bin64
另外我的tsm server是全部安装的,那么怎么判断是在32位模式下还是在64位模式下呢?
2008-3-11 01:50
alex1019
[quote]原帖由 [i]guoguo5481[/i] 于 2008-3-7 17:13 发表 [url=http://bbs.loveunix.net/redirect.php?goto=findpost&pid=764043&ptid=81377][img]http://bbs.loveunix.net/images/common/back.gif[/img][/url]
root用户需要设置这些环境变量么?root的.profile在哪,/目录下只有.dtprofile
DSMI_CONFIG=/usr/tivoli/tsm/client/api/bin64/dsm.opt
DSMI_DIR=/usr/tivoli/tsm/client/api/bin64
另外我的tsm serve ... [/quote]
bin和bin64是看系统的bootinfo -K确认,如果是64位就用bin64,如果是32位就用bin
顺便想问一下
如果是windows设置环境变量也是一样对应吗??
为什么我一直提示406错误
页:
[1]
Powered by Discuz! Archiver 5.5.0
© 2001-2006 Comsenz Inc.