Connecting Information Server to an IBM Db2 Big SQL instance
Using the InfoSphere Metadata Asset Manager, you can use the Db2 connector on the computer designated as a metadata interchange server to import implemented data resources, including database schemas and tables, from Db2 Big SQL.
The Db2 connector uses the Db2 client to connect to your databases. The following example illustrates how you can catalog a remote Db2 Big SQL server and database on the metadata interchange server node, and then use the InfoSphere Metadata Asset Manager to import data from the Db2 Big SQL instance.
- Start by cataloging the bigsql database on a Db2 Big SQL cluster. Run
the following commands as the db2inst1 user to catalog the
bigsql database of a Db2 Big SQL server with the head node running on
FQDN/IP-Address port 32051. In this example, the cataloged node and database use
biwin as the local name for the machine hosting the database, as well as the
alias for the database, respectively.
db2 catalog tcpip node biwin remote <FQDN/IP-Address> server 32051 db2 catalog db bigsql as biwin at node biwin db2 terminate
- Restart the InfoSphere Information Server.
The InfoSphere Metadata Asset Manager (IMAM) can be used to import the metadata that represents schemas, tables, views, nicknames, and columns in Db2 Big SQL. The imported metadata is saved in the metadata repository.
- Open the IBM Information Server launchpad, from which you can access the various IIS
- Open the Metadata Asset Manager and click New Import Area.
- Specify a name, description and the interchange server for the import area, and select
IBM InfoSphere DB2 Connector as the connector type.
- Click on the icon beside the Data connection field to specify the
- Click the New Data Connection button.
- Specify the name, description, location, and credentials for the connection.
- Click Test Connection to verify the settings.
- If the settings are correct the connection test should be reported as successful.
- Provide a description for the import event and click the Express
Import radio button if it is not already selected.
- The new import area should be created successfully.
- The imported database and metadata is now visible in IMAM under
- Under the Import tab you can see the name, description, timestamp,
and other details for the new, completed import.
- You can also see the detailed database metadata and connection information.
What to do next
For more details about using the IMAM see Importing metadata by using InfoSphere Metadata Asset Manager in the InfoSphere Information Server Knowledge Center.