Search:

Thx guys,


Database is some 30GB atm with 42TB of data in primary storage. However, the amount of data is expected to increase to 200-250TB over the next year. Can I safely assume that my DB...

Hi,

We're about to go shopping for a new tsm server and I was wondering if you guys could give me some input. We're currently running TSM 6.3 on an IBM system x3650 M1 (type 7979) and a TS3200...

assuming you have one set of credentials that works on all servers you could do something like this.



@ECHO OFF
TITLE Where's that $!@# tape!

SET tsm_servers=tsmserver1 tsmserver2...

If you want uptime in YY-MM-DD HH:MM:SS, try this.



SELECT -
TRANSLATE('ab-cd-ef gh:ij:kl', DIGITS(current_timestamp-restart_date), '__abcdefghijkl_____',' ') AS yy_mm_dd_hh_mm_ss_uptime -...

Hey Maatje :)

You can sort the results by the original column name bytes_received. You don't need to put the column you sort by in the select part. And if you wanted to, you could also display...

IF is not an option afaik but you can use case-when-else-end.



SELECT -
CASE -
WHEN bytes_received>1099511627776 THEN CAST(DEC(bytes_received)/1024/1024/1024/1024 AS DEC(6,2))||' TB' -...

translate replaces the characters in the first string with characters in the second using the third as a sort of mask. any characters in the third string, not present in the first will be ignored.

Or a bit shorter and easier to read...



select client_name, session_id, state, -
date(start_time) as "Start Date", -
time(start_time) as "Start Time", -
cast(float(bytes_sent/1024/1024) as...

select node_name from nodes where node_name not in (select varchar(node_name) from nodegroup)

this might work, else QUERY VOLUME h00338l3 F=D would be usefull.

MOVE MEDIA h00338l3 STG=* WHEREST=MOUNTABLEN REM=N CHECKL=N

So I did some testing with the last journal. I found that the baclient is able to delete the file succesfully when I perform a dbcache flush on the domino console prior to archiving the journal. That...

Ok found it! You do need the >=17 after all. Without it - it seems to give you last period plus everything in the current 24h period. That's why you see it increase with time. Any how, I changed it...

Weird! I notice one script has the OR (HOUR(current_timestamp)>=17 - where the other has OR (end_time>timestamp(date....
Fix that first and see what it does. I would say you don't need >=17 but...

hmmm that's strange, shouldn't be possible since the query fetches a 24h period that's always in the past.. Ran it a couple of times here and it seems to work flawlessly. Could you pls run them both...

Here you go


SELECT -
CAST(FLOAT(SUM(bytes))/1024/1024/1024 AS DEC(10,2)) AS total_gb -
FROM -
summary -
WHERE -
activity NOT IN ('TAPE MOUNT','EXPIRATION') -
AND...

Something like this perhaps?



SELECT -
VARCHAR(activity,20) AS activity, -
CAST(FLOAT(SUM(bytes))/1024/1024/1024 AS DEC(10,2)) AS gb -
FROM -
summary -
WHERE -

Changed one of my existing scripts a bit to suit your needs. This should do what you want it to.


SELECT -
VARCHAR(entity,18) AS "Node", -
VARCHAR(schedule_name,15) AS "Schedule", -
CASE -...

Thanks moon-buddy, it's not the active mailjournal i'm talking abt. I'm looking to archive and delete an old mail journal after domino has rolled over to a new one. So basically it's just a regular...

Hi guys,

Not really a tdp question but posting it here hoping a domino admin can help me out. We've got mail journaling set up to periodically rollover to a new journal. Old journal is then...

This works for me on TSM 6.3


select -
OO.NODE_NAME, -
NN.PLATFORM_NAME, -
SUM(OO.PHYSICAL_MB) AS "MB's USED", -
SUM(OO.NUM_FILES) AS "NUMBER OF FILES" -
FROM -
OCCUPANCY OO ,...

Not possible with just tsm afaik but you could have another script append date/time info to the logfile at regular intervals. You won't get a timestamp for every line in the log but it would give you...

Try Fix Central

SELECT cast(entity AS varchar(9)) AS "Node name", -
CAST(DEC(sum(bytes))/1024/1024 AS decimal(8,2)) AS "MB Xfer ", -
CAST(DEC(sum(bytes))/1024/1024/1024 AS decimal(8,2)) AS "GB Xfer " -
FROM...

select -
entity, -
date(start_time) -
from -
summary -
where -
activity in ('BACKUP','ARCHIVE') -
and entity='$2' -
and start_time>current_timestamp-$1 hours

By now I have found a workaround for this problem. After checking in LTO5 scratch tapes I manually define them in the LTO5 storage pool. Now I don't have any real LTO5 scratch tapes but rather empty...

You're right, the select * from libvolumes gives me the exact same information as q libv f=d does. Device Type and Media Type are blank for all my tapes including the scratch tapes. Someone I know...

Use this to see a list of tables you can query within tsm.
tsm: SERVER1>select tabname from syscat.tables

Pick your favorite table and run this to see the different columns in that table and what...

When the format does get passed back, where does TSM store this information for scratch volumes?

EDIT:
I found a topic which mentioned a tsm command i didn't know, SHOW SLOTS. It seems TSM has...

Hi mikeymac, I have seen you mention that redbook in various other posts while looking for a solution. I think most of it applies regardless of the fact I run TSM on Windows. Still can't get my head...

Thanks guys for the info, looks like we will need to switch to LTO5 for the off-site pool as well and eventually get rid of the LTO3 drives and tapes.
I have seen some screenshots from somebody...

Hello,

We've been running TSM 6.3.1.0 on Windows Server 2008 SP2 hooked up to a TS3200 tape library with two LTO3 drives. A couple of weeks ago we've added two LTO5 drives to the library and have...