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 (10838) | 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.?

Regards,
Nagesh S

2 answers



permanent link
Nagesh Srinivas (10838) | 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



Regards,

Nagesh S


Comments
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 )


permanent link
Kevin Ramer (4.5k9185200) | 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="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
         xmlns:jfs="http://jazz.net/xmlns/prod/jazz/jfs/1.0/"
         xmlns:dcterms="http://purl.org/dc/terms/"
         xmlns:oslc="http://open-services.net/ns/core#">
    <oslc:Publisher  rdf:about="https://server.com:9443/jazz/application-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>
        <dcterms:identifier>http://jazz.net/application/ccm</dcterms:identifier>
        <jfs:version>5.0.2</jfs:version>
        <oslc:icon rdf:resource="https://server.com:9443/jazz/web/com.ibm.team.rtc.web/ui/graphics/UICustomizations/RTC_16.png"/>
        <jfs:instanceName>RTC</jfs:instanceName>
    </oslc:Publisher >
</rdf:RDF>

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

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.