Logmode (Was: Recovery Log size)

2001-06-25 Thread Reinhard Mersch
> At 08:35 AM 6/22/2001 -0600, Kelly J. Lipp wrote: > >Doesn't this bring back the issue of Roll-Forward vs. not? I guess I'm > >still in the not camp with no compelling reason to join the other. Also, > >for those in the other camp, I'm thinking if your environment is so large as > >to fill a 1

Re: SQL2025N An I/O error "-50" occurred on media "ADSM".

2001-06-25 Thread Walter Ridderhof
I've seen this one before, in our case it had to do with insufficient disk pool storage, by increasing the clients target pool space (the clients policy settings directed the client data to a disk storage pool) the problem was solved. It would seem that an SQL2025N would in someway be connected to

Re: Improving NT client throughput

2001-06-25 Thread Walter Ridderhof
Vint, just to give you an idea that you're not alone, we have similar type servers of which the largest contains 1.9 million tiff files (avg. 45 kb), your worst case client scenario. To increment the file system will cost TSM about 2 1/2 hours. Backuping the data itself will come to an average of

Backup Sybase on NT

2001-06-25 Thread Ofer vaknin
Hi , how can I backup Sybase on NT platform with TSM ver 4.1 do SQL-BackTrack™ for Sybase support NT platform? Thanks in advance Ofer Vaknin Tivoli Product Manager CDD - ISRAEL 972-3-5366010 EXT. 106 972-58-353875

unsubscribe

2001-06-25 Thread Chris Flaherty
unsubscribe __ The information in this e-mail is confidential and may be read, copied or used only by the intended recipients. If you have received it in error please contact the sender immediately by returning the e-mail or

Re: Can TSM directory paths, names be changed?

2001-06-25 Thread Bruce Arlt
We setup things like TSM and Maestro in their own filesystems using soft links. It works fine and keeps the system disks for system code.

Re: AW: Disk pool size vs large file

2001-06-25 Thread John Naylor
Stefan, You cannot rely on "completed" from query event to indicate a successful backup. You need to trap and alert on error messages as well. John Stefan Holzwarth <[EMAIL PROTECTED]> on 06/22/2001 10:41:27 AM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAI

Re: recovery log full

2001-06-25 Thread Caffey, Jeff L.
Geoff, I "THINK" your db backup will still run and clear your log as long as you have scratch tapes available, but I'm not 100% sure on that. I do know that it will NOT run if you are out of scratch tapes AND your recovery log is full. Why not go ahead and extend your recovery log anyway just t

Re: Disk pool size vs large file

2001-06-25 Thread Jeff Bach
Stefan, How can I find out it this will effect me when converting using Informix and Exchange servers on AIX 4.1.3? ADSM SUPPORT PEOPLE, How do we find out about all of these "FEATURES" of design that cause ADSM to break? Jeff Bach Home Office Open Systems E

Re: Recovery log Pct. Utilized

2001-06-25 Thread Nicholas Cassimatis
Geoff, Are there any processes or sessions running? They could be holding the log utilization up. I've also seen it take a while to commit the log to the database after the backup ends - you have 4GB of transactions in the log to commit to the database there, and, depending on your system, that

Re: TDPS in a cluster

2001-06-25 Thread Glen Churchfield
Del, I fixed this in the following way: 1. Two services need to be installed on each node of the Cluster with the batch file; dsmcutil install /machine:%1 /name:"%2 TSM Agent" /node:"SQL_%2" /password:"SQL_%2" /optfile:%3:\tsm\msSQL\dsm.opt /clientdir:C:\tsm\BACLIENT /clusternode:yes /clus

Re: Recovery log Pct. Utilized

2001-06-25 Thread Jeff Bach
If nothing is running (q ses, q pro) and the log is not clearing, the only way I have been able to clear it is to bounce the ADSM instance. Alternatively, kill -11 will create a core dump for them to analyze. Jeff Bach Home Office Open Systems Engineering Wal-Mart Stores, Inc. WAL-MART CONFID

Re: AW: Disk pool size vs large file

2001-06-25 Thread Jeff Bach
This is really sad. Jeff Bach Home Office Open Systems Engineering Wal-Mart Stores, Inc. WAL-MART CONFIDENTIAL -Original Message- From: John Naylor [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 25, 2001 9:17 AM To: [EMAIL PROTECTED] Subject:

Re: BackUp Oracle with min data

2001-06-25 Thread Neil Rasmussen
Wang, Rman has control of the backup. And this is one of the purposes of Rman. Rman will only backup the data inside the datafile not the entire datafile. Does this answer your question? Regards, Neil G. Rasmussen E-mail: [EMAIL PROTECTED] Date:Fri, 22 Jun 2001 13:52:26 +0800 From:L

Re: Backup Sybase on NT

2001-06-25 Thread David Longo
When I checked with BMC several months ago, they did not have SQL-BT backups for Sybase on NT. Quick solution would be to setup disk dump device in Sybase and run script to have Sybase dump to it and then have *SM backup the dump, if you have enough disk space. David Longo >>> [EMAIL PROTECT

ADSM/DATE/SQL

2001-06-25 Thread Sheets, Jerald
Ladies and Gentlemen, Do any of you out there have links to a SQL reference for ADSM ( I already have the documentation from the Administrator's guide) or a SQL 92/93 reference? I am interested specifically with doing date calculations using fields from DB, BACKUPS, and FILESPACES and N

Backup of clients not finishing within 5 hour window

2001-06-25 Thread Joe Cascanette
I have just upgraded from 3.1 ADSM server to 4.1 TSM server and have a few backup clients that keep loosing connections (drop from timeouts): I have uninstalled ADSM 3.1 Client from the servers, removed the ADSM Services manually, and after a reboot, installed TSM 4.1 Client. I have also installe

Re: Recovery log Pct. Utilized

2001-06-25 Thread Gill, Geoffrey L.
>Are there any processes or sessions running? They could be holding the log >utilization up. This is a tough one to answer Nick. The server kicked me out the first time I tried to query anything. I was lucky enough to have a console window open and could see the system wasn't allowing anyone to

Re: SQL2025N An I/O error "-50" occurred on media "ADSM".

2001-06-25 Thread MUSTAFA BAYTAR
The problem is probably related to your TCP/IP configuration. Attempt to 'ping' your ADSM server as soon as the error occurs. In addition, use 'query opt' to check the following settings on your ADSM server: 1. COMMTIMEOUT is on 60 (sec.) by default; increase to 900. 2. IDLETIMEOUT is on 15 (min

Re: SQL2025N An I/O error "-50" occurred on media "ADSM".

2001-06-25 Thread Burton, Robert
There is also an open APAR (can't remember the number) but when an UDB upgrade is done and adsm finds an empty tablespace it can get a -50 error Robert Burton Open System Storage Analyst Royal Bank of Canada 315 Front St West Toronto, On, M5V 3A4 416-348-3849 email: [EMAIL PROTECTED] -

Re: ADSM/DATE/SQL

2001-06-25 Thread Alexander Verkooijen
"Sheets, Jerald" wrote: > So then, to acheive the above desired result, what would my syntax be to > select all the node_name(s) and PW_SET dates older than 100 days? I use the DAYS function for this kind of queries. Here is an example: select node_name as "Node Name", \ days(current_date)-day

Re: ADSM/DATE/SQL

2001-06-25 Thread Xavier Chavanet
From: Xavier 1 Chavanet A valid SQL syntax for your request is : select node_name,pwset_time from nodes where cast((current_timestamp-pwset_time) days as decimal)> 100 Sorry, I have no electronic documentation availlable about SQL92. Regard

Re: ADSM/DATE/SQL

2001-06-25 Thread Gene Walters
Try this: SELECT NODE_NAME, PWSET_TIME from NODES where PWSET_TIME < CURRENT_TIMESTAMP - 100 DAYS >>> "Sheets, Jerald" <[EMAIL PROTECTED]> 06/25/01 11:05AM >>> Ladies and Gentlemen, Do any of you out there have links to a SQL reference for ADSM ( I already have the documentation from t

Re: ADSM/DATE/SQL

2001-06-25 Thread Sheets, Jerald
Thanks to everyone who answered. I've got 4 functionally perfect statements to use. Jerald Sheets, Systems Analyst TIS Our Lady of the Lake Regional Medical Center 5000 Hennessy Blvd, Baton Rouge, LA 70808 Ph.225.765.8734..Fax.225.765.8784 E-mail: [EMAIL PROTECTED] -Original Message- F

library definitions with a HSC/LS-driven powderhorn

2001-06-25 Thread Andreas Rensch
Hi TSMers, we are implementing a TSM server on Sun Solaris. How do I have to define a (OS/390-)HSC-LS-driven powderhorn library against the TSM server? Is it defined as an external library or as an automated library? mfg / regards andreas rensch / rz-qs tel : +49(0)6171 66 3692 / fax : +49(0)61

TSM and TDP for Domino command file.

2001-06-25 Thread Brian L. Nick
We are running TSM 3.7.4 on OS/390 2.10 and we are attempting to configure a TDP for domino environment. My issue is this when we attempt to do a scheduled TDP Incremental client backup of the node we receive a return code 1 when the command file is executed. I can execute the TDP incremental ba

Pre schedule command to stop NT service ??

2001-06-25 Thread Serein, Gilbert Claudio
I'm running TSM 4.1 in Windows NT 4.0. I need to stop a service in NT before a daily backup schedule starts. I've heard of a preschedule in TSM, is this command available to windows users?. I've looked in the Admin. Reference Manual but is not there. Any help on where can I find it or how to use

Re: Pre schedule command to stop NT service ??

2001-06-25 Thread Murray, Jim
We have to do the same here for some Pervasive SQL databases I can't seem to get rid of. We use the AT scheduler to kick off a batch file half an hour before the scheduled time of back up. The batch file looks like this: net stop "Btrieve v7.0 for Windows NT (Server Edition)" net stop "Scalable

Re: Pre schedule command to stop NT service ??

2001-06-25 Thread David Longo
Yes, it's available. We use it here. It is documented in the "Windows Client" manual. Sample as used in dsm.opt file on client: preschedulecmd 'net stop "service name"' David Longo >>> [EMAIL PROTECTED] 06/25/01 04:02PM >>> I'm running TSM 4.1 in Windows NT 4.0. I need to stop a service i

Re: Pre schedule command to stop NT service ??

2001-06-25 Thread Doug Thorneycroft
Just create a batch file that contains the line "net stop " Where Service_Name is the service that you want to start. (I use ADSMSTOP.CMD for the filename.) in the DSM.OPT file, add the line: PRESCHEDULECMD "C:\tivoli\tsm\baclient\ADSMSTOP.CMD" (Adjusting the path to match your system. The batch

Web client access on a Cluster server

2001-06-25 Thread Tyree, David
We are running a 3.7.2 server on a WinNT 4 sp5 machine talking to a 4.1.2 client on a Win2k sp2 Cluster server. All the backups and the restores on the cluster server are fine. The problem is that we can't get the web client piece to work on all the nodes. The only way I can do res

Exchange mailbox restores

2001-06-25 Thread Jim Kirkman
Hello, >From the uninitiated, what is the procedure for restoring an individual mailbox from a backup made with the TDP client? My customer says he can't figure it out from the GUI, and I don't have access. Thanks, -- Jim Kirkman AIS - Systems UNC-Chapel Hill 966-5884

Re: OS/2 Standard Include/Exclude Lists

2001-06-25 Thread John Johnson
Here is what we use, not all that much to them. DOMainC: D: EXCLUDE?:* INCLUDEd:\users\* INCLUDEd:\users\...\* INCLUDEd:\public\* INCLUDEd:\public\...\* INCLUDE

Re: Exchange mailbox restores

2001-06-25 Thread John Pimentel
Jim, In a meeting about a year ago we were told that you could do this, if Microsoft would create an API. You may want to check in that direction. At that time there was no API, but things may have changed. Sorry I don't have a lot of help. John Pimentel, Winn-Dixie Stores, Inc. -Origin

Re: Recovery log Pct. Utilized

2001-06-25 Thread Georges Roig
Gill, That's unfortunatelly a temporary bug, you can use the "ckpt" command to reset the pct_util. Regards Georges

Diskpool size for DirMc

2001-06-25 Thread Raymond Chao
For restore purpose, we are interested in setting up a diskpool for DirMc. We have a DB size of 27 G, about 25 NT clients (mainly Lotus Notes & Lan) & about 50 unix clients(Aix & Sun). Our nightly backup is about 200 G and we don't use any TDP agents. I would be interested to get a ballpark figur

Re: What volume is my backup on, at time of restore?

2001-06-25 Thread Alex Paschal
I don't think that information is actually available. If you take a look at the CONTENTS table, it'll tell you what files live on a volume. However, it doesn't give you a way to map the file to the correct _version_ of the file you wish to restore. Can anyone look and see if they might have add

Re: What volume is my backup on, at time of restore?

2001-06-25 Thread Pothula S Paparao
If i'm correct, try out this select query select * from backups where node_name='NODENAME' which gives u OBJECT_ID,FILESPACE_NAME, HL_NAME . sree Alex Paschal <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 06/23/2001 06:30:35 Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Sent by: "

Re: Exchange mailbox restores

2001-06-25 Thread BURDEN,Anthony
The steps are as follows, 1. Install the TSM exchange agent software onto a different/new exchange server. 2. Configure the DSM.OPT file to be the sever that you need to restore. Eg(the name of the server that has the mail box) 3. Restore the exchange private store to the new exchange server, usi

full drives & offsite pool

2001-06-25 Thread chris harris
Hi, We run ADSM 3.1 on AIX with a StorageTek DLT cabinet w/6 drives. We're starting to run into some minor drive availability issues. I thought of a potential solution (it should at least help), but don't know how feasible it is. Here's the situation: Our backups go to disk. During the day, we

Re: full drives & offsite pool

2001-06-25 Thread Steve Harris
Easy, use the sequence Run a backup stg of all diskpools to tape Run a backup stg of all tapepools to tape then run the migrate. Regards Steve Harris AIX and ADSM Admin (TSM in testing!!!) Queensland Health, Brisbane Australia Easy,   use the sequence   Run a backup stg of all diskpools

NT SAN PROBLEM

2001-06-25 Thread BURDEN,Anthony
Just a little issue I am having and was looking for some help/ideas. I have a SAN that I am attempting to backup and when I schedule the backup the NT server reboots, this happens every time I try to backup the SAN data or just the local c drive on the W2K front end. There are no error reported i

Re: Diskpool size for DirMc

2001-06-25 Thread Lambelet,Rene,VEVEY,FC-SIL/INF.
Hello, 2-3 GB would be sufficient, René Lambelet Nestec S.A. / Informatique du Centre 55, av. Nestlé CH-1800 Vevey (Switzerland) *+41'21'924'35'43 7+41'21'924'28'88 * K4-117 email [EMAIL PROTECTED] Visit our site: http://www.nestle.com This message is intended only for the use of t

Open AFS?

2001-06-25 Thread Suad Musovich
Is there any way to backup a Open AFS filesystem? I see AFS support for AIX but I can't tell if it extends to Open AFS. There is also a reference in the developerworks site that you can compile in Support via the TSM api but aren't sure whether that is equivalent to a TDP, or I'm barking up the