It's all about the answers!

Ask a question

How to find RTC repository version by running SQL commands on Jazz or JTS schema.?

Nagesh Srinivas (10828) | asked Dec 15 '15, 3:16 a.m.
Hi All,

I am sure that we should be able to find out the version of RTC repository by running SQL against Jazz or JTS schema. & I have done this in the past.

But I have missed that information or its not handy.

Can someone share the SQL or any link to it.?

Nagesh S

2 answers

permanent link
Kevin Ramer (4.5k8180199) | answered Dec 16 '15, 2:11 p.m.
I've used the "application-about" to good effect in a curl or wget.  

e.g. curl -k https://server.dom:nnnn/ctx/application-about

substitute as follows:
The fully-qualified host for server.dom
The actual port for nnnn
The application context for ctx

You will get back something like:

<?xml version="1.0" encoding="UTF-8"?>
<rdf:RDF xmlns:rdf=""
    <oslc:Publisher  rdf:about="">
        <dcterms:title>Change and Configuration Management</dcterms:title>
        <dcterms:description>Provides capabilities for change management, planning, software configuration management, automation (build system), and extensions for IBM enterprise platforms development.</dcterms:description>
        <oslc:icon rdf:resource=""/>
    </oslc:Publisher >

The best thing is that NO authentication is required all you need to know is the URI of the server.

permanent link
Nagesh Srinivas (10828) | answered Dec 18 '15, 6:55 a.m.
Hi Kevin,

Thanks for the answer but this method is useful only when application is up & running.

I need to check the version of the repository incase the DB is corrupted or the server is not starting because of repository version mismatch.

I could see something as below in the <JAZZ_SCHEMA>.JAZZ_PROPERTIES table after the application is upgraded to 5.0.2


Nagesh S

Kevin Ramer commented Dec 18 '15, 10:34 a.m.

I find a JAZZ.PROPERTIES table, but none of the rows contain what looks to be a version number.  Yours seems to be an odd use-case and information about repositories and their versions ought to be determined and kept elsewhere.  Some suggestions:

  • Ask IBM Installation Manager to Update your packages.  That will show what it thinks are the versions installed
  • Look at upgrade logs of the repository in question esp repotools-xxx_version.log, where xxx is the context ( jts, ccm, qm, rm, etc )

Your answer

Register or to post your answer.