IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Need info about Subsystem ID and SQL ID


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
sunibabi

New User


Joined: 21 Apr 2005
Posts: 4
Location: swiss

PostPosted: Mon Apr 30, 2007 10:46 pm
Reply with quote

Hello,

Could anyone explain me about the SSID.

I think SSID is logical group in DB2. If it is correct why it is needed when we have different SQL-IDs.

Thanks n Regards
YS
Back to top
View user's profile Send private message
wanderer

Active User


Joined: 05 Feb 2007
Posts: 199
Location: Sri Lanka

PostPosted: Tue May 01, 2007 11:28 am
Reply with quote

I don't know what you mean by 'logical id', but SSID is the subsystem id name of the DB2 instance. SSID can also be the group name if more than one DB2 subsystems are part of a data sharing group. And SQL-id is more or less like a user-id for a user. Hope that clears the confusion. They can't replace each other!
Back to top
View user's profile Send private message
mkk157

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Tue May 01, 2007 4:18 pm
Reply with quote

SSID

Description: SSID = Subsystem Identifier

A user-assigned number that identifies a DASD subsystem.
This number is set by the service representative at the
time of installation and is included in the vital product
data.
Back to top
View user's profile Send private message
sunibabi

New User


Joined: 21 Apr 2005
Posts: 4
Location: swiss

PostPosted: Tue May 01, 2007 6:42 pm
Reply with quote

Thanks for the reply, but I am still confused with the cocept fo the SSID.

Do you have any manucal which gives the basic information about SSID.
Back to top
View user's profile Send private message
wanderer

Active User


Joined: 05 Feb 2007
Posts: 199
Location: Sri Lanka

PostPosted: Wed May 02, 2007 6:00 am
Reply with quote

If you can tell what is the source of your confusion, somebody will help.

However, here is a link that describes a little about the concept of SSID.

www-128.ibm.com/developerworks/db2/library/techarticle/0207chong/0207chong.html
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts in REXX,how to get sysprt info CLIST & REXX 9
No new posts Retrieve IMS SubSystem Name IMS DB/DC 2
No new posts Get name of Subsystem routine is exec... All Other Mainframe Topics 2
No new posts Copy a PDS to a new PDS - why do I ne... TSO/ISPF 8
No new posts Tivoli INFO/MANAGEMENT IBM Tools 1
Search our Forums:

Back to Top