Hi TSM'ers
The below is the message from select output (select * from actlog)
All I want to know is whether or not possible to caputue only the message
no (ex ANR2565I) using select query I tried using string operations in
select command didnt help much If any select expert tried this pls let me
Sree Kumar,
Its absolutely possiblem to do that. Try the following
select * from actlog where message like 'ANR2565I%'
I think this should do the trick. Hope the climate in Bangalore is good :-)
Regards
Mobeen
Mobeen Mahamood C.M
Systems Manager Lead
Micron Semiconductor Asia
Singapore
or this select substr(MESSAGE,1,9) from actlog where substr(MESSAGE,1,9)='ANR2565I'
mobeenm
mobeenm@MICRO To: [EMAIL PROTECTED]
N.COM cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK)
Hi ,
try this
select substr(MESSAGE,1,9) from actlog
Pothula S
Paparao To: [EMAIL PROTECTED]
[EMAIL PROTECTED] cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK)
BM.COM Subject:
From: Xavier 1 Chavanet
Hi everybody,
We experience some I/O problem on our TSM solution based on IBM server, NT4
sp 6a, Storagetek L700 496 slots, 5 Seagate LTO drives connected to LSI HVD
cards (Storagetek recommendation), TSM 4.2.1.10 (quite the last patch). Two
drives are attached per scsi
Has anyone received a similar response from TSM support in the past? We
are working on an issue with a process running for a very long time, and
received the following as part of the response from TSM support:
[W]as that the
run-time of a specific backup process, or was
Slightly off topic but since we are in the recovery position,
anything to help ward off data loss to begin with is close to on topic...
This is all I know for the time being...
Dwight
The Threat
SNMP (Simple Network Management Protocol) is a set of protocols designed for
monitoring and
Quoting Ted Byrne [EMAIL PROTECTED]:
Has anyone received a similar response from TSM support in the past? We
are working on an issue with a process running for a very long time, and
received the following as part of the response from TSM support:
[W]as that the
run-time
Hello,
i wanna backup the database every monday and thuesday on a tape (DB_MO) for
monday and (DB_DO) for thuesday.
the command BACKUP DB DEV=DLTCLS02 T=F VOL=DB_DO SCR=N WAIT=NO for
thuesday is a Admin Command Schedule.
the strange thing is that i always get the following error.. also when i
Hi Wolfgang!
When you issue a Q VOLH T=DBB, is the volume DB_DO listed there?
If so, maybe that's the problem. I don't know for sure, but I can imagine
that TSM does not allow you to write multiple database backups to one tape.
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines
OK, delete volhist type=dbb tod=today will not delete all of your data
base backup volumes...
TSM will never delete your latest/only db backup copy.
If you are trying to reuse that same tape volser DB_DO you will never be
able to do it !
You have to have AT LEAST TWO volumes, one which remains
Dwight, et al
CERT warned of these SNMP flaws more than 2 weeks ago ...
but they were discovered last year, and Microsoft just issued patches
for some of the Windows operating systems, etc.
http://www.computerworld.com/itresources/rcstory/0,4167,STO68242_KEY73,00.ht
ml
-Original
Hello *SMers
I'd like have automated reporting on TSM activities. I'm using a tedious,
manual process right now. I also have scripts defined using the WEB client,
but I don't know how to write the report to a file.
Help please?
Thanks...
Ike
Blue Cross Blue Shield of Florida, Inc., and its
There are some guys down in the AIX support area that answer TSM questions
occasionally. Boy, you can get some wild stuff from them. He is confusing a
shell script with a TSM script. My guess is he did not even read all of you
problem before answering it. That is typically what I feel happens.
You didn't say which platform you're on, but the idea is that you can
prepare a select statement, then issue it from the command line like this
dsmadmc -id=admin -pass=passwd -outfile=reporttxt select blah
from blah where blah
There are other switches that control the format and/or
Hi,
I am using TDP for SAP R/3 V3.2.0.8 and I would appreciate your help in
accomplishing
the following:
-2 copies of the REDO logs, each copy is to go to a different TSM server
(different sites)
-I would like to switch between the TSM servers on a daily base so that the
on/offline backup on day
*SMers,
We're trying to limit backing up *.PST file to weekly. We've asked on this
forum, and received answers, one telling us to exclude *.PST and define a
weekly archive schedule.
So far, here is what we've defined via WEB admin client, but is isn't
working. Has anyone out there been
i wanna backup the database every monday and thuesday on a tape (DB_MO) for
monday and (DB_DO) for thuesday
the command BACKUP DB DEV=DLTCLS02 T=F VOL=DB_DO SCR=N WAIT=NO for
thuesday is a Admin Command Schedule
the strange thing is that i always get the following error also when i
start
but the tape DB_DO dont get mounted.. and the tape should be big enough for
the db.
i use a DLT4000 drive with an dlt IV tape.. should hold 20GB uncomp. or 40GB
comp.
the database and log size:
adsm q log
Available Assigned Maximum MaximumPage Total
Used
Starting SQL database backup...
Beginning difffull backup for database PRD, 1 of 1.
Full: 0 Read: 0 Written: 0 Rate: 0.00 Kb/Sec
Backup of PRD failed.
ACO5403E The configuration of the Virtual Device Set could not be
obtained.
Neil,
We haven't seen this one yet. We will need some
Hello,
i have this schedule defined DEL VOLH TYPE=DBB TODATE=TODAY-4 it runs
every day at 07:20am
on monday 07:30am the command BACKUP DB DEV=DLTCLS02 T=F VOL=DB_MO SCR=N
WAIT=NO executes.
then i checkout DB_MO and do a checkin for DB_DO
on thuesday the command BACKUP DB DEV=DLTCLS02 T=F
select msgno from actlog where msgno=2565
MSGNO
--
2565
2565
2565
2565
2565
2565
2565
2565
2565
2565
2565
Mostly useless as is.
Maybe:
select date(date_time) as date,time(date_time) as time, substr(message,10,2)
as
Any one have a problem with TSM auditing a LTO 3583 library Some of my tapes
are missing but when I open the door of the library I see all the tape slots
full I use the I/O door to input tapes only as SCRATCH so all tapes in the
library should be known to TSM as SCRATCH or PRIVATE
When the
Hello every body.
Is there any command or script or something to delete backup versions of
specific files, obiously, not deleting the whole file space?
Regards
Angel Antsn
IZFE. S.A.
Plaza de Pinares, 1-3
Donostia 20001
Tlf.: +34 943.482.869/811 , Fax: +34 943.321.023
E-Mail : [EMAIL
Try running these three commands in sequence within TSM to synchronize the
library. As you pointed out, however, if the hardware ain't right, this
won't be either:
audit library libname checklabel=barcode
checkin libvol libname search=yes checklabel=barcode status=scratch
checkin libvol libname
Sam,
We had a similar problem.
The library reconfigure itself every time you have had the door open, it
reads some barcode labels internally that tells it what HW is installed and
the barcode could be dirty/destroyed such that it isn't aware of the
magazines in the door. HW support should be able
Hi,
If you are speaking of the DSM.OPT file then here is a suggestion.
You need to first define the DOMAIN which is actually the partition you
want to address = Domain C or D or E, etc...then you need to include/exclude
(which ever your logic requires) everything first, then
Hi,
Here is what I have found to be FACT from M.S. They do not support
Brick Level layer backup, simply because ALL 3rd party vendor's DO NOT use
M.S.'s MAPI for the brick's. They all use their own version as a gentleman
stated in past e-mails. However, They Do support ONLINE backups with
Hello,
Has any one done or had any experience with using TSM client 4.x and
doing a successful disaster recovery for the NT4/ IIS4 or W2K/IIS5 member
server? Please help.
Anthony F.Consiglio
Senior Systems Analyst II
Network Engineer, LAN
try:
q libv whatever DB_DO
Does it show up as scratch?
-Original Message-
From: Wolfgang Rest [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 9:27 AM
To: [EMAIL PROTECTED]
Subject: AW: ANR4583E Database backup terminated
Hello,
i have this schedule defined DEL VOLH
What errors do you see in the dsmsched.log file?
BTW, there is nothing that makes TSM automatically search the whole drive
for files named *.pst.
Try specifying the full path name: C:\whatver\*.pst
-Original Message-
From: Hunley, Ike [mailto:[EMAIL PROTECTED]]
Sent: Thursday,
If you are using the 3583 with Windows 2000 do not let the hardware guys
upgrade your tape drive firmware to 18N2, there is a know issue that is not
communicated between the Hardware and Software folks.
Our nightmare started with a physical bad tape drive. A new drive was
ordered and installed
In the windows world I use another tool to convert the outputted .out file
to html so I can post to a web page for management. The tool is called
asctotab and is postcardware, more info can be found at the following
website http://www.yrl.co.uk/~jaf/AscToTab.html My script is as Justin
described
Tony I think your a little confused. On-line backups are not done with
'M.S's MAPI', it's done through MS's api calls. MAPI is a interface used by
the older Microsoft Mail client. MAPI is the interface that the brick level
backup people use to extract the information from the Exchange Information
I have a lot I think.
1) It works WELL|
2) Hello word is 150 line long
3) The examples are not bad.
4) The manual is not enough on my taste
5) If you have questions email me, I try to answer !
Michel
MARNET
--- Rivera, Jose Spri [EMAIL PROTECTED]
wrote:
Hi - Has anyone had any experience
No
--
Joshua S. Bassi
Sr. Solutions Architect @ rs-unix.com
IBM Certified - AIX/HACMP, SAN, Shark
Tivoli Certified Consultant- ADSM/TSM
Cell (415) 215-0326
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of
Seay, Paul
Sent: Tuesday, February 26,
Yes, it seems like a nightmare story. What drives were those...984x?
-Original Message-
From: Mark Bertrand [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 11:25 AM
To: [EMAIL PROTECTED]
Subject: FW: 3583 LTO problems
If you are using the 3583 with Windows 2000 do not let
I have new install. W2K SP2, SQL Server 7.0 SP2, TSM Client 4.2.1.20
and TDP SQL 2.2.0.0. The B/A client works fine. I can start the TDP SQL
Gui o.k., But can't access the SQL server. When I execute the sqlfull.cmd,
get the following in the sqlfull.log: (Listed the error only)
02/28/2002
I have new install. W2K SP2, SQL Server 7.0 SP2, TSM Client 4.2.1.20
and TDP SQL 2.2.0.0. The B/A client works fine. I can start the TDP SQL
Gui o.k., But can't access the SQL server. When I execute the
sqlfull.cmd,
get the following in the sqlfull.log: (Listed the error only)
We are living this nightmare as we speak
Thanks for the info, I have passed it onto the IBM people that are trying
to fix ours. Hopefully it will end soon ...!!
Jerry R. Kube
Senior Technical Analyst - Corporate Technology
Ceridian Canada Ltd,
Winnipeg, Mb. R3C 3P2
Phone 204-975-5489
Fax
Again, I am at a loss on this one
TDP for MS sql 22
When the scheduler now runs a differential of the database, this is what the
log shows:
Version 2, Release 2, Level 00
(C) Copyright IBM Corporation 1997, 2001 All rights reserved
ACO5057I The C:\Program Files\Tivoli\TSM\TDPSql\sqldifflog
I'm currently testing TDP for Exchange for possible deployment in a very large
enterprise environment. Is anyone aware of tools/scripts that I can use to monitor
the backups/restores. I'm aware that
I can look at the past history of backups/restores and determine approximately how
long it
Environment:
Server: 4.1.3.0
Platform: S390
1. Logmode: We're going to change the Logmode from Normal to Roll Forward. What
determines the amount of disk I'll require?
2. Bufpoolsize: We're going to increase from 24576K to ?. What's the determining
factor?
3. Mpthreading: We're
Good evening, SMers!
Does anyone know of a wholesale place where I can purchase pre-labeled IBM
High Performance 3590 cartridge tapes?
Any tips are welcome!
Thanks,
Demetrius Malbrough
UNIX/TSM Administrator
Environment:
Server: 4.1.3.0
Platform: S390
1. Logmode: We're going to change the Logmode from Normal to Roll Forward. What
determines the amount of disk I'll require?
2. Bufpoolsize: We're going to increase from 24576K to ?. What's the determining
factor?
3. Mpthreading: We're going
What country/state/province might be helpful.
-Original Message-
From: Malbrough, Demetrius [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 3:54 PM
To: [EMAIL PROTECTED]
Subject: Need 3590 tapes!
Good evening, SMers!
Does anyone know of a wholesale place where I can
Dmetrius,
I know of a place here in NJ that has 300
Its called Access data phone 973-263-3475
Malbrough, Demetrius [EMAIL PROTECTED]@VM.MARIST.EDU on 02/28/2002
03:54:25 PM
Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED]
Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED]
Create a dummy management class and storage pool with what you want.
Set the files in your exclude list to that management class.
They will get trimmed. Then remove the management class and they return the
way you want.
However, if they are deleted already then they just hang around until the
Did you specify LANFREEENABLE in the DSM.SYS/DSM.OPT.
-Original Message-
From: Leijnse, Finn F SITI-ITDSES31 [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 9:47 AM
To: [EMAIL PROTECTED]
Subject: lanfree not lan free
Hi guys,
In a totally AIX environment I have set up my
Hello y'all
Any queries or commands that would give me volumes onsite and offsite
with storage capacity? We are trying to figure how much storage is onsite
in Gigage and Volumes and the same for offsite I have a DRM piece, and my
Copypool should show offsite and Tapepool onsite, but I seem
Hi Joe,
At 03:39 PM 2/28/2002 -0500, you wrote:
Environment:
Server: 4.1.3.0
Platform: S390
1. Logmode: We're going to change the Logmode from Normal to Roll Forward. What
determines the amount of disk I'll require?
You need enough log space to hold all the db changes between scheduled db
Starting SQL database backup...
Beginning difffull backup for database pubs, 1 of 1.
Full: 0 Read: 2049808 Written: 2049808 Rate: 982.22 Kb/Sec
Backup of pubs failed.
ANS0327E (RC32) A duplicate object was found, operation cannot
complete.
Bob,
This sounds like IC31171. Go here to
Sorry
USA/Texas
-Original Message-
From: Seay, Paul [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 3:17 PM
To: [EMAIL PROTECTED]
Subject: Re: Need 3590 tapes!
What country/state/province might be helpful.
-Original Message-
From: Malbrough, Demetrius
I'm currently testing TDP for Exchange for possible deployment
in a very large enterprise environment. Is anyone aware of
tools/scripts that I can use to monitor the backups/restores.
I'm aware that
I can look at the past history of backups/restores and
determine approximately how long it
We run a TSM server on an AIX system. Is there a way to issue an operating
system command ie. ls, tar ... from inside a TSM script? Yes, I know I can
run a TSM script from the AIX command line, using dsmadmc ... but I have a
need to run an one or more AIX commands from inside a TSM script, if
I have a node running version 42121 on Solaris 7 I had a disk slice on that box
that was called /Backup_Storage about 1 year ago our UNIX administrator created a new
disk slice called /Backup_Storage2 and then he deleted the other disk slice When I
run the Backup/Archive client and click on
you would need to run a backup against the disk slice that was empty so TSM
can expire the files. Otherwise it keeps the active copy forever...
-Original Message-
From: Julian Armendariz [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 5:02 PM
To: [EMAIL PROTECTED]
Subject:
Not all error messages for TDP For Exchange (1.1.1.01 anyways) are logged on
the server.
We just ran into this on one of our test servers, messages in client log:
ACN3002E --
The Directory service is not running. A backup was attempted
but the necessary Exchange Services were not running.
We use Corporate Express. They are on the web at
http://www.corporateexpress.com/ But you will have to contact an account
rep.
-Original Message-
From: Malbrough, Demetrius [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 4:20 PM
To: [EMAIL PROTECTED]
Subject: Re: Need 3590
Confused? Actually Mark, what I wrote came straight from M.S. And yes the
MAPI is used to do online backups. How else would your backup software
system (i.e. Arcserve 2000) be able to see the Information Store?
As far as the difference of MAPI/API? MAPI's are sub-sets of API's. MAPI
just like a
Tim, Del,
Thanks... how about monitoring a restore in progress? Or monitoring many in progress
(like 10 or 20 which would not be that unusual). For example, your e-mail support
group paging and asking when is
it going to finish?
Is it simply Q the size of the full and the incrs and do the
Or just delete that filespace with DELETE FILESPACE. If everything
in that filespace is gone from disk and you don't need it any longer.
I do this occasionally with temporary filesystems we setup and then don't
need anymore. It just takes a few seconds to a few minutes depending
on how much
Or you can do a query act msg=2565
On Thu, 28 Feb 2002, mobeenm wrote:
Sree Kumar,
Its absolutely possiblem to do that. Try the following
select * from actlog where message like 'ANR2565I%'
I think this should do the trick. Hope the climate in Bangalore is good :-)
Regards
Mobeen
I'm not sure, I couldn't find any numbers that were close to 984x. The IBM
part number and other numbers are as follows.
DC 010208
PN 35L1549
FRU 35L1079
APN 96-5335-08
Hope my experiences help someone else, sharing information is the only key
to success.
Thanks,
Mark Bertrand
-Original
The fix is out.
APAR (IY17630) is available for 4.3.2, just not available for anything
4.3.0 and earlier.
If you fall between the boundries.
Gabriel C. Wiley
ADSM/TSM Administrator
AIX Support
Phone 1-614-308-6709
Pager 1-877-489-2867
Fax 1-614-308-6637
Cell 1-740-972-6441
The volumes are in a couple of places.
LIBVOLUMES Table
DRMEDIA Table
VOLUMES Table
VOLHISTORY Table
It is a long explanation of how these tables are intertwined.
First check to see if you have a limit on the time of database backups by
doing a query DRMSTATUS.
Second, look at volumes in the
You can also specify a macro file on the server or your desktop as input to
the dsmadmc command with the pipe command on the select or whatever
command. The beauty of the macro xx call is that it can do a lot of
things and anyone can execute it. Scripts require that you be a system
This is more of a security issue than anything. If you allow TSM to spawn
scripts, the child process inherits the same security. Which is typically
root. In their glory, they simply said no rather than opening up the OS I
guess. They definitely are not explaining themselves well.
What we used to do is just look at the file spaces - which
used to pretty accurate (Days since last backup completed
successfully 1) and pull out any machine that is greater
than 1 - now with the TDP for exchange 2.2 client it reports
the filespace as successfully completed even if a storage
We had the same problem and it was fixed by changing a card on the
library.You could also try to upgrade to latest library and lto drive firmwares
regards,
burak
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
28.02.2002 17:29
Please respond to
Hi,
Today I have upgraded to the latest library firmware for 3583. I am confused
about the cleaning cartdridge place inside the library. I was placing the
cleaning cartd.
to the top of the left columns. Today, the library started to give me an error
saying that I should
place the cartdridge
Hi all,
Just wondering what kind of experiences people have had running the
MANAGEDSERVICES client option under Win2k. Any particular problems to look
out for? My intention is to use CAD to manged the scheduling service.
I have not tested as yet but would also like to know that if I am running
72 matches
Mail list logo