Information Analyzer configuration

-

Question

How to configure Information Analyzer when IADB is a local DB2 instance?

Cause

After installing InfoSphere Information Server, Information Analyzer must be configured prior to its usage.

Please reference the following links for further information and steps on how to configure Information Analyzer:

IBM Education Assistant: http://publib.boulder.ibm.com/infocenter/ieduasst/imv1r0/index.jsp?topic=/com.ibm.iea.infosphere_is/infosphere_is/8.5/configuration/ConfiguringInformationAnalyzer/player.html

InfoCenter:
- Version 8.5: http://pic.dhe.ibm.com/infocenter/iisinfsv/v8r5/index.jsp?topic=%2Fcom.ibm.swg.im.iis.ia.administer.doc%2Ftopics%2Fc_setting_up_ia.html

- Version 8.7: http://pic.dhe.ibm.com/infocenter/iisinfsv/v8r7/index.jsp?topic=%2Fcom.ibm.swg.im.iis.ia.administer.doc%2Ftopics%2Fc_setting_up_ia.html

- Version 9.1: http://pic.dhe.ibm.com/infocenter/iisinfsv/v9r1/topic/com.ibm.swg.im.iis.ia.administer.doc/topics/c_setting_up_ia.html

Regarding odbc.ini configuration, here are examples that can be used:
- Version 8.5: http://pic.dhe.ibm.com/infocenter/iisinfsv/v8r5/index.jsp?topic=%2Fcom.ibm.swg.im.iis.ia.administer.doc%2Ftopics%2Ft_create_dsn_unix.html

- Version 8.7: http://pic.dhe.ibm.com/infocenter/iisinfsv/v8r7/index.jsp?topic=%2Fcom.ibm.swg.im.iis.ia.administer.doc%2Ftopics%2Ft_create_dsn_unix.html

- Version 9.1: http://pic.dhe.ibm.com/infocenter/iisinfsv/v9r1/topic/com.ibm.swg.im.iis.ia.administer.doc/topics/t_create_dsn_unix.html


Answer

For local IADB DB2 database, please use the following DSN sample:

[IADB]
Driver=/opt/IS91/IBM/InformationServer/Server/branded_odbc/lib/VMdb200.so
Description=DataDirect DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
Database=IADB
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=<Host name>
IsolationLevel=CURSOR_STABILITY
LogonID=
Password=
Package=DB2 package name
PackageOwner=
TcpPort=50000
WithHold=1

Where <Host name> is the local hostname where the DB2 database resides.

After that, check if you are able to connect to the database via DB2 client:
[dsadm@<hostname> example]$ db2 connect to IADB user <iauser> using <iauser>

Database Connection Information

Database server = DB2/LINUXX8664 10.1.0
SQL authorization ID = IAUSER
Local database alias = IADB

Then "list database directory" from the DB2 client to confirm if it is catalogued as follow:

Database 9 entry:

Database alias = IADB
Database name = IADB
Local database directory = /opt/IS91/IBM/InformationServer/Repos/iadb
Database release level = f.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =






Popular posts from this blog

Shrink you container size up to 95%.

-
BLAFS is a bloat-aware filesystem for container debloating. The design principles of BLAFS are effective, efficient, and easy to use. It detects the files used by the container, and then debloats the container by removing the unused files. The debloated containers are still functional and can run the same workload as the original containers, but with a much smaller size and faster deployment. https://github.com/negativa-ai/BLAFS?tab=readme-ov-file
Read more

alma linux: dnf Module yaml error: Unexpected key in data

-
While applying recent updates to a server running Rocky Linux 8, an error presented itself. Module yaml error: Unexpected key in data: static_context [line 9 col 3] Module yaml error: Unexpected key in data: static_context [line 9 col 3] The solution turned out to be a simple one. Update the libmodulemd first to correct the problem then perform the dnf updates as usual. dnf update libmodulemd For a detailed explanation as to the cause of this problem.
Read more