Which DB (Release/Version) does UCCX 8.5.1 use?

[michael.huelskoetter]

Hi Team,

Is there someone who can tell me, which database version UCCX Rel. 8.5.1 uses?

How / Where can I identify what version is currently is in use (e.g. for different UCCX Releases)?

Many thanky in advance!

Kind regards,

Michael

[jessepbeatty]

I couldn't really find anything other than "Informix IDS" in the SRND located here.

The admin guide (here) does mention installing an ODBC driver for "IDS version 3.0.0.13219 and above".

And if you're interested in the database schema, you can find it here.

That information is usually located in the Bill of Materials, but I didn't see one anywhere...not much experience with UCCX for me. Maybe it's somewhere else. I think it's probably handled by the Cisco installer unlike UCCE where you install SQL yourself. Anyone know?

[Anthony Holloway · Accepted solution]

Just pop open CLI and run this command:

run sql select unique dbinfo('version', 'full') from systables

I don't have UCCX 8.5(1) running anywhere to tell you the version information you are looking for, but I think showing you how to figure it out is close enough

Here's an example from a CUC 8.5(1)SU1:

admin:show version active
Active Master Version: 8.5.1.11900-21
Active Version Installed Software Options:
No Installed Software Options Found.
admin:run sql select unique dbinfo('version', 'full') from systables
(constant)
=================================================
IBM Informix Dynamic Server Version 11.50.UC5XE
admin:

Here's an example from a CUCM 7.1(5b)SU3:

admin:show version active
Active Master Version: 7.1.5.32900-2
Active Version Installed Software Options:
No Installed Software Options Found.
admin:run sql select unique dbinfo('version', 'full') from systables
(constant)
=================================================
IBM Informix Dynamic Server Version 10.00.UC9XF
admin:

[michael.huelskoetter]

Hi Anthony!

EXCELLENT!!!

That's exactly what I was looking for.

It's even much better to know where to find the informations.

Again many thanks!!!

Regards,

Michael

[lohjintiam]

Hi guys,

Did you manage to get the version number for it? Any idea if UCCX v8 is having the same Informix db version as v8.5?

Thanks!

-JT-

[Anthony Holloway]

Here is UCCX 8.0

admin:show version active
Active Master Version: 8.0.2.11003-10
Active Version Installed Software Options:
No Installed Software Options Found.
admin:run sql select unique dbinfo('version', 'full') from systables
(constant)
=================================================
IBM Informix Dynamic Server Version 11.50.UC5XA
admin:

Here is UCCX 8.5

admin:show version active
Active Master Version: 8.5.1.10000-37
Active Version Installed Software Options:
No Installed Software Options Found.
admin:run sql select unique dbinfo('version', 'full') from systables
(constant)
=================================================
IBM Informix Dynamic Server Version 11.50.UC5XE
admin: