Anyone actualy found this??
It seems to be GC32-0785-00 but I can't find this document to download or
order anywhere.
Any kind soul point me in the right direction please
Thanks in advance.
.Rikk
Hi all,
is there a way to create a list of all backups and archives and there
expiration date?
I mean all backups and archives for all clients. I think it could be
possible to do this with an SQL-script, but I'm not sure. And if it is
possible, does anyone has such a script. I don't want to
Hi Wolfgang!
Everything is possible to do. Becuse you have all the information
Hi all TSMers!
I got just a prodject on my desk who says that I need to found a good
disaster recovery solution for Microsoft SQL 2000.
And I know how to get back the system in 5 min. But I still don´t know how
to get back the SQL server with out any installation CDs.
I have come so far so I
Hi Cristie,
thanks for answer.
I need information for all files and when they will expire. For sure, it will be a
large list. My company will replace TSM with NetBackup :-(
So I need the information, wich data are at my TSM.
Wolfgang
-Ursprüngliche Nachricht-
Von: Christian
Hi Christian,
you will need TDP2.2 for SQL (Tivoli Data Protection), to backup the SQL
databases.
and that incl. both master and model.
Med venlig hilsen/Regards
Bo Nielsen
* 43 86 46 71
COOP Danmark A/S* (Internt postcenter):
Is it supported?
Has anyone had any success in using Oracle 9.2 on Windows
with RMAN and TDP for Oracle??
This is from Tivoli:
Oracle Supported Plattforms
Data Protection for Oracle Ver 2.2.1 on Windows
Hardware requirements: Intel-based 80486or greater processor, including
xSeries with
Hi!
I can not help you if you going to move from TSM to NetBackup.
I´m just
Anyone actualy found this??
Easy - Enter title into Google search, or at www.ibm.com
Many instances on the web, principally:
http://publibfp.boulder.ibm.com/epubs/pdf/c2346930.pdf
Richard Sims, BU
Hi,
well, it's not my decision ;-)
I need all files from all clients. At the meantime I think I have to do it with a
select for the occupancy. Correct me if I'm wrong.
Wolfgang
-Ursprüngliche Nachricht-
Von: Christian Svensson [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 10. März 2003
Hi Bo!
I´m already use the TDP for backup the data in the databas. But to
From what I remember you need to start SQL in single user mode (from DOS cmd
line), then restore master with TDP. Then restart in normal mode and restore
the other databases with TDP.
-Original Message-
From: Christian Svensson [mailto:[EMAIL PROTECTED]
Sent: 10 March 2003 13:22
To:
is there a way to create a list of all backups and archives and there
expiration date? I mean all backups and archives for all clients.
You can do a Select on the Backups and Archives tables.
Archive expiration is easy, based upon archive date and retention.
For Backups, you need to look at the
Hi,
you have to start SQL in single user mode, with the startup parameter -e, Note:
-e is small and the TDP Documentation says -E I think, when you use -E the sql
server won't start.
Markus Veit
Hej
There is a redbook covering SQL backup/restore,
http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg246148.pdf
Maybe ou will find something there
/Niklas
-Original Message-
From: Christian Svensson [mailto:[EMAIL PROTECTED]
Sent: den 10 mars 2003 13:22
To: [EMAIL PROTECTED]
Hi!
That is one way to do it.
But you are lucky. Becuse for a few days i go i
I don't know if someone else as suggested this already not having seen the
start of this thread but when I'm in a 'have to stop process, need tape
drive' situation, after I issue the cancel of the process, I also update
the cartridge itself to access=unavailable. This will stop the process
almost
Just a small correction in the update from Markus.
To start the SQL Server in single-use mode,
use the -m (in lower case) option.
Del
Hi,
you have to start SQL in single user mode, with the startup parameter -e,
Note:
-e is small and the TDP Documentation says -E I think, when you use -E
the
Wow, great select. I tried the first one. After some minutes my tsm-server quit his
job and break down. Think it was to much for him. ;-)
Wolfgang
-Ursprüngliche Nachricht-
Von: Christian Svensson [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 10. März 2003 14:16
An: [EMAIL PROTECTED]
Hi *SM-ers!
I haven't received an answer yet, so I'll give it another try:
In the IBM Redbook IBM Magstar Tape Products Family: A Practical Guide I
read the following line:
For 3590 Magstar drives, use a value of 999 mounts to perform cleaning based
on drive request rather than library
Hi Mark,
The command I used was:
TSMSERV delete filespacenode_name /filespace_name
The deletion took several days, and actually never finished because I had
to kill it. The reason is that the user got nervous and wants to make the
second copy of the data on disk is really complete.
Hi,
make an incremantal full backup of your system when the SQL service is not
running, as well as the system objects.
when you make a bare metal restore, restore the system objects than the files,
including the SQL files and standard databases,
start the sql service and restore all databases.
Hello together,
I tried to delete a filespace on my TSM-Test-server (V5.1.6.2 on z/OS 1.4) and got the
following messages.
Has anyone seen this before? What can I do? Is my DB corrupted?
ANR2017I Administrator T03281A issued command: DELETE FILESPACE T03281A 4
NAMETYPE=FSID TYPE=ANY
Hi Del,
thanks you are absolutly right, sorry -m it is. :-)
Mit freundlichen Grüßen / Best Regards
Markus Veit
Hi Eric!
I don´t know if this help you.
Maybe the library take up the cleaning
Eric,
did you double check that you still have cleaning cycles left on
your cleaning tape(s) ?
mtlib -l/dev/lmcp3 -qL | more
Library Data:
operational state..Automated Operational State
functional state...00
input stations.1
output
We had a cleaning problem with our 3590 Magstar a few months ago. Here is
what we did though I don't know if yours is set up the same way. We did
find out that the cleaning default 'preset' in the Library was not
initiating cleaning. In the Magstar Library under Commands pull-down, then
I haven't received an answer yet, so I'll give it another try:
We've simply been ignoring you. ;-)
In the IBM Redbook IBM Magstar Tape Products Family: A Practical Guide I
read the following line:
For 3590 Magstar drives, use a value of 999 mounts to perform cleaning based
on drive request
Hi,
I'm running TSM 5.1.6.1 on Sol 8 and want to do
an complete Backup of our NT 4 Servers. I created
an scheduled job and tried to backup the Server but
some files can't be read (i.e. ntuser.dat, SAM, SAM.LOG).
I read the Client Documentation and there where described
that it is possible to do
The following select was pulled from this list;
/* */
select case when SUM(BYTES) IS NOT NULL then CAST(SUM(BYTES) AS -
DEC(40,2))/(1024*1024*1024) else ABS(CAST((0) AS -
DEC(40,2))) end AS Total Gigabytes from summary -
where DAY(end_time) =
I know that. I was looking for people's opinion on what would be a good
4.1.3.x
level client to put on this server. It is their main NDS replica server.
They
are currently moving to Active Directory, but Netware is going to be around
for
a while yet. Right now it's running a 3.7 version that is
Bill,
Netware is gradually being phased out with us as well.
Our 4.11 servers have been on 3.7.20 client for a few years now and I cannot
recall
that we have had any problems with it, certainly not any major ones.
John
**
The
Hi Richard!
Thank you very much for not ignoring me this time :-)
The output from /usr/bin/mtlib -l $LMCP -vqK -s fffd:
Performing Query Inventory Volume Count Data using /dev/lmcp0
Inventory Volume Count Data:
sequence number..10143
number of volumes0
category.FFFD
...Is there a special
procedure for checking in a cleaner cartridge?
No: you simply toss them into the Convenience I/O station and the
library puts them away into arbitrary cells, remembering where
they are. I would hazard that the tape you inserted did not have
a barcode label prefix matching
I saw that the cleaning tape was ejected to the bulk
I/O area. So I removed it from the library and I placed a new one in
the
bulk I/O area. The library picked it from there and placed it in an
empty
cell. I though that that was enough, but apparently not. Is there a
special
procedure for
On the 3494, you set it up so that certain labels on the cartridges are seen
as cleaning tapes. (i.e. CLN*). If your new cleaning tapes match the pattern, then
there is nothing else to do. Perhaps your new cleaning tapes do not match the
cleaning tape mask and you need to adjust/add to
We've got a W2K box running the 5.1.5.0 client and backing up a MS-SQL
database to our 4.1.4.2 server. In lieu of the TDP we're stopping and
starting the sqlserver with the pre/post schedule command and batch
files. I've applied a specialized MC to the primary .mdf file and can
see from the web
Ok, this is my guess. ...
/* */
select case when SUM(BYTES) IS NOT NULL then CAST(SUM(BYTES) AS -
DEC(40,2))/(1024*1024*1024) else ABS(CAST((0) AS -
DEC(40,2))) end AS Total Gigabytes from summary -
where
make sure your cleaning volume mask is set properly...
I think by default it is CLN999
I've set it to CLN***
do this all from the console on the ATL...
Dwight
-Original Message-
From: Loon, E.J. van - SPLXM [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2003 10:18 AM
To: [EMAIL
Most likely explanations: Either the file is not getting backed up when
you think it is, or else it's being overlooked by whoever is looking in
the dsmsched.log file.
For starters, it would help to know the following:
1) Complete dsmsched.log content (zip up and attach, be sure to point out
the
One problem I am aware of at this level of the client (5.1.1.0, if I
understand correctly) is IC34996. For AIX, this is fixed in patch
level
5.1.5.11. You might try applying that patch to one or two machines
that
consistently see this problem to see if that resolves it.
Andy,
Thanks for the
Thanks Jack!
It worked great! I was able to go back 31days as that is how much summary
log that I keep. Normally, I have a script which runs in my morning
process that sends a daily summary of GB's backed-up to a log, which I
eventually use for historical reporting. Because of a problem in
Environment:
Server: RS/6000-AIX5.1 TSM V4.2.1.9
Client: NT4-Service pack 6,
Win2k-SP1, TSM V4.2.1.9
Novell - Netware 6 TSM V5.1.5.0
SP2-AIX5.1 TSM V4.2.1.9
Hi *SM'ers ,
I have an admin schedule setup that does my disk
Hi Ruddy,
have you tested with :
TCPBUFFSIZE=32
TCPWINDOWSIZE=63 or 32 or 16 or 8
TCPNODELAY=YES
LARGECOMMBUFFERS=YES
TXNBYTELIMIT=25600 or 524288 or 1048576 or 2097152 (
for LTO).
There is a tunning guide for TSM version 4.2 is very
good.
.
Regards, Fran .
I don't think the migration was caused by an Admin schedule. Maybe you
filled up the storage pool and that caused the migration.
Jim Sporer
At 12:23 PM 3/10/2003 -0600, you wrote:
Environment:
Server: RS/6000-AIX5.1 TSM V4.2.1.9
Client: NT4-Service pack 6,
Win2k-SP1,
Can you provide a little more information about the problem? For example,
what makes you say that the migration started as a result of the Admin
schedule? Does the activity log actually show the schedule being run? What
does the definition of this schedule look like (output from Q SCH F=D for
this
What is the easiest way to determine the number of bytes transferred for a TDP for
Oracle backup (full or incremental). The backups are client driven with multiple
sessions. The activity log shows
bytes sent (ANE499I) for each session started, but I'm sure there's an easier way to
compile
Field 17 of the TSM accounting record is Amount of backup files, in
kilobytes, sent by the client to the server. If a file is retry-ed,
does it get counted once or twice in this field?
David
Greetings all!
Environment: TSM V 5.1.1.0 on Win2k SP3
While check on this AM's processes and such, one of our ITSM boxes crashed.
This was the only error I saw that showed up in the NT event log:
Event Type: Error
Event Source: ADSMServer
Event Category: None
Event ID: 27
Date:
you can use a select * from backups where node_name='NODENAME' and type=file
or
select * from archives where node_name='NODE_NAME' and type=file
This will list only the files and not each directory. Hope this helps.
T
-Original Message-
From: Herkenrath, Wolfgang
Is Dr. Watson configured as the Windows 2000 default debugger (most likely
it is)? If so, look in the Dr. Watson log file (drwtsn32.log) and find the
exception that corresponds to the date and time stamp shown the Windows
event log record. There should be a stack trace; what does it look like?
Any ideas? NT4 SP5, had 4.2.1.20 client on it and I get this:
Error 1711. An error occurred while writing installation information to
disk. Check to make sure enough disk space is available, and click Retry,
or Cancel to end the installation.
trying to install the 5.1.5.9 client. This isn't
Richard,
what is the mtlib command that shows how many cleaning cycles are available
in the library? I used to know it but nothing seems to work now.
From: Cook, Dwight E [EMAIL PROTECTED]
Reply-To: ADSM: Dist Stor Manager [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: 3494 cleaning (2
mtlib -l /dev/lmcp0 -qL
[EMAIL PROTECTED] 03/10/03 03:17PM
Richard,
what is the mtlib command that shows how many cleaning cycles are
available
in the library? I used to know it but nothing seems to work now.
From: Cook, Dwight E [EMAIL PROTECTED]
Reply-To: ADSM: Dist Stor Manager
what is the mtlib command that shows how many cleaning cycles are available
in the library? I used to know it but nothing seems to work now.
3494 cleaner cycles remaining 'mtlib -l /dev/lmcp0 -qL' line:
avail 3590 cleaner cycles
R.
Hello everyone!
Performance issues have been arising with the TSM server and we were asked
if the data, when it is sent from a client to the TSM server, if it is
converted from binary to EBCDIC? Does anyone have any input on this
matter? Thank you!!! (in advance)
Joni Moyer
Systems Programmer
The job is setup in administrative events, but there was no schedule that
started it at 2:30am. I don't think we need to go too much further to
figure this out, I think you hit the nail on the head with the storage pool
going past the high migration threshold. They run a huge DB2 backup on the
Lisa,
I had the same issue with the 4.1 client.
I can not remember which solution solved my issue.
1. In the readme file it mentions about some value to change in
the setup.ini file.
2. Run the file called instmsiw.exe that's within the
directory of the TSM install files. It's going to
Have a great day,
James W. Brents Jr.
Lead Technical Specialist
Valero Energy Corporation
Voice: 210-592-4441 Fax: 210-370-4441
Hello!
TSM 5.1.6.2 on AIX 4.3.3.10
I am running DRM and I am seeing large discrepancies in what I have
offsite and what TSM reports as being offsite.
I run a q drm wherest=vault [or a select statement] and compare the list
to the physical tapes offsite and they don't match. About 8 weeks ago,
Do you include the database tapes in reporting and bringing back?
-Original Message-
From: Mahesh Tailor [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2003 3:18 PM
To: [EMAIL PROTECTED]
Subject: Offsite Volumes
Hello!
TSM 5.1.6.2 on AIX 4.3.3.10
I am running DRM and I am seeing
We are attempting to perform a point in time restore for one of several
thousand users on a large mail server. The file system involved contains
almost four million files. The server is at level 4.2.3.2 and running
under OS/390. The client is at level 5.1.1.0 and running under Linux
at a 2.4.9-34s
Yes, I have seen this and there are a number of reasons
that can cause this.
1. Are you using DRM to expire the DB
tape? You should be, if not that can be a cause.
2. How detailed are your operations people and your
tape return procedure? Example: if ops is using the
Move DRM command to
Yes, these volumes are also counted (via q volh type=dbb).
Mahesh
Mahesh Tailor
WAN/NetView/TSM Administrator
Carilion Health System
Voice: 540-224-3929
Fax: 540-224-3954
[EMAIL PROTECTED] 03/10/03 16:51 PM
Do you include the database tapes in reporting and bringing back?
-Original
On Tuesday, Mar 11, 2003, at 06:09 Australia/Sydney, David E Ehresman
wrote:
Field 17 of the TSM accounting record is Amount of backup files, in
kilobytes, sent by the client to the server. If a file is retry-ed,
does it get counted once or twice in this field?
I believe (and I'm sure I'll be
We see the same thing. Last week we took all ofsite tapes for a
disaster test and found 18 out of 50 were not listed in q drme.
I cannot guarantee that the tape operators did not make mistakes
and we will double check in the coming weeks but it sure sound as
a lot of lost tapes.
I suspect that it
** High Priority **
we too facing same problem and recently we did manual volume inventory, recoverd
300tapes.
please provide if anyone got solution.
thanks
/mani
Marcel J.E. Mol [EMAIL PROTECTED] 03/10/03 05:23PM
We see the same thing. Last week we took all ofsite tapes for a
disaster test
David, thanks for the email. See my responses below. (Using caps to
differentiate answers not to shout.)
Mahesh
Mahesh Tailor
WAN/NetView/TSM Administrator
Carilion Health System
Voice: 540-224-3929
Fax: 540-224-3954
[EMAIL PROTECTED] 03/10/03 17:14 PM
Yes, I have seen this and there are a
Hello Marcel, Please take a look here and select Media Manager,
http://www-3.ibm.com/software/tivoli/products/tivoliready/storage.html
greetings
Peter
At 23:23 10-3-2003 +0100, Marcel J.E. Mol wrote:
We see the same thing. Last week we took all ofsite tapes for a
disaster test and found 18 out
One common cause for this is that you are running delete volhist on your db backups
rather than letting DRM handle it (or with a shorter retention than DRM does). TSM
then forgets about the DB backup tapes that are offsite.
HTH
Steve Harris
AIX and TSM Admin
Queensland Health, Brisbane
Hi Andy,
There is a stack back trace for each thread. Since the list is pretty long
I am not sure which one to show you. Debugging is NOT my forte`! I could
zip and attach the log. Its not very big when zipped.
Chris
-Original Message-
From: Andrew Raibeck [mailto:[EMAIL
I have a customer trying to restore data from a client backed up in one NT
domain to a new NT domain. He is getting back all of the NTFS permissions
but the ownership is set to the user that is logged in and doing the
restores.
Is this correct and if so why?
Ron L. James
Folks, I am getting a server that fails it's backups. It appears to hang
for days if you let it (and it has on one weekend). In the past, I have had
similar errors and found that the NIC had been set to 100MBit and half
duplex, which does not match the switch. I set it to full duplex and the
Folks, I am getting a server that fails it's backups. It appears to hang
for days if you let it (and it has on one weekend).
...
...TcpRead(): recv(): errno = 10058 ...
The 10058 is: Cannot send after socket shutdown. A request to send or
receive data was disallowed because the socket had
Folks,
I'd like to announce a new TSM reporting website I've created. It's free for
all to use, though you will need to register an account to use the online
graphing tools.
http://ibktsm.dyndns.org:81
Currently it can convert TSM summary and client accounting logs into
MS-Project style
OK, I'll take a stab at this: You are pretty plainly asking for more
files to be restored than you realize. Specifying a simple subdirectory
to be restored, from even a filespace containing a vast number of files,
is fast. e.g. RESTORE /var/mail/johndoe/* Our end-users do it all the
time with the
Hallo,
for my opinion, it seems to be a normal migration process caused by the
migrationthreshold which is defined in your diskpool. Automatic migration
is started by TSM, when the threshold HighMig is reached.
MfG
Sascha Bräuning
Sparkassen Informatik, Fellbach
OrgEinheit: 6322
Henk ten Have,
the result of show bfo 0 243145 is
Bitfile Object: 0.243145 Bitfile Object NOT found.
I called support (created pmr at IBM-Webpage) and wait now for their call ;-)
And I think I'm lucky - my TEST-DB is only 500MB...
thanks for your help - I will post here again when I have a
78 matches
Mail list logo