Setup time out for few user and number of session per users and group in IBM Netezza

############################################################################Setup time out  for few  user nad number of session per users  and group in IBM Netezza###########################################################################

For User 

SYSTEM(ADM_USR)=> \h alter user
Command:     ALTER USER
Description: Alter properties of a user
Syntax:
ALTER USER username
    [WITH]
     [ PASSWORD [ 'string' | NULL ] ]
     [ IN GROUP group  [, ... ] ]
     [ VALID UNTIL 'date' ]
     [ ROWSETLIMIT integer ]
     [ SESSIONTIMEOUT integer ]
     [ QUERYTIMEOUT integer ]
     [ DEFPRIORITY [ CRITICAL | HIGH | NORMAL | LOW | NONE ] ]
     [ MAXPRIORITY [ CRITICAL | HIGH | NORMAL | LOW | NONE ] ]
     [ IN RESOURCEGROUP resourcegroupname ]
     [ RESET ACCOUNT ]
     [ OWNER TO user_name ]
     [ RENAME TO new_user_name ]
     [ SECURITY LABEL '[level] : [category,]... : [cohort,]... ' ]
     [ AUDIT CATEGORY [ NONE | 'category,...' ] ]
     [ COLLECT HISTORY [ ON | OFF | DEFAULT ] ]
     [ CONCURRENT SESSIONS integer ]
     [ ACCESS TIME [ ALL | DEFAULT | ( access_time,... ) ]
     [ AUTH [ LOCAL | DEFAULT ] ]
     [ EXPIRE PASSWORD ]
access_time:
    DAY [ ALL | day,... ]
            [ START time-literal END time-literal,]... ]


EXAMPLE:-

ALTER USER MJAISWAL WITH SESSIONTIMEOUT 60 QUERYTIMEOUT 120 IN RESOURCEGROUP ACCOUNT CONCURRENT SESSION 5 AUTH LOCAL;


For Groups

SYSTEM(ADM_USR)=> \h alter group
Command:     ALTER GROUP
Description: Alter properties of a group
Syntax:
ALTER GROUP name [WITH]
     [ ROWSETLIMIT integer ]
     [ SESSIONTIMEOUT integer ]
     [ QUERYTIMEOUT integer ]
     [ DEFPRIORITY [ CRITICAL | HIGH | NORMAL | LOW | NONE ] ]
     [ MAXPRIORITY [ CRITICAL | HIGH | NORMAL | LOW | NONE ] ]
     [ RESOURCE MINIMUM resourcePercent ]
     [ RESOURCE MAXIMUM resourcePercent ]
     [ JOB MAXIMUM  integer ]
     [ SYSID gid ]
     [ DROP USER username [, ... ] ]
     [ [ADD] USER username [, ... ] ]
     [ OWNER TO user_name ]
     [ RENAME TO new_grp_name ]
     [ COLLECT HISTORY [ ON | OFF | DEFAULT ] ]
     [ CONCURRENT SESSIONS integer ]
     [ ACCESS TIME [ ALL | day,... ]
            [ [START time-literal END time-literal,]... ] ]

SYSTEM(ADM_USR)=> \q

EXAMPLE:-

ALTER GROUP  ACCOUNT  SESSIONTIMEOUT 60 QUERYTIMEOUT 120  CONCURRENT SESSION 5

RESOURCE MINIMUM 10 RESOURCE MAXIMUM 30;
SYSTEM.ADMIN(ADMIN)=> ALTER GROUP Business_Users JOB MAXIMUM 100;
ALTER GROUP

SYSTEM.ADMIN(ADMIN)=> ALTER GROUP EDW_Users  CONCURRENT SESSIONS 100;

 This doc can be used to setup resource utilization