11-28-2012
DB2 clients use a tcp connection, so you can ssh port-forward your connection if you have ssh login somewhere in the destination secure network area. Howe4ver, many shop policies say it must be all the way to the db2 server host, and most shops do not let general users log in to that host at the shell level, ssh or not.
Cleanest is DB2 has a native secure socket layer interface SSL (confusingly, often also called ssh although there is no shell involved), like https for http:
DB2 Database for Linux, UNIX, and Windows
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I need to connect to DB2 through Unix and check whether the database is up or not. We are planning to use Neon shadow direct to connect to the same. I would like to know how to pass parameters to neon shadow direct. Any guidance/help in this regard would be helpful.
My unix box is AIX 1.
... (3 Replies)
Discussion started by: ranj@tcs
3 Replies
2. Shell Programming and Scripting
I am trying to connect to database db2 through shell script.
The process I am trying is
> db2
It gives me error Access Denied.
While checking for access I have the rights.
Is there ant other way round..?
Please help. (3 Replies)
Discussion started by: ankitgupta
3 Replies
3. Shell Programming and Scripting
Hi All,
I want to connect two tables in DB2 using shell script and then compare the contents of two tables field by field. Could any one please help me in connecting database tables using Unix and retriving data from the same.
Thanks,
Durwas (0 Replies)
Discussion started by: dtidke
0 Replies
4. Shell Programming and Scripting
Can anyone please help me with an unix shell script to connect a DB2 database. My requirement is just to display the no of records present in a table of a DB2 database through Unix Shell script. Thx - Ram (1 Reply)
Discussion started by: onlyraja
1 Replies
5. Shell Programming and Scripting
I want to connect to DB2 database which is mainframes using a unix script and run query and get the result set into the unix box.
Is this acheivable using db2 connect? pls help me with a sample script which can perform the same. (1 Reply)
Discussion started by: midhun19
1 Replies
6. Shell Programming and Scripting
Hi
I am trying to connect to db2 database from Unix shell script (k shell)
I need to catch the status of connect whether it is succesful or not.
----------------------------------------------------------
# Read login credentials for db2
tput clear
echo "Please enter your Userid:\c"... (3 Replies)
Discussion started by: mKarri
3 Replies
7. Shell Programming and Scripting
Hi All,
If someone can help me with password encryption. We have shell scripts that connect to a database using db2 connect and we have the password hardcoded in the script.
Can someone let me know if there's a way to encrypt this password?
I've seen alot of users suggest we create an... (3 Replies)
Discussion started by: rethymno19
3 Replies
8. Shell Programming and Scripting
Guys,
I am trying to write a shell script that connect to wcsprod database and read the query
#!/bin/ksh
sqlplus -s < connect to wcsprod user wcsadm using pwd >
select * from catentry fetch first 1 row only with ur;
databse: wcsprod
user: wcsadm
pwd: pwd
thanks (1 Reply)
Discussion started by: skatpally
1 Replies
9. Shell Programming and Scripting
Hi
i m trying to connect DB2 via unix. it is successfully connect. but the connect is getting disconnect .
below is the query ,
countvalue=$(db2 "connect to <Database> user <username> using <Password>" | db2 -x 'select count(*) from <tablename>' ); echo $countvalue
while... (2 Replies)
Discussion started by: baskivs
2 Replies
10. UNIX for Dummies Questions & Answers
I am new to Putty, Unix and DB2 and this is what I am working on right now.
I installed Putty
I got access to username / pwd
I got Unix usrname/Pwd.also got the home directory
once I login into putty I get the screen and it shows $ sign
From here how do I connect to DB2 database?
I have... (2 Replies)
Discussion started by: JayDoshi
2 Replies
LEARN ABOUT X11R4
ssh-keysign
ssh-keysign(1M) ssh-keysign(1M)
NAME
ssh-keysign - ssh helper program for host-based authentication
SYNOPSIS
ssh-keysign
ssh-keysign is used by ssh(1) to access the local host keys and generate the digital signature required during host-based authentication
with SSH protocol version 2. This signature is of data that includes, among other items, the name of the client host and the name of the
client user.
ssh-keysign is disabled by default and can be enabled only in the global client configuration file /etc/ssh/ssh_config by setting Host-
basedAuthentication to yes.
ssh-keysign is not intended to be invoked by the user, but from ssh. See ssh(1) and sshd(1M) for more information about host-based authen-
tication.
/etc/ssh/ssh_config
Controls whether ssh-keysign is enabled.
/etc/ssh/ssh_host_dsa_key
/etc/ssh/ssh_host_rsa_key
These files contain the private parts of the host keys used to generate the digital signature. They should be owned by root, readable
only by root, and not accessible to others. Because they are readable only by root, ssh-keysign must be set-uid root if host-based
authentication is used.
ssh-keysign will not sign host-based authentication data under the following conditions:
o If the HostbasedAuthentication client configuration parameter is not set to yes in /etc/ssh/ssh_config. This setting cannot be overri-
den in users' ~/.ssh/ssh_config files.
o If the client hostname and username in /etc/ssh/ssh_config do not match the canonical hostname of the client where ssh-keysign is
invoked and the name of the user invoking ssh-keysign.
In spite of ssh-keysign's restrictions on the contents of the host-based authentication data, there remains the ability of users to use it
as an avenue for obtaining the client's private host keys. For this reason host-based authentication is turned off by default.
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWsshu |
+-----------------------------+-----------------------------+
|Interface Stability |Evolving |
+-----------------------------+-----------------------------+
ssh(1), sshd(1M), ssh_config(4), attributes(5)
AUTHORS
Markus Friedl, markus@openbsd.org
HISTORY
ssh-keysign first appeared in Ox 3.2.
9 Jun 2004 ssh-keysign(1M)