Monday, March 10, 2008

ITM 6.1'How to make a query read-only/read-write (Undocumented and unsupported)

Sometimes, you might want to make a query read-only to prevent the query from being edited. Sometimes, you might want to remove the read-only attribute to make changes to the query. AFAIK, there is no built-in support for making a query read-only/read-write, though you can do that via a little hack :-)

Disclaimer:
This feature is not supported and not fully tested. The built-in queries are marked as read-only for a reason. Please make these changes at your own risk.


1) Connect to your TEPS database using your database client (DB2 Command Center or MSSQL Client).
2) Issue the following query. Please note instead of ???????????????XYZ',?substitute the first three letters of your application name.

SELECT id, name, query FROM teps.kfwquery WHERE APPL LIKE ???????????????XYZ%'?AND name = ???????????????'

3) Make sure the resulting row is the one you needed.
4) In the above SQL result, the query field is what we need. It is a field with long list of strings and we need to make changes to the query field and update the resulting value.

Tip: If you use graphical sql client like DB2 Command Center, you can issue the select query and edit the result rows directly.

      a. If you are looking to change make your query read/write, then look for a pattern like '@readonly=T@'and change the value to '@readonly=F@'and update the changes to the table.
      b. If you are looking to make your query readonly, make sure that it does not already have the "readonly=F" pattern, then add the following string at the end, 'readonly=T@'?

5) Close any open TEPS windows and restart TEPS.
6) Relogin again, now you will see the changes.

1 comment:

Pierre et Audrey said...

Hi guys,

first of all thanks for your amazing work on Tivoli...
In this post you say :
If you use graphical sql client like DB2 Command Center, you can issue the select query and edit the result rows directly.

I've tried many times to connect to the DB2 TEPS database with no success. Could you tell me the steps to achieve that?

regards