we are trying to import reports from ITCAM, but when running:
./trcmd.sh -modify -dataSources -reports -username tipadmin -password XXX -dataSource name=WAREHOUS -setDatasource odaURL="jdbc:db2://10.16.93.25:50000/WAREHOUS:currentSchema=ITMUSER" odaDriverClass="com.ibm.db2.jcc.DB2Driver" odaUser=itmuser odaPassword=XXX
CTGTRQ099W No datasource matching the criteria was found for modification.
./trcmd.sh -user tipadm -password XXX -dataSource -test WAREHOUS -dbLogin itmuser -dbPassword XXX
CTGTRI164E Processing has failed. See the following error message for details:
QE-DEF-0285 The logon failed.
Should I configure something else in the DB2 client?
SystemAdmin 110000D4XK373 Posts
Re: New with TCR2012-10-16T19:53:09ZThis is the accepted answer. This is the accepted answer.Hi,
That is a command to set a BIRT-based data source. Are you sure you have a BIRT package and not a Cognos package?
First as a general comment, check out the field guide under the videos. That's a great overall resource.
If this is indeed BIRT,: http://pic.dhe.ibm.com/infocenter/tivihelp/v3r1/topic/com.ibm.tivoli.tcr.doc_211/ttcr_jdbc_direct.html
I don't know if WAREHOUS is the correct name the datasource is defined as in the reports. I think it's "ITM". You can instead pass a report name instead of a data source name (get the report name from a -list -reports.
I suspect you instead have a Cognos package. In this case, I prefer to use the web UI to create the data source (but you first must have a local DB2 client or server cataloged with the database:
You can also see this in Video #5, setting up a DB2 data source for a Cognos-based package:
I hope that helps, Dan Krissell