KDE1_STC_CONNECTIONLIMITREACHED on KDE_Gateway agent. Customer was finding that the agents were not all connecting through the KDE_gateway It was found in the agent log (for the agent that is running the KDE_gateway) the error: kdebgpc.c,43,"KDEBG_ProxyConnect") Status 1DE0006B=KDE1_STC_CONNECTIONLIMITREACHED One of the parameters on the kde_gateway configuration is the maxconn value. This is the maximum number of connections allowed through the proxy. This number has to be at least double the number of agents that will... [More]

Tags:  ibm ibm-blog monitoringacademy snd45jns troubleshooting itm kde_gateway hdt15

                        Oracle populate osagents command fails with  ORA-06512: at line 2 If your site runs the Tivoli Data Warehouse, each time you install one or more monitoring agents, you must update the warehouse's ManagedSystem table; the populate_agents.sql script is provided for this purpose. The details are in the manual here: https://www.ibm.com/support/knowledgecenter/SSTFXA_6.3.0/com.ibm.itm.doc_6.3/install/tdwmngdsys.htm   However after the initial run of this script, if you need to run this again later when more agents are... [More]

Tags:  itm ibm troubleshooting monitoringacademy snd45jns hdt15 ibm-blog

        Old data at agent not inserted to warehouse partitions.   Can see both errors of: CTX_ODBCError(20) SQL0327N The row cannot be inserted into table "XXX.XXX" because it is outside the bounds of the defined data partition ranges. SQLSTATE=22525 this error occurs when the data that needs to be inserted is outside of the range of the defined partitions.   The S&P agent is repsonsible for creating the partitions but if it has an error, or is not running correctly the partitions may not be created and the above errors can be... [More]

Tags:  ibm snd45jns ibm-blog monitoringacademy hdt15 troubleshooting itm

        TEPS API link limit on 10,000 rows returned Just a quick piece of information this time. The TEPS API interface, or ITMREST inerface as it is also known, is not designed to handle large amounts of data. It therefore has a default limit of 10,000 rows returned. It is better to introduce a "condition" filter clause into the query to only retrieve a list of what information is needed. However if you do need to change the number of rows returned there is an environment variable can be tried:  KD8FETCHLIMIT=n  where:   0 < n... [More]

Tags:  hdt15 ibm-blog itm ibm monitoringacademy snd45jns troubleshooting

    More are more customer are now changing the OS platform that their ITM is running on and they are doing this to upgrade the monitoring environment. While trying to do the migration they often have to run different versions of ITM monitoring on different platform. So what customers are looking for is to upgrade the ITM environment and at the same stage to re-platform from say SLES to Red Hat. There are many ways of doing this type of change. 1. A scripted install of the environment. 2. Migration using the ITM tacmd command to export and... [More]

Tags:  ws wsblog ibm-blog itm6 tems teps itm monitoringacademy migration troubleshooting

          Uninstalling an unwanted ITM module such as 32 bit ax shared libraries or gskit As discussed in previous  blog about the gskit libraries, components can get out of step when there are a number of upgrade in your ITM environment. These only rarer cause issues (with upgrade and such)  see blog: https://www.ibm.com/developerworks/community/blogs/0587adbc-8477-431f-8c68-9226adea11ed/entry/Unix_6_3_x_TIV_ITM_GSK_8_0_50_88_IJ04522_upgrade_failure?lang=en However there may be times when you want to uninstall some components if they are... [More]

Tags:  ibm-blog snd45jns hdt15 itm ibm monitoringacademy troubleshooting

        Unix 6.3.x-TIV-ITM-GSK-8.0.50.88-IJ04522 upgrade failure Had a report that the upgrade to fix patch  6.3.x-TIV-ITM-GSK-8.0.50.88-IJ04522 failed with the following messages in the itmpatch.log: TRACE Wed May 16 13:23:01 2018 (nls.cpp,142): NLS::getFormattedString() entry TRACE Wed May 16 13:23:01 2018 (nls.cpp,158): NLS::getFormattedString() = Version 07.40.50.00 of product gks is currently installed. The patch requires that you must have at least version 08.00.50.00 of product installed to apply this patch. ERROR Wed May 16 13:23:01... [More]

Tags:  ibm monitoringacademy itm hdt15 snd45jns ibm-blog troubleshooting

                      TCR install fails with CTGFI1007E error The error message seen is: ********** error uid="CRIMA1154E"> Error installing. </error><error uid="CTGFI1007E"> Port number should be an integer between 0 and 65535 You have entered an invalid port number. Enter a valid port number. ************* This is actually a JazzSM message and can be seen on the Registry and Reporting Services installation. The error is  linked to the DB2 instance and the port used to connect to the database. To be sure... [More]

Tags:  tcr ibm-blog snd45jns hdt15 ibm troubleshooting monitoringacademy

                      TCR authorization error  CM-SYS-5003 This will firstly show up as a DPR-ERR-2109 when trying to launch TCR or as CM-REQ-4159 when a report is tried to be run. This is a generic error and the cogserver.log needs to be reviewed to see what the further details of the error are. The cogserver.log shows:     CM-SYS-5003 Content Manager is unable to connect to the content store.   Verify that the database  connection properties in the configuration   tool are correct and that when you test the connection, the test is  ... [More]

Tags:  ibm-blog snd45jns hdt15 tcr ibm monitoringacademy troubleshooting

                       WPA reports SQLSTATE=22525. The  error message in the WPA logs is: SQLException: Error for batch element #728: DB2 SQL Error: SQLCODE=-327, SQLSTATE=22525, SQLERRMC=ITMUSER.NT_Server, DRIVER=4.17.29 == 5150825 t=Thread-240 SQLState: 22525 == 5150826 t=Thread-240 Message: Error for batch element #728: DB2 SQL Error: SQLCODE=-327, SQLSTATE=22525, SQLERRMC=ITMUSER.NT_Server, DRIVER=4.17.29 == 5150827 t=Thread-240 Error Code: -327   this is reported when... [More]

Tags:  warehouse wpa troubleshooting ibm-blog itm monitoringacademy ibm hdt15 snd45jns

                      Sending email from a z/OS agent. Just a quick short note this time. Have a couple of reports of having issues sending an email from a situation that is true on a z/OS agent. In these cases a Take Action had been set to run when the situation became true, however the email facility is not available on the agent machine. If the command is set to run on the TEMS, this will be the TEMS that the agent is connected to. So it will work if the agent is connected to a machine (windows, unix, linux) that has an email facility but if... [More]

Tags:  itm z/os ibm-blog hdt15 monitoringacademy snd45jns how-to agent ibm

        Migrate-export command error SQLSTATE=42601 The migrate-export command can be used to take a backup of the TEPS database, and this should be done regularly. see this blog for information on that: https://www.ibm.com/developerworks/community/blogs/0587adbc-8477-431f-8c68-9226adea11ed/entry/migrate_export_and_backing_up_your_teps_database?lang=en   However had a report when the migrate-export  was done that the saveexport.sql file (which is the file that is created from the command) was empty.   Each time the command is run, the... [More]

Tags:  itm monitoringacademy teps snd45jns troubleshooting hdt15 ibm-blog export migrate ibm

                          S&P agent  or WPA showing error SQLSTATE=40001     As with a lot of the warehouse errors this can be seen on the WPA or the S&P agent. On the S&P agent it could be shown like:   freddie:SY KNT 18000 NT_Processor NT_Processor 02/15/18 11:27:58 com.ibm.db2.jcc.am.SqlTransactionRollbackException: The current transaction has been rolled back because of a deadlock or timeout. Reason code "68".. SQLCODE=-911, SQLSTATE=40001, DRIVER=3.62.57 -911 40001   As the error message show the issue... [More]

Tags:  ibm snd45jns troubleshooting ibm-blog monitoringacademy hdt15 warehouse itm

Background: This is a follow up to the blog on how to reduce the ITM TDW warehouse table size. The database engine type here is Oracle. If the size of the TDW is too big or if you must reduce the size of TDW database you can use one of the three methods below. But before you do anything, I will recommend that your backup your TDW database. The command you use to back up the database will depend on the type of database that you are running. A typical Oracle backup requires you to do the following or you use Oracle RMAN to perform the backup.... [More]

Tags:  ws s&y itm6.3 ibm-blog wpa troubleshooting monitoringacademy tdw