12-27-2011
Going nuts on this problem... anyone?
If not, how can I set a script that runs automatically on every OS start to ensure the aggregate is up?
Thanks,
Cap'
10 More Discussions You Might Find Interesting
1. Solaris
Hi Guru's
Can any want here could explain to me the different between soft reboot and hard reboot .
Best Regards
Seelan (3 Replies)
Discussion started by: seelan3
3 Replies
2. UNIX for Advanced & Expert Users
Hey folks,
i need communicate between 2 processes in a reliable manner. The information delivery has to be guarenteed. I thought about proc 2 sending a signal to proc 1 when information has being written to disc and wirte() has been verified (sync/flush). The IPC method for the data is named... (4 Replies)
Discussion started by: heck
4 Replies
3. Shell Programming and Scripting
I found a way to make a numeric variable persistent for a script :
#!/bin/bash
function Persist() { # 1:Expression like VARIABLE=Value (numeric)
local V=${1%=*}
eval "$1"
sed -i "s/^$V=*/$1/" $(which $(basename $0)) || return 1
}And how to use itAA=12
read -p "Enter a... (2 Replies)
Discussion started by: frans
2 Replies
4. AIX
Hi,
I want to use the service IP incase for any network activity rather than the persistent IP as the Persistent IP is blacklisted in our network. Is there any way
to make the service ip as LPARs default IP to be used as the lpars source IP incase it pings anything or acceses any external... (6 Replies)
Discussion started by: aixromeo
6 Replies
5. AIX
i am trying to make HACMP but when i add a persistent ip, error shows unable to determine address for 'UPIDGIS1_pers'
pls help me out
AIX - 5.3
HACMP -5.4
thanks (2 Replies)
Discussion started by: reply.ravi
2 Replies
6. AIX
I am new in AIX and please forgive my poor english.
I know that AIX allow same subnet IPs for different interfaces, which result in multipath routing / route striping.
My question is,
is there any best practice for the persistent and service IP with same subnet to stay on same interface, or... (5 Replies)
Discussion started by: skeyeung
5 Replies
7. War Stories
:wall::wall::wall::wall:
I am sharing some techno-geeky-work related issue, which can best be dissected here only.
I am expecting more of a discussion,as serious as when two guys sharing experience over smoke and beer.
The thing is, till now i have been only a student, so never cared about how... (10 Replies)
Discussion started by: animesharma
10 Replies
8. Programming
I noticed that when attempting to download videos from the url, I receive a 403 forbidden when I get through to a certain point in my downloads. I can download a third of the videos but will error:
Retrieving file 'blah-video.f4v'...
Traceback (most recent call last): ... (0 Replies)
Discussion started by: metallica1973
0 Replies
9. AIX
I have done other clusters (HP MC/Service Guard and oracle Clusters, and RHEL Cluster services), and have good idea about hacmp (a little older knowledge).
However the term "Boot IP" for some reason is messing with my head. Have not done HACMP since the 4.1.2.X days.
Is the Bootip the... (1 Reply)
Discussion started by: mrmurdock
1 Replies
10. Solaris
Hi,
I am trying to create aggregation by using dladm, But am getting the following error.
dladm create-aggr -P L2 -l net2 sumaggr2
dladm: create operation failed: link busy
I have checked in dladm show-link and the state is "down"..
dladm show-link | grep ^net2
net2 phys ... (1 Reply)
Discussion started by: Sumanthsv
1 Replies
LEARN ABOUT SUSE
alter_aggregate
ALTER
AGGREGATE(7) SQL Commands ALTER AGGREGATE(7)
NAME
ALTER AGGREGATE - change the definition of an aggregate function
SYNOPSIS
ALTER AGGREGATE name ( type [ , ... ] ) RENAME TO new_name
ALTER AGGREGATE name ( type [ , ... ] ) OWNER TO new_owner
ALTER AGGREGATE name ( type [ , ... ] ) SET SCHEMA new_schema
DESCRIPTION
ALTER AGGREGATE changes the definition of an aggregate function.
You must own the aggregate function to use ALTER AGGREGATE. To change the schema of an aggregate function, you must also have CREATE priv-
ilege on the new schema. To alter the owner, you must also be a direct or indirect member of the new owning role, and that role must have
CREATE privilege on the aggregate function's schema. (These restrictions enforce that altering the owner doesn't do anything you couldn't
do by dropping and recreating the aggregate function. However, a superuser can alter ownership of any aggregate function anyway.)
PARAMETERS
name The name (optionally schema-qualified) of an existing aggregate function.
type An input data type on which the aggregate function operates. To reference a zero-argument aggregate function, write * in place of
the list of input data types.
new_name
The new name of the aggregate function.
new_owner
The new owner of the aggregate function.
new_schema
The new schema for the aggregate function.
EXAMPLES
To rename the aggregate function myavg for type integer to my_average:
ALTER AGGREGATE myavg(integer) RENAME TO my_average;
To change the owner of the aggregate function myavg for type integer to joe:
ALTER AGGREGATE myavg(integer) OWNER TO joe;
To move the aggregate function myavg for type integer into schema myschema:
ALTER AGGREGATE myavg(integer) SET SCHEMA myschema;
COMPATIBILITY
There is no ALTER AGGREGATE statement in the SQL standard.
SEE ALSO
CREATE AGGREGATE [create_aggregate(7)], DROP AGGREGATE [drop_aggregate(7)]
SQL - Language Statements 2010-05-14 ALTER AGGREGATE(7)