Folder.search(sql, segStartDate, segStopDate, dateFmt)

[OMi]

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

[Alessandro Perucchi]

Did you try:

Code: [Select]

hits = folder.search(sql, "20160111000000", "20160111235959", "%Y%m%d%H%M%S");

[OMi]

Yes, I did:

Load-ID <76685-6962-0-862FAA-20160111000000-20160111000000-76686>

Code: [Select]

folder.search("where doc_name like '862FAA%'");
works fine and returns 1277 hits

Code: [Select]

folder.search("where doc_name like '862FAA%'", "2016011000000", "20160111000000", "%Y%m%d%H%M%S");
and/or

Code: [Select]

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

[OMi]

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:

Code: [Select]

hits = folder.search("where doc_name like '821FAA%'", "20160111000000",
"20160111000000", "%Y%m%d%H%M%S");


Code: [Select]

hits = folder.search("where doc_name like '821FAA%'", "20160111",
"20160111", "%Y%m%d%");