View previous topic :: View next topic |
Author |
Message |
ashutosh_agl3 Beginner
Joined: 14 Aug 2003 Posts: 28 Topics: 15
|
Posted: Wed Mar 30, 2005 4:55 am Post subject: Knowing actual db2 subsystem name |
|
|
Is there a way to know the db2 subsystem name, given the alias for it is known ? |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12372 Topics: 75 Location: San Jose
|
Posted: Wed Mar 30, 2005 7:21 am Post subject: |
|
|
ashutosh_agl3,
Look at the main screen of QMF and somewhere in the middle left you will find
"Connected to" . Beneath it you will find the db2 subsystem you are connected it.
Hope this helps...
Cheers
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
bauer Intermediate
Joined: 10 Oct 2003 Posts: 315 Topics: 49 Location: Germany
|
Posted: Thu Mar 31, 2005 5:23 am Post subject: |
|
|
..... or by program logic / SQL Select
DCL l_CH16 CHAR(16);
EXEC SQL
SET :l_CH16 = CURRENT SERVER ; |
|
Back to top |
|
|
|
|