 |
Software > Tivoli >
|
|
|
|
Problem executing complex SQL queries using kdstsns tool
|
| | | Problem(Abstract) | | The tool hangs when you execute a complex query on UNIX and Linux systems. The TEMS database along with the kdstsns tool supports only simple SQL queries to query data from TEMS tables. | | | | Symptom | | The kdstsns tools just hangs for the following query on Linux and Unix systems but works fine on windows.
SELECT TOBJACCL.OBJNAME,TNODELST.NODE
FROM O4SRV.TNODELST,O4SRV.TOBJACCL
WHERE TNODELST.NODELIST=TOBJACCL.NODEL AND TNODELST.NODETYPE="V";
where as it works fine for the simple query like
SELECT NODE,
NODELIST,
NODETYPE
FROM O4SRV.TNODELST;
The command to execute the query is as follows. More information above the tool is available in ITM users guide
./kdstsns <sql file name> *HUB
| | | |  | | | Resolving the problem | Currently complex SQL queries (inner joins) as mentioned above is not supported. Just to note, the TEMS database along with the kdstsns tool only support some basic type SQL
The reason it works on windows is that windows tolerates the same lock taken twice on the same thread whereas other distributed platforms won't tolerate this. This is the reason it is running on Windows but not on UNIX and Linux systems
I have created a enhancement request MR0903093611 to support this functionality | | | | | | | | |
|
|
| IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml. |
|
|
|
|
| Please take a moment to complete this form to help us better serve you. |
|
 |
|
|
|
|
|
|
| Product categories: |
|
| | Software | |
| | Systems and Asset Management | |
| | Other Systems and Asset Management | |
| | IBM Tivoli Management Server for Distributed Systems | |
|
| Operating system(s): |
| |
AIX, HP-UX, Linux
|
|
| Software version: |
| |
6.1, 6.2, 6.2.1
|
|
| Software edition: |
| |
All Editions
|
|
| Reference #: |
| |
1399552
|
|
| IBM Group: |
| | Software Group |
|
| Modified date: |
| | 2009-09-08 |
|
|
