Can't create federated object 3

[ddiamond]

When I attempt to create a federated object from the control center I get the following error:

The GET_WRAP_CFG_C stored procedure returned an error. Return
code -805, locale: en_US

Does anyone know what this means? Do I have to install anything special to use DB2 federated objects?

 

[juliane26]

Package missing ...

which edition of DB2 ore you using ?
If I remember correctly Federation is included in ESE, or you have to use WE together with DB2 Connect.


Juliane

 

[ddiamond]

Juliane,

I double checked. We do have the ESE edition. Is there anything I need to configure to use federated objects?

- Dan

 

[ddiamond]

I'm also getting the following error:

The instance for the database is not enabled for the specified
action or operation. Reason code = "1".

Explanation:

An error has been detected at the instance level. The requested
operation cannot be completed because a specified functional area
was not installed or because a specified functional area was not
enabled to the instance.

 

[juliane26]

db2 update dbm cfg using federated yes
db2stop
db2start

(or configure instance in the control center)



Juliane

 

[gregsimpson]

ddiamond,

you need to enter the following

db2 update dbm cfg using federated yes

wherever you wish to use federation.

Then stop and start your instance

Cheers
Greg

 

[gregsimpson]

Sorry for the duplication, looks like juliane got there first.

Greg

 

[ddiamond]

Thanks for your help.

I executed the following commands:

db2 update dbm cfg using federated yes
db2 stop database manager
db2 start database manager

I'm still getting the error massage:

The instance for the database is not enabled for the specified
action or operation. Reason code = "1".

Explanation:

An error has been detected at the instance level. The requested
operation cannot be completed because a specified functional area
was not installed or because a specified functional area was not
enabled to the instance.

Is there anyway I can verify that the DB2 Information Integrator has been installed on the server?

 

[aixnag]

Suspect, that dbm cfg is not updated properly.

Could you login as instance owner.
Post the #db2 get dbm cfg|grep -i federated

if any errors in db2diag.log pertaining to this can also post here.

Ideally, once you set the federated option in dbm cfg and rebounce the instance, should work straightly.



aixnag
IBM Certified Specialist - P-series AIX 5L Administration
IBM Certified Specialist - AIX V4 HACMP
IBM eServer Certified Specialist – p690 Technical Support
IBM Certified Solutions Expert - DB2 UDB V7.1 Database Administration for Unix, Linux, Windows and OS/2

 

[ddiamond]

Thanks aixnag,

I running under windows so I don't have the grep command.

I executed db2 get dbm cfg

          Database Manager Configuration

     Node type = Client

 Database manager configuration release level            = 0x0a00

[blue] Federated Database System Support           (FEDERATED) = YES [/blue]
 Transaction processor monitor name        (TP_MON_NAME) = 

 Default charge-back account           (DFT_ACCOUNT_STR) = 

 Java Development Kit installation path       (JDK_PATH) = C:\Program Files\IBM\SQLLIB\java\jdk

 Diagnostic error capture level              (DIAGLEVEL) = 3
 Notify Level                              (NOTIFYLEVEL) = 3
 Diagnostic data directory path               (DIAGPATH) = 

 SYSADM group name                        (SYSADM_GROUP) = 
 SYSCTRL group name                      (SYSCTRL_GROUP) = 
 SYSMAINT group name                    (SYSMAINT_GROUP) = 
 SYSMON group name                        (SYSMON_GROUP) = 

 Client Userid-Password Plugin          (CLNT_PW_PLUGIN) = 
 Client Kerberos Plugin                (CLNT_KRB_PLUGIN) = IBMkrb5
 Group Plugin                             (GROUP_PLUGIN) = 
 GSS Plugin for Local Authorization    (LOCAL_GSSPLUGIN) = 
 Server Plugin Mode                    (SRV_PLUGIN_MODE) = UNFENCED
 Server List of GSS Plugins      (SRVCON_GSSPLUGIN_LIST) = 
 Server Userid-Password Plugin        (SRVCON_PW_PLUGIN) = 
 Server Connection Authentication          (SRVCON_AUTH) = NOT_SPECIFIED
 Database manager authentication        (AUTHENTICATION) = SERVER
 Cataloging allowed without authority   (CATALOG_NOAUTH) = YES
 Bypass federated authentication            (FED_NOAUTH) = NO

 Java Virtual Machine heap size (4KB)     (JAVA_HEAP_SZ) = 512
 Directory cache support                     (DIR_CACHE) = YES

 Max requester I/O block size (bytes)         (RQRIOBLK) = 32767
 DOS requester I/O block size (bytes)     (DOS_RQRIOBLK) = 4096
 Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10

 Transaction manager database name         (TM_DATABASE) = 1ST_CONN

 NetBIOS Workstation name                        (NNAME) = 

 Discovery mode                               (DISCOVER) = SEARCH

It looks like it is configured as a federated database. Could there be something that is not installed?

 

[aixnag]

Hello ddiamond,

Sorry, am unix guy.

By the way, i can see from posting "Node Type=Client"
When you are working with DB2 ESE, you should get something like the below

"Node type = Enterprise Server Edition with local and remote clients"

Check to make sure that you have done the changes to dbm cfg on right place??? and right box???


Hope it helps.

aixnag
IBM Certified Specialist - P-series AIX 5L Administration
IBM Certified Specialist - AIX V4 HACMP
IBM eServer Certified Specialist – p690 Technical Support
IBM Certified Solutions Expert - DB2 UDB V7.1 Database Administration for Unix, Linux, Windows and OS/2

 

[gregsimpson]

ddiamond,

I'm on ese and do indeed get

Node type = Enterprise Server Edition with local and remote clients

It looks as though you haven't got a server edition copy and despite the fact that it's allowed you to set the cfg to allow federation that maybe the edition of software you have installed doesn't physically support this.

According to a version 7 redbook I have on Federation it's only in certain versions. See extract below

The core federated server capability, also known as the federated server base is provided in the following
versions of DB2:
? DB2 Universal Database for Linux, UNIX, and Windows Version 7 (Enterprise Edition)
? DB2 Universal Database for Linux, UNIX, and Windows Version 7 (Enterprise Edition - Extended)
? DB2 Connect™ Version 7 (Enterprise Edition).

Cheers
Greg

 

[ddiamond]

I had been executing the commands on my client computer, but since I was connected to the server, I had assumed they were executing on the server. Looks like I was wrong. I walked over to our server and executed the cfg command and got
Node type = Enterprise Server Edition with local and remote clients
It also said Federated = No
So on my server I set federated to yes, and then stoped and restarted the database manager.

Now I'm getting a little further, but when I try to create a wrapper I get:
The GET_WRAP_CFG_C stored procedure returned an error. Return
code -805, locale: en_US

Any ideas?

          Database Manager Configuration

     Node type = Database Server with local and remote clients

 Database manager configuration release level            = 0x0a00

 Maximum total of files open               (MAXTOTFILOP) = 16000
 CPU speed (millisec/instruction)             (CPUSPEED) = 2.834066e-007

 Max number of concurrently active databases     (NUMDB) = 8
 Data Links support                          (DATALINKS) = NO
 Federated Database System Support           (FEDERATED) = YES
 Transaction processor monitor name        (TP_MON_NAME) = 

 Default charge-back account           (DFT_ACCOUNT_STR) = 

 Java Development Kit installation path       (JDK_PATH) = C:\PROGRA~1\IBM\SQLLIB\java\jdk

 Diagnostic error capture level              (DIAGLEVEL) = 3
 Notify Level                              (NOTIFYLEVEL) = 3
 Diagnostic data directory path               (DIAGPATH) = 

 Default database monitor switches
   Buffer pool                         (DFT_MON_BUFPOOL) = OFF
   Lock                                   (DFT_MON_LOCK) = OFF
   Sort                                   (DFT_MON_SORT) = OFF
   Statement                              (DFT_MON_STMT) = OFF
   Table                                 (DFT_MON_TABLE) = OFF
   Timestamp                         (DFT_MON_TIMESTAMP) = ON
   Unit of work                            (DFT_MON_UOW) = OFF
 Monitor health of instance and databases   (HEALTH_MON) = OFF

 SYSADM group name                        (SYSADM_GROUP) = PRODADM 
 SYSCTRL group name                      (SYSCTRL_GROUP) = 
 SYSMAINT group name                    (SYSMAINT_GROUP) = 
 SYSMON group name                        (SYSMON_GROUP) = 

 Client Userid-Password Plugin          (CLNT_PW_PLUGIN) = 
 Client Kerberos Plugin                (CLNT_KRB_PLUGIN) = IBMkrb5
 Group Plugin                             (GROUP_PLUGIN) = 
 GSS Plugin for Local Authorization    (LOCAL_GSSPLUGIN) = 
 Server Plugin Mode                    (SRV_PLUGIN_MODE) = UNFENCED
 Server List of GSS Plugins      (SRVCON_GSSPLUGIN_LIST) = 
 Server Userid-Password Plugin        (SRVCON_PW_PLUGIN) = 
 Server Connection Authentication          (SRVCON_AUTH) = NOT_SPECIFIED
 Database manager authentication        (AUTHENTICATION) = SERVER
 Cataloging allowed without authority   (CATALOG_NOAUTH) = NO
 Trust all clients                      (TRUST_ALLCLNTS) = YES
 Trusted client authentication          (TRUST_CLNTAUTH) = CLIENT
 Bypass federated authentication            (FED_NOAUTH) = NO

 Default database path                       (DFTDBPATH) = C:

 Database monitor heap size (4KB)          (MON_HEAP_SZ) = 66
 Java Virtual Machine heap size (4KB)     (JAVA_HEAP_SZ) = 512
 Audit buffer size (4KB)                  (AUDIT_BUF_SZ) = 0
 Size of instance shared memory (4KB)  (INSTANCE_MEMORY) = AUTOMATIC
 Backup buffer default size (4KB)            (BACKBUFSZ) = 1024
 Restore buffer default size (4KB)           (RESTBUFSZ) = 1024

 Agent stack size                       (AGENT_STACK_SZ) = 16
 Minimum committed private memory (4KB)   (MIN_PRIV_MEM) = 32
 Private memory threshold (4KB)        (PRIV_MEM_THRESH) = 20000

 Sort heap threshold (4KB)                  (SHEAPTHRES) = 10000

 Directory cache support                     (DIR_CACHE) = YES

 Application support layer heap size (4KB)   (ASLHEAPSZ) = 15
 Max requester I/O block size (bytes)         (RQRIOBLK) = 32767
 DOS requester I/O block size (bytes)     (DOS_RQRIOBLK) = 4096
 Query heap size (4KB)                   (QUERY_HEAP_SZ) = 1000

 Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 100

 Priority of agents                           (AGENTPRI) = SYSTEM
 Max number of existing agents               (MAXAGENTS) = 200
 Agent pool size                        (NUM_POOLAGENTS) = 100(calculated)
 Initial number of agents in pool       (NUM_INITAGENTS) = 0
 Max number of coordinating agents     (MAX_COORDAGENTS) = MAXAGENTS
 Max no. of concurrent coordinating agents  (MAXCAGENTS) = MAX_COORDAGENTS
 Max number of client connections      (MAX_CONNECTIONS) = MAX_COORDAGENTS

 Keep fenced process                        (KEEPFENCED) = YES
 Number of pooled fenced processes         (FENCED_POOL) = MAX_COORDAGENTS
 Initial number of fenced processes     (NUM_INITFENCED) = 0

 Index re-creation time and redo index build  (INDEXREC) = ACCESS

 Transaction manager database name         (TM_DATABASE) = 1ST_CONN
 Transaction resync interval (sec)     (RESYNC_INTERVAL) = 180

 SPM name                                     (SPM_NAME) = ADMDB2T2
 SPM log size                          (SPM_LOG_FILE_SZ) = 256
 SPM resync agent limit                 (SPM_MAX_RESYNC) = 20
 SPM log path                             (SPM_LOG_PATH) = 

 NetBIOS Workstation name                        (NNAME) = 

 TCP/IP Service name                          (SVCENAME) = 5000
 Discovery mode                               (DISCOVER) = SEARCH
 Discover server instance                (DISCOVER_INST) = ENABLE

 Maximum query degree of parallelism   (MAX_QUERYDEGREE) = ANY
 Enable intra-partition parallelism     (INTRA_PARALLEL) = NO

 No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = 1024
 Number of FCM request blocks              (FCM_NUM_RQB) = AUTOMATIC
 Number of FCM connection entries      (FCM_NUM_CONNECT) = AUTOMATIC
 Number of FCM message anchors         (FCM_NUM_ANCHORS) = AUTOMATIC

 

[gregsimpson]

Can you post the code your running on the server which is giving you the latest error.

Looks like you're back to the first post on this thread

Cheers
Greg

 

[ddiamond]

Thanks for your help, gredsimpson. I was using the control center. I selected my database, right clicked on federated objects, and then clicked on create federated objects. A wizard popped up along with the error message. If I proceeded with the wizard anyway, I would get an empty wrapper drop down box. I also tried clicking on "Create wrapper". That resulted in the same error message. I don't know if any wrappers have been installed. When I asked our network guys who did the installation, they told me they did the default enterprise installation. I don't know what that includes. We're all rather new to DB2.

 

[gregsimpson]

ddiamond,

I'm told by the IBM supplied DBA I have with me today that Federation wasn't installed by default in earlier versions, but he was unable to say when it started to be installed by default. I notice you're on windows. If it helps I think you're looking for something called

drda.ddl

if you're trying to connect to another DB2 data source.

Do a search of the installation directories and see if it exists. Not sure where to go from there at this point.

Cheers
Greg

 

[ddiamond]

We are using a fairly recent version of DB2 - vers 8.2. I could not find drda.dll, however, so it looks like the federation may not be installed. Thanks for all of your help.