ADSM.ORG

Backup of share hangs

redplumptomato — Tue, 21 May 2013 13:14:41 GMT

Hi all,

We are backing up a share as an example:

\\share\files\

The domain statement is simple:

DOMAIN "\\share\files"
We tried using memoryefficient yes, but, doesn't seem to help.

This share contains 3 million objects (and is expected to grow). We find that in the dsmsched.log, it shows the last line at 1.3 million files, but, no activity commences. When doing a q se, you see the session, with an idlew of 0 seconds.

I find that this happens during a manual backup as well. The server is a physical machine, 64 bit windows with 4 cores and 26GB of ram. network, cpu, and memory all look very good during the backup. Nothing appears in dsierror or ac log.

Any suggestions?

No IBMTape or IBMChanger devices in Linux

salsalem — Tue, 21 May 2013 07:43:15 GMT

Hello,

Im running RHEL 5.9 and I have installed lin_tape and lin_taped successfully. In DMESG I have the following:

qla2xxx 0000:10:00.1: LOOP UP detected (2 Gbps).
Vendor: IBM Model: ULT3580-TD3 Rev: 73P5
Type: Sequential-Access ANSI SCSI revision: 03
Vendor: IBM Model: 3576-MTL Rev: 635G
Type: Medium Changer ANSI SCSI revision: 03

I have no tape devices in /dev. Any helpful advise? Thanks in advance :)

Sam

Compression - RMAN vs TSM vs Tape Drive

GregE — Mon, 20 May 2013 18:45:48 GMT

Has anyone done any analysis on compression rates? We compress at the tape drive level as most do, and have several Oracle DBs that backup LAN-Free. For Oracle data that backs up to disk (smaller DBs and archive logs) we compress at the TSM client level.

Oracle can do the compression with the following command:
BACKUP AS COMPRESSED BACKUPSET DATABASE

For LAN-Free, the tape drive would not compress further if the client is doing it, but how does RMAN compression compare with tape drive compression? (LTO-4)

For our smaller DBs and archive logs going over the LAN to disk, how does RMAN compression compare to TSM client compression?

Rman

fabiordeoliveira — Mon, 20 May 2013 18:34:17 GMT

HI,

how to restore the tdporacle?

TSM Enhancement

GregE — Mon, 20 May 2013 15:16:28 GMT

If there is a way to do it, a useful feature would be an inclexcl option to allow files on a path and directories on the same path to go to different storage pools. Similar to what we now have as DIRMC, but that can be applied to specific data.

Example:
A client with a 35 day overall retention.
A specific path on that client requires 1 year retention (or whatever.)
Currently DIRMC applies to the entire client data. If DIRMC is not used, the management class with longest RETAINONLY applies, but to the entire client.

It would be nice to have an inclexcl option which would allow something like this:
include /path_to_data_A/ mc_data
include.dirsonly /path_to_data_A/ mc_dir

Same data path, but files and directories treated differently, at a more granular level than DIRMC.

Some environments may not get involved in archiving, choosing instead to simply retain data as backup. This would be of assistance to that environment.

Format HH:MM:SS field

rdemaat — Mon, 20 May 2013 13:03:20 GMT

Hello all, I have this script that is working except that in the hours, minutes and seconds fields when any of them have a leading zero the zero gets dropped. For instance: if a session has been running for 12 minutes and 7 seconds the output will display 0:12:7 instead of 00:12:07. A trailing zero is ok. Those get displayed. I suspect I have to do something with the decimal(2) but not sure what that might be yet so I thought I'd ask the experts.

Thanks!

select client_name, session_id, state, -
substr(cast((start_time) as char(29)),1,10) as "Start Date", -
substr(cast((start_time) as char(29)),12,8) as "Start Time", -
cast(float(bytes_sent/1024/1024) as dec(12,3)) as "MB Sent", -
cast(float(bytes_received/1024/1024) as dec(12,3)) as "MB Recvd", -
CAST((current_timestamp-start_time)hours as decimal(2))||':'|| -
CAST((current_timestamp-start_time)minutes as decimal(2))||':'|| -
CAST((current_timestamp-start_time)seconds as decimal(2)) as "ELAPTIME HH:MM:SS" -
from sessions order by session_id

Drive Offline

markybee777 — Mon, 20 May 2013 11:08:21 GMT

I keep noticing a Drive within the media library Keeps going offline;

q path
Source Name Source Type Destination Destination On-Line
Name Type
----------- ----------- ----------- ----------- -------
TSM SERVER DRIVE15 DRIVE No

Any idea what could be causing this?

Unsure what I should try searching for in the actlog!!

Unable to install ISC console in New windows OS

Hiten — Mon, 20 May 2013 09:21:55 GMT

Hi,

In our organisation we are planning to install the ISC console version 6.0.2 but its showing attached error. We have checked & installed jvm before installation but still getting error.

OS:Windows 2008 x64 bit R2

Actually we are planning to install & check the TSM version 5.5 in same os but isc console itself not getting installed.

Attached Files

log.txt (3.2 KB)

TSM v6.3 on AIX 7.1 Sequential File Pool Anomoly....

jharris — Mon, 20 May 2013 07:17:34 GMT

I have a sequential file pool 'DIR_BAK_E_F' used just for DIR_MC objects and it rapidly ran out of scratch volumes.

Upon inspection I noticed that the volumes were not reaching their maximum capacity, before being 100% full and a new file volume was created. I inspected the file system and the files appear to be created to the correct size of the device class, but query volume shows that these volumes are full with hardly no utilisation. I then moved the data from one of those FULL volumes and the process completes showing only around 12MB copied.

Any idea's why the volumes aren't storing the maximum amount of data as defined by the device class?

Some details below:
4:44:46 PM DDVTSM01 : q stg DIR_BAK_E_F
Storage Device Estimated Pct Pct High Low Next Stora-
Pool Name Class Name Capacity Util Migr Mig Mig ge Pool
Pct Pct
----------- ---------- ---------- ----- ----- ---- --- -----------
DIR_BAK_E_F DIR_MC 21 G 0.3 0.3 90 70

4:37:13 PM DDVTSM01 : q vol stgp=DIR_BAK_E_F
Volume Name Storage Device Estimated Pct Volume
Pool Name Class Name Capacity Util Status
------------------------ ----------- ---------- --------- ----- --------
/tsmstg/dir_mc/0000024F- DIR_BAK_E_F DIR_MC 15.0 M 100.0 Full
.BFS
/tsmstg/dir_mc/00000250- DIR_BAK_E_F DIR_MC 12.7 M 100.0 Full
.BFS
/tsmstg/dir_mc/00000251- DIR_BAK_E_F DIR_MC 20.2 M 100.0 Full
.BFS
/tsmstg/dir_mc/00000252- DIR_BAK_E_F DIR_MC 11.3 M 100.0 Full
.BFS
/tsmstg/dir_mc/00000253- DIR_BAK_E_F DIR_MC 1,024.0 M 0.1 Filling
.BFS

root@ddvtsm01 /tsmstg/dir_mc #l
total 12652120
drwxrwxr-x 2 root tsmsrvrs 4096 May 20 16:38 .
drwxrwxr-x 21 root tsmsrvrs 4096 May 10 12:14 ..
-rw------- 1 tsminst1 tsmsrvrs 1073741824 May 20 16:28 00000250.bfs
-rw------- 1 tsminst1 tsmsrvrs 1073741824 May 20 16:28 00000251.bfs
-rw------- 1 tsminst1 tsmsrvrs 1073741824 May 20 16:36 00000252.bfs
-rw------- 1 tsminst1 tsmsrvrs 1073741824 May 20 16:38 00000253.bfs
-rw------- 1 tsminst1 tsmsrvrs 85721088 May 20 16:38 00000254.bfs
-rw------- 1 tsminst1 tsmsrvrs 2097152000 May 19 22:41 dir_bak_e_d.vol

05/20/2013 16:36:50 ANR0515I Process 163 closed volume
/tsmstg/dir_mc/00000253.BFS. (SESSION: 9154, PROCESS:
163)
05/20/2013 16:36:50 ANR0986I Process 163 for MOVE DATA running in the
BACKGROUND processed 17,413 items for a total of
12,543,874 bytes with a completion state of SUCCESS at
16:36:50. (SESSION: 9154, PROCESS: 163)

4:43:11 PM DDVTSM01 : q devc dir_mc f=d
Device Class Name: DIR_MC
Device Access Strategy: Sequential
Storage Pool Count: 1
Device Type: FILE
Format: DRIVE
Est/Max Capacity (MB): 1,024.0
Mount Limit: 100
Mount Wait (min):
Mount Retention (min):
Label Prefix:
Library:
Directory: /tsmstg/dir_mc
Server Name:
Retry Period:
Retry Interval:
Shared:
High-level Address:
Minimum Capacity:
WORM: No
Drive Encryption:
Scaled Capacity:
Primary Allocation (MB):
Secondary Allocation (MB):
Compression:
Retention:
Protection:
Expiration Date:
Unit:
Logical Block Protection:
Last Update by (administrator): ADMXXXX
Last Update Date/Time: 05/20/2013 16:08:44

/etc/security/limits file, root and tsminst1 unlimited file size.
root:
fsize = -1
data = -1
stack = -1
core = -1
rss = -1
nofiles = -1

tsminst1:
fsize = -1
data = -1
stack = -1
core = -1
rss = -1
nofiles = -1

After Upgrade to TSM server 6.3.3 Unable to open GUI from dsmj

shadab — Sun, 19 May 2013 07:01:33 GMT

Dear All,
i need an urgent support.
in our environment we upgrade tsm server 5.5 to tsm server 6.3.3 on windows server.
currently we are using to take oracle 9i and 10g lanfree with following configuration:
TDP for oracle 5.4.1.
tsm ba client version 5.5.0
SAN agent 5.5.7.
Atape Driver:12.6.0.0
Library:ts3310

on tsm 5.5 with the same config dsmj and everyting was working fine but now after upgrade i can able to
run backup throguh cmd line but not able to open through dsmj and web.

Dsmj Gui Error: ANS5179E TSM is unable to continue.Existing program.

output of dsmjlog
aixserver:/usr/tivoli/tsm/client/ba/bin>cat dsmj.log
IMBase (Constructor): dsmagent exited with code: 255

if i run dsmagent on my aix client, iam getting below message:

aixserver::/usr/tivoli/tsm/client/ba/bin>dsmagent
exec(): 0509-036 Cannot load program dsmagent because of the following errors:
0509-150 Dependent module libxmlutil-5.5.3.0.a could not be loaded.
0509-022 Cannot load module libxmlutil-5.5.3.0.a.
0509-026 System error: A file or directory in the path name does not exist.

i checked but bit confuse about version compatibility of tdp , ba client support to server 6.3.3.
i need to upgrade my tdp client but need to confirm that which new tdp oracle version will support 9i and 10g with TSM Server 6.3.3 and which ba client?

pls reply.

Archive Retrieval

swarsiri — Sun, 19 May 2013 06:06:57 GMT

Hi Admins,

I have a requirement to test our old archives stored in Tapes for the purpose of Internal Audit. Below is my requirement.

Archive date - older than 15.01.2012 (or say between 01.01.2011 and 15.01.2012)
Nodename - ABC
Folder to retrieve - /b01 (almost 500gb of data)
stg pool=MONTHLY_COPY_POOL

The Tapes are stored in a remote location. I would need a command to identify the list of tapes required, specific to this retrieve. I have tried the below commands already.

select distinct volume_name from contents a, backups b where a.node_name='ABC' and a.object_id=b.object_id and backup_date<'01.01.2012' and stg=MONTHLY_COPY_POOL

q nodedata ABC stg='MONTHLY_COPY_POOL'

select distinct volume_name from volumeusage where node_name='ABC' and stgpool_name='MONTHLY_COPY_POOL' (or)

Expecting a simple and strong command to identify the tape list. :confused:

:up: Cheers - Siri

Tsm lan free backup - performance tuning tips required

anandgmenon — Fri, 17 May 2013 13:44:07 GMT

Hi Team,

We are implementing TSM LAN Free backups for few of our AIX Clients .

However we dont see much improvement in the "Backup elapsed processing time".

Please find below a snapshot of our config.

Kindly help us with a few tips to boost performance.

dsm.sys

tcpwindows 63
tcpbuff 512
txnbytel 25600
tcpnod yes
compression no
enablelanfree yes
lanfreecommmethod SharedMem

lanfreeshmport 1510

dsmsta.opt

COMMmethod TCPIP
COMMmethod SHAREDMEM
TCPPort 1500
TCPWindowsize 63
TCPNodelay YES

SHMPort 1510

Library Setup

We are using a TS3310 tape library with 2 LTO5 drives ( one drive defined as control Path ).

Both the drives are zoned to each TSM Client . Each drive is zoned via a dedicated Tape adapter.

Both the SAN Switch ports as well as the Tape drive ports are set to 8G speed instead of auto negotiation.

Present Data transfer rates

Total number of objects inspected: 204,738
Total number of objects backed up: 639
Total number of objects updated: 0
Total number of objects rebound: 0
Total number of objects deleted: 0
Total number of objects expired: 63
Total number of objects failed: 0
Total number of bytes inspected: 111.11 GB
Total number of bytes transferred: 18.81 GB
LanFree data bytes: 18.80 GB
Data transfer time: 209.98 sec
Network data transfer rate: 93,949.76 KB/sec
Aggregate data transfer rate: 26,228.38 KB/sec
Objects compressed by: 0%
Total data reduction ratio: 83.07%
Elapsed processing time: 00:12:32

MOUNTRETENTION parameter does not affect

hany66 — Fri, 17 May 2013 08:21:23 GMT

i have TSM v6.3 with External tape drive TS2250 Configured as manual Library(Under Windows server 2008r2,64-bit), my question is:

i change the value of MOUNTRETENTION parameter to 9999 minutes, but still the tape dismount after 60 Minutes!! why

even i restare the server

TSM 6.2 Multiple DB backups with difference in expiration days

elaurens — Fri, 17 May 2013 08:00:48 GMT

Hello everyone,

First time posting here since I couldn't find what I'm looking for using the search tool.
Not sure if what I'm trying to do is possible w/ TSM, but it couldn't hurt to ask, right? ;)

The situation is the following; we have a lot of decentralized TSM servers and I would like to accomplish having 4 full DB backups on the decentralized server and 1 full weekly (on saturday) DB backup of every decentralized server at our main office. Since I want to automate the whole process, I make sure that TSM deletes all the (expired) DB backup files (volumes) on disk.

The following commands are part of the maintenance script running on the decentralized servers:

//Create full DB backup on disk @decentralized server and on disk @centralized server
backup db devclass=FILEDB type=FULL wait=yes
backup db devclass=OFFDB type=FULL wait=yes

//Deleting DB backup volumes
set drmdbbackupexpiredays 4
set drmfileprocess yes
move drmedia * source=dbbackup enddate=today-4 wherestate=mountable tostate=vault
move drmedia * source=dbbackup wherestate=vaultretrieve tostate=onsiteretrieve

The result of this is that I'm having the 4 full DB backups on the decentralized server, but that it's only keeping them for 4 days on my centralized server. The DB backups on the centralized server needs to be kept for a whole week (until the next backup is taken)

My question is, is it possible to set a different expiration "policy" on a db backup depending on where they are stored? Or is there another way to achieve what I'm trying to do?

Thx in advance for your answers! :)

Backup to new Mgmtclass

dabe — Fri, 17 May 2013 08:00:46 GMT

Hi,

we defined a new Policy domain and Management Class on our TSM-Server (linux) and then we assigned it to a host. But when i run a backup via command line on this host, the backupfiles stored by the default mgmt class. Did we miss somthing in the configuration and how we can backup to this new mgmtclass from commandline?

Many thanks in advance!

Dave

TSM 6.3.3 AIX 7.1 ANR2981E Database backup terminated DB2 sqlcode -2033 sqlerrmc 106

jharris — Fri, 17 May 2013 07:18:28 GMT

OK,

I'm in the process of building a few TSM 6.3.3 servers on AIX 7.1.

My first instance works perfectly, but the second instance won't backup the database when dsmserv has been automatically started after a system reboot. I get the following error: ANR2981E Database backup terminated due to environment or setup issue related to file access - DB2 sqlcode -2033 sqlerrmc 106

I'm pretty sure this is just a simple file security/pathing problem, so I've tried everything I can think of regarding environment variable, file/folder ownership, deleting the tsmdbmgr.log file, reseting the dsmapipw password (multiple times) and examining the necesarry option file stanza's for any sneaky typo's...

But wait, here's the kicker... If I halt the server, login with account 'tsminst1' and make sure I'm in the instance folder /home/tsminst1/tsminst1 , I can run '/opt/tivoli/tsm/server/bin/dsmerv -q' then issue a backup db command via a dsmadmc console and it all works fine. If I then halt the server again, reboot and let the /etc/inittab run the dsmserv process, it fails.

The /etc/inittab file has the following line in it:
tsminst1:2:once:/opt/tivoli/tsm/server/bin/rc.dsmserv -u tsminst1 -i /home/tsminst1/tsminst1 -q >/dev/console 2>&1

Any help would be much appreciated as I've got another two instances I need to build asap.

ANS0326E (RC41) This node has exceeded its maximum number of mount points.

influx — Thu, 16 May 2013 21:00:21 GMT

Hoping someone can help. I know what this message means, however, the dba insists he's not launching more sessions than the assigned mount points. I'm not seeing anything in the TSM logs to indicate an issue. Also, they see this quite frequently.

backup failed - ANS0326E (RC41) This node has exceeded its maximum number of mount points.

Building the Journal

GregE — Thu, 16 May 2013 17:49:13 GMT

TSM 5.5 server
TSM 6.2.3.3 client.

I have a TSM Windows client that contains over 75 million files on a drive. The TSM journal has corrupted and backup of that drive will not run.

I can't remember something. If I delete the journal and start new, and I stop the backup after a few hours, is my new journal partially built? So I can backup again later and build more, and do this several times?

Or MUST I run a backup from start to finish to populate the journal? (this will literally take days and tax my TSM server greatly)

Moving a TSM HSM managed filesystem to a new host machine with different Filesystems

mguery — Thu, 16 May 2013 11:12:25 GMT

My client asked me migration stub files from a Sun Sparc server with VxFS to a AIX server with JFS2.

I read the article http://www-01.ibm.com/support/docvie...id=swg21286977.

But this applies only to of identical filesystems (ie VxFS to VxFS, or JFS2 to JFS2).

Is there a way to do it , without recall or restore ?

Help Please - Oracle Backup Query

markybee777 — Thu, 16 May 2013 09:33:00 GMT

The Node SERVER_ORA is registered in TSM but I am unable to view any details for this node, see below.

tsm: TSMEPH>Q NODE SERVER_ORA F=D

Node Name: SERVER_ORA
Platform: TDP Oracle HP
Client OS Level: B.11.11
Client Version: Version 5, release 1, level 5.0
Policy Domain Name: ORACLE
Last Access Date/Time: 05/16/13 10:01:19
Days Since Last Access: <1
Bytes Received Last Session: 225.03 M
Bytes Sent Last Session: 3,691
Duration of Last Session: 63.21

tsm: TSMEPH>Q ASSOC ORACLE*

Policy Domain Name: ORACLE
Schedule Name: DAILY
Associated Nodes:
Policy Domain Name: ORACLE
Schedule Name: ORACLE_DAILY_DB
Associated Nodes:

tsm: TSMEPH>Q EVENT * * BEGIND=-01 ENDD=-01 NODE=SERVER_ORA
ANR2034E QUERY EVENT: No match found using this criteria.
ANS8001I Return code 11.