Add or Reduce Filesystem size in AIX

In AIX operating systems we can change the FS size whenever we want it to do but for that we need to check that the Volume Group associated to that FS have Free space or Free PP's.

Steps to Change FS size :-

We are adding 2g Space in /home FS . PFB steps :-

1. Check that the Volume Group have free space available :-

We can see that Free PP's are only 896 MB. We have to free some space from available FS in the Volume Group.

2. Free some space from other FS in this Volume Group so that we can add 2g space in /home partition.

This can be done by CHFS command.

3. Now check Free PP's in the Volume group :-

We can see that around 3g space is availabe in rootvg. Now add 2g space in /home partition using CHFS command.

2 gb space has been added to /home partition.

I hope this article helped you.

Regards,

Amit Rath

Client Side Connect Time Load Balance and Connect Time Fail Over

Client Side Connect Time Load Balance :-

By definition it says that when more than one listener services a single database , then a client while at the time of connect can randomly choose between the listeners for its connect request. This selection is random, its not depend on the load on any of the instances. This random selection enables all listeners to share the load of servicing incoming connect requests.

TNS_PARAMETER to enable this is LOAD_BALANCE.

(LOAD_BALANCE=YES) instructs SQLNet to progress through the list of listeners randomly, balancing load on various listeners. When set to NO then SQLNet tries the address sequentially until connection with one listener succeeds

Parameter should be correctly coded in the net service name connect descriptor. If in ADDRESS_LIST, then (LOAD_BALANCE=YES) should be written within ADDRESS_LIST. If ADDRESS_LIST is not used then it has to be in DESCRIPTION portion.

Sample of TNS net service alias for Client Side Connect Time Load Balance :-

LOADBALANCE=
 (DESCRIPTION =
  (LOAD_BALANCE = yes)
  (ADDRESS = (PROTOCOL = TCP)(HOST = host1-vip)(PORT = 1522))
  (ADDRESS = (PROTOCOL = TCP)(HOST = host2-vip)(PORT = 1522))
  (CONNECT_DATA =
   (SERVICE_NAME = DATABASE)
  )
 )

Client Side Connect Time Failover :- 

Client side Connnect Time Failover enables clients to connect to another listener when the first connection to first listener fails. How many listeners will be tried out in this depends on the number of listener addresses.

Without Connect time failover once a client connection fails with a listener, it retries with that listener only till it connects with that. 

TNS Parameter for Connect time failover is FAILOVER. Default value of this is on.

(failover=on) is default for ADDRESS_LISTs and DESCRIPTION_LISTs , so we do not need to explicitly specify this parameter to put it on.

Sample for TNS net service alias for Client Side Connect time Failover :-

FAILOVER=  
(DESCRIPTION =  
 (ADDRESS_LIST =  
 (ADDRESS = (PROTOCOL = TCP)(HOST = host1-vip)(PORT = 1522))
  (ADDRESS = (PROTOCOL = TCP)(HOST = host2-vip)(PORT = 1522))  
 )  
 (CONNECT_DATA =  
   (SERVICE_NAME = DATABASE)  
 )  
)

Sample for TNS net service alias having both Client Side Connect time Load balancing and Failover :-

LOAD_WITH_FAILOVER= 
(DESCRIPTION =  
 (ADDRESS_LIST =  
  (LOAD_BALANCE = yes)  
  (ADDRESS = (PROTOCOL = TCP)(HOST = host1-vip)(PORT = 1522))
  (ADDRESS = (PROTOCOL = TCP)(HOST = host2-vip)(PORT = 1522)) 
 )  
 (CONNECT_DATA =  
  (SERVICE_NAME = DATABASE)  
 )  
) 

The above configuration is for Client Side Load Balancing. PFB link to configure Server Side Load Balancing.

I hope this article helped you

Regards,
Amit Rath