Retrieve Instance Details

[gregsimpson]

Hi,

AIX Machine running DB2 8.1. I'm trying to establish certain settings with SQL. I'm afer the instance and the database.

I can get the database by issuing

db2 "select current server from sysibm.sysdummy1"

Does anyone know of a way of getting the instance?

Cheers
Greg

 

[gregsimpson]

Hi,

should have said does anyone know how to get the instance using SQL syntax.

I'm already aware of

db2 get instance.

Cheers
Greg

 

[Mercury2]

Could it be
DECLARE APPL_SERVE (VARCHAR(18));
select current server
into APPL_SERVE
from sysibm.sysdummy1 ?
hth

 

[gregsimpson]

Hth,

Current Server gets me the database not the DB2 Instance.

Cheers
Greg

 

[jayjaybigs]

Try entering:
db2ilist

 

[gregsimpson]

jayjaybigs,

thanks for the reply. However as I specified above I need an SQL command to get the instance.

Thanks anyway
greg