08-04-2009
this does not solve purpose
uname -n ==it gives machine name not server name
and
host name == gives current host system
I WANT TO KNOW SERVER NAME
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I don't have root access. How do I find i.p address of our sun server? Thanks. (4 Replies)
Discussion started by: vpotluri
4 Replies
2. UNIX for Dummies Questions & Answers
How can I tell what lpar on AIX is the NFS server? For some reason today I am drawing a blank on what the process name is to search for. (1 Reply)
Discussion started by: vigsgb
1 Replies
3. Solaris
Hi All,
Could any one pls tell me how to find whether a unix server is a stand alone server or its in a cluster.
I need a command through which i can find whether the unix m/c is clustered or not.
Thanx in advance
Regards,
Naveen (1 Reply)
Discussion started by: Naveen Kumar V
1 Replies
4. Solaris
Hi experts
Is there a command or a way in Solaris to find server details like this:
SUN240R
2 @ 160MHz CPU
1Gb memory
Solaris8
lan0 (16SV LAN) 100FD
lan1 (45CI LAN) 100FD
lan2 (8CON LAN) 10HD
lan3 (38SY LAN) 100HD
Thanks (1 Reply)
Discussion started by: lalelle
1 Replies
5. UNIX for Advanced & Expert Users
hi,
how to find whether we are working in keon or non-keon server in unix
thanks in advance (0 Replies)
Discussion started by: trichyselva
0 Replies
6. UNIX for Advanced & Expert Users
hi
is there any way to find out all the shells on server i know bash / ksh are available on all servers but just for Curiosity i want to know .. is there any command for that ???
i can find it out by this
$ /usr/bin >find . -name \*sh
./remsh
./csh
./ksh
./rsh
./chsh
./rksh
./sh... (3 Replies)
Discussion started by: zedex
3 Replies
7. Shell Programming and Scripting
suppose there are in 10 different server
how can i know in which server a process (ex:oracle )is running (6 Replies)
Discussion started by: alokjyotibal
6 Replies
8. Shell Programming and Scripting
Hi All,
Let me know how can i find and delete files from one unix server to another unix server which are 'N' days older.
Please note that I need to delete files on remote unix server.So, probably i will need to use sftp, but question is how can i identify files and folders which are 'N'... (2 Replies)
Discussion started by: sachinkl
2 Replies
9. Shell Programming and Scripting
I have a script, which connecting to remote server and first checks, if the files are there by timestamp. If not I want the script exit without error. Below is a code
TARFILE=${NAME}.tar
TARGZFILE=${NAME}.tar.gz
ssh ${DESTSERVNAME} 'cd /export/home/iciprod/download/let/monthly;... (3 Replies)
Discussion started by: digioleg54
3 Replies
10. How to Post in the The UNIX and Linux Forums
I have a list of servers which has both VIP and normal server. Is there a command to identify which server is a VIP and which is a normal server?
Please help. (1 Reply)
Discussion started by: Usha Rajesh
1 Replies
LEARN ABOUT SUSE
alter_server
ALTER
SERVER(7) SQL Commands ALTER SERVER(7)
NAME
ALTER SERVER - change the definition of a foreign server
SYNOPSIS
ALTER SERVER servername [ VERSION 'newversion' ]
[ OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ) ]
ALTER SERVER servername OWNER TO new_owner
DESCRIPTION
ALTER SERVER changes the definition of a foreign server. The first form changes the server version string or the generic options of the
server (at least one clause is required). The second form changes the owner of the server.
To alter the server you must be the owner of the server. Additionally to alter the owner, you must own the server and also be a direct or
indirect member of the new owning role, and you must have USAGE privilege on the server's foreign-data wrapper. (Note that superusers sat-
isfy all these criteria automatically.)
PARAMETERS
servername
The name of an existing server.
serverversion
New server version.
OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] )
Change options for the server. ADD, SET, and DROP specify the action to be performed. ADD is assumed if no operation is explicitly
specified. Option names must be unique; names and values are also validated using the server's foreign-data wrapper library.
EXAMPLES
Alter server foo, add connection options:
ALTER SERVER foo OPTIONS (host 'foo', dbname 'foodb');
Alter server foo, change version, change host option:
ALTER SERVER foo VERSION '8.4' OPTIONS (SET host 'baz');
COMPATIBILITY
ALTER SERVER conforms to ISO/IEC 9075-9 (SQL/MED).
SEE ALSO
CREATE SERVER [create_server(7)], DROP SERVER [drop_server(7)]
SQL - Language Statements 2010-05-14 ALTER SERVER(7)