Recovery log utilisation and aggregate size

[Eric Winters]

Good People,

I'm interested in establishing to what extent TXNGROUPMAX and TXNBYTELIMIT
(ie aggregate control) options will affect recovery log usage. My objective
at this stage is to reduce the utilisation of the recovery log in a normal
mode environment. The log has been filling when pinned by the backup of
large files. If I back up a larger number of small aggregates from other
nodes at the same time, will they require less recovery log space than if
the same data was sent as fewer larger aggregates? Testing is a little
difficult in this environment so I'd like to hear your experiences.

Your comments gentlemen please.
Thanks.


Eric Winters
Chilly Sydney

Re: PL help why this is happening .

[John Monahan]

Need a little more info, like what version of TSM client and server
version/platform.

John Monahan
Senior Consultant Enterprise Solutions
Computech Resources, Inc.
Office: 952-833-0930 ext 26
Cell: 952-484-5435
http://www.compures.com




"PINNI,
BALANAND To: [EMAIL PROTECTED]
(SBCSI)" cc:
<[EMAIL PROTECTED]Subject: PL help why this is happening .
OM>
Sent by:
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
RIST.EDU>


06/27/2001
12:45 PM
Please
respond to
"ADSM: Dist
Stor Manager"






Hi TSM  / NT Clients gurus PL help
Some times this the error we see in activity log for NT CLIENTS.
Can anyone PL tell me what to do!!!
It only happens sometimes once in a blue moon.



protocol violation detected.
06/27/01   03:55:11  ANR0403I Session 68 ended for node NTL30E06 (WinNT).
06/27/01   03:55:12  ANR8336I Verifying label of ECARTRIDGE volume AA1055
in
  drive ACS_DRV (/dev/mt0).
06/27/01   03:55:13  ANR0406I Session 74 started for node NTL30E06 (WinNT)
  (Tcp/Ip 132.201.1.142(4100)).
06/27/01   03:55:13  ANR0484W Session 74 for node NTL30E06 (WinNT)
terminated -
  protocol violation
detected.>
06/27/01   03:55:14  ANR0406I Session 75 started for node NTL30E06 (WinNT)
  (Tcp/Ip 132.201.1.142(4101)).
06/27/01   03:55:14  ANR0403I Session 75 ended for node NTL30E06 (WinNT).
06/27/01   03:55:14  ANR0406I Session 76 started for node NTL30E06 (WinNT)
  (Tcp/Ip 132.201.1.142(4102)).
06/27/01   03:55:14  ANR0403I Session 76 ended for node NTL30E06 (WinNT).
06/27/01   03:55:38  ANR8468I ECARTRIDGE volume AA1055 dismounted from
drive
  ACS_DRV (/dev/mt0) in library ACS_LIB.



PROTOCOL VIOLATION DETECTED



Thankx in advance

Luuk Kleibrink/D903513/IS/DLVG is niet op zijn/haar kantoor.

[Luuk Kleibrink]

Ik ben niet op kantoor vanaf 28-06-2001 tot 09-07-2001.

tdpsql v2.2 gui opens then immediately closes

[Joel Fuhrman]

tpdsql version 2.2 was working but now the gui window opens and then
immediately closes.

The tdpsql.log file show the request QUERY SQL but there is no connection to
the TSM 4.1.3.0 Server running on AIX 4.3.3 ML06 and there is no entry in
the dsierror.log file.  A command line tdpsqlc QUERY SQL gets the same
results.  However, a tdpsqlc QUERY TSM * /all does list the backups.

Any suggestions as to what would cause this?

Re: Database backup performance

[Paul Zarnowski]

We back up 19,591,179 pages in 4 hours.  This is an 83GB database, 91%
utilized.  Server is an RS/6000 M80.  Backup media is DLT 7000
tape.  Translates to 5.3MB/s by my calculation.  Our incremental backups
usually take 15-30 minutes.

Re: Oracle Agent NT backups

[France, Don G (Pace)]

Yes, it works pretty well, once you figure out the different levels to
support -- RMAN needs a separate repository db for each different release
level of the db's supported.

The bulk of your questions are answered in the TDP for Oracle install guide
(including a sample script for the TDP-Ora backup scheduler); you can
download the book from the Tivoli web site (the following link all on one
line):

http://www.tivoli.com/support/public/Prodman/public_manuals/storage_mgr/adma
nual.htm#optional


Regards,
Don

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




-Original Message-
From: Gill, Geoffrey L. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 11:38 AM
To: [EMAIL PROTECTED]
Subject: Oracle Agent NT backups


I'm finally getting my DBA's to work on using the Oracle agent setup on NT.
I keep getting complaints from the guy and since I can't answer the
questions because I myself have never used it, sorry to be so ignorant about
this, I was wondering if someone could answer a few questions and help
enlighten me.

1. Are the backups kicked off by the TSM server through a .cmd file on the
client?

2. If 1 above is true then does anyone have a sample script I can look at?

3. Besides the few lines in the dsm.opt sample file supplied with the
software do I need to add anything else?

4. If rman is somehow scheduled from the client itself to kick off the
backups, what are the parameters that need to be set up?

5. Has anyone tried to use the Oracle Enterprise Management console from a
designated system to schedule "ALL" these backups no matter what client they
are on?

Thanks all for the help.

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

Informix DB hot backups?

[Gerald Wichmann]

Can the TDP for Informix also backup an Informix DB on a raw file system?

Re: ANS1075E **** Program memory exhausted **** error message

[Davidson, Becky]

We had that once on a restore of an H70.  We discovered that the parameters
for the restore of an incremental backup were too large with too many files
and we now only do archives in the event we have to do a restore like that
again.
Becky

-Original Message-
From: Ken Sedlacek [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 2:56 PM
To: [EMAIL PROTECTED]
Subject: ANS1075E  Program memory exhausted  error message


I have never received this error message in the client dsmerror.log before.

Outside of the obvious message meaning, what could cause this?

I have looked at the Tivoli error message on-line HTML, and can not find it
there. I even looked in the TSM 4.1 messages. Its not there either.

This message came from the TSM backup client on the TSM server.

Environment:
H70 AIX server, running AIX 4.3.3;
TSM server/client 3.7.3.


Comments??




Ken Sedlacek
Kyrus Corporation
Office: 864-322-4260; Cell: 864-444-8375
Text Page: 864-444-7243, follow prompts
[EMAIL PROTECTED]

Kyrus IT Support  (Internal: 4399)   (Greenville: 864-322-4399)
(Toll-Free: 888-413-4399)

ANS1075E **** Program memory exhausted **** error message

[Ken Sedlacek]

I have never received this error message in the client dsmerror.log before.

Outside of the obvious message meaning, what could cause this?

I have looked at the Tivoli error message on-line HTML, and can not find it
there. I even looked in the TSM 4.1 messages. Its not there either.

This message came from the TSM backup client on the TSM server.

Environment:
H70 AIX server, running AIX 4.3.3;
TSM server/client 3.7.3.


Comments??




Ken Sedlacek
Kyrus Corporation
Office: 864-322-4260; Cell: 864-444-8375
Text Page: 864-444-7243, follow prompts
[EMAIL PROTECTED]

Kyrus IT Support  (Internal: 4399)   (Greenville: 864-322-4399)
(Toll-Free: 888-413-4399)

restore db

[Manoel Braz]

Hi *SMs,

1- I am trying to restore a DB that it has 4MB for test but TSM asks for =
64MB of free space to do the restore. Is it ok?

2- Is it possible to restore a DB when I do not know the size of it?

Thanks,

Manoel

Re: help with prepare file write error...

[Lindsay Morris]

Off the top of my head:
Can you create that file /adsm/drplans/DRPLAN.20010627.152129 maually?
Is there enough space in the filesystem? a typical DRplan is maybe 200K.
Can you define a different devclass with FILE devtype pointing to a
different directory and make THAT work?


> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
> Dixon, Swonda
> Sent: Wednesday, June 27, 2001 4:05 PM
> To: [EMAIL PROTECTED]
> Subject: help with prepare file write error...
>
>
> I'm really in a panic state b/c I've been unsuccessful in resolving this
> problem.
>
> What makes matters worse, support has no clue but they're working on it.
>
> I submitted a request earlier pertaining to this exact problem but despite
> some of the suggestions,
> I'm still unsuccessful.
>
> Now I'm asking my fellow gurus to help dig a little deeper.
>
> Error Messages:
> 06/27/01 15:21:29 ANR6953E PREPARE: File write error.
> 06/27/01 15:21:29 ANR6951E PREPARE: Recovery plan file
> /adsm/drplans/DRPLAN-
> .20010627.152129 was not created.
> 06/27/01 15:21:29 ANR0985I Process 2727 for PREPARE running in the
> BACKGROUND completed with completion state FAILURE at 15:21:29.
>
> I've cleared the smit.log and smit.script which allowed more
> space for about
> 2 weeks. Now, I'm receiving this error
> again. The only other script files of considerable sizes are P and PAGE.
>
> HELP, HELP!!!
>
> i'd greatly appreciate ANY assistance. Thanks.
>
> __
> __
> 
> Swonda M. Dixon * The Chester Telephone Company * 803.581.9172 *
> [EMAIL PROTECTED]
>

Re: ANS1075E **** Program memory exhausted **** error message

[PINNI, BALANAND (SBCSI)]

i HAD THE SAME PROBLEM
Pl do vmstat and see that what it shows under avm & free
If free is 128 or low it shows that ur memory is low.
Now use crush cmd to release the mem for time being.
Else apply AIX PATCHES its memory leak problem on AIX 433
dont forget to apply TSM client patches also.
U can also see vmtune and schedtune cmds
to see what is -k flag .Pl increase this value so that
pages are freed up fast.
Process is not killed when low on mem.
BALANAND

-Original Message-
From: Ken Sedlacek [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 2:56 PM
To: [EMAIL PROTECTED]
Subject: ANS1075E  Program memory exhausted  error message


I have never received this error message in the client dsmerror.log before.

Outside of the obvious message meaning, what could cause this?

I have looked at the Tivoli error message on-line HTML, and can not find it
there. I even looked in the TSM 4.1 messages. Its not there either.

This message came from the TSM backup client on the TSM server.

Environment:
H70 AIX server, running AIX 4.3.3;
TSM server/client 3.7.3.


Comments??




Ken Sedlacek
Kyrus Corporation
Office: 864-322-4260; Cell: 864-444-8375
Text Page: 864-444-7243, follow prompts
[EMAIL PROTECTED]

Kyrus IT Support  (Internal: 4399)   (Greenville: 864-322-4399)
(Toll-Free: 888-413-4399)

help with prepare file write error...

[Dixon, Swonda]

I'm really in a panic state b/c I've been unsuccessful in resolving this
problem.

What makes matters worse, support has no clue but they're working on it.

I submitted a request earlier pertaining to this exact problem but despite
some of the suggestions,
I'm still unsuccessful.

Now I'm asking my fellow gurus to help dig a little deeper.

Error Messages:
06/27/01 15:21:29 ANR6953E PREPARE: File write error.
06/27/01 15:21:29 ANR6951E PREPARE: Recovery plan file /adsm/drplans/DRPLAN-
.20010627.152129 was not created.
06/27/01 15:21:29 ANR0985I Process 2727 for PREPARE running in the
BACKGROUND completed with completion state FAILURE at 15:21:29.

I've cleared the smit.log and smit.script which allowed more space for about
2 weeks. Now, I'm receiving this error
again. The only other script files of considerable sizes are P and PAGE.

HELP, HELP!!!

i'd greatly appreciate ANY assistance. Thanks.



Swonda M. Dixon * The Chester Telephone Company * 803.581.9172 *
[EMAIL PROTECTED]

Re: lift blocked 3575l12 33h checkin

[George Lesho]

I have an L32... The long ribbon cable that attaches to the picker is
getting stuck. It can wrap around the picker and get damaged. IBM came up
with a retrofit kit to fix this problem. The ribbon cable will get damaged
if you don't install the retrofit kit which retains and reroutes the ribbon
cable.

George Lesho
Storage/System Admin
AFC Enterprises





"Koen A. Willems" <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 06/27/2001
01:06:31 PM

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

Sent by:  "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>


To:   [EMAIL PROTECTED]
cc:
Fax to:
Subject:  lift blocked 3575l12 33h checkin


Dear Listers,

I have a problem with a 3575 l12 TSM 4.1.3 Atape 5.0.4. AIX 4.3.0.0.

When I want to run dsmadmc " checkin libvol 3575lib stat=scr search=bulk"

q req gives me a reply number and place vol in io

then the magstar moves his picker to the top i/o slot and then gives
33h lift blocked on his console.

If anyone can give me a hint !!

Best Regards,

Koen Willems
Touch The Progress bv
Netherlands

Re: ADSM 3.1.2.90 on AIX 4.3.3-06

[Lloyd Dieter]

Agreed...I'm pretty sure that there were some issues with the IP stack
on ML6...we've been going straight to ML7.

-Lloyd

Angela Hughes wrote:
>
> Irene,
> Check with AIX Support to see if there's a patch
> that's needed for TCPIP.  I can't remember if it's
> 4.3.1 or 4.3.3 that this is a noted problem for but it
> happened to me and the customer thought it was TSM
> when it was AIX.
> Thanks,
> Angela
> --- irene <[EMAIL PROTECTED]> wrote:
> > We were running ADSM 3.1.2.90 on AIX 4.2.1 and it
> > behaved
> > normally.  When we migrated AIX to 4.3.3-06, ADSM
> > slowed
> > down to unacceptable response times.  For example, a
> > backup
> > that used to take 5 minutes now takes 50 minutes.
> > The operating
> > system seems to be performing O.K.  All of this is
> > being done on
> > a test machine at the moment.  Does anyone have any
> > ideas
> > why this is happening?  Should we have done a
> > complete overwrite
> > rather than a migrate when moving to AIX 4.3.3-06
> > from AIX 4.2.1?
> > Thank-you for any insight provided.
> >   Irene Braun
> >   EMAIL:  [EMAIL PROTECTED]
>
> __
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/

--
-
Lloyd Dieter-   Senior Technology Consultant
   Synergy, Inc.   http://www.synergyinc.cc   [EMAIL PROTECTED]
 Main:716-389-1260fax:716-389-1267
-

Re: lift blocked 3575l12 33h checkin

[David Longo]

Cal  IBM service on this if you got the error more than once.  I have a 3575-L32 and 
have had this.  On mine though it required a "special mod" from IBM's manufacturer due 
to a new "phase 3" shaft.   What was basically happening was the big ribbon cable 
connecting to the robot assy was getting partially caught in some instances and 
holding lift and damaging cable.  We actually saw this happen on several occaisions.

Don't know if this would be happening the same on the L12 though.  Examine the ribbon 
cable for any nicks or damage.

There can be other reasons but it is most likely library and not *SM.


David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH  321.434.5536
Pager  321.634.8230
Fax:321.434.5525
[EMAIL PROTECTED]


>>> [EMAIL PROTECTED] 06/27/01 02:06PM >>>
Dear Listers,

I have a problem with a 3575 l12 TSM 4.1.3 Atape 5.0.4. AIX 4.3.0.0.

When I want to run dsmadmc " checkin libvol 3575lib stat=scr search=bulk"

q req gives me a reply number and place vol in io

then the magstar moves his picker to the top i/o slot and then gives 33h lift 
blocked on his console.

If anyone can give me a hint !!

Best Regards,

Koen Willems
Touch The Progress bv
Netherlands



"MMS " made the following
 annotations on 06/27/01 15:07:04
--
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.

==

lift blocked 3575l12 33h checkin

[Koen A. Willems]

Dear Listers,

I have a problem with a 3575 l12 TSM 4.1.3 Atape 5.0.4. AIX 4.3.0.0.

When I want to run dsmadmc " checkin libvol 3575lib stat=scr search=bulk"

q req gives me a reply number and place vol in io

then the magstar moves his picker to the top i/o slot and then gives 33h lift 
blocked on his console.

If anyone can give me a hint !!

Best Regards,

Koen Willems
Touch The Progress bv
Netherlands

AIX BA Client Backup Problem

[Kelly J. Lipp]

Client: AIX 4.3.3 TSM Client 4.1.2.0, Server Windows NT 4.1.2.x

While attempting to backup a directory either ad-hoc or scheduled, the
following results:

I'm thinking resource problem but don't know which one.  Also, behavior on
this client changed after adding a DB2 backup using the API.

Ideas? TIA.

Dsmerror.log entry:

06/27/01   09:38:52 File '/db2logs/NODE/S0007932.LOG' truncated while
reading in Shared Static mode.
06/27/01   09:39:42 File changing during operation
06/27/01   09:39:42 File changing during operation
06/27/01   09:46:02 TcpFlush: Error 32 sending data on Tcp/Ip socket 8.
06/27/01   09:46:02 sessFlushVerb: Error from buffer flush, rc: -50
06/27/01   09:46:02 TcpFlush: Error 32 sending data on Tcp/Ip socket 8.
06/27/01   09:46:03 mpDestroy: Memory Pool #33 doesn't exist
06/27/01   09:47:24 B/A Txn Producer thread, fatal error, signal 6
06/27/01   09:47:24   0xD0014C44 pthread_kill
06/27/01   09:47:24   0xD0014110 _p_raise
06/27/01   09:47:24   0xD0175110 raise
06/27/01   09:47:24   0xD016E864 abort
06/27/01   09:47:24   0xD020B750 __assert
06/27/01   09:47:24   0x10029F0C *UNKNOWN*
06/27/01   09:47:24   0x100DA2CC *UNKNOWN*
06/27/01   09:47:24   0x100D9A0C *UNKNOWN*
06/27/01   09:47:24   0x100D1454 *UNKNOWN*
06/27/01   09:47:24   0x100D0C9C *UNKNOWN*
06/27/01   09:47:24   0x100AA454 *UNKNOWN*
06/27/01   09:47:24   0x100AA2EC *UNKNOWN*
06/27/01   09:47:24   0x100A9E50 *UNKNOWN*
06/27/01   09:47:24   0x100988AC *UNKNOWN*
06/27/01   09:47:24   0x100988FC *UNKNOWN*
06/27/01   09:47:24   0xD00081FC _pthread_body
06/27/01   09:52:21 B/A Txn Producer thread, fatal error, signal 6
06/27/01   09:52:21   0xD0014C44 pthread_kill
06/27/01   09:52:21   0xD0014110 _p_raise
06/27/01   09:52:21   0xD0175110 raise
06/27/01   09:52:21   0xD016E864 abort
06/27/01   09:52:21   0xD020B750 __assert
06/27/01   09:52:21   0x10029F0C *UNKNOWN*
06/27/01   09:52:21   0x100DA2CC *UNKNOWN*
06/27/01   09:52:21   0x100D9A0C *UNKNOWN*
06/27/01   09:52:21   0x100D1454 *UNKNOWN*
06/27/01   09:52:21   0x100D0C9C *UNKNOWN*
06/27/01   09:52:21   0x100AA454 *UNKNOWN*
06/27/01   09:52:21   0x100AA2EC *UNKNOWN*
06/27/01   09:52:21   0x100A9E50 *UNKNOWN*
06/27/01   09:52:21   0x100988AC *UNKNOWN*
06/27/01   09:52:21   0x100988FC *UNKNOWN*
06/27/01   09:52:21   0xD00081FC _pthread_body
06/27/01   10:14:10 B/A Txn Producer thread, fatal error, signal 6
06/27/01   10:14:10   0xD0014C44 pthread_kill
06/27/01   10:14:10   0xD0014110 _p_raise
06/27/01   10:14:10   0xD0175110 raise
06/27/01   10:14:10   0xD016E864 abort
06/27/01   10:14:10   0xD020B750 __assert
06/27/01   10:14:10   0x10029F0C *UNKNOWN*
06/27/01   10:14:10   0x100DA2CC *UNKNOWN*
06/27/01   10:14:10   0x100D9A0C *UNKNOWN*
06/27/01   10:14:10   0x100D1454 *UNKNOWN*
06/27/01   10:14:10   0x100D0C9C *UNKNOWN*
06/27/01   10:14:10   0x100AA454 *UNKNOWN*
06/27/01   10:14:10   0x100AA2EC *UNKNOWN*
06/27/01   10:14:10   0x100A9E50 *UNKNOWN*
06/27/01   10:14:10   0x100988AC *UNKNOWN*
06/27/01   10:14:10   0x100988FC *UNKNOWN*
06/27/01   10:14:10   0xD00081FC _pthread_body

>From the AIX Prompt:

ormal File--> 4,295 /etc/security/lastlog [Sent]
Successful incremental backup of '/'

ANS1898I * Processed 5,000 files *
ANS1898I * Processed15,000 files *
ANS1898I * Processed21,500 files *
ANS1898I * Processed28,000 files *
ANS1898I * Processed37,000 files *
ANS1898I * Processed45,500 files *
<   13.68 MB> [-  ]The assert subroutine failed: poolP->incSize > 0, file
mempool.cpp, line 719
IOT/Abort trap(coredump)

root@av1: /var/adm/syslog >
#

Kelly J. Lipp
Storage Solutions Specialists, Inc.
PO Box 51313
Colorado Springs CO 80949-1313
(719) 531-5926
Fax: (240) 539-7175
Email: [EMAIL PROTECTED] or [EMAIL PROTECTED]
www.storsol.com
www.storserver.com

Oracle Agent NT backups

[Gill, Geoffrey L.]

I'm finally getting my DBA's to work on using the Oracle agent setup on NT.
I keep getting complaints from the guy and since I can't answer the
questions because I myself have never used it, sorry to be so ignorant about
this, I was wondering if someone could answer a few questions and help
enlighten me.

1. Are the backups kicked off by the TSM server through a .cmd file on the
client?

2. If 1 above is true then does anyone have a sample script I can look at?

3. Besides the few lines in the dsm.opt sample file supplied with the
software do I need to add anything else?

4. If rman is somehow scheduled from the client itself to kick off the
backups, what are the parameters that need to be set up?

5. Has anyone tried to use the Oracle Enterprise Management console from a
designated system to schedule "ALL" these backups no matter what client they
are on?

Thanks all for the help.

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

Re: ADSM 3.1.2.90 on AIX 4.3.3-06

[Angela Hughes]

Irene,
Check with AIX Support to see if there's a patch
that's needed for TCPIP.  I can't remember if it's
4.3.1 or 4.3.3 that this is a noted problem for but it
happened to me and the customer thought it was TSM
when it was AIX.
Thanks,
Angela
--- irene <[EMAIL PROTECTED]> wrote:
> We were running ADSM 3.1.2.90 on AIX 4.2.1 and it
> behaved
> normally.  When we migrated AIX to 4.3.3-06, ADSM
> slowed
> down to unacceptable response times.  For example, a
> backup
> that used to take 5 minutes now takes 50 minutes.
> The operating
> system seems to be performing O.K.  All of this is
> being done on
> a test machine at the moment.  Does anyone have any
> ideas
> why this is happening?  Should we have done a
> complete overwrite
> rather than a migrate when moving to AIX 4.3.3-06
> from AIX 4.2.1?
> Thank-you for any insight provided.
>   Irene Braun
>   EMAIL:  [EMAIL PROTECTED]


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/

Re: Backing up NDS database

[Rushforth, Tim]

With 4.11 client (and 3.106 from memory) you specify DIR to backup the NDS
database not NDS.

Our NetWare option files have the line:

DOMAIN ALL-LOCAL DIR

Tim Rushforth
City of Winnipeg


-Original Message-
From: Brian CTR Englert [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 9:56 AM
To: [EMAIL PROTECTED]
Subject:


I am testing our Novell Netware 4.11 servers to see if they are backing up
NDS
(to see that all rights are preserved upon restore) to an ADSM server
running
version 3.7.1. I believe the Novell servers are running client 3.1.1 of
ADSM.
All of my servers seem to be failing on the scheduled backup of NDS. In my
dsmerrorlog I get the following:
ANS1071E Invalid Domain Name Entered: 'NDS'
ANS1512E Scheduled Event 'ADM-INCR_ActApps1' Failed. Return Code=4

I get this on all my servers. In my DSM.OPT file I have the following line

DOMAINSYS: APPS: USER: NDS

Can anyone help?

Brian Englert
FAA Tech Center
[EMAIL PROTECTED]

Re: SQL backtrack /ADSM problem

[Rolf Meyer]

> Once in a while,  I receive errors through SQL backtrack:
> [dtodump 180482} DT-01254E: Program error 11 (Segmentation fault),
> saving core file in
> '/datatools/obacktrack-3.2.80.3/cdump/dtodump-06.18.2001-21:22-180482/core'
>
I remember one situation using TSM and Backtrack with such errors after a
100% full of archlog filesystem, moving the archlog data to another fs, then
backup the remaining files, and copy back the moved files twice (some time
later). If Backtrack found the same archlog dataset the second time, it
crashes. We need a day to find out.

--
Herzliche Gruesse / Many greetings

Rolf Meyer
Raalandsweg 22
D-22559 Hamburg

[EMAIL PROTECTED][EMAIL PROTECTED]

Re: TSM and backint success stories

[Davidson, Becky]

Make sure in upgrading backint to TDP that you go straight to 3.2.  We went
to 3.1.4 and had alot of issues but 3.2 seems to be going well.  We also ran
into CPU issues of a sort.  With backint everything ran about 5 hours but
TDP seems to be more CPU intensive.
Becky Davidson
Data Manager/AIX Administrator
EDS/Earthgrains
voice: 314-259-7589
fax: 314-877-8589
email: [EMAIL PROTECTED]



-Original Message-
From: Kevin Wagner [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 6:06 AM
To: [EMAIL PROTECTED]
Subject: TSM and backint success stories


 Has anyone had any success backing up SAP R3 online tablespaces to a TSM
 server using backint versus Data Protection?
 I haven't seen definitive answers as to whether backint will still work
(i.e.a supported configuration).  I'd hate to think that TDP for SAP is the
only way to run online backups of an SAP ORACLE database.
We are going to upgrade (finally) from ADSM Server 3.1.20 to TSM 4.1, and
we'd like to keep our backint product, especially given the hefty price tag
of the TDP option.

 I'd appreciate any success stories that anyone knows about.  I searched
the archives, but didn't see anything recent there.

 Thanks.

 --k

Re: Database backup performance

[Bill Colwell]

Zoltan,

I have a very large os/390 server.  The last full dbb went at a rate of
3.3 million pages/hr, almost 5 times fater than yours.

Since v1 r1 of adsm I haven't found any tricks to speed this up
except to change hardware.  My current system is

cpu: 9672-ra6
tape: 9840 running 3590 emulation
disk: STK SVA.

5 years ago the dbb went at a rate of 510,000 pages an hour.
The hardware then was STK iceberg disk and 3490 tapes, I don't
remember the processor.

I don't think dbb speed has anything to do with the cache hit%.
A sequential process like a full dbb should stay out of the cache since
it would otherwise flood the cache with pages that aren't likely to be
referenced again.

Hope this helps,

--
--
Bill Colwell
C. S. Draper Lab
Cambridge, Ma.
[EMAIL PROTECTED]
--



In <[EMAIL PROTECTED]>, on 06/27/01
   at 01:34 PM, Zoltan Forray/AC/VCU <[EMAIL PROTECTED]> said:

>I guess I should have clarified that the server is on OS/390, not *NIX !!

>Thanks for all the responses on how long it takes. Now, how about ways to
>improve the speed ?

>I am trying a backup to 3590 drives, to see how much of a difference it
>makes. So far, there does seem to be a speed difference.

>I also went through the ADSM job log and collected some statistics.

>The last FULL DB backup took more than 5-hours for 3665050 pages !!!

>***
 Hello, we full backup our 22.3 GB DB (assigned, used 92%)
>in 39 minutes, using Magstar 3590E cartridges in the 3494 robotic.
>Th DB is laying on mirrowed ssa-disks (7133) using 18GB-disks
>(ibm7133-8518)
>Processor in RS600/H50, OS/AIX 4.3.3 , TSM4.1.3.0

>...mabe you should first check the capability of the disks where your db
>is located - what you would get there by reading on unix for example
>a simple test would be done using dd for example
>( if you have your server on unix)
>Example:
># time dd if=/some_data_located_on_the_db_disk of=/dev/null bs=1024k
>count=100
>100+0 records in.
>100+0 records out.

>real0m8.396s
>user0m0.010s
>sys 0m1.890s
>#
>... would get the time to just read 100MB ( just at the time of the test )
>running the example -dd- test again can to unrealistic low times when
>data is cached, so a new test should be done with new data ( if=...)

Re: Can TSM directory paths, names be changed?

[PINNI, BALANAND (SBCSI)]

U can by setting env parameters.TSM we can then  can't we in ADSM.

-Original Message-
From: Vibhute, Bandu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 10:34 AM
To: [EMAIL PROTECTED]
Subject: Re: Can TSM directory paths, names be changed?


Peter,

There is no way in AIX to specify software to be installed in specific
directory rather than /usr or /usr/lpp. Still you can copy installed
software on other filesystems or disks. If you change directory names it
works but you have to change all executable file links from /usr/bin
directory to refer to new files and more painful is future updates. Simple
way is:

1. Create separate filesystem for /usr/tivoli on the other hard disk.
2. If some file system already exists, create soft link with ln -s /existing
/usr/tivoli

Install Tivoli server/client. It will keep on separate disk.

Good luck,
-Bandu

-Original Message-
From: Glass, Peter [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 22, 2001 5:19 PM
To: [EMAIL PROTECTED]
Subject: Can TSM directory paths, names be changed?


When the TSM Server software for AIX is installed, it rolls out a directory
path of /usr/tivoli/tsm/...
Is it safe to change this, or must the directory paths and names be kept
intact?
We are about to move TSM onto new disk, and the system administrators have
this idea of moving TSM into a different filesystem other than
/usr/tivoli/tsm.
This idea seems questionable to me, but would like to confirm whether this
is safe to do.
Thank you!

Peter Glass
Distributed Storage Management (DSM)
Wells Fargo Services Company
> * 612-667-0086  * 866-249-8568
> * [EMAIL PROTECTED]
>


"WorldSecure Server " made the following
 annotations on 06/22/01 17:34:18

-
The origin of this electronic mail message was the Internet.
Bestfoods Baking cannot validate the authenticity
of the sender and therefore cannot be held accountable
for any content within.
===



"WorldSecure Server " made the following
 annotations on 06/27/01 11:44:10

-
This message may contain confidential and trade secret information of
Bestfoods Baking, and be subject to the Economic Espionage Act of 1996. For
recipient's use only. If you have received this message in error, please
delete immediately, and alert the sender.

===

PL help why this is happening .

[PINNI, BALANAND (SBCSI)]

Hi TSM  / NT Clients gurus PL help
Some times this the error we see in activity log for NT CLIENTS.
Can anyone PL tell me what to do!!!
It only happens sometimes once in a blue moon.



protocol violation detected.
06/27/01   03:55:11  ANR0403I Session 68 ended for node NTL30E06 (WinNT).
06/27/01   03:55:12  ANR8336I Verifying label of ECARTRIDGE volume AA1055 in
  drive ACS_DRV (/dev/mt0).
06/27/01   03:55:13  ANR0406I Session 74 started for node NTL30E06 (WinNT)
  (Tcp/Ip 132.201.1.142(4100)).
06/27/01   03:55:13  ANR0484W Session 74 for node NTL30E06 (WinNT)
terminated -
  protocol violation
detected.>
06/27/01   03:55:14  ANR0406I Session 75 started for node NTL30E06 (WinNT)
  (Tcp/Ip 132.201.1.142(4101)).
06/27/01   03:55:14  ANR0403I Session 75 ended for node NTL30E06 (WinNT).
06/27/01   03:55:14  ANR0406I Session 76 started for node NTL30E06 (WinNT)
  (Tcp/Ip 132.201.1.142(4102)).
06/27/01   03:55:14  ANR0403I Session 76 ended for node NTL30E06 (WinNT).
06/27/01   03:55:38  ANR8468I ECARTRIDGE volume AA1055 dismounted from drive
  ACS_DRV (/dev/mt0) in library ACS_LIB.



PROTOCOL VIOLATION DETECTED



Thankx in advance

Re: TSM V4.2 Hardware compatibility list?

[Neil Schofield]

Xavier

The Tivoli web-site has been updated with the compatibility list for v4.2:

http://www.tivoli.com/support/storage_mgr/devices/all.html

At first glance, it looks like you're OK with your HP/Seagate LTO drives
but not your SDLTs. That's unless anybody else knows differently?

Neil Schofield

Date:Wed, 20 Jun 2001 13:52:07 +0200
From:Xavier Chavanet <[EMAIL PROTECTED]>
Subject: TSM V4.2 Hardware compatibility list?
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

From: Xavier 1 Chavanet

Does somebody know the hardware compatibility list for the new TSM 4.2
release?
I just need to check if SDTL and/or HP/SEAGATE LTO are or not include.

Thank




The information in this e-mail is confidential and may also be legally
privileged. The contents are intended for recipient only and are subject
to the legal notice available at http://www.keldagroup.com/email.htm
Yorkshire Water Services Limited
Registered Office Western House Halifax Road Bradford BD6 2SZ
Registered in England and Wales No 2366682

Re: Database backup performance

[John Naylor]

Zoltan,

Sorry I forgot to mention, as you are OS390 it will be worth looking at the RMF
statistics
for the period of the database backup. This should show which resource is
causing your backup to run so slow.  It could be cpu or possibly disk
contention,

John




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

Antwort: TSM and backint success stories

["Felix Mülbaier"]

Hi
The old backint Versions did not work with the new API Code of the 4.1 client.
Old Backint needs API Code 3xxx. One Customer most go back from Client 4.1 to
client3.1
frendly regards
Felix

Re: Database backup performance

[John Naylor]

Zoltan,

We are OS390 too.
Last full backup of 3.7.20.0 database took
1 hour 45 minutes   (4464417 pages)  to STK 9840 cartridge
So you definitely should be faster

John





"Zoltan Forray/AC/VCU" <[EMAIL PROTECTED]> on 06/27/2001 05:04:04 PM

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

To:   [EMAIL PROTECTED]
cc:(bcc: John Naylor/HAV/SSEG)
Subject:  Re: Database backup performance



I guess I should have clarified that the server is on OS/390, not *NIX !!

Thanks for all the responses on how long it takes. Now, how about ways to
improve the speed ?

I am trying a backup to 3590 drives, to see how much of a difference it
makes. So far, there does seem to be a speed difference.

I also went through the ADSM job log and collected some statistics.

The last FULL DB backup took more than 5-hours for 3665050 pages !!!

***
>>> Hello, we full backup our 22.3 GB DB (assigned, used 92%)
in 39 minutes, using Magstar 3590E cartridges in the 3494 robotic.
Th DB is laying on mirrowed ssa-disks (7133) using 18GB-disks
(ibm7133-8518)
Processor in RS600/H50, OS/AIX 4.3.3 , TSM4.1.3.0

...mabe you should first check the capability of the disks where your db
is located - what you would get there by reading on unix for example
a simple test would be done using dd for example
( if you have your server on unix)
Example:
# time dd if=/some_data_located_on_the_db_disk of=/dev/null bs=1024k
count=100
100+0 records in.
100+0 records out.

real0m8.396s
user0m0.010s
sys 0m1.890s
#
... would get the time to just read 100MB ( just at the time of the test )
running the example -dd- test again can to unrealistic low times when
data is cached, so a new test should be done with new data ( if=...)








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

Database backup performan

[Sam Sheppard]

Elapsed   DB SIZE   USEDTAPEDISK   PROCESSOR  OS/390   TSM Ver
  time

1 Hour11.7G 75%   3494/3590  RVA9672-R14   2.10 4.1.2Hour
41 Min 9.3G 54%   3494/3590  RVA9672-R52   2.10 4.1.2Hour

Sam Sheppard
San Diego Data Processing Corp.

---`


 Top of message 
>>--> 06-27-01  06:50  ..NETMAIL () Database backup performan
Date: Wed, 27 Jun 2001 09:37:11 -0400
From: "Zoltan Forray/AC/VCU" <[EMAIL PROTECTED]>
Subject: Database backup performance
To: [EMAIL PROTECTED]
_Top_of_Message_

Any suggestions on how to improve DB backup performance ?

Doing a FULL DB backup of our 15GB ADSM (yes, not TSM YET. Hoping to
convert to 4.1.3 RSN !!) server, sometimes takes 4-hours.

Since I read a previous message about someone having a 52GB DB, I was
wondering how long it takes to backup that much DB since my meager DB takes
so long ? Note, there is no "operator delay" since it goes to a 3494
ATL, using 3490E drives. I was thinking about moving it to 3590 MAGSTAR but
wasn't sure if it would make much of a difference since the only real
change would be reduction/elimination of tape mounts (currently uses
9-cartridges). Since it is a robot, this would save a few minutes at most.

I have tried increasing the BUFPOOL value (from 32MB to 80MB) with little
noticable improvement. I still haven't reached/sustained the illusive 98%
Cache Utilization !

Since the ADSM address space working set size has often exceed 110MB, I was
wondering what was reasonable (or expected) for thise size DB. How much
further should I increase the BUFPOOL value ?

===
Zoltan Forray
Virginia Commonwealth University
University Computing Center
e-mail: [EMAIL PROTECTED]
voice: 804-828-4807

---`

Re: SQL Server Disaster Recovery question

[William Degli-Angeli]

Did you "rebuild the master database using the same character
set and sort order as the master database backup being restored"?

After restoring the master database, are you restarting the sql server
in multi-user mode ( Ie. Not in single user mode) ?

What errors are you getting when you restart the server? Any event
log messages?


Thanks,
Bill

William Degli-Angeli
IGS TDP Development
Endicott, NY
(607) 752-6749
TieLine: 852-6749
Internet: [EMAIL PROTECTED]



Ruddy STOUDER
   cc:
Sent by: "ADSM:  Subject: Re: SQL Server Disaster 
Recovery question
Dist Stor Manager"
<[EMAIL PROTECTED]
EDU>


06/27/2001 11:44
Please respond to
"ADSM: Dist Stor
Manager"





Del,

Indeed, the msdb database has to be restored but, according to the
redbook, it has to be done after :

- With TDP for SQL 1.1.1, I restored the master.dat file
- I tried to restart the SQL server and it fails ...

So, after restarting the SQL server, I am supposed to restore the msdb
database but the SQL server does not restart ...

Ruddy

Ruddy Stouder
System Engineer
TSM Certified Consultant

I.R.I.S.
Rue du Bosquet 10 - Parc Scientifique de
Louvain-La-Neuve
B- 1435 Mont-Saint-Guibert
[EMAIL PROTECTED]
http://www.irislink.com

Tel: +32 (0)10 48 75 10  -  Fax: +32 (0)10 48 75
40


-Original Message-
From: Del Hoobler [mailto:[EMAIL PROTECTED]]
Sent: mercredi 27 juin 2001 14:39
To: [EMAIL PROTECTED]
Subject: Re: SQL Server Disaster Recovery question


Ruddy,

The piece that I didn't see you mention was
restoring the "msdb" database. That is necessary.
See Appendix B of the TDP for SQL V1 User's Guide.

Also, take a look at the new TDP for SQL Redbook
for more details on using TDP for SQL for disaster recovery.
The redbook examples show the restore using TDP for SQL 2.2
but, you can at least follow the general process used.
You can find it at:

   www.redbooks.ibm.com

Or... here is a direct link:

   http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg246148.pdf

Thanks,

Del



Del Hoobler
IBM Corporation
[EMAIL PROTECTED]

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




Ruddy STOUDER
   cc:
Sent by: "ADSM:  Subject: SQL Server
Disaster Recovery question
Dist Stor Manager"
<[EMAIL PROTECTED]
EDU>


06/27/2001 07:38
AM
Please respond to
"ADSM: Dist Stor
Manager"





Hello,

I made a full NT Server Disaster Recovery. According to the
documentation, after the recovery:

- I made a rebuild of the SQL tables
- I restarted the SQL Server in single user mode
- With TDP for SQL 1.1.1, I restored the master.dat file
- I tried to restart the SQL server and it fails ...

The same table beeing used for master.dat and model.dat, I tried :

- I made a rebuild of the SQL tables
- I restarted the SQL Server in single user mode
- With TDP for SQL 1.1.1, I restored the master.dat and model.dat files
- I tried to restart the SQL server and it fails with the following
error messages ...

...
01/06/14 13:47:58.48 spid1Activating disk 'AMX_Data'
01/06/14 13:47:58.51 kernel   udopen: operating system error 2(The
system cannot find the file specified.) during the creation/opening of
physical device G:\MsSql\SQLserver Data Devices\AMX_Data.DAT
01/06/14 13:47:58.57 kernel   udactivate (primary): failed to open
device G:\MsSql\SQLserver Data Devices\AMX_Data.DAT for vdn 10
01/06/14 13:47:58.62 spid1Activating disk 'AMX_Log'
01/06/14 13:47:58.64 kernel   udopen: operating system error 2(The
system cannot find the file specified.) during the creation/opening of
physical device E:\MsSql\SQLserver Log Devices\AMX_Log.DAT
01/06/14 13:47:58.71 kernel   udactivate (primary): failed to open
device E:\MsSql\SQLserver Log Devices\AMX_Log.DAT for vdn 11
01/06/14 13:47:58.74 spid1Activating disk 'Dev_Device_Data'
01/06/14 13:47:58.78 kernel   udopen: operating system error 2(The
system cannot find the file specified.) during the creation/opening of
physical device G:\MsSql\SQLserver Data Devices\Dev_Device_Data.DAT
...

Many thanks in advance for your help ...


Ruddy Stouder
Senior System Engineer
TSM Certified Consultant
I.R.I.S.
Rue du Bosquet 10 - Parc Scientifique de
Lo

Re: Database backup performance

[Zoltan Forray/AC/VCU]

I guess I should have clarified that the server is on OS/390, not *NIX !!

Thanks for all the responses on how long it takes. Now, how about ways to
improve the speed ?

I am trying a backup to 3590 drives, to see how much of a difference it
makes. So far, there does seem to be a speed difference.

I also went through the ADSM job log and collected some statistics.

The last FULL DB backup took more than 5-hours for 3665050 pages !!!

***
>>> Hello, we full backup our 22.3 GB DB (assigned, used 92%)
in 39 minutes, using Magstar 3590E cartridges in the 3494 robotic.
Th DB is laying on mirrowed ssa-disks (7133) using 18GB-disks
(ibm7133-8518)
Processor in RS600/H50, OS/AIX 4.3.3 , TSM4.1.3.0

...mabe you should first check the capability of the disks where your db
is located - what you would get there by reading on unix for example
a simple test would be done using dd for example
( if you have your server on unix)
Example:
# time dd if=/some_data_located_on_the_db_disk of=/dev/null bs=1024k
count=100
100+0 records in.
100+0 records out.

real0m8.396s
user0m0.010s
sys 0m1.890s
#
... would get the time to just read 100MB ( just at the time of the test )
running the example -dd- test again can to unrealistic low times when
data is cached, so a new test should be done with new data ( if=...)

ADSM 3.1.2.90 on AIX 4.3.3-06

[irene]

We were running ADSM 3.1.2.90 on AIX 4.2.1 and it behaved
normally.  When we migrated AIX to 4.3.3-06, ADSM slowed
down to unacceptable response times.  For example, a backup
that used to take 5 minutes now takes 50 minutes.  The operating
system seems to be performing O.K.  All of this is being done on
a test machine at the moment.  Does anyone have any ideas
why this is happening?  Should we have done a complete overwrite
rather than a migrate when moving to AIX 4.3.3-06 from AIX 4.2.1?
Thank-you for any insight provided.
  Irene Braun
  EMAIL:  [EMAIL PROTECTED]

Incremental DB Backup Not Clearing Log

[Andy Carlson]

I am running TSM 3.7.4, on an AIX box.  I have about 4.8GB of log space,
in roll forward mode.  Up until last week, everything was
peachy.  Starting last week, the database backuptrigger would kick, do
an incremental, then not free the log space.  I discovered by accident
(the log filled up, and I had to do an emergency extend) that setting it
to normal mode, then back to roll-forward allowed the next incremental
or full to clear the log.  Has anyone seen this?  Thanks for any info.

Andy Carlson |\  _,,,---,,_
[EMAIL PROTECTED]ZZZzz /,`.-'`'-.  ;-;;,_
BJC Health System   |,4-  ) )-,_. ,\ (  `'-'
St. Louis, Missouri'---''(_/--'  `-'\_)
Cat Pics: http://andyc.dyndns.org/animal.html

Re: SQL Server Disaster Recovery question

[Ruddy STOUDER]

Del,

Indeed, the msdb database has to be restored but, according to the
redbook, it has to be done after :

- With TDP for SQL 1.1.1, I restored the master.dat file
- I tried to restart the SQL server and it fails ...

So, after restarting the SQL server, I am supposed to restore the msdb
database but the SQL server does not restart ...

Ruddy

Ruddy Stouder
System Engineer
TSM Certified Consultant

I.R.I.S.
Rue du Bosquet 10 - Parc Scientifique de
Louvain-La-Neuve
B- 1435 Mont-Saint-Guibert
[EMAIL PROTECTED]
http://www.irislink.com

Tel: +32 (0)10 48 75 10  -  Fax: +32 (0)10 48 75
40


-Original Message-
From: Del Hoobler [mailto:[EMAIL PROTECTED]]
Sent: mercredi 27 juin 2001 14:39
To: [EMAIL PROTECTED]
Subject: Re: SQL Server Disaster Recovery question


Ruddy,

The piece that I didn't see you mention was
restoring the "msdb" database. That is necessary.
See Appendix B of the TDP for SQL V1 User's Guide.

Also, take a look at the new TDP for SQL Redbook
for more details on using TDP for SQL for disaster recovery.
The redbook examples show the restore using TDP for SQL 2.2
but, you can at least follow the general process used.
You can find it at:

   www.redbooks.ibm.com

Or... here is a direct link:

   http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg246148.pdf

Thanks,

Del



Del Hoobler
IBM Corporation
[EMAIL PROTECTED]

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




Ruddy STOUDER
   cc:
Sent by: "ADSM:  Subject: SQL Server
Disaster Recovery question
Dist Stor Manager"
<[EMAIL PROTECTED]
EDU>


06/27/2001 07:38
AM
Please respond to
"ADSM: Dist Stor
Manager"





Hello,

I made a full NT Server Disaster Recovery. According to the
documentation, after the recovery:

- I made a rebuild of the SQL tables
- I restarted the SQL Server in single user mode
- With TDP for SQL 1.1.1, I restored the master.dat file
- I tried to restart the SQL server and it fails ...

The same table beeing used for master.dat and model.dat, I tried :

- I made a rebuild of the SQL tables
- I restarted the SQL Server in single user mode
- With TDP for SQL 1.1.1, I restored the master.dat and model.dat files
- I tried to restart the SQL server and it fails with the following
error messages ...

...
01/06/14 13:47:58.48 spid1Activating disk 'AMX_Data'
01/06/14 13:47:58.51 kernel   udopen: operating system error 2(The
system cannot find the file specified.) during the creation/opening of
physical device G:\MsSql\SQLserver Data Devices\AMX_Data.DAT
01/06/14 13:47:58.57 kernel   udactivate (primary): failed to open
device G:\MsSql\SQLserver Data Devices\AMX_Data.DAT for vdn 10
01/06/14 13:47:58.62 spid1Activating disk 'AMX_Log'
01/06/14 13:47:58.64 kernel   udopen: operating system error 2(The
system cannot find the file specified.) during the creation/opening of
physical device E:\MsSql\SQLserver Log Devices\AMX_Log.DAT
01/06/14 13:47:58.71 kernel   udactivate (primary): failed to open
device E:\MsSql\SQLserver Log Devices\AMX_Log.DAT for vdn 11
01/06/14 13:47:58.74 spid1Activating disk 'Dev_Device_Data'
01/06/14 13:47:58.78 kernel   udopen: operating system error 2(The
system cannot find the file specified.) during the creation/opening of
physical device G:\MsSql\SQLserver Data Devices\Dev_Device_Data.DAT
...

Many thanks in advance for your help ...


Ruddy Stouder
Senior System Engineer
TSM Certified Consultant
I.R.I.S.
Rue du Bosquet 10 - Parc Scientifique de
Louvain-La-Neuve
B-1348 Mont-Saint-Guibert
[EMAIL PROTECTED]

Tel: +32 (0)10 48 75 10  -  Fax: +32 (0)10 48 75
40

Re: Can TSM directory paths, names be changed?

[Vibhute, Bandu]

Peter,

There is no way in AIX to specify software to be installed in specific
directory rather than /usr or /usr/lpp. Still you can copy installed
software on other filesystems or disks. If you change directory names it
works but you have to change all executable file links from /usr/bin
directory to refer to new files and more painful is future updates. Simple
way is:

1. Create separate filesystem for /usr/tivoli on the other hard disk.
2. If some file system already exists, create soft link with ln -s /existing
/usr/tivoli

Install Tivoli server/client. It will keep on separate disk.

Good luck,
-Bandu

-Original Message-
From: Glass, Peter [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 22, 2001 5:19 PM
To: [EMAIL PROTECTED]
Subject: Can TSM directory paths, names be changed?


When the TSM Server software for AIX is installed, it rolls out a directory
path of /usr/tivoli/tsm/...
Is it safe to change this, or must the directory paths and names be kept
intact?
We are about to move TSM onto new disk, and the system administrators have
this idea of moving TSM into a different filesystem other than
/usr/tivoli/tsm.
This idea seems questionable to me, but would like to confirm whether this
is safe to do.
Thank you!

Peter Glass
Distributed Storage Management (DSM)
Wells Fargo Services Company
> * 612-667-0086  * 866-249-8568
> * [EMAIL PROTECTED]
>


"WorldSecure Server " made the following
 annotations on 06/22/01 17:34:18

-
The origin of this electronic mail message was the Internet.
Bestfoods Baking cannot validate the authenticity
of the sender and therefore cannot be held accountable
for any content within.
===



"WorldSecure Server " made the following
 annotations on 06/27/01 11:44:10
-
This message may contain confidential and trade secret information of Bestfoods 
Baking, and be subject to the Economic Espionage Act of 1996. For recipient's use 
only. If you have received this message in error, please delete immediately, and alert 
the sender.

===

Re: Database backup performance

[Rainer Wolf]

Hello, we full backup our 22.3 GB DB (assigned, used 92%) 
in 39 minutes, using Magstar 3590E cartridges in the 3494 robotic.
Th DB is laying on mirrowed ssa-disks (7133) using 18GB-disks (ibm7133-8518) 
Processor in RS600/H50, OS/AIX 4.3.3 , TSM4.1.3.0

...mabe you should first check the capability of the disks where your db
is located - what you would get there by reading on unix for example 
a simple test would be done using dd for example 
( if you have your server on unix) 
Example:
# time dd if=/some_data_located_on_the_db_disk of=/dev/null bs=1024k count=100
100+0 records in.
100+0 records out.

real0m8.396s
user0m0.010s
sys 0m1.890s
# 
... would get the time to just read 100MB ( just at the time of the test )
running the example -dd- test again can to unrealistic low times when 
data is cached, so a new test should be done with new data ( if=...)


> > -Original Message-
> > From: Zoltan Forray/AC/VCU [SMTP:[EMAIL PROTECTED]]
> > Sent: Wednesday, June 27, 2001 3:37 PM
> > To:   [EMAIL PROTECTED]
> > Subject:  Database backup performance
> >
> > Any suggestions on how to improve DB backup performance ?
> >
> > Doing a FULL DB backup of our 15GB ADSM (yes, not TSM YET. Hoping to
> > convert to 4.1.3 RSN !!) server, sometimes takes 4-hours.
> >
> > Since I read a previous message about someone having a 52GB DB, I was
> > wondering how long it takes to backup that much DB since my meager DB
> > takes
> > so long ? Note, there is no "operator delay" since it goes to a 3494
> > ATL, using 3490E drives. I was thinking about moving it to 3590 MAGSTAR
> > but
> > wasn't sure if it would make much of a difference since the only real
> > change would be reduction/elimination of tape mounts (currently uses
> > 9-cartridges). Since it is a robot, this would save a few minutes at most.
> >
> > I have tried increasing the BUFPOOL value (from 32MB to 80MB) with little
> > noticable improvement. I still haven't reached/sustained the illusive 98%
> > Cache Utilization !
> >
> > Since the ADSM address space working set size has often exceed 110MB, I
> > was
> > wondering what was reasonable (or expected) for thise size DB. How much
> > further should I increase the BUFPOOL value ?
> >
> > ===
> > Zoltan Forray
> > Virginia Commonwealth University
> > University Computing Center
> > e-mail: [EMAIL PROTECTED]
> > voice: 804-828-4807

-- 

Mit freundlichen Grüßen / best regards
Rainer Wolf


 __
   
 Rainer Wolf  [EMAIL PROTECTED]  
 Tel: 0731-50-22482   Fax: 0731-50-22471   
 University of Ulmhttp://www.uni-ulm.de/urz
 University Computing Center  Albert-Einstein-Allee 11   
 AG Basissysteme  89069 Ulm

No Subject

[Brian CTR Englert]

I am testing our Novell Netware 4.11 servers to see if they are backing up NDS
(to see that all rights are preserved upon restore) to an ADSM server running
version 3.7.1. I believe the Novell servers are running client 3.1.1 of ADSM.
All of my servers seem to be failing on the scheduled backup of NDS. In my
dsmerrorlog I get the following:
ANS1071E Invalid Domain Name Entered: 'NDS'
ANS1512E Scheduled Event 'ADM-INCR_ActApps1' Failed. Return Code=4

I get this on all my servers. In my DSM.OPT file I have the following line

DOMAINSYS: APPS: USER: NDS

Can anyone help?

Brian Englert
FAA Tech Center
[EMAIL PROTECTED]

Re: Database backup performance

[Richard Sims]

Doing the math on the quoted database backup sizes and times, plus
my own, shows customers experiencing a db backup data rate of
3 - 4 MB/sec.  That is well below the capabilities of the disk and
tape technology in use, and points to the often-criticized TSM
database system being the drag on performance.  And many customers
experiencing this are using today's fastest processors, so it
looks like only architectural relief in the TSM database system
will help.

   Richard Sims, BU

Re: Database backup performance

[David Longo]

Our DB is 13.5GB, 65% utilized.  Full backup in 30 minutes to IBM 3575 library with 
C-XL drives.
TSM 3.7.4.0 on AIX 4.3.3, IBM RS6000 F50.

David Longo

>>> [EMAIL PROTECTED] 06/27/01 09:37AM >>>
Any suggestions on how to improve DB backup performance ?

Doing a FULL DB backup of our 15GB ADSM (yes, not TSM YET. Hoping to
convert to 4.1.3 RSN !!) server, sometimes takes 4-hours.

Since I read a previous message about someone having a 52GB DB, I was
wondering how long it takes to backup that much DB since my meager DB takes
so long ? Note, there is no "operator delay" since it goes to a 3494
ATL, using 3490E drives. I was thinking about moving it to 3590 MAGSTAR but
wasn't sure if it would make much of a difference since the only real
change would be reduction/elimination of tape mounts (currently uses
9-cartridges). Since it is a robot, this would save a few minutes at most.

I have tried increasing the BUFPOOL value (from 32MB to 80MB) with little
noticable improvement. I still haven't reached/sustained the illusive 98%
Cache Utilization !

Since the ADSM address space working set size has often exceed 110MB, I was
wondering what was reasonable (or expected) for thise size DB. How much
further should I increase the BUFPOOL value ?

===
Zoltan Forray
Virginia Commonwealth University
University Computing Center
e-mail: [EMAIL PROTECTED] 
voice: 804-828-4807



"MMS " made the following
 annotations on 06/27/01 11:07:49
--
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: Database backup performance

[Rushforth, Tim]

Our DB is 21 GB, 85% Utilized.  Backup time is 34 minutes.

Running TSM 3.7.4 on Windows 2000.  Backup to DLT 7000 tape.
This translates to about 9 MB/sec.

Tim Rushforth
City of Winnipeg

Re: dbsnapshot and drm

[David Longo]

do a: q actlog begind=-1 sea=volser

Put your volser in place of volser.  This will show all activity (including DRM state 
changes) for that volume in last day.  Then you can zoom in on when it changed and see 
why.

David Longo

>>> [EMAIL PROTECTED] 06/27/01 10:04AM >>>
We just started doing the snapshot backups yesterday and trying to send them
offsite.  I did the move drm wherest=mountable tostate=courier source=dbs
and it moved the snapshot tape to courier and checked it out according to
the activity log.  The tape is now gone from all records.  I can not come up
with a command that shows that tape.  I have tried q drm * and q drm *
source=dbs and it doesn't show up.  It did not move from courier to vault
when I did the move last night.  Any suggestions?  Is this standard?  Have I
missed something?
Thanks
Becky Davidson
Data Manager/AIX Administrator
EDS/Earthgrains
voice: 314-259-7589
fax: 314-877-8589
email: [EMAIL PROTECTED] 



"MMS " made the following
 annotations on 06/27/01 10:36: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: Database backup performance

[Richard Cowen]

>Doing a FULL DB backup of our 15GB ADSM (yes, not TSM YET. Hoping to
convert to 4.1.3 RSN !!) server, sometimes takes 4-hours.

>Since I read a previous message about someone having a 52GB DB, I was
wondering how long it takes to backup that much DB since my meager DB takes
so long ?

About 3 hours, as I recall.  3494 3590's, MCA high node, fast/wide scsi.  It
usually went to 2 tapes (barely.)

Re: dbsnapshot and drm

[Mahesh Tailor]

Try . . .

q volh type=dbb

Mahesh

>>> [EMAIL PROTECTED] 06/27/01 10:04AM >>>
We just started doing the snapshot backups yesterday and trying to send
them
offsite.  I did the move drm wherest=mountable tostate=courier
source=dbs
and it moved the snapshot tape to courier and checked it out according
to
the activity log.  The tape is now gone from all records.  I can not come
up
with a command that shows that tape.  I have tried q drm * and q drm *
source=dbs and it doesn't show up.  It did not move from courier to
vault
when I did the move last night.  Any suggestions?  Is this standard?
Have I
missed something?
Thanks
Becky Davidson
Data Manager/AIX Administrator
EDS/Earthgrains
voice: 314-259-7589
fax: 314-877-8589
email: [EMAIL PROTECTED]

Re: TSM and backint success stories

[Kauffman, Tom]

Kevin --

We run a nightly online backup and a weekly offline with TDP for R3 -- and
were doing the same when it was called 'backint'. There's no change to the
product, just the version. Our database is running at 560 GB (roughly) right
now. If you haven't done an online with backint yet, be advised that it's
not an incremental, it is a true full backup with the database up and open,
You will generate a fair number of redo logs during the backup, depending on
system activity at the time. As far as 'supported configuration' -- you
aren't currently in a supported configuration at all, and 'backint' the PRPQ
product is no longer supported. What you really have to pay attention to are
the version(s) of the TSM api that your version of backint will work with,
and the versions of SAP that it will work with.

Tom Kauffman
NIBCO Inc

> -Original Message-
> From: Kevin Wagner [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 27, 2001 6:06 AM
> To: [EMAIL PROTECTED]
> Subject: TSM and backint success stories
>
>
>  Has anyone had any success backing up SAP R3 online
> tablespaces to a TSM
>  server using backint versus Data Protection?
>  I haven't seen definitive answers as to whether backint will
> still work
> (i.e.a supported configuration).  I'd hate to think that TDP
> for SAP is the
> only way to run online backups of an SAP ORACLE database.
> We are going to upgrade (finally) from ADSM Server 3.1.20 to
> TSM 4.1, and
> we'd like to keep our backint product, especially given the
> hefty price tag
> of the TDP option.
>
>  I'd appreciate any success stories that anyone knows about.
> I searched
> the archives, but didn't see anything recent there.
>
>  Thanks.
>
>  --k
>

Re: Database backup performance

[Lambelet,Rene,VEVEY,FC-SIL/INF.]

Hello, we full backup our 19 GB DB (used 80%) in 75 minutes, using Magstar
3590E cartridges in the 3494 robotic.

Processor in Hitachi Pilot27, 120 mips, OS/390 2.9

Regards,

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: Zoltan Forray/AC/VCU [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, June 27, 2001 3:37 PM
> To:   [EMAIL PROTECTED]
> Subject:  Database backup performance
> 
> Any suggestions on how to improve DB backup performance ?
> 
> Doing a FULL DB backup of our 15GB ADSM (yes, not TSM YET. Hoping to
> convert to 4.1.3 RSN !!) server, sometimes takes 4-hours.
> 
> Since I read a previous message about someone having a 52GB DB, I was
> wondering how long it takes to backup that much DB since my meager DB
> takes
> so long ? Note, there is no "operator delay" since it goes to a 3494
> ATL, using 3490E drives. I was thinking about moving it to 3590 MAGSTAR
> but
> wasn't sure if it would make much of a difference since the only real
> change would be reduction/elimination of tape mounts (currently uses
> 9-cartridges). Since it is a robot, this would save a few minutes at most.
> 
> I have tried increasing the BUFPOOL value (from 32MB to 80MB) with little
> noticable improvement. I still haven't reached/sustained the illusive 98%
> Cache Utilization !
> 
> Since the ADSM address space working set size has often exceed 110MB, I
> was
> wondering what was reasonable (or expected) for thise size DB. How much
> further should I increase the BUFPOOL value ?
> 
> ===
> Zoltan Forray
> Virginia Commonwealth University
> University Computing Center
> e-mail: [EMAIL PROTECTED]
> voice: 804-828-4807

dbsnapshot and drm

[Davidson, Becky]

We just started doing the snapshot backups yesterday and trying to send them
offsite.  I did the move drm wherest=mountable tostate=courier source=dbs
and it moved the snapshot tape to courier and checked it out according to
the activity log.  The tape is now gone from all records.  I can not come up
with a command that shows that tape.  I have tried q drm * and q drm *
source=dbs and it doesn't show up.  It did not move from courier to vault
when I did the move last night.  Any suggestions?  Is this standard?  Have I
missed something?
Thanks
Becky Davidson
Data Manager/AIX Administrator
EDS/Earthgrains
voice: 314-259-7589
fax: 314-877-8589
email: [EMAIL PROTECTED]

TSM Web Client on MS Cluster Node

[Mertens, Chris]

I currently have TSM configured and working properly on a Microsoft Cluster
Server.  I have three nodes configured, one for each computer in the cluster
and a third for the cluster node (shared drives).  We extensively use the
web client on all of our other TSM nodes and would like to be able to use it
for the cluster node as well.  I've been able to configure it on each of the
nodes for the computers in the cluster, but not the cluster node itself.

Any guidance in getting this to work would be appreciated.  Also, we are
running NT 4.0, SP6 and the latest version of the TSM client.

Thank you in advance.


  _

Chris Mertens, MCSE
OA/Division of Information Services
[EMAIL PROTECTED] 

Re: Database entry size for an object

[Andy Raibeck]

Don't forget to take archive objects into account, as well.

Regards,

Andy

Andy Raibeck
IBM Tivoli Systems
Tivoli Storage Manager Client Development
e-mail: [EMAIL PROTECTED]
"The only dumb question is the one that goes unasked."
"The command line is your friend"


"Prather, Wanda" <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 06/27/2001
06:25:35

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

Sent by:  "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>


To:   [EMAIL PROTECTED]
cc:
Subject:  Re: Database entry size for an object


Select count(*) from backups = 28million
DB size (used) = 22GB
1 copy pool (everything copied)

-Original Message-
From: Kelly J. Lipp [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 3:59 PM
To: [EMAIL PROTECTED]
Subject: Database entry size for an object


Anybody have an idea what the true average db entry for an object is?  How
much space is really consumed per database entry for a backup object?
We're
taught 400-800 bytes per entry but this seems high.

Perhaps we can arrive at this empirically by getting an idea from some of
you about how many objects you have in your db and the size of that db.
We'll do math.

I have a customer with about 2 billion files.  We're trying to size a db or
two to back this up.  We're thinking at least four servers to handle this.

So some numbers please: number of items in the database and the db size.

Thanks,

Kelly J. Lipp
Storage Solutions Specialists, Inc.
PO Box 51313
Colorado Springs CO 80949-1313
(719) 531-5926
Fax: (240) 539-7175
Email: [EMAIL PROTECTED] or [EMAIL PROTECTED]
www.storsol.com
www.storserver.com

Database backup performance

[Zoltan Forray/AC/VCU]

Any suggestions on how to improve DB backup performance ?

Doing a FULL DB backup of our 15GB ADSM (yes, not TSM YET. Hoping to
convert to 4.1.3 RSN !!) server, sometimes takes 4-hours.

Since I read a previous message about someone having a 52GB DB, I was
wondering how long it takes to backup that much DB since my meager DB takes
so long ? Note, there is no "operator delay" since it goes to a 3494
ATL, using 3490E drives. I was thinking about moving it to 3590 MAGSTAR but
wasn't sure if it would make much of a difference since the only real
change would be reduction/elimination of tape mounts (currently uses
9-cartridges). Since it is a robot, this would save a few minutes at most.

I have tried increasing the BUFPOOL value (from 32MB to 80MB) with little
noticable improvement. I still haven't reached/sustained the illusive 98%
Cache Utilization !

Since the ADSM address space working set size has often exceed 110MB, I was
wondering what was reasonable (or expected) for thise size DB. How much
further should I increase the BUFPOOL value ?

===
Zoltan Forray
Virginia Commonwealth University
University Computing Center
e-mail: [EMAIL PROTECTED]
voice: 804-828-4807

Re: SQL backup failed.

[Del Hoobler]

Bo,

-2147024891 is AccessDenied.
This is a security/permissions/access rights error code.

Does the SQL Server user id used by TDP for SQL have the
SQL Server SysAdmin Fixed Server Role?

Does the Windows NT user id that actually runs the
scheduler for TDP for SQL have admin authority?

The return code that the scheduler sees from a COMMAND
type schedule is a return code generated from the
command file execution and not the commands that it runs.
To determine success or failure for certain,
examine the sqldsm.log.

Thanks,

Del



Del Hoobler
IBM Corporation
[EMAIL PROTECTED]

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




Bo Nielsen
cc:
Sent by: Subject: SQL backup failed.
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
IST.EDU>


06/27/2001
06:44 AM
Please respond
to "ADSM: Dist
Stor Manager"





Help.

I'm running a backup on a SQL server 7.0.
Sometime everything is OK, but mostly fail some
of the DB's with the follow errors from the SQL log:

BackupVirtualDeviceSet::Initialize: Open failure on backup device
'TDPSQL-sqladsm-2001021544-3180'. Operating system error -2147024891(error
not found).

>From the TSM log:

06/27/2001 02:15:52,Backed up - FMRK, type: DB, size: 231583513, actual
bytes: 0, secs: 0,00, Kb/Sec: 0,00, SQL server: FDB033, TSM server: dsm,
SQL
status: DB-LIB message: Backup or restore operation terminating abnormally.
, TSM status: TSM operation cancelled.

The configuration is:

TSM server OS/390 version 4.1.30
SQL server 7.0 on NT 4 sp5
TDP SQL agent 1.1.2

Why is the scheduled event '  ' completed successfully,
when the backup is terminated for some DB's??

Regards,
Bo Nielsen

FDB dataPhone: +45 4386 4671
Roskildevej 65 Fax: +45 4386 4990
DK-2620 AlbertslundE-mail: [EMAIL PROTECTED]
Denmark

Re: Database entry size for an object

[Prather, Wanda]

Agreed, we do have a trivial amount of archiving on this server, answer is
actually 28.2 million...

-Original Message-
From: Andy Raibeck [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 9:37 AM
To: [EMAIL PROTECTED]
Subject: Re: Database entry size for an object


Don't forget to take archive objects into account, as well.

Regards,

Andy

Andy Raibeck
IBM Tivoli Systems
Tivoli Storage Manager Client Development
e-mail: [EMAIL PROTECTED]
"The only dumb question is the one that goes unasked."
"The command line is your friend"


"Prather, Wanda" <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 06/27/2001
06:25:35

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

Sent by:  "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>


To:   [EMAIL PROTECTED]
cc:
Subject:  Re: Database entry size for an object


Select count(*) from backups = 28million
DB size (used) = 22GB
1 copy pool (everything copied)

-Original Message-
From: Kelly J. Lipp [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 3:59 PM
To: [EMAIL PROTECTED]
Subject: Database entry size for an object


Anybody have an idea what the true average db entry for an object is?  How
much space is really consumed per database entry for a backup object?
We're
taught 400-800 bytes per entry but this seems high.

Perhaps we can arrive at this empirically by getting an idea from some of
you about how many objects you have in your db and the size of that db.
We'll do math.

I have a customer with about 2 billion files.  We're trying to size a db or
two to back this up.  We're thinking at least four servers to handle this.

So some numbers please: number of items in the database and the db size.

Thanks,

Kelly J. Lipp
Storage Solutions Specialists, Inc.
PO Box 51313
Colorado Springs CO 80949-1313
(719) 531-5926
Fax: (240) 539-7175
Email: [EMAIL PROTECTED] or [EMAIL PROTECTED]
www.storsol.com
www.storserver.com

Re: Database entry size for an object

[Prather, Wanda]

Select count(*) from backups = 28million
DB size (used) = 22GB
1 copy pool (everything copied)

-Original Message-
From: Kelly J. Lipp [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 3:59 PM
To: [EMAIL PROTECTED]
Subject: Database entry size for an object


Anybody have an idea what the true average db entry for an object is?  How
much space is really consumed per database entry for a backup object?  We're
taught 400-800 bytes per entry but this seems high.

Perhaps we can arrive at this empirically by getting an idea from some of
you about how many objects you have in your db and the size of that db.
We'll do math.

I have a customer with about 2 billion files.  We're trying to size a db or
two to back this up.  We're thinking at least four servers to handle this.

So some numbers please: number of items in the database and the db size.

Thanks,

Kelly J. Lipp
Storage Solutions Specialists, Inc.
PO Box 51313
Colorado Springs CO 80949-1313
(719) 531-5926
Fax: (240) 539-7175
Email: [EMAIL PROTECTED] or [EMAIL PROTECTED]
www.storsol.com
www.storserver.com

Re: SQL backtrack /ADSM problem

[Davidson, Becky]

We had that problem at ADSM 3.1 on AIX 4.3.3 but only when we did a backup
of the archive logs...the full backups were fine.  We never managed to
resolve that problem we just stopped doing the archive log backups and are
now migrating to Tivoli Data Protection.
Becky Davidson
Data Manager/AIX Administrator
EDS/Earthgrains
voice: 314-259-7589
fax: 314-877-8589
email: [EMAIL PROTECTED]



-Original Message-
From: Jason Jackson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 5:06 PM
To: [EMAIL PROTECTED]
Subject: SQL backtrack /ADSM problem


I am running ADSM 3.7 on AIX 4.3.2 and have intermittant problems with
an Oracle backup.  Oracle is version 8.1.5. We use BMC SQL Backtrack to
backup the Oracle database and move that backup to storage via ADSM.

Once in a while,  I receive errors through SQL backtrack:
[dtodump 180482} DT-01254E: Program error 11 (Segmentation fault),
saving core file in
'/datatools/obacktrack-3.2.80.3/cdump/dtodump-06.18.2001-21:22-180482/core'

According to the logs,  everything is fine with ADSM.

I know DTODUMP is a SQL Backtrack function.  I've been advised to check
the recommended API levels for ADSM to work with this version of SQL
Backtrack. Has anyone else come across similar problems using Backtrack
& ADSM?

Re: TSM and backint success stories

[Loon, E.J. van - SPLXM]

Hi Kevin!
I haven't got the answer for you, but I agree with you on the price thing.
However, Backint has reached it's end-of-service date at December 2000. You
are now using a software level that's "not supported"...
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines


-Original Message-
From: Kevin Wagner [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 13:06
To: [EMAIL PROTECTED]
Subject: TSM and backint success stories


 Has anyone had any success backing up SAP R3 online tablespaces to a TSM
 server using backint versus Data Protection?
 I haven't seen definitive answers as to whether backint will still work
(i.e.a supported configuration).  I'd hate to think that TDP for SAP is the
only way to run online backups of an SAP ORACLE database.
We are going to upgrade (finally) from ADSM Server 3.1.20 to TSM 4.1, and
we'd like to keep our backint product, especially given the hefty price tag
of the TDP option.

 I'd appreciate any success stories that anyone knows about.  I searched
the archives, but didn't see anything recent there.

 Thanks.

 --k


**
This e-mail and any attachment may contain confidential and privileged material 
intended for the addressee only. If you are not the addressee, you are notified that 
no part of the e-mail or any attachment may be disclosed, copied or distributed, and 
that any other action related to this e-mail or attachment is strictly prohibited, and 
may be unlawful. If you have received this e-mail by error, please notify the sender 
immediately by return e-mail, and delete this message. Koninklijke Luchtvaart 
Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for 
the incorrect or incomplete transmission of this e-mail or any attachments, nor 
responsible for any delay in receipt.
**

Re: SQL Server Disaster Recovery question

[Del Hoobler]

Ruddy,

The piece that I didn't see you mention was
restoring the "msdb" database. That is necessary.
See Appendix B of the TDP for SQL V1 User's Guide.

Also, take a look at the new TDP for SQL Redbook
for more details on using TDP for SQL for disaster recovery.
The redbook examples show the restore using TDP for SQL 2.2
but, you can at least follow the general process used.
You can find it at:

   www.redbooks.ibm.com

Or... here is a direct link:

   http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg246148.pdf

Thanks,

Del



Del Hoobler
IBM Corporation
[EMAIL PROTECTED]

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




Ruddy STOUDER
   cc:
Sent by: "ADSM:  Subject: SQL Server Disaster Recovery 
question
Dist Stor Manager"
<[EMAIL PROTECTED]
EDU>


06/27/2001 07:38
AM
Please respond to
"ADSM: Dist Stor
Manager"





Hello,

I made a full NT Server Disaster Recovery. According to the
documentation, after the recovery:

- I made a rebuild of the SQL tables
- I restarted the SQL Server in single user mode
- With TDP for SQL 1.1.1, I restored the master.dat file
- I tried to restart the SQL server and it fails ...

The same table beeing used for master.dat and model.dat, I tried :

- I made a rebuild of the SQL tables
- I restarted the SQL Server in single user mode
- With TDP for SQL 1.1.1, I restored the master.dat and model.dat files
- I tried to restart the SQL server and it fails with the following
error messages ...

...
01/06/14 13:47:58.48 spid1Activating disk 'AMX_Data'
01/06/14 13:47:58.51 kernel   udopen: operating system error 2(The
system cannot find the file specified.) during the creation/opening of
physical device G:\MsSql\SQLserver Data Devices\AMX_Data.DAT
01/06/14 13:47:58.57 kernel   udactivate (primary): failed to open
device G:\MsSql\SQLserver Data Devices\AMX_Data.DAT for vdn 10
01/06/14 13:47:58.62 spid1Activating disk 'AMX_Log'
01/06/14 13:47:58.64 kernel   udopen: operating system error 2(The
system cannot find the file specified.) during the creation/opening of
physical device E:\MsSql\SQLserver Log Devices\AMX_Log.DAT
01/06/14 13:47:58.71 kernel   udactivate (primary): failed to open
device E:\MsSql\SQLserver Log Devices\AMX_Log.DAT for vdn 11
01/06/14 13:47:58.74 spid1Activating disk 'Dev_Device_Data'
01/06/14 13:47:58.78 kernel   udopen: operating system error 2(The
system cannot find the file specified.) during the creation/opening of
physical device G:\MsSql\SQLserver Data Devices\Dev_Device_Data.DAT
...

Many thanks in advance for your help ...


Ruddy Stouder
Senior System Engineer
TSM Certified Consultant
I.R.I.S.
Rue du Bosquet 10 - Parc Scientifique de
Louvain-La-Neuve
B-1348 Mont-Saint-Guibert
[EMAIL PROTECTED]

Tel: +32 (0)10 48 75 10  -  Fax: +32 (0)10 48 75
40

Re: SQL backup failed.

[Loon, E.J. van - SPLXM]

Hi Bo!
Check the tdpsql.log, the dsierror.log and the dsmerror.log. Maybe you will
find more usefull information there?
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines


-Original Message-
From: Bo Nielsen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 12:44
To: [EMAIL PROTECTED]
Subject: SQL backup failed.
Importance: High


Help.

I'm running a backup on a SQL server 7.0.
Sometime everything is OK, but mostly fail some
of the DB's with the follow errors from the SQL log:

BackupVirtualDeviceSet::Initialize: Open failure on backup device
'TDPSQL-sqladsm-2001021544-3180'. Operating system error -2147024891(error
not found).

>From the TSM log:

06/27/2001 02:15:52,Backed up - FMRK, type: DB, size: 231583513, actual
bytes: 0, secs: 0,00, Kb/Sec: 0,00, SQL server: FDB033, TSM server: dsm, SQL
status: DB-LIB message: Backup or restore operation terminating abnormally.
, TSM status: TSM operation cancelled.

The configuration is:

TSM server OS/390 version 4.1.30
SQL server 7.0 on NT 4 sp5
TDP SQL agent 1.1.2

Why is the scheduled event '  ' completed successfully,
when the backup is terminated for some DB's??

Regards,
Bo Nielsen

FDB dataPhone: +45 4386 4671
Roskildevej 65 Fax: +45 4386 4990
DK-2620 AlbertslundE-mail: [EMAIL PROTECTED]
Denmark


**
This e-mail and any attachment may contain confidential and privileged material 
intended for the addressee only. If you are not the addressee, you are notified that 
no part of the e-mail or any attachment may be disclosed, copied or distributed, and 
that any other action related to this e-mail or attachment is strictly prohibited, and 
may be unlawful. If you have received this e-mail by error, please notify the sender 
immediately by return e-mail, and delete this message. Koninklijke Luchtvaart 
Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for 
the incorrect or incomplete transmission of this e-mail or any attachments, nor 
responsible for any delay in receipt.
**

SQL Server Disaster Recovery question

[Ruddy STOUDER]

Hello,

I made a full NT Server Disaster Recovery. According to the
documentation, after the recovery:

- I made a rebuild of the SQL tables
- I restarted the SQL Server in single user mode
- With TDP for SQL 1.1.1, I restored the master.dat file
- I tried to restart the SQL server and it fails ...

The same table beeing used for master.dat and model.dat, I tried :

- I made a rebuild of the SQL tables
- I restarted the SQL Server in single user mode
- With TDP for SQL 1.1.1, I restored the master.dat and model.dat files
- I tried to restart the SQL server and it fails with the following
error messages ...

...
01/06/14 13:47:58.48 spid1Activating disk 'AMX_Data'
01/06/14 13:47:58.51 kernel   udopen: operating system error 2(The
system cannot find the file specified.) during the creation/opening of
physical device G:\MsSql\SQLserver Data Devices\AMX_Data.DAT
01/06/14 13:47:58.57 kernel   udactivate (primary): failed to open
device G:\MsSql\SQLserver Data Devices\AMX_Data.DAT for vdn 10
01/06/14 13:47:58.62 spid1Activating disk 'AMX_Log'
01/06/14 13:47:58.64 kernel   udopen: operating system error 2(The
system cannot find the file specified.) during the creation/opening of
physical device E:\MsSql\SQLserver Log Devices\AMX_Log.DAT
01/06/14 13:47:58.71 kernel   udactivate (primary): failed to open
device E:\MsSql\SQLserver Log Devices\AMX_Log.DAT for vdn 11
01/06/14 13:47:58.74 spid1Activating disk 'Dev_Device_Data'
01/06/14 13:47:58.78 kernel   udopen: operating system error 2(The
system cannot find the file specified.) during the creation/opening of
physical device G:\MsSql\SQLserver Data Devices\Dev_Device_Data.DAT
...

Many thanks in advance for your help ...


Ruddy Stouder
Senior System Engineer
TSM Certified Consultant
I.R.I.S.
Rue du Bosquet 10 - Parc Scientifique de
Louvain-La-Neuve
B-1348 Mont-Saint-Guibert
[EMAIL PROTECTED]

Tel: +32 (0)10 48 75 10  -  Fax: +32 (0)10 48 75
40

TSM and backint success stories

[Kevin Wagner]

 Has anyone had any success backing up SAP R3 online tablespaces to a TSM
 server using backint versus Data Protection?
 I haven't seen definitive answers as to whether backint will still work
(i.e.a supported configuration).  I'd hate to think that TDP for SAP is the
only way to run online backups of an SAP ORACLE database.
We are going to upgrade (finally) from ADSM Server 3.1.20 to TSM 4.1, and
we'd like to keep our backint product, especially given the hefty price tag
of the TDP option.

 I'd appreciate any success stories that anyone knows about.  I searched
the archives, but didn't see anything recent there.

 Thanks.

 --k

SQL backup failed.

[Bo Nielsen]

Help.

I'm running a backup on a SQL server 7.0.
Sometime everything is OK, but mostly fail some
of the DB's with the follow errors from the SQL log:

BackupVirtualDeviceSet::Initialize: Open failure on backup device
'TDPSQL-sqladsm-2001021544-3180'. Operating system error -2147024891(error
not found).

>From the TSM log:

06/27/2001 02:15:52,Backed up - FMRK, type: DB, size: 231583513, actual
bytes: 0, secs: 0,00, Kb/Sec: 0,00, SQL server: FDB033, TSM server: dsm, SQL
status: DB-LIB message: Backup or restore operation terminating abnormally.
, TSM status: TSM operation cancelled.

The configuration is:

TSM server OS/390 version 4.1.30
SQL server 7.0 on NT 4 sp5
TDP SQL agent 1.1.2

Why is the scheduled event '  ' completed successfully,
when the backup is terminated for some DB's??

Regards,
Bo Nielsen

FDB dataPhone: +45 4386 4671
Roskildevej 65 Fax: +45 4386 4990
DK-2620 AlbertslundE-mail: [EMAIL PROTECTED]
Denmark

NT Blue Screens ( because TSM ?)

[Michel David]

Hi everybody and thank you for precedent help !

Wr work on NT 4.0 SP5,
TSM 3.7.4 : using API Client on the same computer

We get anormal quantity of DISK ERRORS (found with
checkdsk) and blue screen where the TSM runs

Does someone has an idea ?

Thank you very much

Michel

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/

backup Informix via onbar - 64bit

[Kurt Beyers]

Hello everybody,

My environment is the following:TSM Server 3.7.0 on NT
ADSM client 3.1.0.8 on HP-UX
Informix 9.21 FC 5.1 running on the HP-UX box

I've got the following issue with the integration ADSM / TSM / Informix.I've
followed the steps decribed in the redbook "Using ADSM to backup databases"
and then tried to  take a full backup of my database. In the bar_act.log, I
get the following output:

 2001-06-20 11:14:56 2755  2750
/usr/informix/openspec/ix_release/bin/onbar_d -b -w
 2001-06-20 11:14:56 2755  2750 Logical Logs will not be backed up because
LTAPEDEV value is /dev/null
 2001-06-20 11:14:56 2755  2750 An unexpected error occurred:   .
 2001-06-20 11:14:56 2755  2750 Could not open XBSA library
/usr/adsm/api/libXApi.sl, so trying default path.
 2001-06-20 11:14:56 2755  2750 An unexpected error occurred:   .
  2001-06-20 11:14:59 2755  2750 XBSA Error (BSAInit): An unspecified XBSA
error has occured: 133
 2001-06-20 11:15:06 2755  2750 Unable to start the storage space backup:
buc_fe.c : Archive API processing failed at line 256 for rc2.
 2001-06-20 11:15:12 2755  2750 Unable to start the storage space backup:
Another archive is already in progress on DBspace rootdbs..
 2001-06-20 11:15:17 2755  2750
/usr/informix/openspec/ix_release/bin/onbar_d complete, returning 131 (0x83)

The library libXApi.sl can't be opened. After some research I've found the
following. The ADSM client, Informix and the operating system are all 64
bits, however the API and hence the library is 32 bits. This explains the
communication error.

I've asked IBM to provide me the 64bits library of libXApi.sl, but all they
can say is 'You should use the TDP for Informix' and they don't seem to know
if a 64bits library exists?

Is anybody taking a backup of a 64bits version of Informix via onbar? Where
can I find the 64 bits version of the library libXApi.sl ?

Any input would be greatly appreciated,

Kurt Beyers
System Engineer Unix
Dolmen

unsubscribe

[Nick Saund]

This document should only be read by those persons to whom it is
addressed and is not intended to be relied upon by any person
without subsequent written confirmation of its contents.
Bankgesellschaft Berlin AG accepts no liability for the
consequences for any person acting, or refraining from acting,
on such information prior to the receipt by those persons of
subsequent written confirmation.

If you have received this E-mail message in error, please notify
the Sender immediately by telephone. Please also delete the
message from your computer.

Any form of reproduction, dissemination, copying, disclosure,
modification, distribution and/or publication of this E-mail
message is prohibited.