I seem to recall that SQL Backtrack had an outstanding problem with memory
leaks. You might want to check with BMC.
----- Forwarded by S W Branch/PPCO on 05/11/2001 09:46 AM -----
Lindsay Morris <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
05/11/2001 09:15 AM
Any replies will be addressed to: lmorris
To: [EMAIL PROTECTED]
cc:
Subject: Re: TSM Client/AIX/Sybase paging space problem
I could kind of understand it it the SQLBT backup was causing Sybase to use
more paging space.
It's hard to see how the filesystem's incremental backup could.
Might it be the former instead of the latter?
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
David Longo
Sent: Friday, May 11, 2001 9:43 AM
To: [EMAIL PROTECTED]
Subject: TSM Client/AIX/Sybase paging space problem
We have a new installation that has problems in that paging space continues
to grow until it hits 100% over about 8-10 days. Having setup a cron job
on
AIX that logs paging every 5 minutes, I determined that essentially the
only
time paging space increases is when backups are running. We reboot to
clear
problem.
Details:
TSM Server is 3.7.4.0 on AIX 4.3.3
Client is:
IBM RS/6000 Silver SP node w 2x 332 MHz processors and 1GB RAM and 1GB
paging space. (Node is standalone and not "fenced".)
AIX 4.3.3. Maint Level 7
Sybase ASE 12.0.0.1 (Using raw logical volumes for db - vendor insisted on
this)
SQL Backtrack 4.5.00 with OBSI module 2.5.00
TSM Client 4.1.2.0
The paging space will jump up about 4 -8 % per day. I do SQLBT backup of
database at 12:15 am and regular FS incremental at 2:15 am. Paging space
incresases when each backup starts and does not go down.
I saw info on Tivoli site that TSM client 4.1.0.0 (which I was using) had
memory leak problems on NT and possibly other platforms, so I downloaded
what I saw as latest AIX version, 4.1.2.0 and installed - no change.
I have 4.1.0.0 on other AIX and NT boxes with no problems.
We had ML 6 of AIX on and was happening with it too, upgraded to ML 7 for
other reasons and no change.
This is a new install, users not on system yet, Database is getting info
from another system and apps are being developed to generate reports from
this DB.
Last night I disabled both backups and NO PAGING SPACE increase occured.
One other bit of info (maybe confusing). Using the svmon command, it seems
to indicate that Sybase is the user of the growing paging space!
Any ideas folks? It is not obvious to me how a regular FS incremental can
cause Sybase to use additional paging space.
If no one has a solution I will open a ticket with Tivioli to start with
and
then proceed down the line one vendor at a time.
Thanks for your head scratching,
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]
"MMS <health-first.org>" made the following
annotations on 05/11/01 09:44:40
----------------------------------------------------------------------------
--
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.
============================================================================
==
