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
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
cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK)
Sent by: Subject: Re: How to use string operators
in select statement
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 c
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 configurin
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
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
-Origina
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 t
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 Message--
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= -outfile=report.txt select blah
from blah where blah
There are other switches that control the format and/or style o
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 succes
> 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
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 d
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 PROTECTED]
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 include/excl
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
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 Sys
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 TYPE
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, Februar
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 by
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 experie
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, 20
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 t
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 13:
> 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/
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 2
Again, I am at a loss on this one..
TDP for MS sql 2.2
When the scheduler now runs a differential of the database, this is what the
log shows:
Version 2, Release 2, Level 0.0
(C) Copyright IBM Corporation 1997, 2001. All rights reserved.
ACO5057I The C:\Program Files\Tivoli\TSM\TDPSql\sqldiff.
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 wil
> 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
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 to
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 pu
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
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
de
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 s
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
> 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 h
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 [mai
> 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 lon
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 ther
I have a node running version 4.2.1.21 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
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: F
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.
01/29/2
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 ma
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 dat
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
> Mo
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 M
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
Siempr
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 DRME
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
adminis
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.
-Origina
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
group
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 ADSM
Hi Joe,
Our environment is same as yours - Os/390 TSM4.1.3.0.
We run roll-forward mode on the recovery log.
Size currently allocated for the recovery log = 5364Meg
The maximum you can make this is in the region of 5.4 Gig -
check back in the archives - it has been discussed before.
It depends on
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
w
73 matches
Mail list logo
