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 > Federated Server

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-07-12, 16:43
schintala schintala is offline
Registered User
 
Join Date: Apr 2005
Location: USA
Posts: 119
Federated Server

Hi,
We use DB2 9.7 ESE on Linux and we got to connect to z/OS Databases as if it is local to UDB server. I was trying to create federated server using control center and the option is disbaled. I have updated DBM config param Federated to Yes and started the instance. DB2 license command shows, "License is not registred". Is this create any problem? Please advise. I am new to LUW world. What are the other options, I have? Thank you.
Reply With Quote
  #2 (permalink)  
Old 02-07-12, 16:56
ARWinner ARWinner is offline
Registered User
 
Join Date: Jan 2003
Posts: 3,575
You can federate between DB2 LUW for free. Federating to anything else requires buying a license.

Andy
Reply With Quote
  #3 (permalink)  
Old 02-07-12, 19:21
sathyaram_s sathyaram_s is offline
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,534
Quote:
Originally Posted by schintala View Post
Hi,
DB2 license command shows, "License is not registred". Is this create any problem? Please advise.
What is the output of
Code:
db2licm -l
command
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
  #4 (permalink)  
Old 02-08-12, 02:27
przytula_guy przytula_guy is offline
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 1,159
you are probably missing the license for db2 connect ??
can you connect to z/os db2 from command line without federation ?
__________________
Best Regards, Guy Przytula
Database Software Consultant
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
  #5 (permalink)  
Old 02-08-12, 08:36
schintala schintala is offline
Registered User
 
Join Date: Apr 2005
Location: USA
Posts: 119
Thank you all for the reply. I would be able to connect to z/OS with DB2 Connect client and can export data from z/OS and load into Linux DB2 server. But unable to create federated server. The output of db2licm -l command as follows.

db2inst1@mhsocc172:/> db2licm -l
Product name: "DB2 Enterprise Server Edition"
License type: "License not registered"
Expiry date: "License not registered"
Product identifier: "db2ese"
Version information: "9.7"

Thank you.
Reply With Quote
  #6 (permalink)  
Old 02-08-12, 08:46
sathyaram_s sathyaram_s is offline
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,534
The problem lies here, I think
Quote:
License type: "License not registered"
Expiry date: "License not registered"
Quote:
I would be able to connect to z/OS
Are you able to connect ? it is not clear. if you are able to, then try using SQL instead of Control Center,

- create wrapper
- create server
- create user mapping
- create nickname

these are the statements you need to look up for and issue them in the above order

Cheers
Sathyaram
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
  #7 (permalink)  
Old 02-08-12, 12:59
schintala schintala is offline
Registered User
 
Join Date: Apr 2005
Location: USA
Posts: 119
Thank you. It worked in command editor with SQL.
Reply With Quote
  #8 (permalink)  
Old 02-09-12, 04:29
nvk@vhv nvk@vhv is offline
Registered User
 
Join Date: Jan 2010
Posts: 294
Hi,

if you want to use Federation between LUW and z/OS. You need two Products/Licenses.
The First is homogenous Federation which is included in all Editions beside DB2 Express-C. Additionally you need DB2 Connect-Licenses.
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