Tablespace extent in UX Cluster

[Former Member]

We have HP UX System in Cluster , i want to extend one tablespace , i want to know that by extending tablespace can there be any problem in UX System ?

[Former Member]

Now i want to extend PSAPBTABD tablespace & bdf tells -

/dev/vg01/sapreorg 15360000 107234 14299535 1% /oracle/C1P/sapreorg

/dev/vg02/sapdata3 25608192 20222934 5048743 80% /oracle/C1P/sapdata3

/dev/vg02/sapdata4 25608192 20821814 4487286 82% /oracle/C1P/sapdata4

/dev/vg02/sapdata5 10240000 6432023 3570041 64% /oracle/C1P/sapdata5

/dev/vg02/sapdata6 25608192 21965358 3415219 87% /oracle/C1P/sapdata6

/dev/vg02/sapdata7 10240000 4127935 5730065 42% /oracle/C1P/sapdata7

/dev/vg02/sapdata8 10240000 4381255 5492578 44% /oracle/C1P/sapdata8

/dev/vg02/sapdata9 81920000 71051941 10188853 87% /oracle/C1P/sapdata9

/dev/vg03/sapdata2 25608192 16703526 8348189 67% /oracle/C1P/sapdata2

/dev/vg03/sapdata10

30720000 22006963 8168474 73% /oracle/C1P/sapdata10

/dev/vg03/sapdata11

30720000 24531851 5801453 81% /oracle/C1P/sapdata11

/dev/vg03/sapdata12

30720000 29568683 1079424 96% /oracle/C1P/sapdata12

/dev/vg03/sapdata13

30720000 25042707 5322525 82% /oracle/C1P/sapdata13

/dev/vg03/sapdata14

30720000 27789043 2747836 91% /oracle/C1P/sapdata14

& this tablespace has approx 4 GB growth in a month

so , where to add file ?

i have decided sapdata2 where vgdisplay vg03 tells-

VG Name /dev/vg03

VG Write Access read/write

VG Status available, exclusive

Max LV 255

Cur LV 6

Open LV 6

Max PV 16

Cur PV 1

Act PV 1

Max PE per PV 12799

VGDA 2

PE Size (Mbytes) 16

Total PE 12798

Alloc PE 10938

Free PE 1860

Total PVG 0

Total Spare PVs 0

Total Spare PVs in use 0

how much size can i add ?

[JPReyes]

Do you want us to go and do it for you?...

Please read the "Rules of Engagement"

Regards

Juan

[Former Member]

As long as the cluster is properly set up, there won't be any problems.

Of course you have to extend tablespace on that cluster member where sapdata file systems are currently mounted.

hope this helps