Just trying to find out some stuff to access and run SQL commands on CUCM 6 (i think its running on IBM Informix database).
Whats the master table name in CUCM 6 so that I can find other tables from there?
do you have some links where I can find more about connecting to CUCM6 Database via ODBC or JDBC?
The answer do your question on "master table".
admin:run sql select tabname from systables
This command will give you all tables in the database. If you want to see more than just the table name, then you can select "*".
I recommend also downloading the data dictionary: http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/6_1_1/dd_611...
I also recommend reading up on the Administrative XML API (http://developer.cisco.com/)
If interested, I wrote up a 3 part blog series on this topic (more or less) here:
Part 1 goes into table structures
Part 2 explains the AXL Query toolkit
Part 3 provides an example on using the toolkit to modify the database
FYI, you cannot access the database directly therefore ODBC/JDBC is not supported. You must use the AXL/SOAP interface to do your thing.
Please remember to rate helpful posts...