Backing up DB2 to TSM - Linux

[rohitzoom2050]

got it bt when i tried the command

$ db2 backup db sample use tsm

bt got the error
An error occurred while accessing TSM during the processing of a
database utility. TSM reason code: "11".

in dsierror.log
02/24/2011 02:30:33 ANS5216E Could not establish a TCP/IP connection with address '127.0.0.1:1500'. The TCP/IP error is 'Connection refused' (errno = 111).
02/24/2011 02:30:33 ANS9020E Could not establish a session with a TSM server or client agent. The TSM return code is -50.

the error code says that db2 is unable to read the option file
my dsm.sys and dsm.opt files are are as mentioned in previous post
and environment variables are also set
firewall is also off
:-(

 

[Harry_Redl]

Hi,

moved this to the new thread as it is not related to the original topic ...

this is error "11"
0011 E DSM_RC_ABORT_NO_REPOSIT_SPACE Explanation: The server does not have any space available to store the object.

And it seems to be caused by TSM server rejecting the session.
Can you show us the activity log part from the server? (q act begintime=xx:yy endtime=uu:vv)

Harry

 

[rohitzoom2050]

still unable to find the error step
i checked the full trace and tcp/ip connections are working fine as shown in the trace below

trace--> on attempting $db2 backup db sample use tsm
02/25/2011 17:23:43.810 [009293] [2951485136] : session.cpp (106: sessInit: Session initialized.
02/25/2011 17:23:43.810 [009293] [2951485136] : session.cpp (1126): sessOpen: Attempting to open communications
02/25/2011 17:23:43.810 [009293] [2951485136] : session.cpp (1222): sessOpen(): calling the communication specific open routine
02/25/2011 17:23:43.811 [009293] [2951485136] : commtcp.cpp (1583): TcpOpen: Internet socket defined.
02/25/2011 17:23:43.811 [009293] [2951485136] : pscomtcp.cpp (1504): psTcpGetsockopt(): Get options on socket 10 (IPv4) -> rc=0, errno=0
02/25/2011 17:23:43.811 [009293] [2951485136] : pscomtcp.cpp (1504): psTcpGetsockopt(): Get options on socket 10 (IPv4) -> rc=0, errno=0
02/25/2011 17:23:43.811 [009293] [2951485136] : pscomtcp.cpp (1504): psTcpGetsockopt(): Get options on socket 10 (IPv4) -> rc=0, errno=0
02/25/2011 17:23:43.811 [009293] [2951485136] : pscomtcp.cpp (1504): psTcpGetsockopt(): Get options on socket 10 (IPv4) -> rc=0, errno=0
02/25/2011 17:23:43.811 [009293] [2951485136] : commtcp.cpp (3772): SetSocketOptions(): tcp_sendbuffsize(129024), tcp_recvbuffsize(129024)
02/25/2011 17:23:43.811 [009293] [2951485136] : commtcp.cpp (1613): TcpOpen: Trying to connect to server at:
02/25/2011 17:23:43.811 [009293] [2951485136] : commtcp.cpp (1614): Domain Name: LOCALHOST
02/25/2011 17:23:43.811 [009293] [2951485136] : commtcp.cpp (1616): Port #: 1500
02/25/2011 17:23:43.811 [009293] [2951485136] : commtcp.cpp (1641): TcpOpen: using blocking sockets
02/25/2011 17:23:43.812 [009293] [2951485136] : pscomtcp.cpp (1133): psTcpConnect(): Attempt socket 10 (IPv4) connection -> rc=0, errno=0
02/25/2011 17:23:43.812 [009293] [2951485136] : commtcp.cpp (1800): TcpOpen: Server accepted TCP/IP socket connection.
02/25/2011 17:23:43.812 [009293] [2951485136] : session.cpp (4520): sessOpen: Transitioning: sInit state ===> sOpened state
02/25/2011 17:23:43.812 [009293] [2951485136] : session.cpp (1291): sessOpen: Session communications opened, beginning sign-on.
02/25/2011 17:23:43.812 [009293] [2951485136] : session.cpp (1293): sessOpen: Server accepted signon, communications

<b>suspected error lines in the trace </b>

02/25/2011 17:27:48.321 [009432] [2950866640] : optservices.cpp (321: FILE SPACE OPTIONS
02/25/2011 17:27:48.321 [009432] [2950866640] : optservices.cpp (322: fileSpaceList not specified
02/25/2011 17:27:48.321 [009432] [2950866640] : optservices.cpp (3533): DOMAIN OPTIONS
02/25/2011 17:27:48.321 [009432] [2950866640] : optservices.cpp (3536): domainKeywords not specified
02/25/2011 17:27:48.321 [009432] [2950866640] : optservices.cpp (355: domain not specified
02/25/2011 17:27:48.321 [009432] [2950866640] : optservices.cpp (356: -domain not specified
02/25/2011 17:27:48.321 [009432] [2950866640] : optservices.cpp (357: domain.image not specified
02/25/2011 17:27:48.321 [009432] [2950866640] : optservices.cpp (358: domain.nas not specified
02/25/2011 17:27:48.321 [009432] [2950866640] : optservices.cpp (3240): HSM OPTIONS
02/25/2011 17:27:48.321 [009432] [2950866640] : optservices.cpp (7281): SrvCanOvrRde(N) Src(0x00=Default)


<b>but when i check at the server everything seems right</b>

copygroup info
policy domain name = DB2
Policy set active
mgmt class name db2mgmt

device class name =fileclass
storage pool name = db2_stg_pool


is there any step i'm missing ?
i'm using tsm for the first time with no prior experience of any other backup manager

 

[Harry_Redl]

Hi,

the server activity log output please ... as DB2 stores data as type BACKUP and logs as type ARCHIVE, you need both backup and archive copygroups in you db2mgmt - and enough space in all corresponding stgpools.

Harry