Logmode (Was: Recovery Log size)

[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 13 GB log in a 24 hour period perhaps the environment is busting
> >at the seems in other areas and should perhaps be split anyway.
> >
> >Even if larger logs were supported, how long would a db restore take with
> >roll-forward enabled?  I'm thinking way too long.
>
> I don't believe this is a pure issue of database size.  Rather, I think it
> is the combination of performance characteristics of the server, the
> network, and the client - the entire environment.  roll-forward makes sense
> when the time it takes to run an incremental backup is much less than what
> it takes to run a full backup.  If you can afford to run a full backup
> every day, then go for it.  Your recovery time will be short.  The time it
> takes depends not just on DB size, but also tape speed, processor speed,
> processor memory, etc.  When we upgraded our server, we found that database
> backups ran faster - no surprise there.  We run roll-forward because we
> don't have enough wall clock time to perform a full backup every day, but
> we want the protection.  While recovery time is an issue, backup time can
> be too and it is in our environment.

Paul,

why does logmode=normal imply performing full backups every day?
I guess, your statement has to be seen in the context of Kelly's remark
regarding restore times; clearly, having to restore just one full backup
would be advantageous. We also cannot afford to run full backups every day,
so we run daily incrementals. We nevertheless live with logmode=normal,
because, as Lindsay Morris already stated, roll-forward probably gives you
nothing, if the DB is mirrored.

The only situation, where roll-forward seems important to me, is when
the DB is not mirrored. The DB must be big then, because otherwise it
would be better to spend the extra log space needed for roll-forward for
the DB mirror.

Reinhard

--
Reinhard MerschWestfaelische Wilhelms-Universitaet
Zentrum fuer Informationsverarbeitung - ehemals Universitaetsrechenzentrum
Roentgenstrasse 9-13, D-48149 Muenster, Germany  Tel: +49(251)83-31583
E-Mail: [EMAIL PROTECTED]   Fax: +49(251)83-31653

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

[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 a TSM
resource problem, be it disk or tape, you should find the answer to your problem
in the server activity log.

regards Walter Ridderhof.


-
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.

Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-

Re: Improving NT client throughput

[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 10mb/min, I've seen total
times of 3 hrs 46 mins to backup 25080 files for a total of 1.08gb to a
don't-hold-your-breath 9 hrs 41 mins to backup 92587 files.
The client node hardware consists of single CPU HP 6000 servers with 256kb
controller cache, 12 disks are configured as 1 RAID-5, this is all running on a
dedicated FDDI backbone. (system OS is NT4 SP6a, TSM client is V3.7.2.17).
TSM client tuning consisted of setting sensible max options like the
tcpwindowsize 63, tcpbuffsize 32  and tcpnodelay yes.

For the NT TSM server side, well pure misery after migration from 3.1.2.57 to
4.1.3 the db cache hit has dropped from 98 % to 83 % this impacted the backup
time big time but with some client and server re-tuning we're still within the
available backup window. We hope to get the db cache hit up a few percent with a
dump/ loadformat/load/audit but the audit abends, something that should be fixed
in V4.1.3.2.

In conclusion the things to get right where it concerns hardware, big RAIDS
(RAID5 or 10) at least 6 disks, lots of controller cache, try getting file
spaces on their own RAIDS on a seperate SCSI channel this way you can
efficiently run multiple TSM client nodes on 1 box (admittedly customer has to
comply in advance).
Get on to your own TSM or data network backbone, if running ethernet try to let
the big clients run in a quiet time slot.
On the TSM client and server side, the perfomance settings advized by Tivoli
seem to do the job, well, most of the time. And for sure get that % db cache hit
up to 98.

regards Walter Ridderhof.





-
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.

Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-

Backup Sybase on NT

[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

[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

by telephoning the number contained in the body of the e-mail and

please delete the e-mail and do not disclose any of its contents to

anyone. No responsibility is accepted for loss or damage arising from

viruses or changes made to this message after it was sent.



__



Members of the Royal & Sun Alliance Life & Pensions Marketing Group

are regulated by the Personal Investment Authority, solely for life

assurance, pensions and collective investment scheme business, and by

IMRO.



The Royal & Sun Alliance Life & Pensions Marketing Group is composed

of:

Royal & Sun Alliance Life & Pensions Limited 1565099+

Royal & Sun Alliance Linked Insurances Limited 1016269+

Sun Alliance and London Assurance Company Limited 894616+

Phoenix Assurance Plc 71805+

Registered office: New Hall Place, Old Hall Street, Liverpool, L3 9UE.

Telephone 0151 239 3000



Royal & Sun Alliance Unit Trust Management Limited 2170242+*

Registered office: St Mark's Court, Chart Way, Horsham, West Sussex,

RH12 1XL. Telephone: 01403 232 323



+Regulated by the Personal Investment Authority  *Regulated by IMRO



Other associated companies in the Royal & Sun Alliance Insurance Group

plc group of companies:

Royal Life Holdings Limited 2656289

Royal & Sun Alliance Life Holdings Limited 864196

Royal & Sun Alliance Pensions Trustee Services Limited 1967589

Royal & Sun Alliance Life Insurance Services Limited 2680269

Registered office: New Hall Place, Old Hall Street, Liverpool, L3 9UE.

Telephone: 0151 239 3000



All companies registered in England



For your protection and for staff training purposes, telephone calls may

be monitored or recorded

Re: Can TSM directory paths, names be changed?

[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

[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:   [EMAIL PROTECTED]
cc:(bcc: John Naylor/HAV/SSEG)
Subject:  AW: Disk pool size vs large file




**
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric and Southern Electric are trading names of
Scottish and Southern Energy Group.
**




We use TSM 3.7.3.8 @MVS with several 3590-tapes shared with OS390.

Our biggest files are 30GB (Exchange) and normally went direct to tape
by setting a sizelimit to the diskstorage pool.

What happened last week was an incredible short backuptime of the exchange
node
without any error. Looking through the dsmsched.log I found :

06/21/2001 02:33:46 ANS1312E Server media mount not possible
(due to no tape free at this moment?)

The TSM Client skipped the file and finished with the following summary:

06/21/2001 02:33:46 --- SCHEDULEREC STATUS BEGIN
06/21/2001 02:33:46 Total number of objects inspected:8,565
06/21/2001 02:33:46 Total number of objects backed up:  246
06/21/2001 02:33:46 Total number of objects updated:  0
06/21/2001 02:33:46 Total number of objects rebound:  0
06/21/2001 02:33:46 Total number of objects deleted:  0
06/21/2001 02:33:46 Total number of objects expired: 26
06/21/2001 02:33:46 Total number of objects failed:   0
06/21/2001 02:33:46 Total number of bytes transferred:   138.73 MB
06/21/2001 02:33:46 Data transfer time:   74.62 sec
06/21/2001 02:33:46 Network data transfer rate:1,903.68 KB/sec
06/21/2001 02:33:46 Aggregate data transfer rate:  1,067.74 KB/sec
06/21/2001 02:33:46 Objects compressed by:0%
06/21/2001 02:33:46 Elapsed processing time:   00:02:13
06/21/2001 02:33:46 --- SCHEDULEREC STATUS END

The eventlog shows no exception for this schedule.

IBM's comment: "Works as designed"

Now I consider to do the backup of large files to the primary storagepool on
disk, because its very difficult to detect this error. (error.log shows no
errors)

With Regards, Stefan Holzwarth

> -Ursprüngliche Nachricht-
> Von: Sam Schrage [mailto:[EMAIL PROTECTED]]
> Gesendet am: Donnerstag, 21. Juni 2001 20:15
> An: [EMAIL PROTECTED]
> Betreff: Disk pool size vs large file
>
> I have a 56GB disk pool with the next pool to tape.  I have a
> user, DB2
> Admin, that wants to back up a 125GB DB2 backup.  What's the
> best way to
> handle this one user?  If he/she backs up the file will it
> crash the system
> because it's bigger that the diskpool, or will it go right to tape?
>
> Sam Schrage
> TRW Systems
> [EMAIL PROTECTED]
>

Re: recovery log full

[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 to be sure...?

Thank you,

Jeff Caffey
Enterprise Systems Programmer
(AIX & Storage Administrator)
Pier 1 imports, Inc.  -  Information Services
[EMAIL PROTECTED]
Voice: (817) 252-6222
Fax:   (817) 252-7299

 -Original Message-
From:   Gill, Geoffrey L. [mailto:[EMAIL PROTECTED]]
Sent:   Sunday, June 24, 2001 06:36
To: [EMAIL PROTECTED]
Subject:recovery log full

Question:
If the recovery log is full and a database backup is sheduled to run, will
the db backup run since the server is up and clear the log?

Geoff Gill
TSM Administrator
NT Systems Support Engineer
SAIC
E-Mail:   [EMAIL PROTECTED]
Phone:  (858) 826-4062
Pager:   (888) 997-9614

Re: Disk pool size vs large file

[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 Engineering
Wal-Mart Stores, Inc.

WAL-MART CONFIDENTIAL


-Original Message-
From:   France, Don G (Pace) [SMTP:[EMAIL PROTECTED]]
Sent:   Saturday, June 23, 2001 3:17 PM
To: [EMAIL PROTECTED]
Subject:Re: Disk pool size vs large file

Inspect your server activity log;  there's probably better info,
there --
like a tape mount request that didn't get satisfied within the
"mount wait"
time on the device class of the storage pool your
management-class/copy-group points to.  I've seen this happen where
the
max-scratch was set too low, or the TDP node name was trying to use
multiple
mount-points (when the node was registered for less than the
request)...
WAD.

Also, most backup agents (via the API) have gotten smart enough to
send the
estimated "glob" size, which can easily be used to send the data to
the
nextstg pool (usually, tape).  We set max-size on most disk pools,
and we
use scratch tapes in the tape library (maxscr=, rather than
pre-defined
volumes which cause mount request time-outs), so any file or "glob"
greater
than max-size goes to the nextstg pool.

Don France
EDS Infrastructure Engineering
San Jose, CA
mailto:[EMAIL PROTECTED] 
PACE - http://www.pacepros.com 
Bus-Ph:   (408) 257-3037




-Original Message-
From: Stefan Holzwarth [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 22, 2001 2:41 AM
To: [EMAIL PROTECTED]
Subject: AW: Disk pool size vs large file


We use TSM 3.7.3.8 @MVS with several 3590-tapes shared with OS390.

Our biggest files are 30GB (Exchange) and normally went direct to
tape 
by setting a sizelimit to the diskstorage pool.

What happened last week was an incredible short backuptime of the
exchange
node 
without any error. Looking through the dsmsched.log I found :  

06/21/2001 02:33:46 ANS1312E Server media mount not possible

(due to no tape free at this moment?)

The TSM Client skipped the file and finished with the following
summary:

06/21/2001 02:33:46 --- SCHEDULEREC STATUS BEGIN
06/21/2001 02:33:46 Total number of objects inspected:8,565
06/21/2001 02:33:46 Total number of objects backed up:  246
06/21/2001 02:33:46 Total number of objects updated:  0
06/21/2001 02:33:46 Total number of objects rebound:  0
06/21/2001 02:33:46 Total number of objects deleted:  0
06/21/2001 02:33:46 Total number of objects expired: 26
06/21/2001 02:33:46 Total number of objects failed:   0
06/21/2001 02:33:46 Total number of bytes transferred:   138.73 MB
06/21/2001 02:33:46 Data transfer time:   74.62 sec
06/21/2001 02:33:46 Network data transfer rate:1,903.68
KB/sec
06/21/2001 02:33:46 Aggregate data transfer rate:  1,067.74
KB/sec
06/21/2001 02:33:46 Objects compressed by:0%
06/21/2001 02:33:46 Elapsed processing time:   00:02:13
06/21/2001 02:33:46 --- SCHEDULEREC STATUS END

The eventlog shows no exception for this schedule.

IBM's comment: "Works as designed"

Now I consider to do the backup of large files to the primary
storagepool on
disk, because its very difficult to detect this error. (error.log
shows no
errors)

With Regards, Stefan Holzwarth

> -Ursprüngliche Nachricht-
> Von: Sam Schrage [mailto:[EMAIL PROTECTED]]
> Gesendet am: Donnerstag, 21. Juni 2001 20:15
> An: [EMAIL PROTECTED]
> Betreff: Disk pool size vs large file
> 
> I have a 56GB disk pool with the next pool to tape.  I have a 
> user, DB2
> Admin, that wants to back up a 125GB DB2 backup.  What's the 
> best way to
> handle this one user?  If he/she backs up the file will it 
> crash the system
> because it's bigger that the diskpool, or will it go right to
tape?
> 
> Sam Schrage
> TRW Systems
> [EMAIL PROTECTED]
> 


**
This email and any files transmitted with it are confidential
and intended solely for the individual or entity to 
whom they are addressed.  If you have received this email 
in error destroy it immediately.
***

Re: Recovery log Pct. Utilized

[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 could take a while
(especially if the log and DB volumes are on the same spindle).

When this happens to someone on my team, I always caution patience - "the
watched log never clears."

Nick Cassimatis
[EMAIL PROTECTED]




"Gill, Geoffrey
L."To: [EMAIL PROTECTED]
 Subject: Recovery log Pct. Utilized
Sent by: "ADSM:
Dist Stor
Manager"
<[EMAIL PROTECTED]
T.EDU>


06/24/01 09:12
AM
Please respond
to "ADSM: Dist
Stor Manager"





Can anyone here or from Tivoli explain why the recovery log percent
utilized
doesn't reset to 0 as soon as the full database backup is complete? This is
very annoying, especially since I was called at 3 AM. I'm sitting here with
sessions disabled to minimize activity, waiting for this damn thing to
reset. I hate to enable sessions now had have to go through this whole
thing
again

   Available Space (MB): 4,196
 Assigned Capacity (MB): 4,196
 Maximum Extension (MB): 0
 Maximum Reduction (MB): 88
  Page Size (bytes): 4,096
 Total Usable Pages: 1,073,664
 Used Pages: 1,050,659
   Pct Util: 97.9
  Max. Pct Util: 97.9
   Physical Volumes: 4
 Log Pool Pages: 2,048
 Log Pool Pct. Util: 0.05
 Log Pool Pct. Wait: 0.00
Cumulative Consumption (MB): 0.06
Consumption Reset Date/Time: 06/24/01 05:48:00

Geoff Gill
TSM Administrator
NT Systems Support Engineer
SAIC
E-Mail:   [EMAIL PROTECTED]
Phone:  (858) 826-4062
Pager:   (888) 997-9614

Re: TDPS in a cluster

[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 /clustername:
/autostart:no
a.  Install the first service on Node 1 using the parameters
  
b.  Fail all Node 2 resources over to Node 1
c.  Install the second service on Node 1 using parameters
  
d.  Fail Node 2 resources back to Node 2
e.  Install the first service on Node 2 using the parameters
  
f.  Fail all Node 1 resources over to Node 2
g.  Install the second service on Node 2 using parameters
  
2.  The result is that each node is running both of these two services,
both set to manual.
a.   TSM Agent
b.   TSM Agent
3.  Now, when the nodes fail over, the service restarts and any
scheduled event that is still within the window will restart.

I've been unable to find this documented anywhere in the TSM literature, or,
if it's there, it's not clear that both services are required on both nodes.

Glen

-Original Message-
From: Del Hoobler [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 20, 2001 1:45 PM
To: [EMAIL PROTECTED]
Subject: Re: TDPS in a cluster


Glen,

A few suggestions... The steps to run in a cluster are
quite "touchy".  If you miss a step or a step does not
complete, or is done out of order, things may not work.
A few things to check:
1.) Make sure you are using CLUSTERNODE YES in the options file
2.) Make sure you are running the same level of TSM API and
TSM scheduler on both sides of the cluster.
(Hopefully, you are running at least 4.1.2)
3.) Make sure the scheduler services are set up
**exactly** identical on both nodes.
4.) Check the Event Log for any message that might help.
Check the dsmerror.log and dsierror.log.

Keep in mind, if the scheduler is failing to start,
TDP for SQL has not even been invoked yet...
...so the problem has to do with the scheduler
service not being able to "start".

If you still cannot get it solved, call IBM support and
**insist** on speaking with TSM level 2.

Thanks,

Del



Del Hoobler
IBM Corporation
[EMAIL PROTECTED]

"It's a beautiful day.  Don't let it get away."  -- Bono




Glen Churchfield
<[EMAIL PROTECTED]   To: [EMAIL PROTECTED]
ATE.OH.US> cc:
Sent by: "ADSM:Subject: TDPS in a cluster
Dist Stor
Manager"
<[EMAIL PROTECTED]
T.EDU>


06/20/2001 01:11
PM
Please respond
to "ADSM: Dist
Stor Manager"





I have a pair of Win2K servers clustered with MSCS and running MSSQL 7.0.
Backups run fine with TDP 2.2, but if either node fails over to the other
node, the "failed-from" TSM schedule service fails to start on the new box.
When it fails back, the services start and run fine. The setup was
according
to the TDP V2.2 Installation and User's Guide which includes duplicate
options files and config files in the startup directory and replicated
registry keys for the passwords. Has anyone solved this problem? Tivoli
level 1 support was clueless after 2.5 hours on the phone. I'm hopeful that
I've missed something that someone on the list has seen.


Glen Churchfield
Frontway TSM Consultant
Columbus, Ohio
[EMAIL PROTECTED]
740-503-3384

Re: Recovery log Pct. Utilized

[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 CONFIDENTIAL


-Original Message-
From:   Gill, Geoffrey L. [SMTP:[EMAIL PROTECTED]]
Sent:   Sunday, June 24, 2001 8:13 AM
To: [EMAIL PROTECTED]
Subject:Recovery log Pct. Utilized

Can anyone here or from Tivoli explain why the recovery log percent
utilized
doesn't reset to 0 as soon as the full database backup is complete?
This is
very annoying, especially since I was called at 3 AM. I'm sitting
here with
sessions disabled to minimize activity, waiting for this damn thing
to
reset. I hate to enable sessions now had have to go through this
whole thing
again

   Available Space (MB): 4,196
 Assigned Capacity (MB): 4,196
 Maximum Extension (MB): 0
 Maximum Reduction (MB): 88
  Page Size (bytes): 4,096
 Total Usable Pages: 1,073,664
 Used Pages: 1,050,659
   Pct Util: 97.9
  Max. Pct Util: 97.9
   Physical Volumes: 4
 Log Pool Pages: 2,048
 Log Pool Pct. Util: 0.05
 Log Pool Pct. Wait: 0.00
Cumulative Consumption (MB): 0.06
Consumption Reset Date/Time: 06/24/01 05:48:00

Geoff Gill
TSM Administrator
NT Systems Support Engineer
SAIC
E-Mail:   [EMAIL PROTECTED]
Phone:  (858) 826-4062
Pager:   (888) 997-9614


**
This email and any files transmitted with it are confidential
and intended solely for the individual or entity to
whom they are addressed.  If you have received this email
in error destroy it immediately.
**

Re: AW: Disk pool size vs large file

[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: AW: Disk pool size vs large file


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:   [EMAIL PROTECTED]
cc:(bcc: John Naylor/HAV/SSEG)
Subject:  AW: Disk pool size vs large file





**
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric and Southern Electric are trading names of
Scottish and Southern Energy Group.

**
 << File: ATT5936465.txt >>


**
This email and any files transmitted with it are confidential
and intended solely for the individual or entity to
whom they are addressed.  If you have received this email
in error destroy it immediately.
**

Re: BackUp Oracle with min data

[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:Lei L Wang <[EMAIL PROTECTED]>
Subject: BackUp Oracle with min data

Hi all,
The size of my customer's Oracle data file is 1TG,but there is only 1G
real data in the DB. How can I use TDP for Oracle to bacuk/restore the min
data through Oracle RMAN?


Thank you very much !

Wang Lei

Re: Backup Sybase on NT

[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 PROTECTED] 06/25/01 07:42AM >>>
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



"MMS " made the following
 annotations on 06/25/01 11:16:31
--
This message is for the named person's use only.  It may contain confidential, 
proprietary, or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it, and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient.  Health First reserves the right to monitor all e-mail communications 
through its networks.  Any views or opinions expressed in this message are solely 
those of the individual sender, except (1) where the message states such views or 
opinions are on behalf of a particular entity;  and (2) the sender is authorized by 
the entity to give such views or opinions.

==

ADSM/DATE/SQL

[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 NODES.  Particularly, I
need to be able to add & subtact dates at a whim.  THe command line adsm
client allows queries against ACTLOG like so:

q actlog begindate=TODAY-1 begintime=17:00:00 enddate=TODAY
endtime=05:59:59

effectively delivering me a specific date range from the activity log.

Utilizing the same general syntax (which does not work), I think you can
ascertain what I'm trying to get from the following:

Example:  (from the shell)

dsmadmc -id=id -pa=pa -outfile=out.file -commadelimited "select
NODE_NAME,PWSET_TIME from NODES where PWSET_TIME>TODAY-100"

I want a listing of all PWSET times older than around 100 days.  Thataways I
can harass those folks to change their passwords (Hospital policy prevents
from using PW aging techniques...one person can't get logged in fast enough,
someone has less of a chance of surviving trauma).

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?

Thanks!

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]

Backup of clients not finishing within 5 hour window

[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
installed the latest patch IP22151_19.exe and when the backup sessions start
the Client opens up 3 session to the server (great), but one by one they
will time out (see logs from the server and client below). These servers do
not have any connectivity problems with other servers except my TSM.

I am waiting for the new TSM Server (v4.2 - i believe) that will hopefully
solve this problem. TSM Server 4.1.3 is available, however a
uninstall/install is required to complete this install (from what I have
read).

Anyone else have this problem?. I have also search through the web site
(tivoli.com) for solutions, and no luck.

Any suggestions would be greatly appreciated.

Joe






This is a sample from my DSMERROR.log:

06/22/2001 02:27:05 ANS1809E Session is lost; initializing session reopen
procedure.
06/22/2001 02:27:19 ANS1811S TSM session could not be reestablished.
06/22/2001 02:28:30 TcpFlush: Error 10038 sending data on Tcp/Ip socket
4294967295.
06/22/2001 02:28:30 sessSendVerb: Error sending Verb, rc: -50
06/22/2001 02:28:30 ANS1809E Session is lost; initializing session reopen
procedure.
06/22/2001 02:28:30 ANS1809E Session is lost; initializing session reopen
procedure.
06/22/2001 02:28:45 ANS1810E TSM session has been reestablished.
06/22/2001 02:28:50 ANS1369W Session Rejected: The session was canceled by
the server administrator.
06/22/2001 02:28:50 ANS1369W Session Rejected: The session was canceled by
the server administrator.


Sample from dsmsched.QBSSNF09.log (one of the servers that is having the
problem):

06/22/2001 02:01:50 Retry # 3  Normal File-->   149,094,400
\\qbssnf09\d$\Production\HomeDirs\CLICAdmin\KinsmanS\userdir\notes\a_skins.n
sf  ** Unsuccessful **
06/22/2001 02:01:50 ANS1809E Session is lost; initializing session reopen
procedure.
06/22/2001 02:02:04 ... successful
06/22/2001 02:26:49 Retry # 4  Normal File-->   149,094,400
\\qbssnf09\d$\Production\HomeDirs\CLICAdmin\KinsmanS\userdir\notes\a_skins.n
sf  ** Unsuccessful **
06/22/2001 02:26:49 ANS1809E Session is lost; initializing session reopen
procedure.
06/22/2001 02:27:04 ... successful
06/22/2001 02:27:04 ANS1228E Sending of object
'\\qbssnf09\d$\Production\HomeDirs\CLICAdmin\KinsmanS\userdir\notes\a_skins.
nsf' failed
06/22/2001 02:27:04 Unknown system error
Please check the TSM Error Log for any additional information

06/22/2001 02:27:05 ANS1809E Session is lost; initializing session reopen
procedure.
06/22/2001 02:27:05 Directory-->   0
\\qbssnf09\d$\Production\HomeDirs\CLICAdmin\MaurinB\Salaries [Sent]
06/22/2001 02:27:05 Normal File-->13,991
\\qbssnf09\d$\Production\HomeDirs\CLICAdmin\MaurinB\Salaries\newhire Christi
Pretorius.rtf [Sent]
06/22/2001 02:27:05 Normal File--> 2,870
\\qbssnf09\d$\Production\HomeDirs\CLICAdmin\MaurinB\userdir\notes\bmaurin.id
[Sent]
06/22/2001 02:27:05 Directory-->   0
\\qbssnf09\d$\Production\HomeDirs\CLICAdmin\WestD\Don [Sent]
06/22/2001 02:27:05 Directory-->   0
\\qbssnf09\d$\Production\HomeDirs\CLICAdmin\WestD\Mike [Sent]
06/22/2001 02:27:05 Normal File-->28,672
\\qbssnf09\d$\Production\HomeDirs\CLICAdmin\WestD\Don\Individual Life Team
pre-reading SMT.ppt [Sent]
06/22/2001 02:27:05 Normal File-->45,056
\\qbssnf09\d$\Production\HomeDirs\CLICAdmin\WestD\Don\RST Planning Pres June
2001.doc [Sent]
06/22/2001 02:27:05 Normal File-->23,040
\\qbssnf09\d$\Production\HomeDirs\CLICAdmin\WestD\Don\Survey Summary.doc
[Sent]
06/22/2001 02:27:05 Normal File-->64,000
\\qbssnf09\d$\Production\HomeDirs\CLICAdmin\WestD\Don\updated original.ppt
[Sent]
06/22/2001 02:27:05 Normal File-->64,000
\\qbssnf09\d$\Production\HomeDirs\CLICAdmin\WestD\Don\updated original2.ppt
[Sent]
06/22/2001 02:27:16 Normal File-->22,528
\\qbssnf09\d$\Production\HomeDirs\CLICAdmin\WestD\Mike\CUNA Mutual -
Canadian ODL.doc [Sent]
06/22/2001 02:27:20 ... failed
06/22/2001 02:28:30 ANS1809E Session is lost; initializing session reopen
procedure.
06/22/2001 02:28:46 ... successful
06/22/2001 02:28:50 --- SCHEDULEREC STATUS BEGIN
06/22/2001 02:28:50 Total number of objects inspected:   61,862
06/22/2001 02:28:50 Total number of objects backed up:  117
06/22/2001 02:28:50 Total number of objects updated:  0
06/22/2001 02:28:50 Total number of objects rebound:  0
06/22/2001 02:28:50 Total number of objects deleted:  0
06/22/2001 02:28:50 Total number of objects expired:  1
06/22/2001 02:28:50 Total number of objects failed:  31
06/22/2001 02:28:50 Total number of bytes transferred:   354.45 MB
06/22/2001 02:28:50 Data transfer time:5,869.13 

Re: Recovery log Pct. Utilized

[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 get in, backups were
either missed or failed. Unfortunately I don't know the exact message that
was scrolling the screen but it was related to the log being full, and
obviously since the log was full it didn't write to it. The last log entry
was about 10:45 PM then it picks up again after I extended the log and
restarted at 5 AM.

I could see during that evening the server was getting lots of log entries
for this "Session open with XXX.XXX.XXX.XXX failed due to connection
refusal". There are quite a few other servers which had the same thing going
on so there are hundreds of these. Unfortunately I don't have acces to these
nodes to stop and start the Scheduler service to make the backup kick in.

I obviously never expected this to happen to me. With as few backups I have
on Saturday night, doing one db backup and one incremental daily I thought
was enough to keep a 4GB log from filling up. I can see that I was mistaken
and have now taken the necessary steps to, hopefully, not see this again.

The burning question still is this: If I have scratch tapes available, a
schedule with 1 full and 1 incremental db backup daily about 12 hours apart,
and the log fills, will the full or incremental db backup be able to run and
clear the log or do I still have to shutdown and make space?

Geoff Gill
TSM Administrator
NT Systems Support Engineer
SAIC
E-Mail:   [EMAIL PROTECTED]
Phone:  (858) 826-4062
Pager:   (888) 997-9614

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

[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.) by default.

Parameter COMMTIMEOUT is reset by the following ADSM command:

adsm> setopt COMMTIMEOUT 



Pothula S
Paparao  To: [EMAIL PROTECTED]
<9pothula@SG.cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK)
IBM.COM> Subject: SQL2025N An I/O error "-50" 
occurred on media "ADSM".
Sent by:
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
RIST.EDU>


23.06.2001
10:43
Please
respond to
"ADSM: Dist
Stor Manager"






hi all,
we are often coming across this error while taking online backup from
db2-server. this job is run from crontab at 00:00 hours. i m unable to
trace out the problem , what causing database backup to fail. do any one
knows about it. please reply immdly.


Performing database backup type ONLINE

issuing db2 backup database tcimain ONLINE USE ADSM WITHOUT PROMPTING

06-15-2001 02:02:05 BACKUP DATABASE tcimain ONLINE USE ADSM WITHOUT
PROMPTING
06-15-2001 02:13:39 SQL2025N  An I/O error "-50" occurred on media "ADSM".
 06/15/01 02:13:39 Backup tcimain ONLINE USE ADSM WITHOUT PROMPTING sqlcode
= -2025

 #+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#
 ADSM Backup End Time: 02:13:39 AM with rc= -2025

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

[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]



-Original Message-
From: MUSTAFA BAYTAR [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 25, 2001 11:16 AM
To: [EMAIL PROTECTED]
Subject: Re: SQL2025N An I/O error "-50" occurred on media "ADSM".


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.) by default.

Parameter COMMTIMEOUT is reset by the following ADSM command:

adsm> setopt COMMTIMEOUT 



Pothula S
Paparao  To: [EMAIL PROTECTED]
<9pothula@SG.cc: (bcc: MUSTAFA
BAYTAR/ATIM/ICECEK)
IBM.COM> Subject: SQL2025N An I/O error
"-50" occurred on media "ADSM".
Sent by:
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
RIST.EDU>


23.06.2001
10:43
Please
respond to
"ADSM: Dist
Stor Manager"






hi all,
we are often coming across this error while taking online backup from
db2-server. this job is run from crontab at 00:00 hours. i m unable to
trace out the problem , what causing database backup to fail. do any one
knows about it. please reply immdly.


Performing database backup type ONLINE

issuing db2 backup database tcimain ONLINE USE ADSM WITHOUT PROMPTING

06-15-2001 02:02:05 BACKUP DATABASE tcimain ONLINE USE ADSM WITHOUT
PROMPTING
06-15-2001 02:13:39 SQL2025N  An I/O error "-50" occurred on media "ADSM".
 06/15/01 02:13:39 Backup tcimain ONLINE USE ADSM WITHOUT PROMPTING sqlcode
= -2025

 #+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#
 ADSM Backup End Time: 02:13:39 AM with rc= -2025

--
This e-mail may be privileged and/or confidential, and the sender does not waive any 
related rights and obligations. Any distribution, use or copying of this e-mail or the 
information it contains by other than an intended recipient is unauthorized. If you 
received this e-mail in error, please advise me (by return e-mail or otherwise) 
immediately. 

Ce courriel est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et 
obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou 
des renseignements qu'il contient par une personne autre que le (les) destinataire(s) 
désigné(s) est interdite. Si vous recevez ce courriel par erreur, veuillez m'en aviser 
immédiatement, par retour de courriel ou par un autre moyen. 


==

Re: ADSM/DATE/SQL

[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)-days(lastacc_time) as "Last access (>10)" \
from nodes \
where (days(lastacc_time) < (days(current_date)-10))

Hope this helps,

Alexander
--
---
Alexander Verkooijen([EMAIL PROTECTED])
Senior Systems Programmer
SARA High Performance Computing

Re: ADSM/DATE/SQL

[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


Xavier Chavanet, Kodak, EAMER Technical Services
IS-SIRM, Kodak Industrie, Bt17, Rue Paul Sabatier, ZI Nord 71102 Chalon sur
Saône CEDEX, France
Tel: (+33) (0) 3 85 99 70 13,  Fax:  (+33) (0) 3 85 99 19 13,  E-Mail
[EMAIL PROTECTED]
---







"Sheets, Jerald" <[EMAIL PROTECTED]> on 25/06/2001 17:05:01

Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>

To:   [EMAIL PROTECTED]
cc:(bcc: Xavier 1 Chavanet/979460/Chalon/France/Europe/EKC)
Subject:  ADSM/DATE/SQL





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 NODES.  Particularly, I
need to be able to add & subtact dates at a whim.  THe command line adsm
client allows queries against ACTLOG like so:

q actlog begindate=TODAY-1 begintime=17:00:00 enddate=TODAY
endtime=05:59:59

effectively delivering me a specific date range from the activity log.

Utilizing the same general syntax (which does not work), I think you can
ascertain what I'm trying to get from the following:

Example:  (from the shell)

dsmadmc -id=id -pa=pa -outfile=out.file -commadelimited "select
NODE_NAME,PWSET_TIME from NODES where PWSET_TIME>TODAY-100"

I want a listing of all PWSET times older than around 100 days.  Thataways I
can harass those folks to change their passwords (Hospital policy prevents
from using PW aging techniques...one person can't get logged in fast enough,
someone has less of a chance of surviving trauma).

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?

Thanks!

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]

Re: ADSM/DATE/SQL

[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 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 NODES.  Particularly, I
need to be able to add & subtact dates at a whim.  THe command line adsm
client allows queries against ACTLOG like so:

q actlog begindate=TODAY-1 begintime=17:00:00 enddate=TODAY
endtime=05:59:59

effectively delivering me a specific date range from the activity log.

Utilizing the same general syntax (which does not work), I think you can
ascertain what I'm trying to get from the following:

Example:  (from the shell)

dsmadmc -id=id -pa=pa -outfile=out.file -commadelimited "select
NODE_NAME,PWSET_TIME from NODES where PWSET_TIME>TODAY-100"

I want a listing of all PWSET times older than around 100 days.  Thataways I
can harass those folks to change their passwords (Hospital policy prevents
from using PW aging techniques...one person can't get logged in fast enough,
someone has less of a chance of surviving trauma).

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?

Thanks!

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]

Re: ADSM/DATE/SQL

[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-
From: Gene Walters [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 25, 2001 11:45 AM
To: [EMAIL PROTECTED]
Subject: Re: ADSM/DATE/SQL


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 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 NODES.  Particularly, I
need to be able to add & subtact dates at a whim.  THe command line adsm
client allows queries against ACTLOG like so:

q actlog begindate=TODAY-1 begintime=17:00:00 enddate=TODAY
endtime=05:59:59

effectively delivering me a specific date range from the activity log.

Utilizing the same general syntax (which does not work), I think you can
ascertain what I'm trying to get from the following:

Example:  (from the shell)

dsmadmc -id=id -pa=pa -outfile=out.file -commadelimited "select
NODE_NAME,PWSET_TIME from NODES where PWSET_TIME>TODAY-100"

I want a listing of all PWSET times older than around 100 days.  Thataways I
can harass those folks to change their passwords (Hospital policy prevents
from using PW aging techniques...one person can't get logged in fast enough,
someone has less of a chance of surviving trauma).

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?

Thanks!

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]

library definitions with a HSC/LS-driven powderhorn

[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)6171 66 7500 3692 / pse : 75 / mobil
: +49(0)172 6649 016 / mailto:[EMAIL PROTECTED]
Alte Leipziger Lebensversicherung aG - Alte Leipziger Platz 1 - D 61440
Oberursel - http://www.alte-leipziger.de

Everything is possible. Some things are neccessary. Some not.

TSM and TDP for Domino command file.

[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 backup of the client from the command
line. The only time I have trouble is using the TSM scheduler.

 I have 2 dsm.opt files on the node one in the TSM baclient directory and
the other in the TSM domino directory. I have also verified the domdsm.cfg
file and I believe that these are all set up correctly. I am using unique
node names for the TSM client and Domino clients.

 I understand that this in not allot of information but if anyone has any
ideas for me I am all ears.

 Thanks for your help on this.

 Brian.

Pre schedule command to stop NT service ??

[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 it
would
be greatly appreciated.

Regards
Gilbert

Re: Pre schedule command to stop NT service ??

[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 SQL v4.0 for NT (Server Edition)"


Run another batch file an hour after the backup should end (to allow for the
glitches)

net start "Btrieve v7.0 for Windows NT (Server Edition)"
net start "Scalable SQL v4.0 for NT (Server Edition)"

works fine for us use it on 3 different servers.

Jim Murray
Senior Systems Engineer
Liberty Bank
[EMAIL PROTECTED]
(860)638-2919
No trees were killed sending this message,
however several electrons were greatly
inconvenienced.


-Original Message-
From: Serein, Gilbert Claudio [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 25, 2001 16:03
To: [EMAIL PROTECTED]
Subject: Pre schedule command to stop NT service ??


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 it
would
be greatly appreciated.

Regards
Gilbert



The information transmitted is intended only for the person
or entity to which it is addressed and may contain confidential
and/or privileged material. If you are not the intended
recipient of this message you are hereby notified that any use,
review, retransmission, dissemination, distribution, reproduction
or any action taken in reliance upon this message is prohibited.
If you received this in error, please contact the sender and
delete the material from any computer.  Any views expressed
in this message are those of the individual sender and may
not necessarily reflect the views of the company.

Re: Pre schedule command to stop NT service ??

[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 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 it
would
be greatly appreciated.

Regards
Gilbert



"MMS " made the following
 annotations on 06/25/01 16:11:27
--
This message is for the named person's use only.  It may contain confidential, 
proprietary, or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it, and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient.  Health First reserves the right to monitor all e-mail communications 
through its networks.  Any views or opinions expressed in this message are solely 
those of the individual sender, except (1) where the message states such views or 
opinions are on behalf of a particular entity;  and (2) the sender is authorized by 
the entity to give such views or opinions.

==

Re: Pre schedule command to stop NT service ??

[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 file doesn't have to
reside in the TSM directory)

You can also add a POSTSCHEDULECMD to restart the service after the backup
completes.

Note: The Scheduler service must be stopped and restarted before the command
will become active,
and the Scheduler must be running under an account that has NT rights to stop
the service.

On Monday, June 25, 2001 1:03 PM, Serein, Gilbert Claudio
[SMTP:[EMAIL PROTECTED]] wrote:
> 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 it
> would
> be greatly appreciated.
>
> Regards
> Gilbert

Web client access on a Cluster server

[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 restores is from the GUI on the cluster server. It
would be nice to be able to do a restore from a users PC and not have to go
back to the computer room. All of the other web clients work just fine.
I used the following node names, darthvader, darthmaul,
v_darthvader, and v_darthmaul. The darthvader and darthmaul nodes cover the
local drives that contain the OS. The other two cover the shared resources.
I can go to http://darthmaul:1581   and
http://darthvader:1581   and get to the local drives
for restores and backups. If I try to go to http://v_darthvader:1581
  or http://v_darthmaul:1581
  I get a "This page cannot be displayed" error.
The dsm.opt files look right to me, at least the normal scheduled
backups are running fine.
I've got a call into support (PMR80135,BRE) but nothing so far.
Any ideas??

David Tyree
Microcomputer Specialist
South Georgia Medical Center
229.333.1155

Confidential Notice:  This e-mail message, including any attachments, is for
the sole use of the intended recipient(s) and may contain confidential and
privileged information.  Any unauthorized review, use,  disclosure or
distribution is prohibited.  If you are not the intended recipient, please
contact the sender by reply e-mail and destroy all copies of the original
message.

Exchange mailbox restores

[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

[John Johnson]

Here is what we use, not all that much to them.


DOMainC: D:

EXCLUDE?:*
INCLUDEd:\users\*
INCLUDEd:\users\...\*
INCLUDEd:\public\*
INCLUDEd:\public\...\*
INCLUDEc:\cmlib\dbserver.*
INCLUDEc:\ibmlan\dcdb\profile\*.xrf
INCLUDEc:\ibmcom\protocol.ini

I also use Exclude.dir statements extensively to exclude the remaining
directories on C: and D:.


John Johnson




"Mueller,
Philip J."   To: [EMAIL PROTECTED]
  Subject: OS/2 Standard Include/Exclude 
Lists
Sent by:
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
IST.EDU>


06/24/2001
10:42 AM
Please respond
to "ADSM: Dist
Stor Manager"





Would anyone using the OS/2 backup client let me know what standard
include/exclude statements you are using?  I have those for NT.  I would
also be interested in any for Windows 2000.

Thanks

Philip J. Mueller
Information Systems Assistant
Ralston Purina Company - Denver CO
[EMAIL PROTECTED] 

Re: Exchange mailbox restores

[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.

-Original Message-
From: Jim Kirkman [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 25, 2001 4:31 PM
To: [EMAIL PROTECTED]
Subject: Exchange mailbox restores


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: Recovery log Pct. Utilized

[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

[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 figure for  the size of disk
required.

TIA,
Raymond
Unix Admin
IPAustralia, Canberra

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

[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 added the
OBJECT_ID to the CONTENTS table in 4.1?  I'm not quite there yet.

Alex

-Original Message-
From: Robin Sharpe [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 20, 2001 8:01 AM
To: [EMAIL PROTECTED]
Subject: Re: What volume is my backup on, at time of restore?


What I don't understand is why it takes so darn long for the query to run,
when TSM can find the tape it needs very quickly when you run the actual
restore command.  What is really needed  is "preview" option like on the
restore volume command.  Just my opinion.
Robin Sharpe
Berlex Laboratories




Mark Brown
 To:[EMAIL PROTECTED]
  cc:(bcc: Robin Sharpe/WA/USR/SHG)
06/15/01  Subject:
08:30 PM Re: What volume is my backup on, at
time of restore?
Please
respond to
"ADSM: Dist
Stor Manager"







Hello,

When I first read this I thought it would simply be easier for TSM to
take
care of the restore. However, IF, you have a screaming fast server where
TSM
runs the massive searches, the script could be pretty handy used in the
right places.

If anyone has one out there I would like to see it also.

Mark Brown

Jim Taylor wrote:
>
> Anyone have a nifty way to find out exactly which volume, specific backed
up
> files are located on.
>
> I would like to build a restore script that will restore files in
multiple
> streams without one session waiting for a tape that is in use by one of
my
> other restore sessions.
>
> ThanX
>
> > Jim Taylor
> > Senior Associate, Technical Services
> > Enlogix
> > *  E-mail: [EMAIL PROTECTED]
> > *  Office: (416) 496-5264 ext. 286
> > * Cell:  (416)458-6802
> > *   Fax: (416) 496-5245
> >
> >

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

[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:  "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>


To:   [EMAIL PROTECTED]
cc:
Subject:  Re: What volume is my backup on, at time of restore?


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 added the
OBJECT_ID to the CONTENTS table in 4.1?  I'm not quite there yet.

Alex

-Original Message-
From: Robin Sharpe [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 20, 2001 8:01 AM
To: [EMAIL PROTECTED]
Subject: Re: What volume is my backup on, at time of restore?


What I don't understand is why it takes so darn long for the query to run,
when TSM can find the tape it needs very quickly when you run the actual
restore command.  What is really needed  is "preview" option like on the
restore volume command.  Just my opinion.
Robin Sharpe
Berlex Laboratories




Mark Brown
 To:[EMAIL PROTECTED]
  cc:(bcc: Robin Sharpe/WA/USR/SHG)
06/15/01  Subject:
08:30 PM Re: What volume is my backup on,
at
time of restore?
Please
respond to
"ADSM: Dist
Stor Manager"







Hello,

When I first read this I thought it would simply be easier for TSM to
take
care of the restore. However, IF, you have a screaming fast server where
TSM
runs the massive searches, the script could be pretty handy used in the
right places.

If anyone has one out there I would like to see it also.

Mark Brown

Jim Taylor wrote:
>
> Anyone have a nifty way to find out exactly which volume, specific backed
up
> files are located on.
>
> I would like to build a restore script that will restore files in
multiple
> streams without one session waiting for a tape that is in use by one of
my
> other restore sessions.
>
> ThanX
>
> > Jim Taylor
> > Senior Associate, Technical Services
> > Enlogix
> > *  E-mail: [EMAIL PROTECTED]
> > *  Office: (416) 496-5264 ext. 286
> > * Cell:  (416)458-6802
> > *   Fax: (416) 496-5245
> >
> >

Re: Exchange mailbox restores

[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, using the
GUI.
4. Run the constancy checker (can take a while)
5. open the individual mail box that you need and make a PST file.
6. Copy the file to a location that the user can access.
7. Configure the exchange client to open the new PST file.

I think that all, hope it helps

ant

 -Original Message-
From:   Jim Kirkman [mailto:[EMAIL PROTECTED]]
Sent:   Tuesday, 26 June 2001 6:31
To: [EMAIL PROTECTED]
Subject:Exchange mailbox restores

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

Notice:
The information contained in this e-mail message and any attached files may
be confidential information, and may also be the subject of legal
professional privilege.  If you are not the intended recipient any use,
disclosure or copying of this e-mail is unauthorised.  If you have received
this e-mail in error, please notify the sender immediately by reply e-mail
and delete all copies of this transmission together with any attachments.

full drives & offsite pool

[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 migrate the data from disk to DLT
tape using
   update stgpool backuppool
where "stgpool" is the onsite DLT pool, and
"backuppool" is the disk

Then, we copy the data from the onsite DLT pool to the
offsite DLT pool using
   backup stg dltops dltoffsite
where "dltops" is one of our onsite DLT pools, and
"dltoffsite" is the offsite DLT pool.

So the data trail is:
Disk->OnsiteDLT then OnsiteDLT->OffsiteDLT (which
requires 3 drive mounts in a 24 hour period)

Because we've got a handfull of storage pools to copy
to "dltoffsite", and a few other processes which go
directly to tape, we've been running into drive
availability issues.

My question is this, is there some way to make, both,
onsite and offsite copies straight from disk to tape?


The new data trail would be:
Disk->OnsiteDLT then Disk->OffsiteDLT (which requires
2 drive mounts in a 24 hour period)

Beside using up fewer drives, it seems that the
migration from disk to tape is considerably faster
than the copy from tape to tape, e.g. one of our
migrations is set to run 4 hours.  The tape to tape
copy can sometimes take >12.

The one reason I can see that this would not work is
in the case of restoring volumes.  Does ADSM build the
relational database between onsite and offsite during
our copy, making the copy process necessary? or can it
build the database purely by matching the data between
onsite and offsite volumes?

Thanks,
ch

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year!  http://personal.mail.yahoo.com/

Re: full drives & offsite pool

[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 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
 
 
 

NT SAN PROBLEM

[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
in the event log for TSM or NT.

TSM Config
TSM Server 4.1.3
TSM Client 4.1.2.12

The font end is a Compaq ML530 running W2k Server attached to a Compaq/Dec
Storage works box.  I do have a different SAN that I backup fine using the
Exchange Client and the TSM 3.1.08 client on a NT4 front end.

Thanks for your time

Anthony.

Notice:
The information contained in this e-mail message and any attached files may
be confidential information, and may also be the subject of legal
professional privilege.  If you are not the intended recipient any use,
disclosure or copying of this e-mail is unauthorised.  If you have received
this e-mail in error, please notify the sender immediately by reply e-mail
and delete all copies of this transmission together with any attachments.

Re: Diskpool size for DirMc

[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 the addressee and 
may contain information that is privileged and confidential.



> -Original Message-
> From: Raymond Chao [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, June 26, 2001 2:27 AM
> To:   [EMAIL PROTECTED]
> Subject:  Diskpool size for DirMc
> 
> 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 figure for  the size of disk
> required.
> 
> TIA,
> Raymond
> Unix Admin
> IPAustralia, Canberra

Open AFS?

[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 wrong tree.
(http://oss.software.ibm.com/developerworks/opensource/afs/downloads.html)

Anybody been through this?

Suad
--