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

Nagesh Srinivas (108●2●8) | 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

Most liked answers|Newest answers ↓|Oldest answers

permanent link

Kevin Ramer (4.5k●6●175●193) | 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.

permanent link

Nagesh Srinivas (108●2●8) | 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 )

It's all about the answers!

Related questions

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

2 answers

Your answer