Load ID Format - Help

Previous topic - Next topic

Pk2016

Hi,

Can anyone direct me to the documentation of the updated load-id format in CMOD 9.5 .

Pre upgrade format (v8.5)
LoadId(5559-11-0-10369FAA-17081-17081) File(/ars/tmp/67110863 (DD:INPUT- xxxx.xxxx.AFP)) InputSize(540349) OutputSize(144973) Rows(13) Time(3.7510) Appl(XXXX2AAC)

Post Upgrade :(v9.5)
LoadId(5559-11-0-10381FAA-20161007000000-20161007000000-5562)File(/ars/tmp//33556151.000001579F7B8B58) InputSize(211107) OutputSize(57367) Rows(5) Time(0.1723) Appl(XXX2AAC) InputFileSize(-1)


ALso in 9.5 ,  its not showing the input file name(underlined above)  used for the load  instead shows ars/tmp/.......

Would like to know if that is its supposed to be with the new upgrade or what we have is incorrect.

upgraded from 8.5 to 9.5( Zos)

Thank you


Greg Ira

The load ID format can be found in the V9.5 Administration guide under ARSADMIN -L parameter description.
Input file name looks consistent with what we get in our load messages.

Pk2016

Thank you Greg Ira,that helped.

Still trying to figure out the File name change.

Justin Derrick

The filename in /ars/tmp looks like a bug.  It should be the path and filename where the original file was listed, not where the temporary file lives.

The Load ID hasn't changed much.  The old format was:

5559-11-0-10369FAA-17081-17081
AppGroupID-StorageSet-0-DocNamePrefix-MinDate-MaxDate

The date format was either number of days since January 1st, 1970, or the number of seconds since January 1st, 1970, depending on the configuration of the Segment Date field in your Application Group.

And the new format isn't much different.
5559-11-0-10381FAA-20161007000000-20161007000000-5562

AppGroupID-StorageSet-0-DocNamePrefix-MinDate-MaxDate-ApplicationID

Where dates are now stored in YYYYMMDDHHMMSS format (Thats YearMonthDayHourMinuteSecond).  The only addition is the ApplicationID at the end, which refers to the internal numeric ID for the Application definition that was used to index/load the data.

There's also an article on the Doc_Name format on the CMOD wiki:  http://cmod.wiki/index.php/DOC_NAME

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

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

Pk2016

Thank You Dustin.

I agree with the filename . Will have to investigate further where that is picking from and why the input file name is not picked up.

Thanks again for the description of the Load iD Format. The "20161007000000" is actually the load date . It is same as the date the statements were loaded to ondemand. Was skeptical about why does it write  the timestamp twice.

Will go through the CMOD Wiki link.

Alessandro Perucchi

in the load id, the field corresponding to MinDate and MaxDate correspond in your load that you are trying to archive to the field that represent the "segment" flag in your application group (maybe a field called docdate).
And during the load "arsload" will look at the oldest date and newest date from your batch.
In your case, all documents have the date "20161007000000", so it is normal that MinDate = MaxDate = "20161007000000"
If you have a mix of dates, let say "20161001000000", "20161007000000", "20161011000000", the your load ID would look like :

5559-11-0-10381FAA-20161001000000-20161011000000-5562

since MinDate=20161001000000 and MaxDate = 20161011000000.

Regards,
Alessandro
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

Pk2016

Thank you for the explanation Alessandro .