In Informix, the first new table added to the database after the database is created will start with the ID of 100. If you are only interested in tables that were created by Cisco then you can use the following query: The above will list all of the table names within the database, including systables. A simple query can be used to dump all of the system tables: The systables table contains some very basic information about all of the tables in the Informix database. We will be using the systables and syscolumns catalogs. Without going too deep into this, the system catalogs can be thought of as metadata for the database. We are going to be working with the Informix system catalogs to get at the information we need. Let's walk through our recent installment of this series: Displaying Devices and Assigned DNs. If we want to keep this blog from meandering on forever, we need an example to walk through. This is definitely more efficient when I am trying to find the exact column name in a table (or set of tables) that I already have some familiarity. However, I find it is often quicker (for me anyway) to query system tables directly from the CLI. This resource is handy when you are looking to build a query involving tables you haven't much familiarity with.
Cisco provides a Data Dictionary that anyone can download. Output from the above query on my CUCM 8.5(1)SU3 system:įor this week's post I wanted to introduce some tools that may come in handy when trying to put together a query on the system. So, in the spirit of that goal we will look at our first query: how can you tell which version of the Informix IDS is running on your CUCM? This week's query (or query set?) focuses on exploring the Informix database structure via the system tables. A great place for support info is provided by IBM at the Informix IDS 11.5 Information Center. The current Informix version used by CUCM 8.x is 11.5. That's OK, I still find the resource helpful. I started with this tutorial which is based on Informix IDS version 10.0 (which was EOL in 2010). However, you do need to understand some basics around SQL and, as you try to perform some advanced queries, you will need to learn a little about the specific syntax expected by this RDBMS.
You don't need to know anything about Informix to get started with exploring the CUCM database. Informix is the relationship database management system (RDBMS) used on the Cisco UCM appliance (as well as many other Cisco UC apps).
0 kommentar(er)
