Extending database filesystem

Ok, I'm a newbie to AIX so I just want to make sure my thinking is correct with regards to this issue. Any insight you guys could give would be appreciated. A main question I have is should I shutdown the database to extend this LV?

The filesystem the dba wants to extend is

/dev/fslv83      12582912    232244   99%       10     1% /gtp/db/ORGTDGP/data/dat01

The LV is a member of the volume group gtpdg01xpe

# lslv fslv83
LOGICAL VOLUME:     fslv83                 VOLUME GROUP:   gtpdg01xpe
LV IDENTIFIER:      00c704d200004c000000011f658be445.4 PERMISSION:     read/write
VG STATE:           active/complete        LV STATE:       opened/syncd
TYPE:               jfs2                   WRITE VERIFY:   off
MAX LPs:            512                    PP SIZE:        128 megabyte(s)
COPIES:             1                      SCHED POLICY:   parallel
LPs:                99                     PPs:            99
STALE PPs:          0                      BB POLICY:      relocatable
INTER-POLICY:       minimum                RELOCATABLE:    yes
INTRA-POLICY:       middle                 UPPER BOUND:    32
MOUNT POINT:        /gtp/db/ORGTDGP/data/dat01 LABEL:          /gtp/db/ORGTDGP/data/dat01
MIRROR WRITE CONSISTENCY: on/ACTIVE
EACH LP COPY ON A SEPARATE PV ?: yes
Serialize IO ?:     NO

The PP size for this LV is 128MB, so that means I need 64 PPs to increase the file system by 8GB.

There are currently 107 free PPs in the volume group gtpdg01xpe so I should be able to extend the file system without adding additional space.

# lspv hdisk4
PHYSICAL VOLUME:    hdisk4                   VOLUME GROUP:     gtpdg01xpe
PV IDENTIFIER:      00c704d2658be3fb VG IDENTIFIER     00c704d200004c000000011f658be445
PV STATE:           active
STALE PARTITIONS:   0                        ALLOCATABLE:      yes
PP SIZE:            128 megabyte(s)          LOGICAL VOLUMES:  10
TOTAL PPs:          539 (68992 megabytes)    VG DESCRIPTORS:   2
FREE PPs:           107 (13696 megabytes)    HOT SPARE:        no
USED PPs:           432 (55296 megabytes)    MAX REQUEST:      256 kilobytes
FREE DISTRIBUTION:  00..00..00..00..107
USED DISTRIBUTION:  108..108..107..108..01

# lsvg -p gtpdg01xpe
gtpdg01xpe:
PV_NAME           PV STATE          TOTAL PPs   FREE PPs    FREE DISTRIBUTION
hdisk4            active            539         107         00..00..00..00..107

The command to increase the file system 8GB would be:
extendlv fslv83 64

Technically, extendlv will extend the LV. chfs will extend the LV and grow the filesystem.

You are correct on the LPs. The LV is not mirrored, so it will take only one PP per LP.

As a side note, I tend to use the free PP/LP numbers in lsvg, rather than look for the disk in the VG and then look for the free PP/LPs there.

---------- Post updated at 02:29 PM ---------- Previous update was at 02:26 PM ----------

Oh... and to your original question about shutting down the DB. It should not be necessary, but it may be best to do this in a window (non-production hours).

The fact that this filesystem is so full *may* be problematic.

I wouldn't shutdown the Database to do the extend, and as the previous poster said I'd make the change by doing.

chfs -a size=+8G /gtp/db/ORGTDGP/data/dat01

I've always looked at lsvg gtpdg01xpe to see how much space is left in the VG.

Thanks wfavorite and ross

The dba wanted to make the change while the database was still up.
I took both or your suggestions and used the chfs command.

chfs -a size=+8G "filesystem name"

Success!
Thanks again.