ITIM DB2

Connecting to itim db2 is easy , but most of us forget to profile db.

Login to itim db2 server as root

Then profile the db :

# . /home/db2admin/sqllib/db2profile
db2 connect to user itimuser using

Easy as it gets :)

if u want to run select commands, put db2 "Select * from abc where d = 'gupta'"

GLPCTL088E Unable to run the command on directory server instance ''

GLPCTL088E Unable to run the command on directory server instance '' If u got an error like this running ibmslapd -k command ,do check if there is -k or .k

The correct syntax is :  /location/ibmslapd -k

Tivoli General Rules

The way things have come up in recent past have changed.
modus operandi tends to include most if not all of the following:

•    It is reactive, not proactive.
•     Resources may be healthy while customer service levels are not acceptable.
•     Events describe problems, not corrective actions.
•     Events flow into the Operations room at an incredibly high rate, and “event storms” have performance impact on systems.

•    Fixes are typically manual and inefficient.
•     Problems cannot be prioritized because impacts are unknown.
•    Most problems cannot be detected; more than 50% of all problems are reported through the help desk.
•   Organizational boundaries breed incompatible tools, making end-to-end management and integration very difficult.
•    Lack of vision and strategic direction increases costs.

ReF: IBM Redbooks: Tivoli Monitoring

TAM For E-Business

Lets talk about Links and Junctions :
WebSEAL is a proxy that is located between the Internet and the internal back-end servers. In the following figure, the browser requests a Web page using the URL https:///Junction1/index.html. WebSEAL uses the junction name Junction1 to identify the back-end server and sends a request for http://ServerA/index.html.

The Problem :
Webpage contains links to other webpages, and resources which are accessed using the URLs. These Hyperlinks are send to back-end servers using webseal, but these URLs might not be validated as they dont contain the junctions.
Link Types:  There are 3 link types we come across ITIM/ ITAM : Relative, server relative and Absolute.

Relative links do not contain the name of the server or the name of the current directory. When the browser receives a relative link, the link appears to be located on the WebSEAL server. Relative links are correctly interpreted as links to other pages in the same directory on the same server.
For example, assume that this line appears in http://serverA/index.html: About this site
The browser retrieved this page from https://webseal/Junction1/index.html. This URL is correctly interpreted as pointing to https://webseal/Junction1/ about.html. This request would go back to WebSEAL and WebSEAL would know to request http://serverA/about.html.
•    Server-relative links do not contain the name of the server, but they do contain the name of the directory.
For example, assume that this line appears in http://serverA/index.html: Contact information
The browser retrieved this page from https://webseal/Junction1/index.html. This URL is interpreted as pointing to /contact.html on the same server. However, from the browser’s perspective the server is WebSEAL. If WebSEAL did not change the HTML, the browser would attempt to retrieve https://webseal/contact.html instead of the correct URL, which is https://webseal/Junction1/contact.html.
•    Absolute links contain the name of the server and the directory. For example, assume that this line appears in http://serverA/index.html:
Copyright Information
If WebSEAL did not change the HTML, the browser would attempt to connect directly to ServerA, bypassing WebSEAL. A correctly configured firewall would only allow connections to ServerA from WebSEAL.



ReF: Junctions and Links.pdf IBM White paper

Tivoli Directory Integrator - Access the Database

TDI or Tivoli directory integrator is used to send and receive data from a data source to ITIM and back. TDI is a much more powerful tool that can be used over IBM Tivoli applications and also over many other places.
Things to understand about TDI :
1. The way the data is transmitted across
2. The java packets in which data flows across.

I will try to talk about various connectors here :
Lets start with JDBC , possibly the most popular considering the fact its easy to connect to Databases. I have successful connections from MS-Access to MS-SQL server, Oracle 10g connection and now JD Edwards.
The basic rule for JDBC connector is it talks to the database with the correct credentials. Once you have correct JDBC , and passwords entered , you need to specify schema.
The tables you want to fetch the data from. If you have multiple tables , enter all the table names.

Once the DB2 connector is up and running : 

JDBC URL : jdbc:db2://localhost:port/dbSchema

JDBC Driver: com.ibm.db2.jcc.DB2Driver

Username: adminDB

Password: ****

Schema : dbInfo

Sometimes we have to access data from different db and feed it into other db. Like fetching data from MS Server 2005 or JD Edwards , or Oracle and feeding the data in ITIM LDAP / ITIM DB2 or any other platform. 

The most important advantage of using the JDBC connector is it takes care of the data change, the hooks helps us weed unwanted entries and play with the data while in transit. 

Suppose we have to take data from MS SERVER 2008 and put in DB2, there are many ways where we can check the data. 

I prefer to check for valid data in Feed hooks while the manipulation in Flow. 

Always remember to use : 

task.logmsg("****** CONN OBJECT before GETNEXT*******");

task.dumpEntry(conn); 

Using the above in hooks can help in determing the connection parameters.