TSM 6.x Time Calculation

I use the summary table frequently and like to calculate the elapsed time by subtracting the END_TIME from the START_TIME. In TSM 5.x you could easily do this because the TSM DB was setup for returning a day/time when calculating those two fields, but TSM 6.x's DB2 database does not work the same way. When calculating the difference in 6.x the result looks like this:


      ENTITY: STG_V0653 -> STG_T10K_C2
  START_TIME: 2010-12-28 08:00:11.000000
    END_TIME: 2010-12-28 22:39:29.000000
ELAPSED_TIME: 143918.000000
    AFFECTED: 258
GB BACKED UP: 8814.00

You'll notice that the value given is actually in HHMMSS without the colon seperators. So my select formats the output to a more time based solution. You might ask why I didn't use timestampdiff, but the problem with the timstampdiff format is that it does not return in a time format like previous (5.x) versions. The timestampdiff would return the format calculation of either days, hours, minutes, or seconds only. So I actually worked with a friend who has a little more experience with DB2 and we came up with the following.


select schedule_name, entity, start_time, end_time, substr(cast((end_time-start_time) as char(22)),7,2) || ' ' || substr(cast((end_time-start_time) as char(22)),9,2) || ':' || substr(cast((end_time-start_time) as char(22)),11,2) || ':' || substr(cast((end_time-start_time) as char(22)),13,2) AS ELAPSED_TIME, affected from summary where activity='STGPOOL BACKUP' and timestampdiff(8, char(current_timestamp-start_time))<=24

Results:

SCHEDULE_NAME: AS_BACK_V655

ENTITY: STG_655 -> STG_10_C2

START_TIME: 2010-12-28 08:00:26.000000

END_TIME: 2010-12-29 07:40:46.000000

ELAPSED_TIME: 00 23:40:20

AFFECTED: 632

So now it shows the elapsed time as Days, Hours:Minutes:Seconds

You could eliminate the Day by removing the first calculation, but I have some storage pool backup processes that can run VERY long so I included it.

UPDATE: Weird Query Results From 6.1.4

So the problem has been identified and listed in an APAR. In the document it states that SELECT commands on multiple tables not working as expected on a 6.x server.  The table list is quite large and it looks like the problem is resolved in 6.1.5 and 6.2.2.  Which means I have no fix unless I upgrade the servers.

Weird Query Results From 6.1.4

So we have a couple servers we upgraded from 5.3 to 6.1.4.2 and since the upgrade the following select statement does not work. I posted it on ADSM.org and others report their 6.x servers run it without issue.  Here is the statement and my results:

select server_name, node_name, PLATFORM_NAME || ' ' || cast(CLIENT_OS_LEVEL as char(20)) as OS_Version, cast(client_version as char) || '.' || cast(client_release as char) || '.' || cast(client_level as char) || '.' || cast(client_sublevel as char(2)) as TSM_Version from nodes, status


here is the return code I get:


ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.

I run this through a while loop and append the data to an comma-delimited output file so I can pull it into a spreadsheet and organize clients by version. I can then more easily prioritize my client upgrades.  I really need this to work so I can sort and identify the clients location by server_name. Any ideas?

Update of SQL For TSM 6.1

So the previous select is not compatible with TSM 6.1 so I was searching through the IBM Redbooks for TSM and found changes to make TSM conform to SQL standards.  There are changes to the TSM supported time functions.  Here is the link, it's under Appendix B.


def script event-check desc="Events - Exceptions"
upd script event-check "/* ---------------------------------------------*/"
upd script event-check "/* Script Name: event-check                          */"
upd script event-check "/* ---------------------------------------------*/"
upd script event-check '  select -'
upd script event-check '  schedule_name, -'
upd script event-check '   cast(SUBSTR(CHAR(actual_start),12,8) as char(8)) AS START, - '
upd script event-check '   node_name, -'
upd script event-check '   cast(status as char(10)) as "STATUS", -'
upd script event-check '    case -'
upd script event-check "      when result=0  then ' 0-Succ' -"
upd script event-check "      when result=4  then ' 4-SkFi' -"
upd script event-check "      when result=8  then ' 8-Warn' -"
upd script event-check "      when result=12 then '12-Errs' -"
upd script event-check "      else cast(result as char(7)) -"
upd script event-check '    end -'
upd script event-check '      as "RESULT" -'
upd script event-check '  from events -'
upd script event-check '  where timestampdiff(8, char(current_timestamp-scheduled_start))<=24 -'
upd script event-check '    and result<>0 and node_name is not NULL'

Previously Unknown TSM SQL Feature

So while doing some script maintenance on a TSM server I came across this select statement and was shocked to see the CASE option in a select. I've used it in shell scripts but didn't think TSM allowed for it. Well it does and it works. Go figure!  (Runs on a TSM 5.3.5.2 server).

/* ---------------------------------------------*/
/* Script Name: eventx */
/* ---------------------------------------------*/
select -
schedule_name as "Schedule Name ", -
cast(substring(cast(scheduled_start as character(26)) from 12 for 8) as char(8)) as "Sched", -
node_name, -
cast(status as char(10)) as "Status", -
case -
when result=0 then ' 0-Succ' -
when result=4 then ' 4-SkFi' -
when result=8 then ' 8-Warn' -
when result=12 then '12-Errs' -
else cast(result as char(7)) -
end -
as "Result" -
from events -
where current_timestamp-scheduled_start<interval '24' hours -
and result<>0

I saw this and a whole new world opened up before my eyes! The possibilities!

TSM 6.1...Finally!!!

So I have landed on my feet as a contractor and where I am currently working they are migrating to 6.1.4 TSM from 5.x versions. In their testing they found a 36GB DB took 14 hours for the complete migration of the DB. This time includes completing storage pool migration, stopping all processes, and bringing down the original TSM server clean.  So I am not looking forward to the large 100+GB DB's.  I also find it interesting how many companies have not migrated to version 6. The only reason they are going  to 6.1.x is that it has been tested and 6.2 has not (their testing process is long and tedious).  So what has everyone else seen as their average migration time from 5.x to 6.x?

TSM Admin Contract - Cheshire, UK

I just received this job posting for Cheshire, England. If you're qualified and interested give Matthew a call.

The successful TSM Administrator will be working for a large company based just outside Chester, UK.

The key points for the role are:

• Recent commercial experience of using TSM v6.2
• Install TSM Server / TSM Client on AIX
• Present / configure tape drives for use with TSM
• Some of the work will involve deployment for the TSM project
• General TSM support & maintenance, resolving PRMs with IBM support

The contract attracts very competitive rates and will last at least 4 months.

You will need to be eligible to work in the UK and hold a HMRC Tier 1 Visa.

Many thanks,

Matt

---

Matthew Burrows RECRUITER
4020 LAKESIDE, SOLIHULL PARKWAY
BIRMINGHAM BUSINESS PARK, SOLIHULL, BIRMINGHAM, B37 7YN
T +44 (0)121 717 2828 F +44 (0)845 643 9702
E MBURROWS@TEKSYSTEMS.CO.UK

Multiple Telecommuting Positions Open

Artech is trying to staff for a number of telecommuting TSM Admin positions. If you are a high level TSM admin and looking for work contact Arjun at Artech.

Arjun Kumar Dhir Sr. Executive Staffing
Artech Information Systems LLC 240 Cedar Knolls Road, Suite 100 | Cedar Knolls, NJ 07927
Office: 973.967.3427 | Fax: 973.998.2599
Email: Arjun_Dheer@artechinfo.com | Website: www.artechinfo.com

Good TSM Oracle Backup Blog

I came across this website and it has a lot of TSM Oracle backup related information. If you perform Oracle TDP backups then check out this site.

May I Have One Free Brain Dump...And Another?

OK, so I was contacted by a person from India (I only state that so you'll know why there are so many grammar/typos in the questions) who proceeded to ask me 18 of the following questions of which I was reluctant to respond. I did, however, respond with the following note letting them know what I thought of such e-mails:                

(Keep reading past the first set of questions...it continues.)

I would like to point out that the questions you asked are all easily answered by reading the documentation, accessing ADSM.org, or simply by searching the web using Google. Having previously helped in the interviewing and hiring process, I would stress that your inability to utilize the resources already available would make me hesitant to consider you for employment. You need to be a self motivated, problem solving, and resourceful person to excel in IT. The one question I always asked when hiring was, "If you have a problem and you can't resolve it, what would be your steps in finding a solution?" The answer to this one question usually determined if they were good candidates. In the future try to use the resources available to find the answers, and note that just typing HELP on the admin command line can usually provide a majority of the answers you require.

• How to configure the library in unix level? Depends...if you mean discover the hardware and such it is dependent on the UNIX version. I always used AIX for my TSM servers so cfgmgr was used to discover the hardware and define it to the OS.
• How to make a communication b/w TSM and library? Most communication happens over the control point. For example in a 3584 you will select one of the drives to be the control point and the HBA it is zoned in the SAN to will be the HBA the library controller (robot) shows up under. All communication happens across this connection. If you use ACSLS then its a whole different process.
• Different type of H/W components available in library? Again this depends on the library type/manufacturer. You could have LTO, 3590, SDLT, VTL options along with dual robots.
• In which way you will access the library? There are various tools to access the library but I tend to use the web interface more than I use the AIX library/tape tools (i.e. tapeutil)
• What will happen when the volume will move to different storage slot inside the library.How to rectify the same? TSM should track the slots and where every tape is. If for some reason the inventory is inaccurate you can run both a library level audit and a TSM level audit. Lookup the AUDIT LIBRARY command in the TSM Admin Reference.
• If you are running out of scratch tapes then what are the steps you will do to overcome that? Of course there is the standard RECLAIM STG and MOVE DATA commands but a lot depends on how good my processes are at freeing up tapes. It could just come down to deleting old DB backups or I might go so far as investigating whether the Oracle DBA's have been keeping their RMAN catalogue sync'd with TSM. If they haven't I have a very good chance of freeing up a lot of tapes when I manually delete their data from TSM. 
• How to checkout the tapes from library? If using DRM then MOVE DRMEDIA if not then the CHECKOUT LIBVOLUME command. See the TSM Admin Reference for more details.
• How to manual clean the drive? You should not need to manually clean a drive but if you decide to then it depends on if you initiate it from the library's web interface or from TSM. From TSM it's a simple CLEAN DRIVE
• Which will act as a interface b/w library & TSM? I don't quite understand what you mean? In the case of TSM you usually don't need the library's web interface much, most of the handling can be done through TSM.
• When the volume is throwing error while mounting then what you will do as a TSM admin? I usually check to see if the tape has a history of mount errors, if so I check it out of the library, if not then it could be the drive or accessor are in need of service. If mount errors continue on the drive I will call in a service technician to look at the drive.
• What is the use of Audit Library? Makes sure that the library physical inventory matches TSM's inventory. If they get out of sync you could have mount failures and errors due to TSM thinking it is grabbing a different tape then it should have found in that slot. 
• If the stgpool reusedelay parameter is 2 then what will happen when volume becomes empty? After two days the volume is available to be used as scratch again. The reusedelay parameter is good to use if there is a possibility that you might need data from beyond the normal expired time. So technically if you keep 5 days worth of TSM DBbackups then the oldest TSM DB could request tapes that have since expired and been sent back onsite to be used as scratch so you should set the resuse delay parameter to the same setting or same+1 day as the number of TSM DB backups you keep.
• Uses of Reclamation: Think of reclamation as a Defrag for tape. Reclamation can tape two or more tapes and condense them down to one tape if used correctly. Again lookup RECLAMATION in the TSM Admin Reference.
•  Depends on library type/config and the number of scratch I need to load. For example I currently am working with a 3584 that has a 10 tape I/O door and needed to load 50 scratch. So I paused the library, opened the storage frame's door and manual inserted all 50 into the open slots (I have a number of columns not in use). I then closed the library and allowed the library's audit to complete before I ran the CHECKIN LIBVOLUME SEARCH=YES CHECKL=BARCODE STATUS=SCRATCH otherwise the standard checkin process through the I/O door works fine. With ACSLS and 3494 libraries the tapes are automatically entered into the library and the CHECKIN LIBVOLUME SEARCH=YES CHECKLABEL=NO STATUS=SCRATCH command is used. Notice it is a little different from a SCSI based library like the 3584.
• Use of reusedelay & maxscratch? Maxscratch will determine how many scratch a sequential TSM storage pool can use. The reuse delay parameter will determine the number of days a tape that shows as empty in TSM will be in "limbo" before TSM will allow it to be reassigned back to a scratch status. 
• Why we need multiple management class in a single domain? Multiple management classes in a single domain allow for you to reference different retention rules "on the fly" when running a backup or archive by using the INCLUDE . So say I had a management class called 1_YEAR that keeps UNLIMITED versions for 1 year. To use it on specific data types I would put an include in a clients DSM.OPT or in a client option set.

INCLUDE "C:\USERS\...\MY DOCUMENTS\WORD\*.DOC" 1_YEAR

• Diff b/w session & process? A session is a TSM client/admin/alternate TSM server connection where a process is an internal task (i.e. MIGRATION) running on the TSM server.
• Different types of client established session? There are standard client sessions, datamover sessions (NAS), storage agent sessions (LAN-Free), TDP sessions (Exchange, SQL, Oracle, etc), and TSM Server sessions (If the server is a library client accessing the library manager or if using the virtual volume feature).

So after answering these questions, with the added commentary on what I thought about such requests, you would think the person would get a clue and start researching the answers to any further questions...NOPE! I just received the following e-mail from the same person:

Pls clear me.....

1. Difference between other application and TSM?
2. About features of TSM.
3. Make clear me on Roll  forward Mode & Storage pool Hierarchy?
4. What is meant by copy storage pool?
5. What is need of SAN in TSM environment?
6. Where you will mention the destination of backup?
7. If client want 3 inactive version for 60 days what are the parameter we will mention?
8. Explain about scheduling and its types
9. Explain some types of tapes with its capacity.
10. What are the types of copy group
11. Where will you allocate the no.of tapes?
12. How will you check the node belongs to particular domain? 
13. Where will you define the server for the particular tape?
14. How will you know the particular volume which has data?
15. Advantages of Linux?
16. How to configuring the TSM?
17. How to see the Database time of yesterday missed file?
18. About device class and types?
19. What is meant by Admin Process?
20. How to see the node started confirmation from server side?
21. In Migration, why we r giving LOWMIG?
22. Retension period for node?
23. Diff between foreground and background?
24. Tell me the device name for library in TSM on AIX? 
25. Difference between clientopt and clopset? 
26. Difference between label and checkinlibvolume? 
27. Backupset where it will be used? 
28. If recovery log 100% what will happen?
29. Suppose TSM server crashed ...what we will do?
30. What is client option set?
31. About Restore process and Data Shredding?

Seriously?!? I would never hire this person...I can understand asking a question or two but 31? I just answered 18 out of shear boredom...are some people really this lazy?

TSM to DPM transition

I am currently working a contract transitioning a companies old TSM environment to Microsoft DPM and am discovering once again how Microsoft operates. Just like many of their software products when they were first released, Microsoft's product lacks certain features that others have had for years. As they revise the product they slowly reach a close parity, but it's never quite equal to older more mature products. The clincher is that it's a Microsoft tool and Windows shops don't know any better. As I learn more about DPM I'm convinced it's not going to supplant TSM or Netbackup by features, but shear lack of backup expertise from the administrators. Their MS rep will come in and tout the product with the limited information he has, show them a decent bundle price, sell them DPM, and not be heard of until the next licensing cycle. (Does The Music Man ring a bell?) The reporting capabilities alone are awful! You can't easily create your own and DPM runs on MS SQL. Go figure! And what's with Microsoft pushing their PowerShell?? You can script reports but have to know how to script within MS PowerShell. I thought the whole purpose of Windows was to eliminate the command line? (Not that I mind, I just find it ironic) So as I learn more I'll post what I find, but so far I'm shocked they thought DPM was a better tool than TSM...what they really needed was a good TSM admin not new software.

I was contacted today for a position with J.P. Morgan Chase and thought I would pass it on since it does not allow remote/telecommuting and would require me to move to either Houston, TX or Columbus, OH. If you have senior level TSM skills and are either willing to move or live within these metro areas send Melissa your resume. All I ask is that you tell her you saw the post on TSMExpert.org. (And no, I don't get a referral fee!)

Hi Chad; thanks again for your time today.  As discussed, I recruit for our core infrastructure tech roles (storage, server) at JPMorgan Chase, and would love to be in touch with any talented individuals for current or future needs our managers may have.

The role I called you about today is for  a TSM expert who would be willing to work the weekends.  We offer great benefits+ competitive salary, including OT pay + 10% shift differential due to the nature and hours of the roles.  Individuals can be based in Columbus or Houston, and we are offering a  $10K net lump sum to help with relocation for those who live outside a reasonable commute distance of the two sites. 

Also, due to a couple of recent team promotions,  I will be posting two more roles that require skills in both NBU and intermediate TSM (with command line environment knowledge).

I appreciate any referrals you may be able to offer!

Best regards, and thanks again!

Melissa

Melissa Greenwood | JPMorgan Chase Corporate Recruiting |  614-213-6670  |  Melissa.J.Greenwood@jpmchase.com

TSM Console Manager

While catching up with my e-mail I came across Spirit Software's TSM Console Manager. I had been asked to review it and did not get the e-mail until today. So I thought I would post the video describing the product and giving you and idea of how it works. Oh, and the cost isn't bad either...it's FREE!

Updated E-mail

I apologize to anyone who has sent me an e-mail to tsmexpert@hotmail.com since I really have not checked it consistently and thought I had switched everything over to my gmail account. If you have a question or would like to submit an article I have updated my e-mail link or you can contact me at chadsmal@gmail.com (yes that's one l).

On The Bench

Well I am back in the job market today. When searching TSM positions I notice there are quite a few positions available out there. I wonder how long it took those of you out there to find new positions? I'm pretty optimistic. At least for the moment.

I was let go due to cost cutting demanded from the higher ups, so I'm thankful I can use Infocrossing as a solid reference. If anyone has suggestions or is hiring feel free to send me an e-mail.

When Data Isn't There, But Is Really There!

OK so the title seems odd, but I had this occur recently when our UNIX Admins decided to convert a subdirectory to a file system. So they created the file system and wiped out the subdirectory expecting us to restore the data. When you would query for the backups nothing would show as having been backed up. (Let me clarify that the Admins did the change and then a week later alerted us and asked for the restore.) So the project manager asked for the restore but did not clarify the directory had gone from /opt/ar/ to being file system /opt/ar/. So any

dsmc res /opt/ar/* /opt/ar/ -pick -inactive -subdir=yes 

returned no data. What I had to do was

dsmc res /opt/* /opt/ar/ -pick -inactive -subdir=yes -pitd=

and then the data would show and I could select it manually for restore. If there is one thing I have learned with TSM is always double, triple, and quadruple check for "missing" data using various methods, chances are it is probably there. Remember the user is clueless....don't get me started on symbolic links and how users don't always know the actual location of their data.

Tivoli Storage Manager v6.2 install and see the Exception Stack Trace for more information... [sorry for the long entry]

Am I too old for that? or this is the real future? Is it realy the way it has to be? I don't think so... :-(

--- CUT ---

Welcome
Tivoli Storage Manager 6.2


Licensed Materials - Property of IBM Corp. (c) IBM Corporation and other(s)
1994, 2010. All rights reserved. US Government Users Restricted Rights --
Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM
Corp.


It is highly recommended that you stop all other programs before continuing
with this installation.


PRESS TO CONTINUE:

===============================================================================


International Program License Agreement

Part 1 - General Terms

BY DOWNLOADING, INSTALLING, COPYING, ACCESSING, CLICKING ON AN
"ACCEPT" BUTTON, OR OTHERWISE USING THE PROGRAM, LICENSEE AGREES TO
THE TERMS OF THIS AGREEMENT. IF YOU ARE ACCEPTING THESE TERMS ON
BEHALF OF LICENSEE, YOU REPRESENT AND WARRANT THAT YOU HAVE FULL
AUTHORITY TO BIND LICENSEE TO THESE TERMS. IF YOU DO NOT AGREE TO
THESE TERMS,

- DO NOT DOWNLOAD, INSTALL, COPY, ACCESS, CLICK ON AN "ACCEPT" BUTTON,
OR USE THE PROGRAM; AND

- PROMPTLY RETURN THE UNUSED MEDIA, DOCUMENTATION, AND PROOF OF
ENTITLEMENT TO THE PARTY FROM WHOM IT WAS OBTAINED FOR A REFUND OF THE
AMOUNT PAID. IF THE PROGRAM WAS DOWNLOADED, DESTROY ALL COPIES OF THE
PROGRAM.


Press Enter to continue viewing the license agreement, or enter "1" to
accept the agreement, "2" to decline it, "3" to print it, "4" to read
non-IBM terms, or "99" to go back to the previous screen.: 1




===============================================================================
Component Selection
-------------------

Select the components to install.


1- Tivoli Storage Manager Server
2- Tivoli Storage Manager License
3- Tivoli Storage Manager Devices
4- Tivoli Storage Manager Storage Agent

ENTER A COMMA-SEPARATED LIST OF NUMBERS REPRESENTING THE DESIRED CHOICES: 1,2



===============================================================================
Deployment Engine Initialization
--------------------------------

Please Wait
...
Step 1 of 15...............................................................
Step 2 of 15.................................................................................
Step 3 of 15...
Step 4 of 15...
Step 5 of 15....
Step 6 of 15.....
Step 7 of 15.................................................................... .....
Step 8 of 15.....................
Step 9 of 15....
Step 10 of 15........
Step 11 of 15...............
Step 12 of 15.............
Step 13 of 15...
Step 14 of 15...
Step 15 of 15............................................................
Completed.


===============================================================================
Pre-Installation Summary
------------------------

Review the Following Summary Before You Continue:

Product Name:
Tivoli Storage Manager

Install Folder:
/opt/tivoli/tsm

Components:
TSM Server,DB2 9.7,TSM Client API 32 bit,TSM Client API 64 bit,TSM License

Disk Space Information (for Installation Target):
Required: 1,815,384,781 bytes
Available: 478,806,016 bytes

PRESS TO CONTINUE:


===============================================================================
Not Enough Disk Space
---------------------


Warning!

This installation requires 1,731.29 MB of free disk space, but there are only
456.62 MB available at:

/opt/tivoli/tsm

Please free at least 1,274.66 MB to proceed with the installation.

PRESS TO RECALCULATE AVAILABLE DISK SPACE,
OR TYPE 'QUIT' TO EXIT THE INSTALLER:
Warning!

This installation requires 1,731.29 MB of free disk space, but there are only
456.62 MB available at:

/opt/tivoli/tsm

Please free at least 1,274.66 MB to proceed with the installation.

PRESS TO RECALCULATE AVAILABLE DISK SPACE,
OR TYPE 'QUIT' TO EXIT THE INSTALLER:
Warning!

This installation requires 1,731.29 MB of free disk space, but there are only
456.62 MB available at:

/opt/tivoli/tsm

Please free at least 1,274.66 MB to proceed with the installation.

PRESS TO RECALCULATE AVAILABLE DISK SPACE,
OR TYPE 'QUIT' TO EXIT THE INSTALLER:
Warning!

This installation requires 1,731.29 MB of free disk space, but there are only
456.62 MB available at:

/opt/tivoli/tsm

Please free at least 1,274.66 MB to proceed with the installation.

PRESS TO RECALCULATE AVAILABLE DISK SPACE,
OR TYPE 'QUIT' TO EXIT THE INSTALLER:
Warning!

This installation requires 1,731.29 MB of free disk space, but there are only
456.62 MB available at:

/opt/tivoli/tsm

Please free at least 1,274.66 MB to proceed with the installation.

PRESS TO RECALCULATE AVAILABLE DISK SPACE,
OR TYPE 'QUIT' TO EXIT THE INSTALLER:
Warning!

This installation requires 1,731.29 MB of free disk space, but there are only
456.62 MB available at:

/opt/tivoli/tsm

Please free at least 1,274.66 MB to proceed with the installation.

PRESS TO RECALCULATE AVAILABLE DISK SPACE,
OR TYPE 'QUIT' TO EXIT THE INSTALLER:
Warning!

This installation requires 1,731.29 MB of free disk space, but there are only
456.62 MB available at:

/opt/tivoli/tsm

Please free at least 1,274.66 MB to proceed with the installation.

PRESS TO RECALCULATE AVAILABLE DISK SPACE,
OR TYPE 'QUIT' TO EXIT THE INSTALLER:

There is now enough disk space to proceed with the installation.

PRESS TO BEGIN INSTALLATION:



===============================================================================
Installing...
-------------

[==================|==================|==================|==================]
[------------------|------------------|------------------|------------------]



===============================================================================
Installation Complete
---------------------

The product did not install.
See /var/tivoli/tsm/log.txt for details.


PRESS TO EXIT THE INSTALLER:

--- CUT ---

total 800
drwxrwxr-x 2 root system 256 May 14 14:09 .
drwxrwxr-x 3 root system 256 May 14 12:34 ..
-rw-rw-r-- 1 root system 320432 May 14 14:09 log.txt
-rw-rw-r-- 1 root system 84750 May 14 14:01 logs.zip
-rw-rw-r-- 1 root system 0 May 14 13:55 rxa_message.log
-rw-rw-r-- 1 root system 0 May 14 13:55 rxa_trace.log

and the of that SMALL log:

.
.
.
Fri May 14 14:01:50.310 CEST 2010 : FINE : PlanStepEventOccurred(Failed target 'step_00001_TSM_Server_1_1') (from com.ibm.ac.coi.ext.ia.COIWrapperPluginImpl$SimpleListener.eventOccurred)
Fri May 14 14:01:50.311 CEST 2010 : FINE : COIEventType.ERROR (from com.ibm.ac.coi.ext.ia.COIWrapperPluginImpl$SimpleListener.eventOccurred)
Fri May 14 14:01:50.313 CEST 2010 : FINE : MachinePlanEventOccurred(An exception was received during the processing of MachinePlan: localhost. See the Exception Stack Trace for more information.) (from com.ibm.ac.coi.ext.ia.COIWrapperPluginImpl$SimpleListener.eventOccurred)
Fri May 14 14:01:50.313 CEST 2010 : FINE : COIEventType.ERROR. Last step started was: TSM_Server_1_1 (from com.ibm.ac.coi.ext.ia.COIWrapperPluginImpl$SimpleListener.eventOccurred)
Fri May 14 14:01:50.314 CEST 2010 : FINE : DeploymentPlanEventOccurred(Failed Deployment Plan 'install') (from com.ibm.ac.coi.ext.ia.COIWrapperPluginImpl$SimpleListener.eventOccurred)
Fri May 14 14:01:50.315 CEST 2010 : FINE : COIEventType.ERROR (from com.ibm.ac.coi.ext.ia.COIWrapperPluginImpl$SimpleListener.eventOccurred)
Fri May 14 14:01:50.926 CEST 2010 : FINE : Exception via callback from DeploymentPlanProcessor.process(INSTALL): (from com.ibm.ac.coi.ext.ia.COIWrapperPluginImpl.install)
Fri May 14 14:01:50.927 CEST 2010 : FINE : COIEventType.ERROR reported (from com.ibm.ac.coi.ext.ia.COIWrapperPluginImpl.install)
Fri May 14 14:01:50.928 CEST 2010 : STDERR : com.ibm.ac.coi.ext.ia.COIWrapperException: COIEventType.ERROR reported
Fri May 14 14:01:50.929 CEST 2010 : STDERR : at com.ibm.ac.coi.ext.ia.COIWrapperPluginImpl$SimpleListener.eventOccurred(COIWrapperPluginImpl.java:121)
Fri May 14 14:01:50.930 CEST 2010 : STDERR : at com.ibm.ac.coi.impl.COIRuntimeImpl.notifyListener(COIRuntimeImpl.java:226)
Fri May 14 14:01:50.931 CEST 2010 : STDERR : at com.ibm.ac.coi.impl.COIRuntimeImpl.notifyListeners(COIRuntimeImpl.java:215)
Fri May 14 14:01:50.932 CEST 2010 : STDERR : at com.ibm.ac.coi.impl.utils.ParallelPlanListener.eventOccurred(ParallelPlanListener.java:105)
Fri May 14 14:01:50.934 CEST 2010 : STDERR : at com.ibm.ac.coi.impl.COIRuntimeImpl.notifyListener(COIRuntimeImpl.java:229)
Fri May 14 14:01:50.935 CEST 2010 : STDERR : at com.ibm.ac.coi.impl.COIRuntimeImpl.notifyListeners(COIRuntimeImpl.java:219)
Fri May 14 14:01:50.936 CEST 2010 : STDERR : at com.ibm.ac.coi.impl.MachinePlanImpl.process(MachinePlanImpl.java:254)
Fri May 14 14:01:50.937 CEST 2010 : STDERR : at com.ibm.ac.coi.impl.utils.MachinePlanRunner.run(MachinePlanRunner.java:64)
Fri May 14 14:01:50.938 CEST 2010 : STDERR : at java.lang.Thread.run(Thread.java:736)
Fri May 14 14:01:50.939 CEST 2010 : STDERR : Caused by:
Fri May 14 14:01:50.940 CEST 2010 : STDERR : com.ibm.ac.coi.api.exception.DeploymentPlanExecutionException: One or more Machine Plans within the DeploymentPlan failed. Failure count = 1
Fri May 14 14:01:50.941 CEST 2010 : STDERR : at com.ibm.ac.coi.impl.utils.ParallelPlanListener.eventOccurred(ParallelPlanListener.java:92)
Fri May 14 14:01:50.942 CEST 2010 : STDERR : ... 5 more
Fri May 14 14:01:50.943 CEST 2010 : SEVERE : Raw Exception in DeploymentPlanProcessor.process(INSTALL): COIEventType.ERROR reported (from com.ibm.ac.coi.ext.ia.COIWrapperPluginImpl.install)
Fri May 14 14:01:50.944 CEST 2010 : FINER : THROW (from com.ibm.ac.coi.ext.ia.COIWrapperPluginImpl.install)
.
.
.


and bla, bla, bla, bla...

Sorry, but nice week-end!!! ;-)

TSM Upcoming Events and Live Technical Training

Here are some events that you might find worthwhile. If you don't receive the technical information updates from IBM then check out the FAQ page. If you'd like to sign up for daily/weekly notifications concerning TSM then access IBM's "My Notifications." 

• 19 May 2010 - TSM and Electronic Vaulting for Disaster Recovery
• 27 May 2010 - Implementation and Use of TSM Client/Server Data De-duplication with TSM 6.2
• 08 June 2010 - Encryption and Security with TSM Version 6
• 13 June 2010 - TSM V6.2 Automatic Client Deployment

NetbackupExpert?

Once again licensing time has arrived and Symantec is giving away Netbackup. IBM's pricing model makes it hard to justify staying with TSM when Symantec is pricing their product sooooo low. Sure I can pull out graphs, reports, and pretty little charts to try and help management understand the difference, but let's face it, it all comes down to the bottom line. IBM doesn't like to budge on pricing and Symantec has nothing to lose. Anyone have some Netbackup training materials I can borrow?

Obstacles Upgrading to 6.1

I have a server with 8 instances of TSM running on it. The first instance is the library controller and the other seven are production instances. So the problem has been how to best reconfigure everything for TSM 6.1 since IBM says it's best not to run multiple instances on the same server unless they are in their own LPAR. So what I have been trying to figure out is how best to migrate to 6.1 with the least impact. I figure I will need to merge the 7 production instances into 3 or 4, but then what would be the best procedure for dividing up the hardware (i.e. NICs and HBA's) for the other LPARs. Any suggestions?

Tivoli Storage Manager v6.2 is coming in March

Tivoli Storage Manager v6.2

Finally! MySQL backups with TSM

Computer Technology Review has an announcement from Zmanda stating they are releasing a TSM backup agent (Zmanda Recovery Manager for MySQL). The ZRM-TSM agent is available immediately. You can read the full article here. Those of you who have been asking for a TDP for MySQL, the wait is over.