If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Initial Catalog

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-09-11, 22:53
perumj1 perumj1 is offline
Registered User
 
Join Date: Oct 2010
Posts: 33
Question Initial Catalog

Could you please provide me a suggestion or a hint to know the initial catalog name in DB2. Are there any Batch jobs are Clist execution where we can fetch this details.
Reply With Quote
  #2 (permalink)  
Old 03-09-11, 23:00
Stealth_DBA Stealth_DBA is offline
Registered User
 
Join Date: May 2009
Posts: 472
perumj1, since you mentioned batch jobs and clists, I assume you are talking about DB2 z/OS (or possibly DB2i but I don't know much about that environment).

What do you mean by the initial catalog name? What are you trying to find?
Reply With Quote
  #3 (permalink)  
Old 03-09-11, 23:03
perumj1 perumj1 is offline
Registered User
 
Join Date: Oct 2010
Posts: 33
Hi,

Apology for not being more precise. It is in Z/os system.

Initial catalog: ------- (The RDB name is on the DB2. Typically, it's the name of the server when it was originally built, but it could also be an alias .
This was the description given, but I am unable to find the Alias.
Reply With Quote
  #4 (permalink)  
Old 03-09-11, 23:21
Stealth_DBA Stealth_DBA is offline
Registered User
 
Join Date: May 2009
Posts: 472
When DB2 is installed, it is given a SubSustemID (SSID) which could be any name (although I have only seen 4 character SSID names). The only 'catalog' I know about is the System Catalog tables (SYSIBM.* tables).

If something is defining an Alias name, it sounds like it is being cataloged on another computer client (or DB2 Connect) to allow access to the z/OS system. That Alias name could be anything the person who has (or will) set it up wants.

To me, 'Initial Catalog' still has no meaning.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On