CMOD 9.5, DB2 10.1 - Scratching my head on this one, I've done this before but its been a while. I want to just generate a list of 66 messages for a certain time frame. I think this is what i used last time.
arsdoc query -u admin -p stash.file -h archive -f 'System Log' -i "WHERE TIME_STAMP_DT > '2021-02-12-01.00.00.352804' and TIME_STAMP_DT < '2021-02-12-2.43.45.352804' and MSG_NUM='66'"
I want to get all 66 messages, between 2021-02-12-01.00.00.352804 and 2021-02-12-2.43.45.352804
When I run above arsdoc query, I get this.. Notice the dates look funky... Anyone have a thought?
02/11/21 21:30:34,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.003) ObjName(38657GAAA) Off(0) Len(40646) CompOff(0) CompLen(34621) Size(40646) Seg(1) Total Segs(1) Flds(),A,1271258566,
02/11/21 21:30:31,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.009) ObjName(42537GAAA) Off(44384) Len(89182) CompOff(0) CompLen(57683) Size(89182) Seg(1) Total Segs(1) Flds(),A,1271258560,
02/11/21 21:30:30,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.002) ObjName(39760GAAA) Off(0) Len(43120) CompOff(0) CompLen(9725) Size(43120) Seg(1) Total Segs(1) Flds(),A,1271258562,
02/11/21 21:30:29,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.003) ObjName(39813GAAA) Off(0) Len(49624) CompOff(0) CompLen(11097) Size(49624) Seg(1) Total Segs(1) Flds(),A,1271342777,
02/11/21 21:00:21,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.003) ObjName(38657GAAA) Off(0) Len(40646) CompOff(0) CompLen(34621) Size(40646) Seg(1) Total Segs(1) Flds(),A,1271258566,
02/11/21 21:00:19,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.010) ObjName(42537GAAA) Off(44384) Len(89182) CompOff(0) CompLen(57683) Size(89182) Seg(1) Total Segs(1) Flds(),A,1271258560,
02/11/21 21:00:17,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.003) ObjName(39760GAAA) Off(0) Len(43120) CompOff(0) CompLen(9725) Size(43120) Seg(1) Total Segs(1) Flds(),A,1271258562,
02/11/21 21:00:16,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.004) ObjName(39813GAAA) Off(0) Len(49624) CompOff(0) CompLen(11097) Size(49624) Seg(1) Total Segs(1) Flds(),A,1271342777,
02/11/21 20:30:19,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.003) ObjName(38657GAAA) Off(0) Len(40646) CompOff(0) CompLen(34621) Size(40646) Seg(1) Total Segs(1) Flds(),A,1271258566,
02/11/21 20:30:17,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.008) ObjName(42537GAAA) Off(44384) Len(89182) CompOff(0) CompLen(57683) Size(89182) Seg(1) Total Segs(1) Flds(),A,1271258560,
02/11/21 20:30:15,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.003) ObjName(39760GAAA) Off(0) Len(43120) CompOff(0) CompLen(9725) Size(43120) Seg(1) Total Segs(1) Flds(),A,1271258562,
02/11/21 20:30:14,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.004) ObjName(39813GAAA) Off(0) Len(49624) CompOff(0) CompLen(11097) Size(49624) Seg(1) Total Segs(1) Flds(),A,1271342777,
02/11/21 20:00:32,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.003) ObjName(38657GAAA) Off(0) Len(40646) CompOff(0) CompLen(34621) Size(40646) Seg(1) Total Segs(1) Flds(),A,1271258566,
02/11/21 20:00:30,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.006) ObjName(42537GAAA) Off(44384) Len(89182) CompOff(0) CompLen(57683) Size(89182) Seg(1) Total Segs(1) Flds(),A,1271258560,
02/11/21 20:00:28,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.003) ObjName(39760GAAA) Off(0) Len(43120) CompOff(0) CompLen(9725) Size(43120) Seg(1) Total Segs(1) Flds(),A,1271258562,
02/11/21 20:00:26,ADMIN,4,66,Application Group Document Get: Name(APPLICATION_AG_S) Agid(5150) ApplName(APPLICATION_APP_S) Aid(5151) NodeName(-CACHE-) Nid(3) Server(server) Time(0.004) ObjName(39813GAAA) Off(0) Len(49624) CompOff(0) CompLen(11097) Size(49624) Seg(1) Total Segs(1) Flds(),A,1271342777,