Author Topic: System Load table dates incorrect in ARSDOC Query  (Read 1082 times)

lfbeach

  • Jr. Member
  • **
  • Posts: 43
    • View Profile
System Load table dates incorrect in ARSDOC Query
« on: November 08, 2021, 08:54:35 AM »
We want to run ARSDOC Query against the System Load table to obtain daily counts for some of our cmod application loads.  However when we supply the date range we are looking for, using the ODDAT_LOAD_TIME,  the results do not match what we see in the CMOD Client.  How can we make this work and get proper counts for the proper dates?

           OSHELL /u/arssp/product/bin/arsdoc query -                               
        -h ARSSP                -                                         
        -G 'System Load'        -                                         
        -d /u/arsss/tmp1        -                                         
        -o LOADCNTS.GIAUTOF.out  -                                         
        -e ,                    -                                         
        -i "WHERE               -                                         
           ODDAT_LOAD_TIME >= '2021-11-04 00:00:00.000000'  -             
           AND ODDAT_LOAD_TIME < '2021-11-05 00:00:00.000000'  -           
           AND APPL_NAME LIKE 'GIAUTOF%'"                   -             
        -v   

VIEW FROM CMOD CLIENT

2021-11-05 21:08:42.328850   FEDEXPDF16002   GIAUTOF-V01
2021-11-04 21:08:25.774097   FEDEXPDF16002   GIAUTOF-V01
2021-11-03 21:05:20.620995   FEDEXPDF16002   GIAUTOF-V01
2021-11-02 21:07:43.251008   FEDEXPDF16002   GIAUTOF-V01

ARSDOC QUERY RESULTS:
Output:
11/03/21 21:05:20,FEDEXPDF16002,GIAUTOF-V01

Lori Frazier Beach
Developer-CMOD Admin
Document Management Systems

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2228
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: System Load table dates incorrect in ARSDOC Query
« Reply #1 on: November 09, 2021, 09:08:19 AM »
A few things...

First, I see that you're writing your own SQL - and this comes with some caveats...  The time stored in the database table is UTC, not your local time zone.  You need to adjust your queries for that.

Second, for dates, try using the 'between' operator for the dates, rather than multiple 'AND' operators.

Try those out and let us know how it goes.  :)

-JD.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

lfbeach

  • Jr. Member
  • **
  • Posts: 43
    • View Profile
Re: System Load table dates incorrect in ARSDOC Query
« Reply #2 on: November 09, 2021, 02:43:36 PM »
Thank you for the response!
The developer running this utility tried LOAD_START_DT and that is giving the results that match our CMOD Client search.
I think we are ok.
Lori Frazier Beach
Developer-CMOD Admin
Document Management Systems