Not that there is a lot to the TDW layout, but knowing the schema assists in the documentation process and developing queries and procedures of the TDW (Tivoli Data Warehouse).

Make short work of this by using the opensource tools of SchemaSpy and Graphviz

SchemaSpy is a jar file that supports over 21 DBs, including the 3 supported by ITM TDW (Oracle, Sybase, MSSQL) and is run from the command line to generate a html directory of content about the interrogated schema.

Not all of them mind you, but some important ones none-the-less:

• KFW_STARTJVM=N
• KFW_USE_EMBEDDED=Y
• KFW_EWAS_SERVER_PID_FILE=C:\IBM\ITM\CNPSJ\profiles\ITMProfile\logs\ITMServer\ITMServer.pid
• KFW_EWAS_STARTSERVER_SCRIPT=C:\IBM\ITM\CNPSJ\profiles\ITMProfile\bin\startServer.bat
• KFW_EWAS_STOPSERVER_SCRIPT=C:\IBM\ITM\CNPSJ\profiles\ITMProfile\bin\stopServer.bat

I verified the following by modifying all the variables in my %CANDLEHOME%\CNB\kfwenv file where numerical values like ports and max where incremented by one, and the string vlaues had _XXX_ inserted

The modified kfwenv was backed up, then I reconfigured the TEPS and ran a diff on both files, and the above variables are the resulting default values.

Regular expression predicates were introduced as of T/EC 3.7 that make the task of string pattern matching and manipulation a clean and intuitive procedure.

In a nutshell, there are basically 7 predicates, where

• one is used to define a regular expression pattern
• two are to perform a substring subsitition
• the remaining four are for pattern matching.

Read the rest of this entry »

  parse_ddpro.tgz (1.2 KiB, 331 hits)

Rename ambigous files downloaded from passport advantage

If you use the IBM Passport Advantage or PartnerWorld portal to download software, you no doubt want to have the filenames renamed to something more meaningful than the software part number. This script will rename files based on the parsed info in the dlmgr.pro file. Example

jdsmedia@deantp1 /cygdrive/c/DownloadDirector $ ls -1
C1FT9EN.zip
C1FU3EN.tar
C1FU4EN.tar
C473DIE.exe
dlmgr.pro
itmpatchagents.zip
itmsup.zip
jdsmedia@deantp1 /cygdrive/c/DownloadDirector $ /usr/local/bin/parse_ddpro.pl
PWD is /cygdrive/c/DownloadDirector
mv C1FU4EN.tar ITM_Version_6_1_Vol_6_Fixpack_7_Linux_Intel_C1FU4EN.tar
mv C1FT9EN.zip ITM_Version_6_1_Vol_1_Fixpack_7_Windows_Plat_C1FT9EN.zip
mv C1FU3EN.tar ITM_Version_6_1_Vol_7_Fixpack_7_Linux_Intel_P_C1FU3EN.tar

Over the past 10 years of consulting, I’ve come up with various scripts that others would find useful: perl, shell and otherwise, including vbscripts for windows WMI and ITM5.x Resource Model visitTrees.

As I get around to organizing this blog, I’ll make them available in some kind of structure.

Go to the Scripts Tag