ADSM-L

Re: Moving tivoli's database (UNIX)

2002-08-22 03:20:23
Subject: Re: Moving tivoli's database (UNIX)
From: Zlatko Krastev/ACIT <acit AT ATTGLOBAL DOT NET>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 22 Aug 2002 10:16:42 +0300
Your calculator is fine but it would be a hard job.
- DB volumes occupy ~6GB (6000 MB not 6144), DB is assigned to 4000 MB of
which 1304 are not used. Total used space (without spare room for
anything) is ~= 2700 MB.
- rootvg is having 1376 MB in unallocated partitions (the line from `lsvg
rootvg`),  / filesystem is having 1.3 GB free and /usr can be reduced with
more than 0.55 GB. I do not know why they have grown so much but can be
reduced only by re-installing AIX on the node (from mksysb for example).
Look carefully at /usr usage - uninstall of some never-used html filesets,
CDE (if not used), many unnecessary devices.* filesets, etc. can give you
much more space. Also commit of filesets would also free some space. Look
in `lslpp -L` in detail and you probably will find something to uninstall.
So if reduction of rootvg usage in "another story" suceeds it would be
possible to put DB in rootvg.
BUT (!!!) it would fit without mirroring (except if / and /usr are
mirrored now). It is possible if you have only one disk in wide node to
put second one (as David pointed wide nodes have room for two internal
disks). Other option is to replace disks with bigger ones during AIX
re-install (or no re-install if are big enough).
TSM unload/load DB can recover additional 450-490 MB ( (1024-575 pages) *
4kB = 1796 MB not used; 1796 - 1304 = 492 MB from reorg).
Conclusion: 2300 MB used (575 000 pages) can fit in rootvg freed space
(1376 + 1382 +  553 = 3311 MB) only without mirroring and with enough
space for minor DB expansion. If / and /usr are mirrored their reduction
will give enough for very tight DB fit ( (1376 + 2x1382 +  2x553) / 2 =
5246 / 2 = 2623 MB).

Zlatko Krastev
IT Consultant




Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Sent by:        "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To:     ADSM-L AT VM.MARIST DOT EDU
cc:

Subject:        Re: Moving tivoli's database (UNIX)

Unless my calculator has slipped a decimal point, it won't fit
with a shoehorn and a big hammer!  Need 6GB + for your DB.
Also what happens if you do an AIX or PSSP upgrade?  No room!!!

It's not considered good TSM practice either even if it would fit.
Just guessing that this is a "wide node" and you have 2 internal disks
for rootvg, then you can add two more for the DB by itself.  Get two
and big enough for expansion.  You should use mirroring but TSM
mirroring not AIX mirroring.  There have been a few discussions on
this in the past as it provides more protection.

If no room internally, then either tell them you need some other
external disks or stay on EMC!  Don't put your DB on some cheap
disk nobody else wanted for their system.

David Longo

>>> IFMC.tsarver AT SDPS DOT ORG 08/21/02 05:30PM >>>
Hi all - it's me again...

Environment:
SP Model 9076 (1 Frame w/ 7 nodes)
AIX 4.3.3 ML8
P.S.S.P 3.2
ptfset 8
TSM 4.1.5

Currently our TSM database resides on mirrored EMC disks - I have been
instructed to move TSM's database (yes, just the database) into the
rootvg.  Does anyone have any ideas on how I can do this?

Also, and perhaps more importantly - our rootvg only has approx 2GB avail
(I've been instructed to "reduce" /usr to give it another .5GB - but
that's another story)...so when I get done we'll have approx 3GB free in
rootvg...however, I think our TSM DB is too big for rootvg to begin with.
??  Could someone please review the enclosed info and let me know what you
think?

Thanks in advance for your time;
Theresa

Filesystem Info:
Filesystem    1024-blocks      Free %Used    Iused %Iused Mounted on
/dev/hd4          1523712   1382308   10%     3457     1% /
/dev/hd2          3637248    553124   85%    79072     9% /usr

lsvg rootvg:  FREE PPs:       86 (1376 megabytes)

q db info:

          Available Space (MB): 6,000
        Assigned Capacity (MB): 4,000
        Maximum Extension (MB): 2,000
        Maximum Reduction (MB): 1,304
             Page Size (bytes): 4,096
            Total Usable Pages: 1,024,000
                    Used Pages: 575,056
                      Pct Util: 56.2
                 Max. Pct Util: 58.6
              Physical Volumes: 3
             Buffer Pool Pages: 32,768
         Total Buffer Requests: 34,510,747
                Cache Hit Pct.: 98.87
               Cache Wait Pct.: 0.00
           Backup in Progress?: No
    Type of Backup In Progress:
  Incrementals Since Last Full: 0
Changed Since Last Backup (MB): 35.52
            Percentage Changed: 1.58
Last Complete Backup Date/Time: 08/21/02 09:40:14




q dbvol info:

Volume Name (Copy 1): /tivoli/db/dbb.dsm
         Copy Status: Sync'd
Volume Name (Copy 2):
         Copy Status: Undefined
Volume Name (Copy 3):
         Copy Status: Undefined
Available Space (MB): 2,000
Allocated Space (MB): 2,000
     Free Space (MB): 0

Volume Name (Copy 1): /tivoli/db/dbc.dsm
         Copy Status: Sync'd
Volume Name (Copy 2):
         Copy Status: Undefined
Volume Name (Copy 3):
         Copy Status: Undefined
Available Space (MB): 2,000
Allocated Space (MB): 0
     Free Space (MB): 2,000

Volume Name (Copy 1): /tivoli/db/dba.dsm
         Copy Status: Sync'd
Volume Name (Copy 2):
         Copy Status: Undefined
Volume Name (Copy 3):
         Copy Status: Undefined
Available Space (MB): 2,000
Allocated Space (MB): 2,000
     Free Space (MB): 0



"MMS <health-first.org>" made the following
 annotations on 08/21/2002 08:30:42 PM
------------------------------------------------------------------------------
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.

==============================================================================

<Prev in Thread] Current Thread [Next in Thread>