Author Topic: Contents of ARSLOAD Table  (Read 3719 times)

BHUMENY

  • Guest
Contents of ARSLOAD Table
« on: September 18, 2015, 11:43:05 AM »
Where can I find the meaning of the fields in the ARSLOAD table?

Alessandro Perucchi

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1002
    • View Profile
Alessandro Perucchi

#Install #Migrations #Conversion #Educate #Repair #Upgrade #Migrate #Enhance #Optimize #AIX #Linux #Multiplatforms #DB2 #Windows #Oracle #TSM #Tivoli #Performance #Audits #Customizing #Availability #HA #DR #JavaApi #ContentNavigator #ICN #WEBi #ODWEK #Services #PDF #AFP #XML

BHUMENY

  • Guest
Re: Contents of ARSLOAD Table
« Reply #2 on: September 21, 2015, 08:50:04 AM »
Sort of.

It tells me the name of the fields, but not the meaning.
EG.
start BIGINT

What does a start date 0f 16010 mean?  I have forgotten what the base date was.

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2228
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Contents of ARSLOAD Table
« Reply #3 on: September 21, 2015, 10:46:06 AM »
What does a start date 0f 16010 mean?  I have forgotten what the base date was.

Number of days since January 1st, 1970.  You use arsdate to calculate the actual date, or turn a real date into an internal date format.

Code: [Select]
$ /opt/ondemand/bin/arsdate 16010
16010 -> 10/31/13
$ /opt/ondemand/bin/arsdate 09/21/15
09/21/15 -> 16700

-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