OnDemand User Group
Support Forums => OD/WEK & JAVA API => Topic started by: OMi on January 14, 2016, 07:58:54 AM
-
Hi *all,
for one tracking issue I need to read all metadata/hits for one load/report. Because high amount of data it must be done most effectively.
All of the "tracked" application groups could be searched over special technical folder with all of them. I take a application group name and Load-Id as input (found in syslog 87 Message) and generate query SQL-String . For example (1):
String sql = "where doc_name like '83267FAA%'";
folder.setApplGroupForSearchWithSQL(load.applGroupName);
hits = folder.search(sql);
it runs fine ;)
as a next step to get a better performance on large application groups with multiple segments, I get start_date / stop_date from Load-Id and try to use another search method. For example (2):
hits = folder.search(sql, "20160111000000", "20160111000000", "%Y%m%d%H%M%S");
here is the result empty (nothing found) :(
In arswww.trace and/or Job-Log of ARSSOCKD I don't see any errors, but I observe no search-records in ARSSOCKD log
Any ideas??
CMOD Server: 9.5.0.3 z/OS
ODWEK: 9.5.0.4 Windows x64
-Oleg
-
Did you try:
hits = folder.search(sql, "20160111000000", "20160111235959", "%Y%m%d%H%M%S");
???
-
Yes, I did:
Load-ID <76685-6962-0-862FAA-20160111000000-20160111000000-76686>
folder.search("where doc_name like '862FAA%'");
works fine and returns 1277 hits
folder.search("where doc_name like '862FAA%'", "2016011000000", "20160111000000", "%Y%m%d%H%M%S");
and/or
folder.search("where doc_name like '862FAA%'", "2016011000000", "20160111235959", "%Y%m%d%H%M%S");
returns empty result
It seems to be a PMR
-Oleg
-
fyi - the problem was solved months ago - very much Thanks IBM Support. The solution was:
The, with segStart/segStopDate "searched", Folder Needs a Folder field that maps to the application group Segment (date) field.
Once I had mapped the new Folder field then both of These searches worked:
hits = folder.search("where doc_name like '821FAA%'", "20160111000000",
"20160111000000", "%Y%m%d%H%M%S");
hits = folder.search("where doc_name like '821FAA%'", "20160111",
"20160111", "%Y%m%d%");