connect to Db2 thru Unix

Shell Programming and Scripting
1

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.

Thanks in advance.

2

ranj@tcs,

Your question really is quite broad. Connection from a UNIX system to DB2 UDB is like any other client/server - You need:

  1. The DB2 Connect client installed on your UNIX host
  2. Appropriate security auths and a valid user/pass defined in UDB
  3. To define the host and database directory connection information for the client

It is all well documented in IBM's DB2 Connect manual.

Cheers,

Keith

3

Thanks kduffin. I will get back with more details later.

4

one thing u can do to check whether database is up or not is to use
`db2pd` utility (in DB2)

this is very similiar to onstat- used in informix database.