Search:

A slightly different take on moon-buddy' select statement

select stgpool_name, count(*) from volumeusage where node_name='node_name' group by stgpool_name

Hi

I came across rpad in this thread

http://adsm.org/forum/showthread.php?25089-Awful-SQL-output-with-v6&highlight=rpad

Cheers

Hi

Try this

select rpad(volume_name,9) as volume, rpad(stgpool_name,13) as stgpool from volumes where DEVCLASS_NAME='TEST' order by stgpool

Hope that helps

Hi

I just tried the same thing with a windows host and using fsid from 5.5.4 to 6.3 TSM servers and it worked ok and kept c$

No clues in the actlog as to why this happened ?

Cheers

Hi

This should do what you want..

SELECT aa.node_name, bb.filespace_name, bb.stgpool_name, SUM(bb.logical_mb) AS "Total MB" FROM nodes aa, occupancy bb where aa.lastacc_time<=(current_timestamp...

Hi

"dsmc q filespace" would be a good place to start.

Cheers

Has anyone tried running a 6.3 Library manager with a 5.5.4 library client ?

I might need to do this for a short period.

Hi

What is it exactly that you are not sure about?

You could also query the actlog and search for ANR0415I

tsm: STSM01>help ANR0415I
ANR0415I Session session number proxied by storage agent name started
for node node name.
...

Hi

Check that expire inventory and reclamation jobs are running properly.

Also if you are desperate for scratch tapes and have reusedelay setup for some of your storage pools, you could...

Hi

try this,

select distinct events.node_name, events.status, nodes.platform_name from events, nodes where events.node_name=nodes.node_name and events.status<>'Completed' and...

Hi

I thnk this will work

Change the last part to be

date(events.scheduled_start)>='2012-03-28'

Cheers

Hi

You could do

select distinct node_name from backups where class_name='MGMTCLASS_NAME'

This could take along time to process !

You would need to run cfgmgr first to bring in the new additional smc device

then

chdev -l smc0 -a alt_pathing=yes
chdev -l smc1 -a alt_pathing=yes

Hi

The only thing I can think is that perhaps the physical labels on the tapes have got damaged in some way, resulting the the barcode scanner not being able to read it properly. Have you...

Hi

I think you want the "define backupset" command

"Use this command to define a client backup set that was previously
generated on one server and make it available to the server running...

Try this

select distinct volume_name,node_name from volumeusage

Cheers

Hi

try this

select volume_name,last_write_date from volumes where LAST_WRITE_DATE<='2011-06-01 00:00:00' order by last_write_date

Its not somehow got excluded has it ?

Post the output of

dsmc q inclexcl

Cheers

So what version of firmware are you running now on the library ?

I'm going to be upgrading from 7422 -> 8930 -> A470 -> B180

Is there anyway I can check which sort of picker we have? I...

Looks like everything is ok, its just that no files changed since the last incremental.

To test , create a file in /oracle/product and re-run your incremental backup.

Excellent... good news..

Thanks for the replies...

The firmware update is going to be a bit of a pain... the readme states

"2. Firmware must be upgraded in steps if the firmware update crosses major releases. For...

Hi

This should do it (TSM 5.5)

select distinct volume_name,stgpool_name from volumeusage where copy_type='ARCHIVE'

Hope that helps

Hi

For whichever client this is , have you tried using the TSM client web GUI.... for example, if its an AIX client you will need the dsmcad process running and then point your web browser at ...

Well its taken a while but I'm finally in a position to move ahead. We actually got 4 LTO5 drives installed in frame 2. Currently the library does not recognise them as LTO5 because of the firmware...

Hi

I'd be very interested to hear how you get on with this as I'm about to replace LTO3 with LTO5 and enable ALMS on our 3584 in the next couple of weeks.

Could you post the exact firmware...

Hi

Yes, just use a comma seperated list with the directory= statement..

for example
define devclass fileclass devtype=file directory=/fileclass1,/fileclass2,/fileclass3

look at "help def...

I think this answers your question

http://publib.boulder.ibm.com/infocenter/tsminfo/v6r2/index.jsp?topic=%2Fcom.ibm.itsm.srv.doc%2Ft_dedup_setup.html

CHeers

Hi

As long as FILEA is a primary storage pool you should be fine to send Archive data to it.

Cheers

Hi

This might help

EVent
Specifies that the retention time specified in the RETVER
parameter is initiated at the time a client application notifies
the server of a...

HI

No there are no file devclasses defined. This NFS mount is used to store an offsite copy of our DR plans,volhist,devconfig.

On the one TSM server where I have seen this the NFS mount is...

Hi

I've seen this a couple of times now and wondered if anyone can provide an explanation

Server - AIX 6.1 TL5
Atape.driver - 12.2.9.0
TSM Server - 5.5.4.0

In a nutshell what happens is,...

Hi

You can't tell migration to take priority over reclamation so as Hema said you need to schedule things slightly differently, perhaps change reclamation to only use 1 process.

If your...

Hi

Yes of course - use the maxpro option with backup stgpool command. For example:

backup stgp stgpoolA offsitepoolA maxpro=2


For more info do:
help backup stgp from the tsm server...

moitweety

It sounds like your a little confused about what an incremental file backup is in TSM.. By default (unless using sub-file backup) if a file changes the whole file is backed up by the...

You can try a restore, obviously you'll use the timestamp that you can see from the "db2adtul query db" command. It might not work though as you cannot specify <nodename> and <password> with db2...

Hi

do you get any errors at all when you use the db2 user? or is it just it finds no backup images?

Cheers

Hi

On the HPUX server can you not use something like this is your dsm.sys to tell it to use the storage agent on the AIX server. Admittedly this will still invole a network element but would...

Hi

How big is your recovery log ?

Cheers

Hi

You might also want to consider using the compression option if you need to reduce the number of tapes this will use. I've got a BW database approx 1Tb that compresses to a 200Gb backup. The...

Try this thread

http://adsm.org/forum/showthread.php?19337-Including-tmp-FS-in-scheduled-backup

answers your question I think

for each node you want to use the client optionset just do

update node <nodename> cloptset=<cloptsetname>

you could use the wheredomain or whereplatform options as well if you needed to..

HTH

robocopy would do the rsync equivilent for your windows server...

Hi

how do you store you archive logs on TSM ? Do they go to a disk pool or do they share the same tape stgpool as the database backups ?

could you post the tsm server actlog a few minutes...