Extending TAMIT ASSETNUM attribute field length

Here is the procedure to extend the size of the attribute ASSETNUM in the ASSET MBO in TAMIT:

• Do a database backup
  
• Go To-> System Configuration -> Platform Configuration -> Database Configuration
• Object: ASSET
• Select ASSET
• Go to Attributes tab
• Select ASSETNUM
• Change the length to 32
• The attribute will be in Change mode
• Save it
• Go to List tab
• Select Action -> Managed Admin Mode
• Click Turn Admin Mode On
• Click Refresh Status until Admin Mode is ON
• Connect to TPAP DB
• db2 drop trigger multiassetloccip_u
• db2 drop trigger multiassetloccip_t
• Select Action -> Apply Configuration Changes
• Check Do you have a current backup?
• Click Start Configuring the Databsase
• Click Turn Admin Mode OFF
  

TDI class material

These are the links for the material used in the TDI class in Charlotte on Sep 18 - 20, 2008

Source CSV file: http://spreadsheets.google.com/pub?key=p4p_qEbMe9m6VL-TWV1NyQQ
Lab instructions: http://docs.google.com/Doc?id=ddnnhc4w_2793ph5zxcg
Presentation: http://docs.google.com/Presentation?id=ddnnhc4w_54f9tnwmd2

How to configure TADDM 7.1.1 to run BIRT reports

1. replace the reports.xml in dist/etc/cdm/xml
2. replace the dist/deploy-tomcat/cdm/WEB-INF/view/dm_newsummary_sidebar.jsp with the one here
3. untar birt-viewer.tar to dist/deploy-tomcat/
4. restart the server
5. Login to domain manager and you shd see the BIRT reports icon with a list of reports under the Analytics section

These files are available at: http://www.megaupload.com/?d=N1VTT5LT

Exporting data from TADDM

It's very simple to extract data from Tivoli Application Dependency Discovery Manager (TADDM), using Tivoli Directory Integrator (TDI) and the TADDM Connector, available at:

TADDM Connector at Tivoli OPAL

Using the TADDM Connector, you just specify the TADDM configuration information (host name, user, password, CI type), then drag and drop the fields into the desired Connector (for example, a CSV file, using the FileSystem Connector).

Setting the JDBC Transaction Isolation Level in TDI

As the JDBC Transaction Isolation needs to be set in the client side, I asked my Norwegian friends how to do it. As always, Eddie had the answer:

So you should have this option from TDI:

myJDBConnector.getConnector().getConnection().setTransactionIsolation( desiredLevel_int );


The Connection JavaDocs have this to say:

setTransactionIsolation
public void setTransactionIsolation(int level)
throws SQLException
Attempts to change the transaction isolation level for this Connection object to the one given. The constants defined in the interface Connection are the possible transaction isolation levels.
Note: If this method is called during a transaction, the result is implementation-defined.
Parameters:
level - one of the following Connection constants: Connection.TRANSACTION_READ_UNCOMMITTED, Connection.TRANSACTION_READ_COMMITTED, Connection.TRANSACTION_REPEATABLE_READ, or Connection.TRANSACTION_SERIALIZABLE. (Note that Connection.TRANSACTION_NONE cannot be used because it specifies that transactions are not supported.)

Throws:
SQLException - if a database access error occurs or the given parameter is not one of the Connection constants
See Also:
DatabaseMetaData.supportsTransactionIsolationLevel(int), getTransactionIsolation()

You will need to do this for each JDBC Connector with its own connection.

TDI class material

Here are the links for the TDI class:

Presentation: http://docs.google.com/Presentation?id=ddnnhc4w_19tsdmvbfk
Lab material: http://docs.google.com/Doc?id=ddnnhc4w_18fs4dpmcc

Creating Business _____ in an IBM Service Management solution

After doing many, many engagements with Tivoli's discovery tool (TADDM), one issue that always pops up where a business application/service/system should be defined.

Although TADDM has the capability of discovering the components of a business applications (the database servers, web servers, etc), and provides some basic ways to create business application (application template, application descriptor or individually selecting the components), TBSM claims to have better ways to create them.

I admit I'm not an expert in TBSM, and the lawn on the other side of the fence always seems greener, here are the problems I see:

• Assuming TBSM indeed has a better mechanism to associate CIs to Business Services, how can TBSM provide this information back to TADDM and CCMDB, so that these products can consume the BA definition for impact assessment, topology, etc ?
• The current strategy is to have TADDM as the discovery tool, populating CCMDB, which will perform the Change and Configuration Managements. If TBSM is the creator of the Business Application (or Service), the customer is required to have another problem in the solution architecture, just to create the BAs.

As the lawn in TBSM's backyard seems greener, shouldn't TBSM provide a component TADDM (or CCMDB) can use to create the Business Applications?

By the way, I created a small tool, called Automated Builder of Business Application, inspired in the old TBSM 3.1 ABS that traverses the dependencies of a certain CI and associated the entire connected graph to a Business Application. Take a look and see what you think...