Extending database filesystem


 
Thread Tools Search this Thread
Operating Systems AIX Extending database filesystem
# 1  
Old 04-16-2010
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
Code:
/dev/fslv83      12582912    232244   99%       10     1% /gtp/db/ORGTDGP/data/dat01

The LV is a member of the volume group gtpdg01xpe
Code:
# 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.

Code:
# 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

Last edited by Scott; 04-16-2010 at 08:19 PM.. Reason: Code tags, please...
# 2  
Old 04-16-2010
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.
# 3  
Old 04-16-2010
I wouldn't shutdown the Database to do the extend, and as the previous poster said I'd make the change by doing.
Code:
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.
# 4  
Old 04-16-2010
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.

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

Success!
Thanks again.

Last edited by Scott; 04-16-2010 at 08:19 PM.. Reason: Code tags, please...
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Red Hat

Error while extending logicalvolume

Hello all, I tried to extend my lvm today, found the following error, lvextend -L +10G /dev/vg/a Extending logical volume a to 60.21 GB device-mapper: reload ioctl failed: Invalid argument Failed to suspend a Any help (7 Replies)
Discussion started by: gull05
7 Replies

2. Red Hat

Extending swap space

I've to install Oracle binaries (I'm oracle DBA) and for that I've extend swap space in my home computer. My situation is like this. # parted -s /dev/sda print free Model: ATA VBOX HARDDISK (scsi) Disk /dev/sda: 38.7GB Sector size (logical/physical): 512B/512B Partition Table: msdos ... (8 Replies)
Discussion started by: Mukul Sharma
8 Replies

3. Red Hat

Extending swap space

I've to install Oracle binaries (I'm oracle DBA) and for that I've extend swap space in my home computer. My situation is like this. # parted -s /dev/sda print free Model: ATA VBOX HARDDISK (scsi) Disk /dev/sda: 38.7GB Sector size (logical/physical): 512B/512B Partition Table: msdos ... (1 Reply)
Discussion started by: Mukul Sharma
1 Replies

4. HP-UX

Extending file system in HP-UX

Hi Guys, Hope everyone is doing great. We've few servers on HP-UX. I'm not sure of extending file systems in HP-UX. Please help me. It could be helpful If you provide the commmand basing on the details below. Thanks in Advance. # hostname ******* # date Sun Sep 7 14:39:59 EDT 2014 #... (2 Replies)
Discussion started by: vamshigvk475
2 Replies

5. Red Hat

LVM- extending PV

Hi All, I have one VG on single PV /dev/sda3 with two LV Physically after /dev/sda3 i have 40G unallocated I want to extend /dev/sda3 + 40G and extend its VG, then extend last LV in VG to take new free space What is correct procedure? // I cannot create second PV after /dev/sda3 because of... (5 Replies)
Discussion started by: kactech
5 Replies

6. AIX

Mount Filesystem in AIX Unable to read /etc/filesystem

Dear all, We are facing prolem when we are going to mount AIX filesystem, the system returned the following error 0506-307The AFopen call failed : A file or directory in the path name does not exist. But when we ls filesystems in the /etc/ directory it show -rw-r--r-- 0 root ... (2 Replies)
Discussion started by: m_raheelahmed
2 Replies

7. UNIX for Dummies Questions & Answers

hwo to find shared filesystem and local filesystem in AIX

Hi, I wanted to find out that in my database server which filesystems are shared storage and which filesystems are local. Like when I use df -k, it shows "filesystem" and "mounted on" but I want to know which one is shared and which one is local. Please tell me the commands which I can run... (2 Replies)
Discussion started by: kamranjalal
2 Replies

8. AIX

Extending filesystems

Hi to all i want to increase the /usr size. but, it is mirrored on hdisk0 and hdisk1. i know that chfs will work, but i am not confident about mirroring. can anyone tell me the procedure. thanks (2 Replies)
Discussion started by: honeym210
2 Replies

9. UNIX for Advanced & Expert Users

I need some help matching my file database to my filesystem.

Hi There I have a big problem, but maybe a simple question. I'm attempting something that is turning out to be a huge job, but maybe it could be simpler if I knew some more advanced commands or techniques. My problem is this: I work for a company that has a primary file server with 27T... (2 Replies)
Discussion started by: charlesm
2 Replies

10. Programming

Help in extending netfilter

Hi everybody, I have to write a module for matching in netfilter , extending the netfilter but I'm facing some problems can somebody guide me in that. I know that I need to write matching module working in kernel space and a program in userspace. I went through the HOWTO on netfilter-hacking but... (0 Replies)
Discussion started by: Trusted Penguin
0 Replies
Login or Register to Ask a Question