You can set this parameter by running DB2 UPDATE DBM CFG using federated Yes. After modifying this parameter, the instance must be restarted before it takes effect (Db2stop/db2start)
. So you're going to show up with that error: the instance is not started
This article describes the method of accessing the table Table1 of the target library dbtarget in the source database dbsrc in the same DB instance
User name: usr, password: pwd
DB2 version: UDB for AIX 8.2.2
Os:microsoft Windows XP Professional version 2002 SP2
DB2 INSTANCE:DB2
DB2 DATABASE:WEBSPC, CRTLSPC
DB2 version:db21085i Instance "DB2" uses the "32" bit and DB2 code release "SQL08029", and the level is identified as "030a0106".
The references are labeled "DB2 v8.1.17.789", "s080813", and "WR21440", and the revision package is "17".
These two databases are run at the DB2 instance level. I want to use WEBSPC to access the tables in CTRLSPC. This is the concept of a federated database.
First of all:
1. Updated the parameters at the instance level:
DB2 = Update dbm CFG using federated YES
Db20000i the UPDATE DATABASE MANAGER CONFIGURATION command completed.
2. Create Wrapper
DB2 = Create wrapper "DRDA" LIBRARY ' Db2drda.dll ' OPTIONS (ADD db2_fenced ' N ')
When I run this command, I get an instance of sql20076n not enabling the database for the specified operation. Reason code = "1". sqlstate=0a502.
I have checked the federated parameters, has been modified, I do not know why the creation of wrapper is not through?
Please advise.
Thank you!
Go to the command line:
1. DB2
2. DB2 =>update dbm CFG using federated YES
3. DB2 =>db2stop Force
4. DB2 =>db2start
5. DB2 =>conncet DBSRC user user using PWD
6. DB2 =>create wrapper Drda--library ' libdb2drda.a ' (optional)
7. DB2 =>create Server FP type Db2/aix version 8 wrapper drda autid "usr" password "pwd" options (add dbname ' Dbtarget ', Password ' Y ');
8. DB2 =>create USER MAPPING for "usr" SERVER "FP" OPTIONS (remote_authid ' usr ', Remote_password ' pwd ')
9. DB2 =>create nickname Fp_table1 for FP. Usr.table1
This builds a cross-library access environment,
You can use "SELECT * from Fp_table1" To access the table table1 in Dbtarget.
When you create wrapper, sql20076n does not enable instances of the database for the specified operation.